SQL Tutorial for Beginners 2023 | MySQL Basics for Beginners | MySQL Full Course | DBMS | RDBMS
🔥Free Certificate course on SQL: https://www.mygreatlearning.com/academy/learn-for-free/courses/mysql-basics?ambassador_code=GLYT_DES_udVSuvnukYQ&utm_source=GLYT&utm_campaign=GLYT_DES_udVSuvnukYQ
🔥Build a career in Data Science & Business Analytics: https://www.mygreatlearning.com/pg-program-data-science-and-business-analytics-course?ambassador_code=GLYT_DES_PG_udVSuvnukYQ&utm_source=GLYT&utm_campaign=GLYT_DES_PG_udVSuvnukYQ
SQL Tutorial for Beginners 2023 | MySQL Basics for Beginners | MySQL Full Course | DBMS | RDBMS
Hello and welcome to MySQL tutorial for beginners by Great Learning. Based on structured query language, MySQL is a relational database management system (RDBMS) created by Oracle (SQL). A systematic collection of data is called a database. Anything from a straightforward shopping list to a photo gallery or a location to store enormous volumes of information in a Corporate network.
This MySQL tutorial for beginners will help you understand the basics of MySQL, database fundamentals, and database management systems, with a little bit more focus on MSQL text tags. If you are a beginner, this video is a must-watch.
– Alias in SQL aid us in providing alternate temporary names to the tables and columns in a database
– Joins in SQL enable us to combine columns for multiple tablets in or across the database for a more comprehensive look at the data. They work on the basis of conditions
– There are various joins in SQL like inner join, left join, full join, and self join
– The Group By, Having, and order By clauses in SQL further specify the kind of output that you need from a database on a select query by including or filtering out data on the basis of these clauses
#sql #sqlforbeginners #mysql #dbms
Topics Covered in this video:
00:00:59 What is Database?
00:02:34 What is DBMS (Database Management System)
00:04:43 Commonly Used DBMS Software
00:05:25 Types of DBMS
00:08:58 Advantages of using DBMS
00:10:19 DBMS vs. File System
00:12:05 What is RDBMS
00:13:43 RDBMS vs. DBMS
00:16:11 Types of Keys in RDBMS – What is a Key
00:30:31 What is Normalization & Types of Normalization
00:38:53 Types of Commands in SQL
00:47:54 Filters, Operators, and Pattern Matching in SQL
00:49:56 Null values in SQL
01:38:25 Alias in SQL
01:38:53 Joins in SQL
01:58:35 Group by Concept in SQL
02:00:42 Subquery in SQL
âš¡ 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
Comments are closed.