arrow_back
Must Read Information
Introduction
IntroV_01
Course Overview
Files_sql
Installation and Getting Started
Lecture_1
Installing and setting up PostgreSQL
Case Study : Demo
Case Study Part 1
Case Study Part 2
Fundamental SQL Statements
CREATE
Exercise 1 Create Db And Table
INSERT
Import data from File
Lecture_06_INSERT and COPY
Exercise 2: Inserting and Importing
Student
SELECT statement
Lecture_07_SELECT _ DISTINCT
SELECT DISTINCT
Lecture_08_WHERE
WHERE
Logical Operators
Exercise 3: SELECT & WHERE
Lecture_10_UPDATEDelete
UPDATE
DELETE
Lecture_11_ALTER
ALTER
Exercise 4: Updating Table
Restore and Backup
Restore and Back-up
Data
Supermart_DB_new
Debugging restoration issues
Creating DB using CSV files
Exercise 5: Restore and Back-up
Selection Commands : Filtering
Lecture_12_IN_12
IN
Lecture_13_BETWEEN
BETWEEN
Lecture_14_LIKE
LIKE
Exercise 6: In, Like & Between
Selection Commands : Ordering
Side Lecture: Commenting in SQL
Lecture_15_ORDER BY
ORDER BY
Lecture_16_LIMIT
LIMIT
Exercise 7: Sorting
Alias
Lecture_17_AS
AS
Aggregate Commands
Lecture_18_count
COUNT
Lecture_19_SUM
SUM
Lecture_20_AVG
AVERAGE
Lecture_21_MIN_MAX
MIN & MAX
Exercise 8: Aggregate functions
Group By Commands
GROUP BY
Lecture_23_HAVING
HAVING
Lecture_22_group by
Exercise 9: Group By
Conditional Statement
Lecture_CASE
CASE WHEN
JOINS
Concepts of Joining and Combining Data
041 Introduction To Joins-26
Preparing the data
Lecture_24_INNER join
Inner Join
Lecture_25_LEFT join
Left Join
Lecture_26_RIGHT join
Right Join
Lecture_27_OUTER join
Full Outer Join
Lecture_28_Cross join
Cross Join
Intersect and Intersect ALL
Lecture_29_EXCEPT
Except
Lecture_30_UNION
Union
Exercise 10: Joins
Subqueries
Lecture_Create_Queries_2
Lecture_31_SUBQUERY
Subqueries
051 Exercise 11 Subqueries-34
Views and Indexes
Lecture_32_VIEWS
VIEWS
Lecture_33_INDEX
INDEX
Exercise 12: Views
String Functions
LENGTH
UPPER LOWER
REPLACE
TRIM, LTRIM, RTRIM
CONCATENATION
SUBSTRING
LIST AGGREGATION
Lecture_34_STRING functions
062 Exercise 13 String Functions-45
Mathematical Functions
CEIL & FLOOR
RANDOM
SETSEED
ROUND
POWER
Lecture_35_MATH functions
Exercise 14: Mathematical Functions
Date - Time Functions
Lecture_36_DATETIME functions
CURRENT DATE & TIME
AGE
EXTRACT
Exercise 15: Date-time functions
PATTERN (STRING) MATCHING
Lecture_Pattern_Matching
PATTERN MATCHING BASICS
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
Exercise 16: Pattern Matching
Data Type Conversion Functions
Lecture_Data_Types
Converting Numbers/ Date to String
Lecture_37_Conversion functions
Converting String to Numbers/ Date
User Access Control Functions
Lecture_38_ACCESS control
User Access Control
Bonus Section : Nail The Interview!
Lecture_TABLESPACE
Tablespace
Lecture_5_Keys
PRIMARY KEY & FOREIGN KEY
Lecture_ACID
ACID compliance
Lecture_TRUNCATE
Truncate
Performance Tuning Tips
Lecture_Performance_Tuning
TIP 1 (EXPLAIN)
TIP 2
TIP 3
TIP 4 (VACCUM)
TIP 5
TIP 6 (STRING FUNCTIONS)
TIP 7 (JOINS)
TIP 8 (SCHEMAS)
Bonus Section : Database Basics
Lecture_1
What Is SQL
Lecture_2
Tables and DBMS
Lecture_3_Queries
Types of SQL commands
Lecture_5_Postgresql
PostgreSQL
