1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?ambassador_code=GLYT_DES_Top_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Top_SEP22
Build a career in Data Science & Business Analytics https://www.mygreatlearning.com/pg-program-data-science-and-business-analytics-course?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP53
Here is the SQL Tutorial For Beginners to help you take that first step to learn SQL right from scratch! Technology is taking the world by storm, and a variety of its disciplines have evolved in this era of information! One such field is Structured Query Language, better known in its abbreviated form SQL, a programming language used to manage data in Database Management Systems.
With the amount of data increasing exponentially by the day, its management becomes extremely crucial, and that's where SQL enters! Data in its raw form is more often than not incomprehensible and requires to be organized to be made sense of. SQL involves organization, manipulation, retrieval and storage of data in relational databases.
Great Learning brings you this 9-hour long tutorial on SQL for beginners to take you from the starting point through the finishing point of everything you need to know about SQL and getting started on the journey to master it. This video starts by guiding you through the installation process of MySQL, understanding DBMS, its history, types, advantages and associated key concepts. Following this, the video teaches SQL and its key functions and concepts by carrying out simultaneous demonstrations on MySQL, with a brief introduction to Python.
Topics Covered:
00:00:00 Introduction
00:01:49 How to Install MySQL Workbench
00:12:44 Introduction To Database Management System
00:22:23 What is Relational Database Management System
00:28:30 Key Concepts in Relational Database Management System
00:39:12 Normalization Technique
00:48:22 What is ER Diagram?
01:12:32 What is SQL and Getting Started with MySQL
01:17:42 Types of Commands in MYSQL
01:57:23 Filter Records in MySQL
01:57:55 Operators in MySQL
02:13:23 Pattern Matching in MYSQL
02:24:24 Null Values in MySQL
02:27:15 Group by and Having Concept in MYSQL
02:57:27 Functions in MySQL
02:58:28 Joins in MYSQL
04:06:23 Subquery in SQL
04:40:02 SQL Case Statement
04:53:12 View in MySQL
04:58:00 HR Database Management System
05:54:03 Broadband Database Management System
08:31:30 MySQL with Python
Check Our Free Courses with free certificate:
MySQL Basics Course: https://glacad.me/3z4qMxo
SQL Interview Questions and Answers: https://www.mygreatlearning.com/academy/learn-for-free/courses/sql-interview-questions-and-answers?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP22
SQL Projects for Beginners: https://www.mygreatlearning.com/academy/learn-for-free/courses/sql-projects-for-beginners?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP22
SQL for Data Science: https://www.mygreatlearning.com/academy/learn-for-free/courses/sql-for-data-science?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP22
SQL with Python: https://www.mygreatlearning.com/academy/learn-for-free/courses/sql-with-python?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP22
Advanced SQL: https://www.mygreatlearning.com/academy/learn-for-free/courses/advanced-sql?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP22
About Great Learning Academy:
Visit Great Learning Academy to get access to 1000+ free courses with free certificate on Data Science, Data Analytics, Digital Marketing, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development, and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free.
About Great Learning:
With more than 5.4 Million+ learners in 170+ countries, Great Learning, a part of the BYJU'S group, 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 the top institutions like Stanford Executive Education, MIT Professional Education, The University of Texas at Austin, NUS, IIT Madras, IIT Bombay & 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