SQL – The Query Writing Bootcamp [2019]

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: ORACLE Live SQL – Registration

Lecture 3: Lecture 3: Resources

Chapter 2: Creating Table & Relational Database in SQL

Lecture 1: How to CREATE a Table in SQL

Lecture 2: ALTER, UPDATE, DELETE in SQL

Lecture 3: CREATE TABLE: Book Challange

Lecture 4: CREATE Book Table

Lecture 5: CREATE TABLE: Editor Challange

Lecture 6: CREATE Editor Table

Lecture 7: CREATE TABLE: Rating Challange

Lecture 8: CREATE Rating Table

Lecture 9: How To Load The Database in ORACLE Live SQL

Lecture 10: Section 1 Review: CREATE Tables

Chapter 3: SQL SELECT Statemet

Lecture 1: SELECT Statement

Lecture 2: SELECT FROM WHERE

Lecture 3: Practice 1: Solutions

Lecture 4: Comparison Operators

Lecture 5: Practice 2: Comparison Operators Solutions

Lecture 6: AND Operator

Lecture 7: Practice 3: AND Operator Soultions

Lecture 8: OR Condition

Lecture 9: Practice 4: OR Condition Solutions

Lecture 10: NOT Condition

Lecture 11: Practice 5: NOT Condition Solutions

Lecture 12: BETWEEN Condition

Lecture 13: Practice 6: BETWEEN Condition Solutions

Lecture 14: LIKE Condition

Lecture 15: Practice 7: LIKE Condition Solutions

Lecture 16: Section 2: The SELECT Statement Conclusion

Chapter 4: Aggregate Functions Part 1

Lecture 1: Aggregate Functions Introduction

Lecture 2: AVERAGE

Lecture 3: COUNT

Lecture 4: MAX & MIN

Lecture 5: SUM

Lecture 6: Practice 8: Solutions

Chapter 5: Aggregate Functions Part 2: GROUP BY and ORDER BY

Lecture 1: GROUP BY: Aggregate Functions

Lecture 2: Practice 9: Solutions

Lecture 3: ORDER BY: Aggregate Functions

Lecture 4: ORDER BY: Practice 10 Solutions

Lecture 5: Aggregate Functions Conclusion

Chapter 6: JOINS: Aggregate Functions

Lecture 1: Introduction to JOIN's

Lecture 2: JOIN Lesson One

Lecture 3: Practice 11: JOIN's Lesson One Solution

Lecture 4: JOIN's Lesson Two: Practice 12

Lecture 5: JOIN's Lesson Three: Practice 13

Lecture 6: JOIN's Lesson Three: Practice 13 Solutions

Lecture 7: JOIN's Lesson Four: Practice 14

Lecture 8: JOIN's Lesson Four: Practice 14 Solution – Query 1

Lecture 9: JOIN's Lesson Four: Practice 14 Solution – Query 2

Lecture 10: JOIN's Lesson Four: Practice 14 Solution – Query 3 & 4

Lecture 11: JOIN's Lesson Six: Practice 15

Lecture 12: JOIN's Lesson Six: Practice 15 Solution – Query 1

Lecture 13: JOIN's Lesson Six: Practice 15 Solution – Query 2

Lecture 14: JOIN's Lesson Six: Practice 15 Solution – Query 3

Lecture 15: JOIN's Lesson Six: Practice 15 Solution – Query 4

Lecture 16: JOIN's Lesson Six: Practice 15 Solution – Query 5

Chapter 7: Special Features in SQL

Lecture 1: Aliases

Lecture 2: Aliases 2

Lecture 3: Concatenate

Lecture 4: LENGTH

Lecture 5: SYSDATE

Chapter 8: Course Conclusion

Lecture 1: Additional Practice

Lecture 2: Thank You!