Comprehensive SQL Course:Hands-on Project & Coding Exercises
- Description
- Curriculum
- FAQ
- Reviews
Welcome!
I am looking forward to helping you with learning SQL, one of the fundamental skills required to become a data professional. SQL is one of the important skill required to become data engineers, data analysts, data scientists, web developers, application developer etc.
This is a hand-on course with 120+ SQL coding exercises and a real world project of building a database for one of the popular sporting tournaments, Indian Premier League and writing all the SQL statements required for the scorecard of the tournament website.
No downloads or database installations required. I teach this SQL course using the Udemy’s coding exercises platform which comes with a database installed for you! You just need a web browser with any device (i.e., iPad, tablet, laptop) to practice SQL!
Once you have completed the course including all the SQL coding exercises and the project, I strongly believe that you will be in a position to start working in a real world data project using SQL.
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 by the end of the course you will be proficient in SQL.
Currently this course teaches you the following
-
Basics of SQL statements
-
Querying Data
-
Filtering Data
-
Simple SQL functions
-
Date Functions
-
Conditional Expressions & Functions
-
Aggregate Functions
-
Grouping Data
-
SQL Joins
-
SQL Constraints
-
Primary & Foreign Keys and Relationships
-
Database Design & Entity Relationship Diagrams
-
Subqueries
-
Common Table Expressions (CTEs)
-
Views
-
Window/ Analytical Functions
-
Working with a Real World Project
This course assumes no prior knowledge of SQL or any programming language. Once you complete the course, I genuinely believe that you will be in a position to confidently work in a real time project using SQL!
-
8Section OverviewVideo lesson
-
9Creating TablesVideo lesson
-
10Writing SQL Statement - Best PracticesVideo lesson
-
11Practice - Creating TablesQuiz
-
12Inserting Single RecordVideo lesson
-
13Practice - Inserting Single RecordQuiz
-
14Inserting Multiple RecordsVideo lesson
-
15Practice - Inserting Multiple RecordsQuiz
-
16Selecting DataVideo lesson
-
17Practice - Selecting specific columnsQuiz
-
18Practice - Selecting all columnsQuiz
-
19Filtering DataVideo lesson
-
20Practice - Filtering DataQuiz
-
21Updating DataVideo lesson
-
22Practice - Updating DataQuiz
-
23Deleting DataVideo lesson
-
24Practice - Deleting DataQuiz
-
25Dropping TablesVideo lesson
-
26Practice - Dropping TablesQuiz
-
27Code Used During DemonstrationText lesson
-
28Challenge 1 - Introduction to SQL StatementsQuiz
-
29Challenge 2 - Introduction to SQL StatementsQuiz
-
30Querying Data - OverviewVideo lesson
-
31Select Clause OverviewVideo lesson
-
32Practice - Select ClauseQuiz
-
33Renaming Columns - Column AliasVideo lesson
-
34Practice - Renaming ColumnsQuiz
-
35Removing Duplicates - DISTINCTVideo lesson
-
36Practice - Removing Duplicates - DISTINCTQuiz
-
37FROM Clause OverviewVideo lesson
-
38Sorting Outputs by Single Column - ORDER BYVideo lesson
-
39Practice - Sorting Outputs by Single ColumnQuiz
-
40Sorting Outputs by Multiple Columns and Positions - ORDER BYVideo lesson
-
41Practice - Sorting Outputs by Multiple Columns and PositionsQuiz
-
42Restricting number of records - LIMITVideo lesson
-
43Practice - Restricting number of recordsQuiz
-
44Code Used During DemonstrationText lesson
-
45Challenge 1 - Querying DataQuiz
-
46Challenge 2 - Querying DataQuiz
-
47Introduction to Filtering DataVideo lesson
-
48Filtering Using Mathematical OperatorsVideo lesson
-
49Practice - Filtering Using Mathematical OperatorsQuiz
-
50Filter Data Using BETWEEN OperatorVideo lesson
-
51Practice - Filter Data Using BETWEEN OperatorQuiz
-
52Filter Data Using Like Operator and Percentage WildcardVideo lesson
-
53Practice - Filter Data Using Like Operator and Percentage WildcardQuiz
-
54Filter Data Using Like Operator and Underscore WildcardVideo lesson
-
55Practice - Filter Data Using Like Operator and Underscore WildcardQuiz
-
56Filter Data Using Like Operator - Bringing It All TogetherVideo lesson
-
57Practice - Filter Data Using Like Operator - Bringing It All TogetherQuiz
-
58Filter Data Using IN OperatorVideo lesson
-
59Practice - Filter Data Using IN OperatorQuiz
-
60Filter Data Using Multiple Conditions - AND OperatorVideo lesson
-
61Practice - Filter Data Using Multiple Conditions - AND OperatorQuiz
-
62Filter Data Using Multiple Conditions - OR OperatorVideo lesson
-
63Practice - Filter Data Using Multiple Conditions - OR OperatorQuiz
-
64Filter Data Using Multiple Conditions - Bringing It All TogetherVideo lesson
-
65Practice - Filter Data Using Multiple Conditions - Bringing It All TogetherQuiz
-
66Filter Data Using Negative ConditionsVideo lesson
-
67Practice - Filter Data Using Negative ConditionsQuiz
-
68Filters in UPDATE and DELETE StatementsVideo lesson
-
69Practice - Filters in UPDATE and DELETE StatementsQuiz
-
70Code Used During DemonstrationText lesson
-
71Challenge 1 - Filtering DataQuiz
-
72Challenge 2 - Filtering DataQuiz
-
73SQL Functions - OverviewVideo lesson
-
74String Functions - UPPER, LOWER, CONCATVideo lesson
-
75Practice - String Functions UPPER, LOWER, CONCATQuiz
-
76String Functions - REPLACE, TRIMVideo lesson
-
77Practice - String Functions - REPLACE, TRIMQuiz
-
78String Functions - SUBSTR, INSTR, LENGTHVideo lesson
-
79Practice - String Functions - SUBSTR, INSTR, LENGTHQuiz
-
80Math FunctionsVideo lesson
-
81Practice - Math FunctionsQuiz
-
82Nested Function CallsVideo lesson
-
83Practice - Nested Function CallsQuiz
-
84Code Used During DemonstrationText lesson
-
85Challenge 1 - Simple SQL FunctionsQuiz
-
86Challenge 2 - Simple SQL FunctionsQuiz
External Links May Contain Affiliate Links read more