Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Tutorial for Beginners - MySQL Basics - DBMS - RDBMS

Great Learning via YouTube

Overview

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

Syllabus

What is Database?
What is DBMS Database Management System
Commonly Used DBMS Software
Types of DBMS
Advantages of using DBMS
DBMS vs. File System
What is RDBMS
RDBMS vs. DBMS
Types of Keys in RDBMS – What is a Key
What is Normalization & Types of Normalization
Types of Commands in SQL
Filters, Operators, and Pattern Matching in SQL
Null values in SQL
Alias in SQL
Joins in SQL
Group by Concept in SQL
Subquery in SQL

Taught by

Great Learning

Reviews

5.0 rating, based on 1 Class Central review

Start your review of SQL Tutorial for Beginners - MySQL Basics - DBMS - RDBMS

  • Naveenchandra
    It's good teaching .I like do more courses here.the lecture teaches very well..I had many doubts in dbms by this course after hearing to vedio my doubt are clarified.today I will start and course.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.