Completed
- SQL Joins
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL Full Course with Generative AI for 2024 - Tutorial for Beginners
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - Introduction to SQL
- 3 - Difference between DBMS and RDBMS
- 4 - Introduction to SQL
- 5 - Types of Data Models
- 6 - Advantges of DBMS
- 7 - RDBMS in detail
- 8 - Features of RDBMS
- 9 - Normalization
- 10 - SQL Constraints
- 11 - Data Definition Language
- 12 - Transaction Control
- 13 - SQL Operators
- 14 - SQL UNION
- 15 - SQL UNION ALL
- 16 - SQL Joins
- 17 - Demo of all the Joins
- 18 - Installing MySQL
- 19 - Data Types in MySQL
- 20 - String Data Types in MySQL
- 21 - Types of Commands in MySQL - DDL
- 22 - Types of Commands in MySQL - DQL
- 23 - Types of Commands in MySQL - DCL
- 24 - CASE Statement in MySQL
- 25 - Views in MySQL
- 26 - Execution of Subqueries in MySQL
- 27 - Introduction to Oracle SQL
- 28 - Creation of Table in Oracle SQL
- 29 - Oracle Database Edition
- 30 - Relational Model in Oracle SQL
- 31 - Projection in Oracle SQL
- 32 - Case Sensitivity in SQL
- 33 - Demo on Oracle
- 34 - introduction to PostgreSQL
- 35 - Installation of PostgreSQL
- 36 - Demo of using PostgreSQL
- 37 - Case study with a project in MySQL
- 38 - MySQL Workbench and its Demo
- 39 - Demo with tables in the project
- 40 - Start range and End range in queries
- 41 - Substring function in the Project
- 42 - Joins usage in the Project
- 43 - Generative AI in SQL
- 44 - Generative AI simplifies database work
- 45 - Benefits of Gen AI in SQL
- 46 - Introduction to GitHub
- 47 - Introduction to GitHub Copilot
- 48 - Demo on the version
- 49 - Visual Studio Code
- 50 - Creating Files
- 51 - GitHub Copilot Chat
- 52 - Conclusion
