Home

All courses

Comprehensive SQL Course For Data Professionals [2024]

Business Analytics & Intelligence

IT & Software

Comprehensive SQL Course For Data Professionals [2024]

Become a Confident SQL Developer by Developing a Real World Project using SQL and Solving 120+ SQL Coding Exercises

4.6

(761)

5018 enrolled on this course

Last updated 11/2021

Ramesh Retnasamy . 200,000+ Learners

₹ 3299.0

₹ 4799.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

Welcome!
I am looking forward to helping you to
become proficient in SQL
, one of the fundamental skills required to become a
data professional
. SQL is one of the important skill required to become
data engineer, data analyst, data scientist, web developer, application developer
etc. So, if you aspire to be a competent data professional, this is course is for you!
Course Approach:
This is a comprehensive hands-on course with
120+ SQL coding exercises
and
a Real World Project
of building a database for one of the popular sporting tournaments, and writing all the SQL statements required for the tournament website.
I have combined my experience working with SQL in the industry for
25 years
with teaching on Udemy for
160,000 students
to create this comprehensive curriculum. Throughout the course, I provide guidance on using
best practices
for writing SQL statements and also take you through
real world examples
.
I value your time as much as I do mine.
So, I have designed this SQL course to be fast-paced and to the point. Also, the course has been taught with
simple English and no jargons
. I start the course from basics and progress to complex topics, and by the end of the course you will be proficient in SQL.
Comprehensive Curriculum:
Beginner Level Topic:
Introduction to Databases and SQL
Basics of SQL statements
Querying Data
Filtering Data
Intermediate Level Topic:
Simple SQL functions
Date Functions
Conditional Expressions & Functions
Aggregate Functions
Grouping Data
SQL Joins
SQL Constraints
Primary & Foreign Keys and Relationships
Advanced Level Topic:
Database Design & Entity Relationship Diagrams
Subqueries
Common Table Expressions (CTEs)
Views
Window/ Analytical Functions
Project:
Requirements gathering & Database Design
Writing SQL Queries for a Website
ANSI SQL:
This course follows the ANSI standard for SQL. So, once you complete the course, you will be able to with with SQL on all major databases such as
MySQL, PostgreSQL, SQLite, Oracle, SQL Server
etc, and also with any big data and parallel processing engines such as
Spark SQL, Hive SQL, Snowflake, Google BigQuery, Azure Synapse
etc.
Course Outcome:
Once you have completed the course including all the SQL coding exercises and the project, I genuinely believe that you will be in a position to start working in a real world data project using SQL.
Student Feedback:
Here are some of the reviews from existing students which may help you make the decision, but also please feel free to go through the reviews from others at the bottom of this page!
Ayantika N [5*] -
This is my first-hand experience with SQL. I thoroughly enjoyed the course, especially being a student with no background in computer language. I found the course well-thought out and beneficial for me. The hands-on examples are really well explained. I look forward to coming back to your courses in future as well. Kudos to you!! :)
Mayank S [5*] -
A very comprehensive course which starts with the basics then slowly moves on to intermediate and advanced concepts. The best part is the practice exercises to solidify one's understanding. Easy to follow along.
Ritesh T [5*] -
I have purchased all his courses. The best part of him is that, he explains the concepts + the use cases where it would be used. Just like his databricks, azure df, azure synapse courses, the theories are there as well as the scenarios where such concepts could / would / should be used. There are times when a student like me who is working on live projects could use a particular concept, and bingo, his lectures come life saving.
Who this course is for:
University students looking for a career in Information Technology
Software Engineers working with data, i.e, Web Developers, App Developers etc
Anyone interested in Data Engineering, Data Analysis, Data Science, Business Intelligence etc

What you'll learn

You will learn how to create database tables, alter an existing table and drop a table that's not required using SQL

You will learn how to query data from a table, apply transformations using functions, filter and sort the data returned using SQL

You will learn how to join multiple tables, summarise the data as required to produce summaries using SQL

You will learn how to use sub queries and common table expressions to implement complex logic using SQL

You will learn how to create and work with views to simplify complex solutions using SQL

Using SQL, you will learn how to use window functions to carry out complex data analysis with ease

Using SQL, you will learn how to design and implement a database for a real world project

You will learn how to write SQL queries required to satisfy the requirements for a real world project

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Beginner - Comprehensive SQL Course Introduction

1.1-SQL Course Introduction

1.2-SQL Course Structure

1.3-Course Slides Download

2-Beginner - Overviews

2.1-Introduction to SQL

2.2-Udemy Coding Exercises Overview

2.3-Practice - Udemy Coding Exercises Overview

2.4-SQLite Documentation (Optional)

3-Beginner - Introduction to SQL Statements

3.1-Section Overview

3.2-Creating Tables

3.3-Writing SQL Statement - Best Practices

3.4-Practice - Creating Tables

3.5-Inserting Single Record

3.6-Practice - Inserting Single Record

3.7-Inserting Multiple Records

3.8-Practice - Inserting Multiple Records

3.9-Selecting Data

3.10-Practice - Selecting specific columns

3.11-Practice - Selecting all columns

3.12-Filtering Data

3.13-Practice - Filtering Data

3.14-Updating Data

3.15-Practice - Updating Data

3.16-Deleting Data

3.17-Practice - Deleting Data

3.18-Dropping Tables

3.19-Practice - Dropping Tables

3.20-Code Used During Demonstration

3.21-Challenge 1 - Introduction to SQL Statements

3.22-Challenge 2 - Introduction to SQL Statements

4-Beginner - Querying Data

4.1-Querying Data - Overview

4.2-Select Clause Overview

4.3-Practice - Select Clause

4.4-Renaming Columns - Column Alias

4.5-Practice - Renaming Columns

4.6-Removing Duplicates - DISTINCT

4.7-Practice - Removing Duplicates - DISTINCT

4.8-FROM Clause Overview

4.9-Sorting Outputs by Single Column - ORDER BY

4.10-Practice - Sorting Outputs by Single Column

4.11-Sorting Outputs by Multiple Columns and Positions - ORDER BY

4.12-Practice - Sorting Outputs by Multiple Columns and Positions

4.13-Restricting number of records - LIMIT

4.14-Practice - Restricting number of records

4.15-Code Used During Demonstration

4.16-Challenge 1 - Querying Data

4.17-Challenge 2 - Querying Data

5-Beginner - Filtering Data

5.1-Introduction to Filtering Data

5.2-Filtering Using Mathematical Operators

5.3-Practice - Filtering Using Mathematical Operators

5.4-Filter Data Using BETWEEN Operator

5.5-Practice - Filter Data Using BETWEEN Operator

5.6-Filter Data Using Like Operator and Percentage Wildcard

5.7-Practice - Filter Data Using Like Operator and Percentage Wildcard

5.8-Filter Data Using Like Operator and Underscore Wildcard

5.9-Practice - Filter Data Using Like Operator and Underscore Wildcard

5.10-Filter Data Using Like Operator - Bringing It All Together

5.11-Practice - Filter Data Using Like Operator - Bringing It All Together

5.12-Filter Data Using IN Operator

5.13-Practice - Filter Data Using IN Operator

5.14-Filter Data Using Multiple Conditions - AND Operator

5.15-Practice - Filter Data Using Multiple Conditions - AND Operator

5.16-Filter Data Using Multiple Conditions - OR Operator

5.17-Practice - Filter Data Using Multiple Conditions - OR Operator

5.18-Filter Data Using Multiple Conditions - Bringing It All Together

5.19-Practice - Filter Data Using Multiple Conditions - Bringing It All Together

5.20-Filter Data Using Negative Conditions

5.21-Practice - Filter Data Using Negative Conditions

5.22-Filters in UPDATE and DELETE Statements

5.23-Practice - Filters in UPDATE and DELETE Statements

5.24-Code Used During Demonstration

5.25-Challenge 1 - Filtering Data

5.26-Challenge 2 - Filtering Data

6-Intermediate - Simple SQL Functions

6.1-SQL Functions - Overview

6.2-String Functions - UPPER, LOWER, CONCAT

6.3-Practice - String Functions UPPER, LOWER, CONCAT

6.4-String Functions - REPLACE, TRIM

6.5-Practice - String Functions - REPLACE, TRIM

6.6-String Functions - SUBSTR, INSTR, LENGTH

6.7-Practice - String Functions - SUBSTR, INSTR, LENGTH

6.8-Math Functions

6.9-Practice - Math Functions

6.10-Nested Function Calls

6.11-Practice - Nested Function Calls

6.12-Code Used During Demonstration

6.13-Challenge 1 - Simple SQL Functions

6.14-Challenge 2 - Simple SQL Functions

7-Intermediate - Conditional Functions & Expressions

7.1-Conditional Functions - IIF

7.2-Practice - Conditional Functions - IIF

7.3-Simple CASE Expression

7.4-Practice - Simple CASE Expression

7.5-Searched CASE Expression

7.6-Practice - Searched CASE Expression

7.7-Introduction to NULLs

7.8-Practice - Introduction to NULLs

7.9-Conditional Functions - IFNULL

7.10-Practice - Conditional Functions - IFNULL

7.11-Conditional Functions - COALESCE

7.12-Practice - Conditional Functions - COALESCE

7.13-Conditional Functions - NULLIF

7.14-Practice - Conditional Functions - NULLIF

7.15-Code Used During Demonstration

7.16-Challenge 1 - Conditional Functions & Expressions

7.17-Challenge 2 - Conditional Functions & Expressions

8-Intermediate - Date Functions

8.1-Introduction to Date Functions

8.2-Transforming Date & Time

8.3-Practice - Transforming Date & Time

8.4-Formatting Date & Time

8.5-Practice - Formatting Date & Time

8.6-Bringing it all together

8.7-Practice - Bringing it all together

8.8-Code Used During Demonstration

8.9-Challenge 1 - Date Functions

9-Intermediate - Aggregate Functions

9.1-Introduction to Aggregate Functions

9.2-Practice - Introduction to Aggregate Functions

9.3-Aggregate Functions and NULLs

9.4-Practice - Aggregate Functions and NULLs

9.5-Aggregate Functions - COUNT

9.6-Practice - Aggregate Functions - COUNT

9.7-Aggregate Functions - COUNT DISTINCT

9.8-Practice - Aggregate Functions - COUNT DISTINCT

9.9-Grouping Records

9.10-Grouped Aggregates (Single Column Groups)

9.11-Practice - Grouped Aggregates (Single Column Groups)

9.12-Grouped Aggregates (Multiple Column Groups)

9.13-Practice - Grouped Aggregates (Multiple Column Groups)

9.14-Having Clause

9.15-Practice - Having Clause

9.16-Order of Execution

9.17-Practice - Order of Execution

9.18-Code Used During Demonstration

9.19-Challenge 1 - Aggregate Functions

9.20-Challenge 2 - Aggregate Functions

10-Intermediate - SQL Joins

10.1-Introduction to Joins

10.2-Introduction to Inner Join

10.3-Practice - Introduction to Inner Join

10.4-An intuition to Inner Join

10.5-Cartesian Product from Joins

10.6-Practice - Cartesian Product from Join

10.7-Introduction to Outer Join

10.8-Left Outer Join

10.9-Practice - Left Outer Join

10.10-Right Outer Join

10.11-Practice - Right Outer Join

10.12-Full Outer Join

10.13-Practice - Full Outer Join

10.14-Inner Join with Filters

10.15-Practice - Inner Join with Filters

10.16-Outer Join with Filters

10.17-Practice - Left Outer Join with Filters

10.18-Practice - Right Outer Join with Filters

10.19-Code Used During Demonstration

10.20-Challenge 1 - SQL Joins

10.21-Challenge 2 - SQL Joins

10.22-Challenge 3 - SQL Joins

11-Intermediate - Managing Tables

11.1-Managing Tables - Section Overview

11.2-SQL Constraints Overview

11.3-SQL Constraints Demo

11.4-Practice - NOT NULL Constraints

11.5-Practice - CHECK Constraints

11.6-Practice - UNIQUE Constraints

11.7-Practice - DEFAULT Constraints

11.8-Primary Key, Foreign key & Relationships Overview

11.9-Primary Key, Foreign key & Relationships Demo

11.10-Practice - Primary Key

11.11-Practice - Foreign Key Relationships

11.12-Alter Table

11.13-Practice - Alter Table

11.14-Drop Table

11.15-Code Used During Demonstration

11.16-Challenge 1

12-Project - Requirements & Database Design

12.1-Project Requirements

12.2-Database Design

12.3-Data Modelling

12.4-Creating & Populating Tables

12.5-Practice - Create Table Venue

12.6-Practice - Create Table Team

12.7-Practice - Create Table Player

12.8-Practice - Create Table Match

12.9-Practice - Create Table Innings

12.10-Practice - Create Table Score By Ball

12.11-Practice - Create Table Result

12.12-Code Used During Demonstration

13-Project - SQL Queries for the Website

13.1-Section Overview

13.2-Match Summary

13.3-Practice - Match Summary

13.4-Innings Summary - Total Runs & Wickets

13.5-Practice - Innings Summary - Total Runs & Wickets

13.6-Innings Summary - Total Overs

13.7-Practice - Innings Summary - Total Overs

13.8-Batting Scorecard - Player Level

13.9-Practice - Batting Scorecard - Player Level

13.10-Batting Scorecard - Team Level

13.11-Practice - Batting Scorecard - Team Level

13.12-Bowling Scorecard - Player Level

13.13-Practice - Bowling Scorecard - Player Level

13.14-Code Used During Demonstration

14-Advanced - Subqueries

14.1-Introduction to Subqueries

14.2-Practice - Introduction to Subqueries

14.3-Multiple Row / Column Subqueries

14.4-Practice - Multiple Row Subqueries

14.5-Practice - Multiple Column Subqueries

14.6-Introduction to Subquery in the FROM Clause

14.7-Practice - Introduction to Subquery in the FROM Clause

14.8-Real Use Case for Subquery in the FROM Clause

14.9-Practice - Real Use Case for Subquery in the FROM Clause

14.10-Correlated Subquery

14.11-Practice - Correlated Subquery

14.12-Code Used During Demonstration

14.13-Challenge 1 - Subqueries

14.14-Challenge 2 - Subqueries

15-Advanced - Common Table Expressions (CTEs)

15.1-Introduction to Common Table Expressions (CTEs)

15.2-Practice - Introduction to CTEs

15.3-Multiple CTEs in a Query

15.4-Practice - Multiple CTEs in a Query

15.5-Code De-Duplication using CTEs

15.6-Practice - Code De-Duplication using CTEs

15.7-Code Used During Demonstration

15.8-Challenge 1 - Common Table Expressions (CTEs)

15.9-Challenge 2 - Common Table Expressions (CTEs)

16-Advanced - Views

16.1-Introduction to Views

16.2-Views to Simplify Transformation Logic

16.3-Practice - Views to Simplify Transformation Logic

16.4-Views to Simplify Subqueries/ CTEs

16.5-Views to Simplify Subqueries/ CTEs

16.6-Views to Simplify Joins

16.7-Views to Simplify Joins

16.8-Code Used During Demonstration

16.9-Challenge 1 - Views

17-Advanced - Window Functions

17.1-Introduction to Window Functions

17.2-OVER Clause

17.3-Practice - Over Clause

17.4-PARTITION BY Clause

17.5-Practice - PARTITION BY Clause

17.6-ORDER BY Clause

17.7-Practice - ORDER BY Clause

17.8-PARTITION BY & ORDER BY Clauses Together

17.9-Practice - PARTITION BY & ORDER BY Clauses Together

17.10-Analytical Functions

17.11-Practice - Analytical Functions - LAG

17.12-Practice - Analytical Functions - LEAD

17.13-Ranking Functions - RANK & DENSE_RANK

17.14-Practice - Ranking Functions - RANK & DENSE RANK

17.15-Ranking Functions - ROW_NUMBER

17.16-Practice - Ranking Functions - ROW_NUMBER

17.17-Ranking Functions - NTILE

17.18-Practice - Ranking Functions - NTILE

17.19-Introduction to Window Frames

17.20-Calculate Rolling Totals using Window Frames

17.21-Practice - Calculating Rolling Totals

17.22-Code Used During Demonstration

17.23-Challenge 1 - Window Functions

17.24-Challenge 2 - Window Functions

17.25-Challenge 3 - Window Functions

18-Next Steps

18.1-Good Luck

18.2-Bonus Lecture

Course Categories

Popular Courses

Comprehensive SQL Course For Data Professionals [2024]

Description

What you'll learn

Requirements

Course Content

You May Like