SQL
Topics for this course
SQL
-
07:43
-
Case study part 1
04:16 -
Case study part 2
03:39 -
Create
11:19 -
Exercise 1 create db and table
01:27 -
Insert
07:54 -
Import data from file
04:39 -
Exercise 2 inserting and importing
01:01 -
Select statement
03:32 -
Select distinct
05:09 -
Hands-On with Facebook Ads Quiz
-
Where
03:26 -
Logical operators
05:13 -
Exercise 3 : select and where
01:14 -
Update
04:30 -
Delete
03:39 -
Alter
14:22 -
Exercise 4 : updating table
00:59 -
Restore and Backup
06:22 -
Debugging Restoration
07:44 -
Creating db using csv files
05:20 -
Exercise 5 : Restore and Backup
00:50 -
in
03:41 -
Between
04:46 -
Like
07:45 -
Exercise 6 : in like between
00:48 -
Side lecture (commenting_in_sql)
01:14 -
Order by
06:06 -
Limit
02:56 -
Exercise 7 : sorting
00:47 -
as
03:12 -
Count
04:03 -
Sum
02:29 -
Average
02:32 -
Min and Max
03:28 -
Exercise 8 : Aggregate Functions
00:57 -
Group by
09:32 -
Having
03:59 -
Exercise 9 : Group by
01:09 -
Case when
04:43 -
Introduction to joins
02:23 -
Inner join
06:53 -
Left join
06:43 -
Right join
05:53 -
Full outer join
03:49 -
Cross joins
03:13 -
Except
02:37 -
Union
02:43 -
Exercise 10 : joins
01:09 -
Part 1 : subquery in where clause
03:57 -
Part 2 : Subquery in from clause
04:17 -
Part 3 : Subquery in select
03:34 -
Views
06:26 -
Index
06:05 -
Exercise 11 : views
00:41 -
String length
03:11 -
String upper and lower
01:43 -
String Replace
03:34 -
String trim
05:27 -
String concat
02:22 -
String substring
05:17 -
String stringaggregator
04:01 -
Exercise 12 : string function
02:12 -
Ceil floor
03:16 -
Random
04:32 -
Setseed
03:17 -
Round
02:17 -
Power
01:46 -
Exercise 13 : Mathematical function
01:23 -
Current date time
04:05 -
Date time (age)
03:29 -
Date time (extract)
06:36 -
Converting numbers date to string
08:44 -
Converting string to numbers date
04:18 -
ACID compliance
03:35 -
Average Function
05:18 -
colease
05:07 -
COUNT
03:05 -
Implementing Row Number in SQL
13:52 -
Introduction to Row Number
04:18 -
Introduction to Windows Function
07:41 -
LAG LEAD
05:49 -
m3_t1_v1_module_introduction
02:18 -
m3_t1_v2_joining_concepts
10:30 -
m3_t1_v3_preparing_data_for_joins
02:01 -
m3_t1_v9_intersect,_intersect_all,_union_all (1080p)
06:07 -
Ntile
05:07 -
Primary key Foreign key
04:24 -
Rank and Denserank
05:25 -
Running Total
05:41 -
SUM function
07:57 -
Tablespace
04:26 -
TIP 2
01:17 -
Tip 3
02:31 -
Tip 4 Vaccum
00:54 -
Tip 5 Truncate
01:56 -
Tip 6 String functions
02:04 -
Tip 7 Joins
01:46 -
Tip 8 Schemas
04:13 -
Truncate table
03:08 -
Tip 1
03:15
Description
This PostgreSQL course provides a complete, hands-on introduction to relational database management and SQL querying. Learners begin by installing and setting up PostgreSQL, followed by creating databases and tables, inserting and importing data, and performing CRUD operations. The course covers filtering, sorting, aggregation, grouping, joins, subqueries, and views. Advanced topics include string, mathematical, and date-time functions, indexing, backup and restore, ACID compliance, and performance tips. Learners also explore window functions, ranking, running totals, and keys. Real-world case studies and exercises build strong SQL skills for data analysis and backend development.
