Главная
Study mode:
on
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
Description:
Embark on a comprehensive 11-hour SQL tutorial designed for beginners in 2024, incorporating Generative AI techniques. Dive into the fundamentals of databases and Relational Database Management Systems (RDBMS), mastering core SQL concepts including data manipulation and querying. Gain hands-on experience with MySQL installation and practical applications, and explore advanced topics such as subqueries, Oracle SQL, and PostgreSQL. Apply your skills to real-world projects, including a Broadband DBMS, and learn to integrate Generative AI in database management. Cover essential topics like normalization, SQL constraints, joins, and data types, while also exploring tools like MySQL Workbench and GitHub Copilot. Perfect for aspiring data professionals looking to enhance their database management skills and stay current with the latest industry trends.

SQL Full Course with Generative AI for 2024 - Tutorial for Beginners

Great Learning
Add to list
#Programming #Domain-Specific Languages (DSL) #SQL #Databases #Relational Databases #MySQL #PostgreSQL #Database Design #Normalization #Oracle SQL
1 of 52

- Introduction