Certification training

SQL and PostgreSQL: Introductions Course for Beginners

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

58Lectures
5h 5m 34sDuration
Vendor
SQL and PostgreSQL: Introductions Course for Beginners course cover Best seller
certification training 58 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

6 sections, 58 lessons, and lecture-level duration details.

01 Section Introduction 1m 14s
02 Databases and SQL 3m 25s
03 Installing PostgreSQL 6m 1s
04 Setting Up the Database 10m 34s

01 Section Introduction 2m 10s
02 Select 5m 32s
03 Select Where 6m 12s
04 Multiple Wheres 9m 36s
05 Solution 1: Selecting From a Table 3m 46s
06 In, Not In 7m 21s
07 Between 5m 31s
08 CODE: SQL for BETWEEN 7m 40s
09 Like 5m 46s
10 Solution 2: Selecting From a Table 7m 31s
11 Order By 6m 4s
12 Limiting Number of Results 5m 25s
13 Distinct 5m 6s
14 Setting a Column Name Alias 4m 32s

01 Section Introduction 54s
02 Joins in SQL 2m 24s
03 Inner Join Part 1 4m 4s
04 Inner Join Part 2 3m 35s
05 Solution 1: Selecting from Multiple Tables 3m 59s
06 Left Join 3m 3s
07 Right Join 11m 44s
08 Full Join 3m 45s
09 Solution 2: Selecting from Multiple Tables 5m 59s
10 Joining More Than Two Tables 13m 47s
11 Union 11m 34s
12 Solution 3: Selecting from Multiple Tables 6m 30s

01 Section Introduction 54s
02 What are Aggregate Functions 2m 24s
03 Count 4m 4s
04 Min and Max 3m 35s
05 Sum 3m 59s
06 Average 3m 3s
07 Group By 11m 44s
08 Having 3m 45s
09 Solution: Aggregate Functions 5m 59s

01 Section Introduction 1m
02 What is Data Definition Language? 1m 23s
03 Data Types 7m 54s
04 Primary Keys 3m
05 Foreign Keys 2m 50s
06 Creating Tables: Part 1 10m 39s
07 Creating Tables: Part 2 8m 51s
08 Solution 1: Data Definition Language 3m 41s
09 Modifying Tables: Adding and Removing Columns 5m 29s
10 Modifying Tables: Modifying Columns 10m 12s
11 Removing Tables 1m 42s
12 Deleting All Rows from Tables 1m 58s
13 Solution 2: Data Definition Language 3m 35s

01 Section Introduction 36s
02 What is Data Manipulation Language? 56s
03 Inserting Data into Tables 9m 16s
04 Updating Data in Tables 7m 44s
05 Deleting Data from Tables 4m 31s
06 Solution: Data Manipulation Language 6m 6s
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.