SQL Server Crash course | Microsoft SQL Server Tutorial | From Absolute Beginners to Advanced

This tutorial is about SQL Server Crash course in 2021. It is a complete crash course for those who are interested to learn SQL from Zero and reach till the advanced level. In this crash course, you will learn SQL concepts, using SQL to store and manage the data. This course is great for beginners and also for intermediates. This crash course will cover installing MySQL, connect to AdventureWorks2019, creating users, writing SQL queries with practical demonstrations, so you will not only understand the concepts but also master them practically.
If you are looking for a career upgrade and a better salary, then this course is for you. This SQL Server crash course helps to learn SQL using Microsoft SQL Server but it will also help to master SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, etc.
🔔 If you like the video, Please LIKE, Comment, and Subscribe to my RUclips channel
/ tutorialbrain
⌚TimeStamp:
0:00 - Introduction
3:55 - Install MS SQL Server Developer edition 2019
7:12 - Install SSMS(SQL Server Management Studio)
11:12 - Download and Import AdventureWorks2019 database
19:47 - Connect to AdventureWorks2019
20:30 - SELECT Statement
22:47 - WHERE Clause in SQL Server
25:19 - Arithmetic operators in SQL Server
30:36 - Combine Strings in SQL Server - Concatenation
32:38 - How to find Null values in SQL Server
34:20 - Logical operators - AND and OR Operators in SQL Server
36:40 - BETWEEN & IN Operators in SQL
39:40 - LIKE Operator in SQL
42:21 - ORDER BY Clause in SQL
46:46 - GROUP BY Clause in SQL
52:14 - String Functions in SQL Server
57:22 - Date Functions in SQL Server
59:38 - HAVING Clause
1:04:32 - SubQuery
1:07:42 - UNION and UNION ALL operators
1:10:23 - INNER Joins
1:14:57 - LEFT Join
1:19:26 - RIGHT Join
1:21:55 - FULL JOIN
1:24:06 - Data Types in SQL Server
1:31:18 - CREATE Table Statement
1:38:40 - CREATE Table with constraints
1:50:54 - INSERT Statement
1:56:51 - UPDATE Statement
1:59:42 - ALTER Statement
2:03:55 - DELETE Statement
2:06:19 - DROP Statement
2:07:00 - Wrap up
#SQLServerCrashCourse #SQLServerTutorial #SQLCourse #SQLTutorial #SQLCrashCourse #SQLServerCourse #MicrosoftSQL #MicrosoftSQLServerCourse #SQLServer
🚩Let’s connect on social:
Website: www.tutorialbrain.com
Facebook: / tutorialbrain
Twitter: / tutorial_brain
LinkedIn: / tutorialbrain

[@Ropenfold]

Will you be doing a intermediate SQL Server crash course? it's so hard to get a decent intermediate course on youtube and I think yours would be good

[@TutorialBrain]

Thanks, you can consider this course as an Intermediate level course it contains most of the concepts. In case, you are interested in my paid courses, you can reach out to me. Thanks.

[@ahmedalamri2456]

.
...
...............hmmmm.......,
.........
...#............
..kv

[@RajeshKumar-yj5hw]

🔜

[@MessingWithCode]

@@TutorialBrain i am

[@bunnypvk]

@@TutorialBrain I'm interested

[@vkiran7847]

One of the best SSMS related course in youtube, with in two hours covered most of concepts

[@Rowiep]

Love this tutorial. Was able to manipulate sql but did not understand all the commands. This is a great course.

[@prathamedupoint6131]

This is the video I am searching for. I had viewed many videos but my some doubts not got cleared. You have cleared my all doubts.
Thanx a lot. 🙏🙏🙏🙏

[@napstericious]

Thank you for this comprehensive and fast paced course! :)
Great job! Cheers! :)

[@tetianakorshunova2466]

Thank you Sandeep for this course! Everything is clear and laconic. Great job.

[@BaconEggUSA]

I really enjoyed this course. Fantastic and clear instructor. 5 stars!

[@TutorialBrain]

Glad you enjoyed it!

[@luffygear5362]

This is the most crystal clear and compact course I’ve found on SQL till now. Thank you very much Sir!

[@TutorialBrain]

You are always welcome and thanks for your motivational words

[@pavelfedorov2891]

Yeah man, thank you very much for the clear step-by-step instructions. Much love!

[@TutorialBrain]

Happy to help!

[@khorshedhasantutul202]

Thanks for the crash course.
An fabulous course for beginner to learn SQL .

[@DrNoseWater]

This was a great beginners course! I've watched a few over the past weeks, and this one resonated the most with me. Awesome explanations, and logical progressions from one clause to the next.

[@TutorialBrain]

Thanks and glad you took the entire course

[@kavithanair7933]

I am a beginner and I wanted a short basic course on SQL.Thank you .Very clearly and nicely explained

[@TutorialBrain]

Happy that you liked the course

[@graceyemisi8246]

Thank you so much! You don’t know how grateful I am to have come across your explanation!

[@abdullahalmamunnahid552]

This is the most useful sql beginners course on RUclips for me.

[@betageric3217]

It is a excellent course and I got full confidence that I can learn on my own, I was searching for many RUclips but this gives me full confidence. Gob bless you.

[@praveenna7630]

Awesome tutorial! Thank you

[@cherryvegrabato9849]

THANK YOU MY GUY!! I have regained my knowledge in SQL using this course you're a legend!

[@TutorialBrain]

Glad that I helped you

[@vicroberts3080]

i will skip any tutorial that is not narrated by an indian dude.. indian dudes are legit AF when it comes to this life

[@mimiblouki3198]

This tutorial is for sure the best. I never did programmation and it was all well explained from the very beginning. Thank you for making this course and share it for free! I will for sure check your other tutorials!

[@TutorialBrain]

Very happy to hear that i was able to help you in any way

[@manjumankoji1448]

Clear Explanation .. Thank you So much Sir 🙏

[@rossbiva]

this is soooo good for someone, who is just starting sql. thank you so much.

[@TutorialBrain]

Thanks a lot

[@jdram82]

Great Video for SQL server, and its a begineer friendly and your way of teaching is superb!

[@rohandeshpande7515]

Love this crash course, a much needed refresher for me, thanks a Ton!

[@TutorialBrain]

Thanks a lot

[@fardeenburhan221]

THANKS, excellent work!

[@daphnesmith4816]

Thanks for the great tutorial!

[@DevSAGurus]

This truly helped to kinda catch-up for my SQL interview

[@TutorialBrain]

All the best for your interview ☺️☺️

[@Mr_Review95]

really amazing , thank you sir

[@kamalrajan1715]

simple, neat,good..... best for beginners.. thank you sir.

[@TutorialBrain]

Welcome

[@nbansal4]

Great effort . Thank you

[@shellyorenshtein3421]

Excellent and useful course, I enjoyed it very much

[@sivakumar19831]

Thank you...good one

[@lafayettemusic5900]

Really enjoyed the tutorial. Thank you so much had to subscribe

[@TutorialBrain]

Thanks for subscribing. Glad you liked

[@harshitsamdhani2426]

Thank You ! The course content is good, explanation is clear and speed is accurate . You are an awesome Instructor ❤

[@TutorialBrain]

Thank you

[@Electronics61]

Today I came across your YT and found this topic very useful. Thanks. I new to T SQL. Also subscribed to your YT channel

[@TutorialBrain]

Happy to hear that you liked the course. Thanks for subscribing

[@RESTESSMYSTIC]

Thankyou 4 great course !!!

[@MrSasiya07]

This is very helpfull for my sql exam..thank you i learned every thing from here
😋😇

[@jimmyphilip2227]

This course is superb, very clear explanation, Thank you!!

[@TutorialBrain]

Welcome. Thanks for the lovely comments

[@nimmi44]

Great tutorial ! Clear in every part !

[@TutorialBrain]

Thank you

[@abdelrahmanashraf7636]

Just Finished it, Thanks for the Great Effort

[@TutorialBrain]

Always welcome

[@blow9773]

I just want to thank you, for the time you spend recording this great tutorial, good luck

[@TutorialBrain]

Welcome

[@hemantsingh9966]

It is another great course for beginners

[@antonkorolev8059]

Thank you!

[@RPSHARMAVlogs]

welldone nice 👍

[@alifnaiech6972]

This very good tutorial for the beginner who want to learn SQL Server. Thank You TutorialBrain

[@TutorialBrain]

Glad that you liked it

[@trendsandmore911]

Great tutorial!!

[@yon_draper]

Thank you so much brother ! Very helpful and I subscribed for you :)

[@TutorialBrain]

Always welcome and thanks for subscribing

[@chiranjitdey1430]

Thank You so much. You cleared my concepts.

[@TutorialBrain]

Glad it helped!

[@nikoalnabawi6066]

This really helped me in learning mssql. thankyou so much :)

[@TutorialBrain]

Welcome

[@bombered]

I admit its a perfect course, can u make a video about the foreign key relationship between two tables and how they work.

[@aryavrata4542]

Good comprehensive SQL tutorial.

[@TutorialBrain]

Thanks

[@MessingWithCode]

thanks for this video

[@thomasmathew4252]

A good course and good explanation! Anyone who want to refresh the course or for beginner its best

[@TutorialBrain]

Glad you like the course

[@abdulrahmanshalabi3149]

Great course by clear instructor

[@TutorialBrain]

Thanks

[@abdulfatorma348]

Thank you

[@engrismailkhan]

I have a question before I start the course, from where I can download the practice database you used in the course?

[@SKDasTube]

Very helpful.

[@IndianHacker-hisBest]

Thanks a lot bro

[@amatulathok597]

thanks a lot dude

[@dania_884]

This is more for a Beginner's course, topic like OR operator, IN operator becomes formed into one Video. In Textbook we can get it from a short chapter also. Hope to see you give an intermediate level topic that really talked into MSSQL architecture, High Availability, etc.

[@affanbutt9829]

Very nice video for SQL learning it's too much in just 2 hours The efforts put into this video are awesome👍

[@TutorialBrain]

Thanks a lot

[@archie_2609]

Thanks for the useful and short content on SQL SERVER

[@scorpion-hv9du]

Hello ma'am

[@prajktagite5738]

I really enjoyed this course. Thank you..

[@TutorialBrain]

Glad to hear that

[@kunalkumar57]

Superb lecture's, very clear explanation, Thank you!!

[@TutorialBrain]

Thanks

[@sobo5476]

Very good course and I found this really helpful. I haven't used SQL in a while and I have a job interview on Tuesday and I will need to do some SQL in it, I'm hoping this has refreshed my mind enough to get the test done at the interview and get a new job.

[@TutorialBrain]

All the best for your interview

[@Mihail01100]

how it went?

[@milindjagtap7483]

Very useful for me... Thanks you.

[@TutorialBrain]

Welcome. Plz subscribe to the channel

[@shahbazsiddiqui9697]

Fanatstic explanation !

[@TutorialBrain]

Thanks

[@andrw8946]

We need part 2 for more advanced concepts like indexes, stored procedures etc.

[@yonasfanta3560]

Fire 🔥 🔥 🔥

[@hirudikapremaratne2034]

Learned a lot. Thanks

[@TutorialBrain]

Glad it was helpful!

[@dipsikhaphukan5563]

Nice video. It was helpful.

[@TutorialBrain]

Glad to hear that it helped

[@khanspiro]

hey when i clicked on Backup, its not taking to anywhere as it has done with u. since, I cannot restore the exisiting database although I downloaded adventure work sample.

[@shubhampapadkar2503]

very helpfull this video !

[@TutorialBrain]

Glad it did

[@otaviofaria3186]

Best SQL guide ever!!!

[@TutorialBrain]

Thanks

[@saktechnologytutorial]

It is the best for me a Beginner.

[@TutorialBrain]

Glad you like it.

[@fadajohna]

Best lecturer 👏🏼👏🏼👏🏼

[@TutorialBrain]

Thank you! 🙂

[@laminbojang4266]

Hello friend, your tutorial is pretty helpful, I will like you to make another videos whereby you will download the app's frontend, put your own inputs and have access to it in the backend by SQL.

[@ame7272]

Thank you so much, you are awesome. I watched until 58 minutes. I didn't want the whole video yet. I don't know if you will cover the administration part of SQL Server or not, but i hope you can make a whole video for Administring SQL Server
But your video is great really and i wrote notes and examples of everything you did. Thank you so much.
Subscribed :)

[@TutorialBrain]

Thanks for such great compliments. I am elated and glad you loved the Course

[@ame7272]

@@TutorialBrain Believe me it wasn't a compliment, it really is one of the greatest, straight to the point, courses on youtube. I hope you can make one just like it for Administrating SQL Server. Thank you again very much.

[@shyamaprasadchakraborti723]

Thank you very good tutorial video

[@TutorialBrain]

Welcome

[@yateeshmadaka7718]

Thank you Sir

[@TutorialBrain]

Welcome

[@maheshhasabe9565]

Perfect tutorial..

[@TutorialBrain]

Glad you like it.

[@Loedairy]

Thanks so much for this tutorial God bless you 🙏✌️ pls at where you create table in covidstart the Covid date changed on my sql, I create /4-25-2000 the exact way you did but mine changed to 1996, all the dates what could be the reason ? 1:56:20

[@rollarhockeyAnviKalra]

lot of thanks for remember me sql query part

[@TutorialBrain]

I am happy to help you

[@Chydos]

Thank you Sandeep

[@TutorialBrain]

Welcome

[@babatatani9781]

I cannot find the MSSQLSEVER afre the CDl folder in the programfiles please advise

[@vivekpandey5142]

Good one

[@TutorialBrain]

Thanks

[@hugomelgar5046]

Great course

[@TutorialBrain]

Thanks

[@dudamneerajdattu1459]

9:28 here i'm getting "A connection was successfully established with the server, but then an error occurred during the login process. " what to do?

[@jefoxop5700]

6:22 ... after the application is installed it is showing me en error that .exe didn't installed with a decimal code. can't get the solution pls help

[@christophernadar5022]

Hello sir, I enjoyed your teaching and I wanted to practice this but I'm not able to login to my SSMS. Can you please help me with the login part?

[@TutorialBrain]

What is the error you are getting?

[@pianomusicmaxmd4134]

thank you very much for making this course. I am a beginner in SQL and your crash course is amazing. I want to know if I have a grip knowledge of all that you shared in the video should I have the confidence to add to my resume that I know SQL?

[@TutorialBrain]

Definitely you have a solid foundation in SQL now. You can add it to your resume. You can build upon these skills and learn more concepts in SQL and practice more to get better at it.

[@pianomusicmaxmd4134]

@@TutorialBrain appreciated so much for replying

[@sjahmmad4932]

sir
create more sql server class ,
and
nice teaching
tq

[@TutorialBrain]

Will keep this in mind.. thanks

[@Kunalsingh25125]

sir at time (1:56:16) i got this error ( The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. ) please provide solution sir. i got stuck please help

[@sherifelsherif7332]

In 14:13, what should i do if the Backup folder doesn't open, I try to open it but, it doesn't give any response!!

[@iAmGratchet_]

Does anyone know why I'm not able to open the file after downloading from the website?

[@nazmul9511]

Excellent Tutorial. Any Tutorial of being a SQL Developer with BI?

[@TutorialBrain]

Please follow me. I will create one if you want

[@user-gq1ij]

One week of assignment at job done in 2 hours tutorial
Now lets binge watch Netflix whole week

[@TutorialBrain]

Awesome, enjoy after your hard work

[@samirpoudel3535]

could you please also share the link of the database so that i can practice it together while watching the video

[@user-mk8lm3hr4h]

i am using SQL 2022 and everytime i try to use "WHERE" i get an error

[@SheikhMuhammadNawaz]

Please make a detailed tutorial on Store Procedures for beginners ......

[@TutorialBrain]

Sure.. will try to adjust it when free

[@yilmakebede7418]

very useful

[@scorpion-hv9du]

Hello