Course overview
8 sections • 27 topics • 2 hrs 26 mins
1. Introduction
9 mins
2. SQL Foundation
37 mins
Understanding SQL structure
Start Learning
Installation and setup
Start Learning
Data type in SQL
Start Learning
Creating database and table in pgAdmin
Start Learning
Creating table in database
Start Learning
3. CRUD Operations
22 mins
Insert value in table
Start Learning
Practice test One
Start Learning
Update and delete values from table
Start Learning
4. Table Operations & SQL Statements
12 mins
Table related operations
Start Learning
Statments in SQL language
Start Learning
Code comments (Ignoring lines while code runs)
Start Learning
5. Filtering & Operators
12 mins
Like Operator and Wild Card
Start Learning
Limit claus
Start Learning
6. SQL Functions
7 mins
Functions in SQL
Start Learning
Sum And Avg functions in SQL
Start Learning
7. Joins
25 mins
Understanding JOINS
Start Learning
Inner Join
Start Learning
Left Join
Start Learning
Right and Full Join
Start Learning
Union
Start Learning
8. Subquery
18 mins
Subquery using WHERE
Start Learning
Subquery using IN
Start Learning
Import CSV File into Database
Start Learning
Conclusion
Start Learning
