Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL DATABASE
Section 1: Introduction
Course Overview (20:02)
What Is SQL (10:40)
Who Uses SQL In RealTime (6:56)
DBMS & TABLES (9:24)
Types of SQL commands (7:14)
DML & DQL COMMANDS (5:14)
DCL & TCC COMMANDS (11:24)
WHY POSTGRESQL (7:57)
Section 2: Installation and getting started
Installing and setting up PostgreSQL (10:36)
MYSQL Installation Process
Section 4: Fundamental SQL statements
Creation of Database In Postgre SQL (7:40)
Create of Table Overview (9:00)
Primary Key & Foreign Key Constraints (8:39)
Creation of Table Implementation (8:30)
Assignment-1 (2:31)
How To Insert Data Into Tables Overview (7:05)
How To Insert Data Into Tables Implementation (12:30)
How To Work With COPY Statement. (10:07)
Assignment-2 (5:40)
How To Work With SELECT Statement. (8:45)
How To Work With DISTINCT SELECT Statement. (6:43)
How To Work With WHERE Clause (10:00)
Logical Operator In SQL (8:05)
NOT CONDITION IN SQL (7:00)
Assignment-3 (5:08)
How To Work With UPDATE Query (15:23)
How To Work With DELETE Query (5:57)
How To Work With ALTER Query (8:08)
COLUMN – MODIFY & RENAME (6:07)
CONSTRAINT – ADD & DROP (16:09)
Assignment-4 (3:20)
Section 5: Restore and Back-up
How To Restore Data (9:54)
How To Take Back-up (4:23)
Assignment - 5 (2:33)
Section 6: Selection commands: Filtering
IN (8:03)
BETWEEN (11:29)
LIKE (22:49)
Assignment - 6 (4:48)
Section 7: Selection commands: Ordering
ORDER BY (11:52)
LIMIT (5:58)
ASSIGNMENT - 7 (3:28)
Section 8: Alias
ALIAS KEYWORD (5:37)
Section 9: Aggregate Commands
COUNT (16:39)
SUM (6:41)
AVERAGE (7:48)
MIN & MAX (11:23)
ASSIGNMENT - 8 (3:30)
Section 10 : COMMENTING IN SQL
Commenting In SQL (5:22)
Group By Commands
GROUP BY (21:10)
GROUP BY CLAUSE ADVANCED FEATURES (12:06)
HAVING (13:50)
ASSIGNMENT - 9 (3:52)
Conditional Statement
CASE WHEN (8:39)
JOINS
Introduction to Joins (13:02)
Inner Join (24:57)
left Join (28:08)
Right Join (10:37)
Full Outer Join (15:51)
Cross Join (14:20)
Except (6:52)
Union (8:28)
Exercise 10: Joins
Quiz
Subqueries
Subqueries In Where (18:28)
Subqueries In From (18:53)
Subqueries In Select (4:46)
Exercise 11: Subqueries
Views and Indexes
VIEWS (17:07)
INDEX (15:55)
Exercise 12: Views
String Functions
STRING FUNCTIONS INTRODUCTION (2:57)
LENGTH (5:55)
UPPER LOWER FUNCTIONS (3:30)
REPLACE (7:26)
TRIM, LTRIM, RTRIM (8:40)
CONCATENATION (4:44)
SUBSTRING (9:35)
STRING AGGREGATION (8:13)
Exercise 13: String Functions
Mathematical Functions
CEIL & FLOOR (6:14)
RANDOM (10:45)
SETSEED (6:08)
ROUND (4:14)
POWER (4:20)
Exercise 14: Mathematical Functions
Date-Time Functions
CURRENT DATE & TIME (7:32)
AGE (7:37)
EXTRACT (8:07)
Exercise 15: Date-time functions
Data Type Conversion Functions
Converting Numbers to String (9:34)
Converting Date To String (4:56)
Converting String To Date (5:52)
Converting String To Number (4:14)
User Access Control Functions
User Access Control
DCL & TCC COMMANDS
Complete and Continue