Section 1 : Introduction

Lecture 1 Course Overview 3:42

Section 2 : Installation and getting started

Lecture 2 About Proctor Testing Pdf
Lecture 3 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 4 Installing and setting up PostgreSQL 9:31
Lecture 5 About Proctor Testing Pdf

Section 3 : Case Study Demo

Lecture 6 Case Study Part 1 9:31
Lecture 7 Case Study Part 2 6:17

Section 4 : Fundamental SQL statements

Lecture 8 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 9 Exercise 1 Create DB and Table 1:25
Lecture 10 Solutions to all Exercises Text
Lecture 11 INSERT 9:7
Lecture 12 Import data from File 4:59
Lecture 13 Exercise 2 Inserting and Importing 0:57
Lecture 14 SELECT statement 3:40
Lecture 15 SELECT DISTINCT 6:6
Lecture 16 WHERE 4:2
Lecture 17 Logical Operators 6:11
Lecture 18 Exercise 3 SELECT & WHERE 1:16
Lecture 19 UPDATE 5:25
Lecture 20 DELETE 4:12
Lecture 21 ALTER 17:21
Lecture 22 Exercise 4 Updating Table 1:4

Section 5 : Restore and Back-up

Lecture 23 Restore and Back-up 7:38
Lecture 24 About Proctor Testing Pdf
Lecture 25 About Certification Pdf
Lecture 26 If your restore fails, then Text
Lecture 27 Exercise 5 Restore and Back-up 0:51

Section 6 : Selection commands Filtering

Lecture 28 IN
Lecture 29 BETWEEN 5:41
Lecture 30 LIKE 8:52
Lecture 31 Exercise 6 In, Like & Between 0:51

Section 7 : Selection commands Ordering

Lecture 32 Side Lecture Commenting in SQL 1:21
Lecture 33 ORDER BY 7:42
Lecture 34 LIMIT 3:39
Lecture 35 Exercise 7 Sorting 0:48

Section 8 : Alias

Lecture 36 AS 3:33

Section 9 : Aggregate Commands

Lecture 37 COUNT 5:5
Lecture 38 SUM 3:25
Lecture 39 AVERAGE 2:53
Lecture 40 MIN & MAX 4:18
Lecture 41 Exercise 8 Aggregate functions 1:19

Section 10 : Group By Commands

Lecture 42 GROUP BY 11:45
Lecture 43 HAVING
Lecture 44 Exercise 9 Group By 1:14

Section 11 : Conditional Statement

Lecture 45 CASE WHEN 5:19

Section 12 : JOINS

Lecture 46 Introduction to Joins 2:19
Lecture 47 About Proctor Testing Pdf
Lecture 48 About Certification Pdf
Lecture 49 Inner Join 8:6
Lecture 50 Left Join 7:32
Lecture 51 Right Join 6:27
Lecture 52 Full Outer Join 4:59
Lecture 53 Cross Join
Lecture 54 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 55 Except 3:1
Lecture 56 Union 3:13
Lecture 57 Exercise 10 Joins 1:18

Section 13 : Subqueries

Lecture 58 Subqueries 14:29
Lecture 59 Exercise 11 Subqueries 1:21

Section 14 : Views and Indexes

Lecture 60 VIEWS 7:15
Lecture 61 INDEX 6:32
Lecture 62 Exercise 12 Views 0:47

Section 15 : String Functions

Lecture 63 LENGTH 3:26
Lecture 64 UPPER LOWER 2:11
Lecture 65 REPLACE 4:14
Lecture 66 TRIM, LTRIM, RTRIM 6:57
Lecture 67 CONCATENATION 2:56
Lecture 68 SUBSTRING 6:2
Lecture 69 LIST AGGREGATION 5:2
Lecture 70 Exercise 13 String Functions 2:28

Section 16 : Mathematical Functions

Lecture 71 CEIL & FLOOR 3:28
Lecture 72 RANDOM 5:7
Lecture 73 SETSEED 4:12
Lecture 74 ROUND 2:27
Lecture 75 POWER
Lecture 76 Exercise 14 Mathematical Functions 1:34

Section 17 : Date-Time Functions

Lecture 77 CURRENT DATE & TIME 4:25
Lecture 78 AGE 3:50
Lecture 79 EXTRACT 8:18
Lecture 80 Exercise 15 Date-time functions 1:24

Section 18 : PATTERN (STRING) MATCHING

Lecture 81 PATTERN MATCHING BASICS 7:39
Lecture 82 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 15:21
Lecture 83 Exercise 16 Pattern Matching 1:43

Section 19 : Data Type conversion functions

Lecture 84 Converting Numbers Date to String 10:46
Lecture 85 Converting String to Numbers Date 5:53

Section 20 : User Access Control Functions

Lecture 86 User Access Control

Section 21 : Bonus Section Nail that Interview!

Lecture 87 Tablespace 5:38
Lecture 88 PRIMARY KEY & FOREIGN KEY 5:3
Lecture 89 ACID compliance 5:57
Lecture 90 Truncate 3:54

Section 22 : Performance tuning tips

Lecture 91 TIP 1 (EXPLAIN) 4:3
Lecture 92 TIP 2 1:17
Lecture 93 TIP 3 2:33
Lecture 94 TIP 4 (VACCUM) 0:35
Lecture 95 TIP 5 2:0
Lecture 96 TIP 6 (STRING FUNCTIONS) 2:20
Lecture 97 TIP 7 (JOINS) 1:57
Lecture 98 TIP 8 (SCHEMAS) 4:51

Section 23 : Bonus Section Database Basics

Lecture 99 What is SQL 1:50
Lecture 100 Tables and DBMS 3:10
Lecture 101 Types of SQL commands 4:44
Lecture 102 PostgreSQL 2:30