Animated SQl for Beginners

Course Curriculum

Chapter 1: SECTION 1

Lecture 1: Introdution

Lecture 2: How to Use Resource Material

Chapter 2: SECTION 2

Lecture 1: How to Create a Database

Lecture 2: How to Create Table in a Database

Lecture 3: How to Select records from a table.

Lecture 4: Playing with Tables using CREATE, INSERT & SELECT

Lecture 5: Select Statement problem

Lecture 6: What is a String

Lecture 7: How to perform Calculation using arithmetic operators

Chapter 3: SECTION 3

Lecture 1: Filter Out Records From a Table.

Lecture 2: Using Where Statement : Solution

Lecture 3: Calculations with Where Statement : Solution

Lecture 4: Select Records Between a range

Lecture 5: Comparison Operators

Lecture 6: In Operator

Lecture 7: How to Update records in a table.

Lecture 8: Updating Records in a Table : Solution

Lecture 9: How to Delete a record for a table.

Lecture 10: Deleting Rows from table : Solution

Chapter 4: SECTION 4

Lecture 1: Database Design

Lecture 2: Create Primary Key

Lecture 3: Create Foreign Key

Lecture 4: Foreign Key : Solution

Chapter 5: SECTION 5

Lecture 1: How to Select Records from Both the tables.

Lecture 2: Joining : Solution

Lecture 3: How to select the common records from both the tables.

Lecture 4: Inner Joins : Solution

Lecture 5: Select all the records from left side table and the matching records Right table

Lecture 6: More on join : Solution

Lecture 7: Select all the records from Right side table and the matching records Left table

Lecture 8: Select all the records from both the tables.

Lecture 9: Does order of Tables across Joins Matters.

Lecture 10: Filter Records Returned By Join

Lecture 11: Apply join on more than one table.

Lecture 12: Three way Join : Solution

Chapter 6: SECTION 6

Lecture 1: How to Group Records in a table.

Lecture 2: Aggregate Functions

Lecture 3: Grouping and Aggregating : Solution

Lecture 4: Grouping with Join : Solution

Lecture 5: Filtering out the Groups returned by Group By

Lecture 6: Exercise on Having : Solution

Lecture 7: Practicing with Group By : Solution

Chapter 7: SECTION 7

Lecture 1: Sorting the Records in a Table

Lecture 2: More complex use of Where Statement

Lecture 3: Sorting Exercise : Solution

Lecture 4: Limit the records returned by Select Statement

Chapter 8: SECTION 8

Lecture 1: UNION

Lecture 2: Merging with Unions : Solution

Lecture 3: INTERSECT

Chapter 9: SECTION 9

Lecture 1: Sub Query

Lecture 2: Embedding in Select : Solution

Lecture 3: Subquery using Where : Solution

Lecture 4: More on Subqueries : Solution

Lecture 5: Subquery without From & Where : Solution

Lecture 6: Correlated Query

Chapter 10: SECTION 10

Lecture 1: Select Distinct Records

Lecture 2: Distinct Exercise : Solution