Sql For Absolute Beginner - With Portfolio Projects
Published 9/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.72 GB | Duration: 7h 41m

Master SQL from scratch with hands-on projects. Build real-world skills in querying, data manipulation, and analysis.

What you'll learn

Understand the Fundamentals of SQL: Learn the basic concepts of SQL, including how to create, read, and delete data in relational databases.

Write Complex SQL Queries: Develop the ability to write advanced SQL queries involving multiple tables, joins, subqueries, and aggregate functions.

Design and Implement Relational Databases: Gain hands-on experience in designing and setting up relational database structures.

Build and Manage Real-World SQL Projects: Complete portfolio projects that simulate real-world scenarios.

Requirements

No prior programming experience required.

This course is designed for absolute beginners.

Description

Unlock your potential in data analytics with SQL for Absolute Beginners - With Portfolio Projects. This course is tailored to take you from zero experience to a confident SQL user, perfect for those new to databases.Master SQL and Build Real-World Projects That Showcase Your SkillsBegin with the essentials, learning to install and navigate PostgreSQL, a powerful database management system. Through hands-on projects, you'll engage with real-world datasets, gaining practical experience that's directly applicable to the workplace.By the end of this course, you will:Understand the fundamentals of relational databases and how they're used in today's data-driven world.Write and optimize SQL queries to retrieve, manipulate, and analyze data efficiently.Apply aggregate functions to summarize data and extract key insights.Use joins and unions to combine data from multiple tables, allowing for more comprehensive analysis.Complete a portfolio project that simulates real-world challenges, demonstrating your SQL skills to potential employers.Whether your goal is to break into data analytics, advance in data science, or simply enhance your technical toolkit, this course provides you with the essential knowledge and hands-on experience. You'll finish with a solid grasp of SQL and a portfolio project that sets you apart.Begin your SQL journey today and transform your career prospects!!

Overview

Section 1: Introduction

Lecture 1 Introduction to PostgreSQL

Lecture 2 Introduction to databases I

Lecture 3 Introduction to databases II

Lecture 4 Introduction to databases III

Section 2: Getting Ready!

Lecture 5 Installing PostgreSQL

Lecture 6 The PostgreSQL GUI 1

Lecture 7 The PostgreSQL GUI II

Lecture 8 The PostgreSQL GUI III

Section 3: Working with Data in PostgreSQL: Importing, Querying, and Filtering

Lecture 9 Importing CSV Files to pgAdmin I

Lecture 10 Importing CSV Files to pgAdmin II

Lecture 11 Simple SELECT statements I

Lecture 12 Simple SELECT statements II

Lecture 13 Simple SELECT statements III

Lecture 14 Filtering query results with WHERE clause I

Lecture 15 Filtering query results with WHERE clause II

Lecture 16 Filtering query results with WHERE clause III

Section 4: Aggregate Functions in SQL

Lecture 17 Aggregate Functions

Section 5: Subqueries in SQL

Lecture 18 Subqueries In SELECT clause

Lecture 19 Subqueries In the FROM clause

Lecture 20 Subqueries In the WHERE clause

Lecture 21 Subqueries - ANY/ALL Operators

Section 6: Joins & Unions

Lecture 22 Basics of Joins

Lecture 23 INNER JOIN

Lecture 24 LEFT JOIN

Lecture 25 RIGHT JOIN

Lecture 26 FULL JOIN

Lecture 27 UNION & UNION ALL

Section 7: Data Transformation and String Manipulation in SQL

Lecture 28 SQL Cleaning String & concat function

Lecture 29 UPPER & LOWER Function

Lecture 30 REPLACE Function

Lecture 31 LENGTH Function

Lecture 32 TRIM Functions

Lecture 33 LEFT, RIGHT & SUBSTRING Functions

Lecture 34 DATE Function I

Lecture 35 DATE Function II

Lecture 36 Views in SQL

Lecture 37 CASE Statements in SQL

Lecture 38 PostgreSQL SHELL

Section 8: Portfolio Projects

Lecture 39 Supply Chain Analytics

Section 9: Wrap-Up

Lecture 40 Wrap-Up & Capstone Project

Complete beginners who have never written a line of SQL before but want to learn from scratch.,Aspiring data professionals looking to build a strong foundation in SQL for data analysis, data science, or database management.,Business professionals who want to enhance their data skills and become more self-sufficient in querying and analyzing data.,Students and recent graduates seeking to add practical SQL experience to their portfolios.,Anyone interested in transitioning to a tech role and starting their journey with one of the most essential data skills.