SQL Full Course | SQL Tutorial For Beginners | Learn SQL (Structured Query Language) | Edureka

This Edureka SQL Full Course video will cover all the topics of Structured Query Language (SQL) starting from scratch. This SQL tutorial for beginners is great for beginners who want to learn SQL and for professionals who want to brush up their SQL skills. The following topics are covered in this SQL tutorial:
00:00 Introduction
2:00 What is RDBMS?
2:54 Normalization in DBMS
3:44 Normalization Types in DBMS
10:00 Data Types in SQL

***Database Commands***
17:03 Create Database Objects
25:04 Alter Table Statements
30:47 Drop Table Statements
32:05 Various Constraints
57:54 Creating Views

***Table Commands***
1:02:18 Insert Statements
1:07:47 Insert – As- Select Statement
1:13:58 Update Statements
1:20:05 Delete Statements
1:22:47 Select Statement
1:28:01 Select Statement: Alias
1:31:39 Select Statement: Distinct Values
1:32:49 Sorting
1:36:20 Filtering

***Comparison Operators***
1:45:29 NOT IN
1:45:58 IN
1:48:10 Symbols
1:49:21 Example
1:29:29 LIKE
1:52:37 CASE Expression

***Joins***
1:56:23 Joins
1:57:15 Self-Join
1:58:36 Inner Join
2:14:24 Left outer Join
2:19:46 Right outer Join
2:24:32 Full outer join
2:28:12 Cross Join

***Functions***
2:34:17 SQL Built-in Functions
2:37:20 Conversion Function
2:42:16 Logical Functions
2:48:44 Math Function
2:54:45 Aggregate Functions
3:02:28 String Functions
3:09:00 Date & Time Functions
3:11:55 Custom Functions
3:19:01 Stored Procedure
3:43:44 User Defined Functions
4:02:57 Triggers

📢📢 𝐓𝐨𝐩 𝟏𝟎 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐢𝐧 𝟐𝟎𝟐𝟒 𝐒𝐞𝐫𝐢𝐞𝐬 📢📢

------------------------

-------------------

How does it work?

1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!

- - - - - - - - - - - - - -

About the Course

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

- - - - - - - - - - - - - -

Who should go for this course?

This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
- - - - - - - - - - - - - -

Project

In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM:-

• Employee list to be maintained having id, name, designation, experience
• Salary details having employee id, current salary
• Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
• Salary increment to be given by next year if any depending upon constraints
• Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.

- - - - - - - - - - - - - -
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.

[edurekaIN]

2:00 What is RDBMS?
2:54 Normalization in DBMS
3:44 Normalization Types in DBMS
10:00 Data Types in SQL

***Database Commands***
17:03 Create Database Objects
25:04 Alter Table Statements
30:47 Drop Table Statements
32:05 Various Constraints
57:54 Creating Views

***Table Commands***
1:02:18 Insert Statements
1:07:47 Insert – As- Select Statement
1:13:58 Update Statements
1:20:05 Delete Statements
1:22:47 Select Statement
1:28:01 Select Statement: Alias
1:31:39 Select Statement: Distinct Values
1:32:49 Sorting
1:36:20 Filtering

***Comparison Operators***
1:45:29 NOT IN
1:45:58 IN
1:48:10 Symbols
1:49:21 Example
1:29:29 LIKE
1:52:37 CASE Expression

***Joins***
1:56:23 Joins
1:57:15 Self-Join
1:58:36 Inner Join
2:14:24 Left outer Join
2:19:46 Right outer Join
2:24:32 Full outer join
2:28:12 Cross Join

***Functions***
2:34:17 SQL Built-in Functions
2:37:20 Conversion Function
2:42:16 Logical Functions
2:48:44 Math Function
2:54:45 Aggregate Functions
3:02:28 String Functions
3:09:00 Date & Time Functions
3:11:55 Custom Functions
3:19:01 Stored Procedure
3:43:44 User Defined Functions
4:02:57 Triggers

[theearthkyu]

This really helps! I'm a complete beginner who sees an Msql screen for the very first time, but even I can understand your explanation!

[meghanasurapaneni]

Best video I have ever watched ! It covered all the topics in an appropriate manner .

[nikitatorane]

It’s was brief and quick learning of sql commands . Very nice course to prepare for interviews . Thankyou !!

[arslanmaqsood]

EXCELLENT TUTORIAL, Kindly also make a detail tutorial on Oracle

[zarakikenpachi]

Great course. Very well explained. However, the explanation for data types and how and when to use each of those, could be better, because complete beginners who have never worked with data types will have a hard time understanding it.

[azmatsaba]

Awesome explanation. Anyone can easily learn through this video . Thanku ☺️

[bavithavarala]

Thanks to the Anil. This session helped me in revising and restoring all the concepts of SQL. Excellent!!!

[i_habeeb]

What is the meaning of scema_name
That u have included as (dbo. )In stored procedures 3:25:15
Can u explain me this sir ..

[natriumguy]

Thank you for your tutorial!
I successfully established SQL and PLC connection!

[sonalkamble]

Thank you so much.
You explained here allot of things.✌️

[jakirahmed]

Appreciate this fantastic session! Thank You...

[BalaMurugan-xnyv]

This is an excellent video session… !!!! Thanks to edureka for continous efforts to offer such a wonder presentation… And I request you to share the PPT and source code which will be great to have for training… Thanks again…!!!

[israelramirez]

Love, love, love this girl. She is extraordinary teacher

[muhammadasad]

Great, Covered each and every concept I have read in a full semester:)

[kommivishnuteja]

Hello Edurekha team, Amazing course content and very easy to understant from scratch. It will be more helpful if its possible to get this PPT for further learning process
Thank you

[avinash]

edureka was awesome sharing the information and this channel is the best for online learning platform, teaching was good and with clear cut examples

[dishalipatil]

Easy to learn, Crystal clear and time saving! Thanks a lot!

[deekshanv]

One of the best Session to start up with, would kindly Request you to share the syntax and the example code document which was used in this video

[meghaarora]

You are doing very good job Edureka.. many thanks! :)