In this video, we’ll explore the fundamental differences between a database and a Relational Database Management System (RDBMS). You'll then cover the core concepts of SQL, learning how to create, read, update, and delete data efficiently. We’ll guide you through hands-on practices with MySQL, including installation and practical use cases. You'll also learn advanced topics like subqueries, Oracle SQL, and PostgreSQL. Finally, you’ll apply your skills to real-world projects, including a Broadband DBMS and the integration of Generative AI techniques. Watch now to enhance your database management skills!
Learn techniques to organize and manage large datasets for data science in our free SQL for Data Science course. Gain hands-on experience using Python for SQL queries in real Data Science projects. Enroll now! https://www.mygreatlearning.com/academy/learn-for-free/courses/sql-for-data-science?utm_source=CPV_YT&utm_medium=Desc&utm_campaign=SQLTutfrBgnnrs_2024
Earn an MS in Analytics from the University of Arizona without GRE/TOEFL, save up to ₹55+ lakhs, and get up to 3 years STEM OPT VISA. Grab the chance—apply today! https://www.mygreatlearning.com/masters-in-business-analytics-hybrid?utm_source=CPV_YT&utm_medium=PPDesc1&utm_campaign=SQLTutfrBgnnrs_2024
Advance your career with our PG Program in Software Development and Engineering. Grab this opportunity and apply today! https://www.mygreatlearning.com/pg-program-software-engineering-course?utm_source=CPV_YT&utm_medium=PPDesc2&utm_campaign=SQLTutfrBgnnrs_2024
🏁 Topics Covered:
00:00:00 - Introduction
00:01:48 - Introduction to SQL
00:11:40 - Difference between DBMS and RDBMS
00:17:57 - Introduction to SQL
00:18:44 - Types of Data Models
00:27:07 - Advantges of DBMS
00:27:54 - RDBMS in detail
00:29:42 - Features of RDBMS
00:32:54 - Normalization
00:58:41 - SQL Constraints
01:05:04 - Data Definition Language
01:31:29 - Transaction Control
01:34:03 - SQL Operators
02:10:05 - SQL UNION
02:17:50 - SQL UNION ALL
02:20:24 - SQL Joins
02:50:00 - Demo of all the Joins
03:50:33 - Installing MySQL
03:51:23 - Data Types in MySQL
03:53:09 - String Data Types in MySQL
03:56:20 - Types of Commands in MySQL - DDL
04:21:25 - Types of Commands in MySQL - DQL
04:24:39 - Types of Commands in MySQL - DCL
04:34:18 - CASE Statement in MySQL
04:47:49 - Views in MySQL
04:54:54 - Execution of Subqueries in MySQL
05:12:25 - Introduction to Oracle SQL
05:29:01 - Creation of Table in Oracle SQL
05:38:03 - Oracle Database Edition
05:56:03 - Relational Model in Oracle SQL
06:07:38 - Projection in Oracle SQL
06:12:09 - Case Sensitivity in SQL
06:24:22 - Demo on Oracle
06:43:41 - introduction to PostgreSQL
06:55:17 - Installation of PostgreSQL
07:26:10 - Demo of using PostgreSQL
07:34:05 - Case study with a project in MySQL
07:48:03 - MySQL Workbench and its Demo
08:12:37 - Demo with tables in the project
08:46:40 - Start range and End range in queries
09:06:40 - Substring function in the Project
09:56:47 - Joins usage in the Project
10:11:48 - Generative AI in SQL
10:12:30 - Generative AI simplifies database work
10:14:00 - Benefits of Gen AI in SQL
10:18:41 - Introduction to GitHub
10:21:16 - Introduction to GitHub Copilot
10:35:25 - Demo on the version
10:37:24 - Visual Studio Code
10:47:02 - Creating Files
10:54:44 - GitHub Copilot Chat
11:01:32 - Conclusion
🔥1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?utm_source=CPV_YT&utm_medium=Desc&utm_campaign=YTVids2024
⚡ About Great Learning Academy:
Visit Great Learning Academy to get access to 1000+ free courses with free certificates on Data Science, Data Analytics, Digital Marketing, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development, and many more. These courses are supplemented with free projects, assignments, datasets, and quizzes. At the end of the course, you can earn a certificate of completion for free.
⚡ About Great Learning:
With more than 11 Million+ learners in 170+ countries, Great Learning is a leading global edtech company for professional and higher education offering industry-relevant programs in the blended, classroom, and purely online modes across technology, data, and business domains. These programs are developed in collaboration with top institutions like Stanford Executive Education, MIT Professional Education, Wharton, University of Arizona, Northwestern University, The University of Texas at Austin, NUS, Microsoft & more.
SOCIAL MEDIA LINKS:
🔹 For more interesting tutorials, don't forget to subscribe to our channel: https://glacad.me/YTsubscribe
🔹 For more updates on courses and tips follow us on:
✅ Telegram: https://t.me/GreatLearningAcademy
✅ Facebook: https://www.facebook.com/GreatLearningOfficial/
✅ LinkedIn: https://www.linkedin.com/school/great-learning/mycompany/verification/
✅ Follow our Blog: https://glacad.me/GL_Blog