Become an expert at SQL!

What you'll learn

Use SQL to query a database

Be confident in putting SQL and PostgreSQL on your resume

Replicate real-world situations and query reports

Use SQL to perform data analysis

Learn to perform GROUP BY statements

Requirements

No prerequisites, you will learn everything from scratch

Description

Learn SQL fast and easy with this course!In this course, you'll quickly learn how to read and write complex database queries using PostgreSQL, one of the most popular and in-demand SQL tools. The skills you learn here can also be used with other major SQL databases like MySQL, Microsoft SQL Server, Oracle, Amazon Redshift, and more.Learning SQL is a great way to boost your career because it's one of the top tech skills companies are looking for. This course will help you learn quickly, with challenges and tests along the way to make sure you understand everything!Here's what you'll learn in this course:How to use PostgreSQL and PgAdmin, two of the most popular tools for working with SQL.The basics of SQL syntax (the rules for writing SQL code).How to analyze data with GROUP BY commands and aggregate functions.How to write advanced queries using string operations and comparison operations.How to use logical operators to add more complex conditions to your queries.The most common SQL JOIN commands.How to create tables and databases with rules to control the data.How to use Python to improve your SQL skills.And much more!This course puts you in control right from the start! You won't just watch someone else code—you'll set up and restore databases yourself. Every section includes challenges that help you practice real-world tasks.I have years of experience teaching both online and in-person at big companies, and this course combines the best methods for learning at your own pace. You'll start with the basics and soon be working with advanced SQL commands, like handling timestamps and character data, just like a pro.SQL is one of the most in-demand skills for business analysts, data scientists, and anyone working with data. So, level up your skills and add SQL to your resume by joining today!

Overview

Section 1: Introduction to SQL

Lecture 1 Data Types in SQL and MySQL

Lecture 2 SQL Commands and DML, DDL, DQL and DCL

Lecture 3 Practical Example and Summary

Section 2: Filtering and Sorting Data

Lecture 4 Filtering data using WHERE clause and logical operators

Lecture 5 Sorting data using ORDER BY clause

Lecture 6 Practical Examples for Filtering and Sorting

Section 3: Aggregate Function in MySQL

Lecture 7 Using aggregate functions (SUM, AVG, MIN, MAX, COUNT)

Lecture 8 Combining data from multiple tables using JOINs (INNER JOIN, OUTER JOIN, etc.

Lecture 9 Grouping data using GROUP BY clause and Filtering groups using HAVING clause

Lecture 10 Where and Having Clause in SQL with Examples

Lecture 11 Practical Examples with Summary

Section 4: SubQuery, Coalesce, Case/When in MySQL

Lecture 12 Introduction to SubQuery, Types, Syntax & Parameters, Operators

Lecture 13 MySQL SubQueries and Functions

Lecture 14 Syntax and Parameters of MySQL Functions

Lecture 15 My SQL SubQuery with Different Operators, Types Explanation with Examples

Lecture 16 Practical Examples with Summary

Section 5: DB Normalization, (OVER) Clause, (WITH) Clause in MySQL)

Lecture 17 DB Schema, Normalization in SQL, Types of Normal Forms

Lecture 18 Rank Functions & Syntax

Lecture 19 Practical Usage of Rank Functions, OVER and WITH Clause

Section 6: SQL for Data Science

Lecture 20 SQL for Data Science

Section 7: SQL for Data Analytics

Lecture 21 SQL for Data Analytics

Anyone interested in learning more about SQL, PostgreSQL, or SQL for data analysis and data science!