SQL, a programming language that may be really intimidating, especially when you first start out. Here’s Shashank Mishra (Data Engineer III, Expedia) with a detailed SQL tutorial for beginners. Check out our FREE masterclasses by leading industry experts now: https://www.scaler.com/events?utm_sou...

If you have watched the SQL basics, watch the complete SQL Full course with Interview Questions and Answers now:    • SQL Full Course and Interview Questio...  

Watch other detailed tutorials on SQL here:    • SQL Tutorial  

What is SQL?

When working with relational databases, Structured Query Language is the preferred language. Database records can be updated, deleted, searched for, and added using SQL. Numerous other tasks, such as database optimisation and maintenance, are also possible with SQL.

What is a programming language?

Programmers create software programmes, scripts, and other sets of instructions for computers to follow using a programming language.

With the help of SQL, you can create and drop databases and tables. It helps users to access data in the RDBMS system, and also helps you to describe the data.

As a data engineer, Shashank Mishra uses SQL every single day of his work. As a result, if you are a beginner, we strongly advise you to follow this tutorial, in which Shashank covers all the fundamentals required to begin writing SQL code. Check it out!

Link to the Github repository: https://bit.ly/3CTruAO

0:00 Introduction
0:51 Setup MySQL workbench in local
4:05 Executing SQL commands in workbench (Creating databases)
11:14 Create, Show, Drop & Truncate tables
23:56 Insert data into tables
30:42 Alter table and Select command
44:09 Order by Clause
47:46 Where Clause
1:04:11 Update, Delete, Group By and Group by Having
1:20:04 Joins in SQL

About SCALER

A transformative tech school, creating talent with impeccable skills. Upskill and Create Impact.

Learn more about Scaler: https://bit.ly/3yxcQNZ

Follow us on Social and be a part of an amazing tech community
Meet likeminded coder folks on Discord   / discord  
Tweets you cannot afford to miss out on   / scaler_official  
Check out student success stories, expert opinions, and live classes on Linkedin   / scalerofficial  
Explore valuepacked reels, carousels and get access to exclusive updates on Instagram   / scaler_official  
Be a part of our one of a kind telegram community: https://t.me/Scalercommunity

Hit that bell icon to get notified of all our new videos

If you liked this video, please don't forget to like and comment. Never miss out on our exclusive videos to help boost your coding career! Subscribe to Scaler now!
https://www.youtube.com/Scaler?sub_co...

#sql #structuredquerylanguage #sqltutorial #scaler #shashankmishra