Microsoft SQL Server 2022 Tutorial for Beginners | Amit Thinks | 2023

Microsoft SQL Server 2022 Tutorial for Beginners | Amit Thinks | 2023 | Class 11th 12th

Рет қаралды 122,562

Күн бұрын

Пікірлер: 87

@Amit.Thinks Жыл бұрын

Thank you for your support. The below topics are explained in this 2 hours SQL Course: 1. SQL Introduction & Overview 01:06 2. SQL vs NoSQL 03:31 3. Install SQL Server 2022 on Windows 11 07:11 4. Create a new database 11:37 5. Create a new table 12:59 6. Insert Records 15:38 7. SQL SELECT Statement 18:23 8. SQL SELECT DISTINCT Statement 20:08 9. SQL WHERE Clause 21:48 10. SQL ORDER BY Clause 25:26 11. SQL AND Operator 29:10 12. SQL OR operator 31:49 13. SQL NOT operator 34:15 14. SQL IN Operator 36:20 15. SQL BETWEEN Operator 39:36 16. SQL LIKE Operator 43:18 17. SQL MAX() Function 48:25 18. SQL MIN() Function 50:32 19. SQL SUM() Function 52:40 20. SQL AVG() function 54:35 21. SQL COUNT() Function 56:26 22. SQL NOT NULL Constraint 58:58 23. SQL UNIQUE Constraint 1:01:57 24. SQL Primary Key Constraint 1:05:59 25. SQL Foreign Key Constraint 1:08:24 26. SQL Check Constraint 1:12:31 27. SQL ASC Command 1:16:42 28. SQL DESC Command 1:19:00 29. SQL ALTER TABLE Statement 1:21:25 30. SQL UPDATE Statement 1:23:41 31. SQL Aliases 1:27:40 32. SQL Stored Procedures 1:30:00 33. SQL CREATE INDEX Statement 1:36:07 34. SQL SELECT INTO Statement 1:38:53 35. SQL SELECT TOP CLAUSE 1:42:16 36. Backup Database in SQL 1:45:38 37. SQL Views 1:47:37 38. Drop a Table in SQL 1:52:49

@okaforcyprianogbonnaya1066 3 ай бұрын

I started this video and I taking it gradually, You do this so welll Amit, Thank you so much.

@Amit.Thinks 3 ай бұрын

Welcome. Refer to our free courses: 🔥GenerativeAI Free Courses: bit.ly/3Vhsbxv 🔥Database Courses: bit.ly/3EMv1Bi 🔥Learn Web Development" bit.ly/3tl9nlp 🔥Data Science Courses: bit.ly/3O7KfGk 🔥Data Analytics Courses: bit.ly/48MxV

@DriftDudes Жыл бұрын

tnx Just compled with better understanding, now bring new video with advanced concept.

@malekshaar99 Жыл бұрын

You’re the best AMIT. thanks!

@Amit.Thinks Жыл бұрын

I disagree, but thank you for your appreciation. :) Refer our other free course: Python Tutorial: kzbin.info/www/bejne/foTFqnWtoqqCh80 Jupyter Notebook Tutorial: kzbin.info/www/bejne/haaQaHpvi7aonck PyCharm Tutorial: kzbin.info/www/bejne/pJrblKRsoqp6jbM MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I SQL Tutorial: kzbin.info/www/bejne/aZ7YnHqPn9ucrqc Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: kzbin.info/www/bejne/eXfKkJWrp7KNZ5I

@mithunshaha4342 8 ай бұрын

Very Nice Explanation,Sir.Needs More Tutorial From You.

@Amit.Thinks 8 ай бұрын

Thank you for your appreciation. Here are our other free tutorials: SQL Tutorial: kzbin.info/www/bejne/aZ7YnHqPn9ucrqc MongoDB Tutorial: kzbin.info/www/bejne/mYuaapSspNZsi7c Python Tutorial (English): kzbin.info/www/bejne/fpLOiaOhjcidmqs Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k Pandas Tutorial (English): kzbin.info/www/bejne/r3fSh6ZplNyphtE Pandas Tutorial (Hindi): kzbin.info/www/bejne/a2izgHmwj5yZbJI NumPy Tutorial (English): kzbin.info/www/bejne/jaSof6atoritbK8 NumPy Tutorial (Hindi): kzbin.info/www/bejne/qKDUhKeMjLOFbbM Matplotlib Tutorial (English): kzbin.info/www/bejne/enelnId_ndWnhbM Matplotlib Tutorial (Hindi): kzbin.info/www/bejne/rHOmiaZ3mcSmrc0 Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc

@eymardemis-hiversegna2585 Жыл бұрын

On your channel I'm gone to improve my sql skills. Thank u Amit. You deserve better 🙌🏿

@Amit.Thinks Жыл бұрын

Welcome! Refer our other free Tutorials: Python Tutorial (English): kzbin.info/www/bejne/foTFqnWtoqqCh80 Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: kzbin.info/www/bejne/eXfKkJWrp7KNZ5I

@vikassharma-er9ql 4 ай бұрын

bhai bohut he simple way mae complete basic sql sikha diya great

@Amit.Thinks 4 ай бұрын

Thanks bhai. Hamarein hindi courses bhi hai. Unse bhi seekh sakte hai: 👇👇 Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k Pandas Tutorial (Hindi): kzbin.info/www/bejne/a2izgHmwj5yZbJI NumPy Tutorial (Hindi): kzbin.info/www/bejne/qKDUhKeMjLOFbbM Matplotlib Tutorial (Hindi): kzbin.info/www/bejne/rHOmiaZ3mcSmrc0

@KaushikDas-wx4hr 10 ай бұрын

Hi Amit! I have completed this video. It was really a smooth one and took me 3 days to complete, and your explanation made it easier than ever. Do you have the next part of this?

@Amit.Thinks 10 ай бұрын

Glad it helped. Thank you for your appreciation. Unfortunatly, I did not created the next part. Currently, I have the following free courses: Python Tutorial (English): kzbin.info/www/bejne/fpLOiaOhjcidmqs Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k NumPy Tutorial (English): kzbin.info/www/bejne/jaSof6atoritbK8 NumPy Tutorial (Hindi): kzbin.info/www/bejne/qKDUhKeMjLOFbbM Google Colab Tutorial: kzbin.info/www/bejne/n37Pfpmoja-Mick Anaconda Tutorial: kzbin.info/www/bejne/pafPendtnMqZsKc PyCharm Tutorial: kzbin.info/www/bejne/pJrblKRsoqp6jbM Jupyter Notebook Tutorial: kzbin.info/www/bejne/haaQaHpvi7aonck MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc

@KaushikDas-wx4hr 10 ай бұрын

@@Amit.Thinks Ok, thanks!

@shailjachaudhary601 3 ай бұрын

Bestest video for Beginners ❤

@Amit.Thinks 3 ай бұрын

@cybermage4249 5 ай бұрын

Your explanation is too good... Thanks for this course. 😊

@Amit.Thinks 5 ай бұрын

@swapnareddyvaka5201 9 ай бұрын

Crystal clear explanation , thank you so much sir ☺️

@Amit.Thinks 9 ай бұрын

You're most welcome. Refer to our other free courses: Python Tutorial: kzbin.info/www/bejne/fpLOiaOhjcidmqs Pandas Tutorial: kzbin.info/www/bejne/r3fSh6ZplNyphtE NumPy Tutorial: kzbin.info/www/bejne/jaSof6atoritbK8 Matplotlib Tutorial: kzbin.info/www/bejne/enelnId_ndWnhbM MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: bit.ly/3VHaUvq

@iahmedku 8 ай бұрын

Thank you for the wonderful course. I have one question. Which are the best user interface for users for SQL server . Like forms in Microsoft Access.

@RavinTradeZone 8 ай бұрын

very good to understand of sql basics

@Amit.Thinks 7 ай бұрын

Glad it was helpful! Do refer to our following playlists: Full Database Courses: kzbin.info/aero/PLSwH4ViBDl2Rj0TAxrbVLqbTT9zRzUJbk Data Science Course for Beginners: kzbin.info/aero/PLSwH4ViBDl2T9tVh0GvrG7kMo5CKY_e99

@innocentboy8338 Ай бұрын

Awesome vidoes and teaching ..take a bow for ur efforts.. Salute 🫡

@Amit.Thinks Ай бұрын

Thanks! Glad you liked it, I put a lot of effort into making these tutorials easy to understand. Refer to our other free courses: Python Tutorial: bit.ly/3znnb1y Pandas Tutorial: kzbin.info/www/bejne/r3fSh6ZplNyphtE NumPy Tutorial: kzbin.info/www/bejne/jaSof6atoritbK8 Matplotlib Tutorial: kzbin.info/www/bejne/enelnId_ndWnhbM MySQL Tutorial: kzbin.info/www/bejne/qZjTdXSfe5JkbtE MongoDB Tutorial: kzbin.info/www/bejne/mYuaapSspNZsi7c HTML Tutorial: bit.ly/3VHaUvq CSS Tutorial: bit.ly/3Khx5Ei Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc

@innocentboy8338 Ай бұрын

Excellent video 👏🏻 🎉 i had never seen past....❤❤❤

@Amit.Thinks Ай бұрын

You're welcome. Refer to our free courses: SQL Tutorial: kzbin.info/www/bejne/aZ7YnHqPn9ucrqc Python Tutorial: bit.ly/3znnb1y Pandas Tutorial: kzbin.info/www/bejne/r3fSh6ZplNyphtE NumPy Tutorial: kzbin.info/www/bejne/jaSof6atoritbK8 Matplotlib Tutorial: kzbin.info/www/bejne/enelnId_ndWnhbM MySQL Tutorial: kzbin.info/www/bejne/qZjTdXSfe5JkbtE MongoDB Tutorial: kzbin.info/www/bejne/mYuaapSspNZsi7c HTML Tutorial: bit.ly/3VHaUvq CSS Tutorial: bit.ly/3Khx5Ei Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc

@innocentboy8338 Ай бұрын

Hi sir...can I get snowflake tutorial if available

@technology__explained Жыл бұрын

Thanks amit, finally my search for sql learning ends with your video. Your way of teaching is really smooth which makes a clear pathway yo learn sql, waiting for many more concepts from sql.

@Amit.Thinks Жыл бұрын

Glad to hear that and thank you for the appreciation. Refer our other free Tutorials: Python Tutorial (English): kzbin.info/www/bejne/fpLOiaOhjcidmqs Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k Google Colab Tutorial: kzbin.info/www/bejne/n37Pfpmoja-Mick Anaconda Tutorial: kzbin.info/www/bejne/pafPendtnMqZsKc PyCharm Tutorial: kzbin.info/www/bejne/pJrblKRsoqp6jbM MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I SQL Tutorial: kzbin.info/www/bejne/bZXGip-AmKybp80 Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: kzbin.info/www/bejne/eXfKkJWrp7KNZ5I

@vmgoal2024 Жыл бұрын

Thanks Amit,great learning platform from basic

@Amit.Thinks Жыл бұрын

You're welcome. Get our other free Tutorials: Python Tutorial: kzbin.info/www/bejne/foTFqnWtoqqCh80 MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: kzbin.info/www/bejne/eXfKkJWrp7KNZ5I Numpy Tutorial: studyopedia.com/tutorials/numpy Pandas Tutorial: studyopedia.com/tutorials/pandas Matplotlib Tutorial: studyopedia.com/tutorials/matplotlib Java Tutorial: studyopedia.com/tutorials/java C# Tutorial: studyopedia.com/tutorials/csharp JavaScript Tutorial: studyopedia.com/tutorials/javascript jQuery Tutorial: studyopedia.com/tutorials/jquery

@uttammondal-t1t 8 ай бұрын

amazing video, thanks sir.

@Amit.Thinks 8 ай бұрын

Glad you liked it. Refer to our other free courses: MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I MongoDB Tutorial: kzbin.info/www/bejne/mYuaapSspNZsi7c Python Tutorial (English): kzbin.info/www/bejne/fpLOiaOhjcidmqs Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k Pandas Tutorial (English): kzbin.info/www/bejne/r3fSh6ZplNyphtE Pandas Tutorial (Hindi): kzbin.info/www/bejne/a2izgHmwj5yZbJI NumPy Tutorial (English): kzbin.info/www/bejne/jaSof6atoritbK8 NumPy Tutorial (Hindi): kzbin.info/www/bejne/qKDUhKeMjLOFbbM Matplotlib Tutorial (English): kzbin.info/www/bejne/enelnId_ndWnhbM Matplotlib Tutorial (Hindi): kzbin.info/www/bejne/rHOmiaZ3mcSmrc0

@manishworld5533 7 ай бұрын

Best video for learning basics

@Amit.Thinks 7 ай бұрын

@saadhussain4681 Жыл бұрын

Very informative Video. Thanks Instructor. Kindly can you please make a video tutorial on Ms Sql server 2022 administration complete?

@Amit.Thinks Жыл бұрын

Welcome! Right now, we can only provide the following free Tutorials: Python Tutorial: kzbin.info/www/bejne/foTFqnWtoqqCh80 MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: kzbin.info/www/bejne/eXfKkJWrp7KNZ5I Java Tutorial: studyopedia.com/tutorials/java C# Tutorial: studyopedia.com/tutorials/csharp C Tutorial: studyopedia.com/tutorials/c-programming C++ Tutorial: studyopedia.com/tutorials/cpp/

@piyush_xt09__ Жыл бұрын

Amazing, the video was very good, and you taught the every thing in less time. Thanks... 😀

@Amit.Thinks 7 ай бұрын

@biswal999 9 ай бұрын

Very well explained sir

@Amit.Thinks 9 ай бұрын

Thanks and welcome, Biswal. Refer to our other free courses: Python Tutorial (English): kzbin.info/www/bejne/fpLOiaOhjcidmqs Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k Pandas Tutorial (English): kzbin.info/www/bejne/r3fSh6ZplNyphtE Pandas Tutorial (Hindi): kzbin.info/www/bejne/a2izgHmwj5yZbJI NumPy Tutorial (English): kzbin.info/www/bejne/jaSof6atoritbK8 NumPy Tutorial (Hindi): kzbin.info/www/bejne/qKDUhKeMjLOFbbM Matplotlib Tutorial (English): kzbin.info/www/bejne/enelnId_ndWnhbM Matplotlib Tutorial (Hindi): kzbin.info/www/bejne/rHOmiaZ3mcSmrc0 MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I MongoDB Tutorial: kzbin.info/www/bejne/mYuaapSspNZsi7c

@FunnyVideos-zl5di 7 ай бұрын

great tutorial for beginners

@Amit.Thinks 7 ай бұрын

Glad it was helpful! Refer to our other Database courses: kzbin.info/aero/PLSwH4ViBDl2Rj0TAxrbVLqbTT9zRzUJbk

@pujekarparameshwar2412 2 сағат бұрын

Thank you boss🎉

@Amit.Thinks 2 сағат бұрын

You're welcome. Refer to our other free courses: Power BI Tuorial: kzbin.info/www/bejne/hXq3dIptermtY68 Python Tutorial: bit.ly/3znnb1y Pandas Tutorial: kzbin.info/www/bejne/r3fSh6ZplNyphtE NumPy Tutorial: kzbin.info/www/bejne/jaSof6atoritbK8 Matplotlib Tutorial: kzbin.info/www/bejne/enelnId_ndWnhbM MySQL Tutorial: kzbin.info/www/bejne/qZjTdXSfe5JkbtE MongoDB Tutorial: kzbin.info/www/bejne/mYuaapSspNZsi7c SQL Tutorial: kzbin.info/www/bejne/aZ7YnHqPn9ucrqc HTML Tutorial: bit.ly/3VHaUvq CSS Tutorial: bit.ly/3Khx5Ei Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc

@vismayam7416 5 ай бұрын

Is this vedio is enough for sql learning?

@tanyakaushik3806 Жыл бұрын

Thanks amit for dis video #very helpful

@Amit.Thinks Жыл бұрын

You're welcome. Keep learning. 🔥Refer to our other free Tutorials: Python Tutorial: kzbin.info/www/bejne/foTFqnWtoqqCh80 MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: kzbin.info/www/bejne/eXfKkJWrp7KNZ5I MongoDB Tutorial: kzbin.info/www/bejne/mYuaapSspNZsi7c

@umer4587 28 күн бұрын

Hi Amit sir completed this video what would i next pleases suggest i am in 4th semester BSCS student from Pakistan and not interesting in programming but interest in data analyst can you guide what should i learn next and become a good data analyst Thanks

@Amit.Thinks 28 күн бұрын

Check this for Data Analysis: kzbin.info/aero/PLSwH4ViBDl2QV8RhlLQLpG6vR3BnkgvQR&si=EI4ihNoFfVHOjNiQ

@TayyabaMughal-h7j 2 күн бұрын

sir ,apky notes download krny h offline revision ky lia to koi option ni h kindly provide kr dy

@Amit.Thinks Күн бұрын

Check my website for free study material: studyopedia.com

@meettrivedi6033 6 ай бұрын

thank you for best video

@Amit.Thinks 6 ай бұрын

You're welcome. Refer to our free courses: 🔥ChatGPT Course: kzbin.info/www/bejne/iZLHpYalad5meKM 🔥Database Courses: bit.ly/3EMv1Bi 🔥Learn Web Development" bit.ly/3tl9nlp 🔥Data Science Courses: bit.ly/3O7KfGk 🔥Data Analytics Courses: bit.ly/48MxVTU

@vlog.444 Жыл бұрын

Thank you for this great

@Amit.Thinks Жыл бұрын

You're very welcome! Generate a Certificate of Completion: www.udemy.com/course/sql-server-course-for-beginners/

@ayyd123 6 ай бұрын

great tutorial

@Amit.Thinks 6 ай бұрын

Glad you think so! Happy to help. Refer to our free courses: 🔥ChatGPT Course: kzbin.info/www/bejne/iZLHpYalad5meKM 🔥Database Courses: bit.ly/3EMv1Bi 🔥Learn Web Development" bit.ly/3tl9nlp 🔥Data Science Courses: bit.ly/3O7KfGk 🔥Data Analytics Courses: bit.ly/48MxV

@polakipavansai1342 2 ай бұрын

Worth worth😊 thankyou very much for ur efforts👍

@Amit.Thinks 2 ай бұрын

Welcome. Refer to our other free courses: 🔥GenerativeAI Free Courses: bit.ly/3Vhsbxv 🔥Database Courses: bit.ly/3EMv1Bi 🔥Learn Web Development" bit.ly/3tl9nlp 🔥Data Science Courses: bit.ly/3O7KfGk 🔥Data Analytics Courses: bit.ly/48MxV

@technology__explained Жыл бұрын

Jus a question, before converting the data into newtable, don't we need to create that newtable, (while using 'into' )

@MR_FAHATH Жыл бұрын

Not needed because it will automatically create new table for the records

@jafarjs4943 2 ай бұрын

Is there any difference between mysql and MSsql

@Amit.Thinks 2 ай бұрын

SQL-based databases are the following: - MS SQL is Microsoft SQL Server - MySQL: kzbin.info/www/bejne/qZjTdXSfe5JkbtE - Oracle, etc. All the above are relational i.e. SQL-based databases that means records are stored in tables, ro, and column format.

@jafarjs4943 2 ай бұрын

For all 3 databases the queries are same or it differs

@fayaalpaakeer 6 ай бұрын

Is this software support to macOS

@Raj_Vishwa1 Жыл бұрын

Thanks 🙏😊

@Amit.Thinks Жыл бұрын

Welcome. Refer our other free Tutorials: Python Tutorial (English): kzbin.info/www/bejne/fpLOiaOhjcidmqs Python Tutorial (Hindi): kzbin.info/www/bejne/mGqaiKaFgp51j8k Google Colab Tutorial: kzbin.info/www/bejne/n37Pfpmoja-Mick Anaconda Tutorial: kzbin.info/www/bejne/pafPendtnMqZsKc PyCharm Tutorial: kzbin.info/www/bejne/pJrblKRsoqp6jbM MySQL Tutorial: kzbin.info/www/bejne/nHfKlaGJZtGUd5I SQL Tutorial: kzbin.info/www/bejne/bZXGip-AmKybp80 Bootstrap Tutorial: kzbin.info/www/bejne/pJLLlqqJqciejLc HTML Tutorial: kzbin.info/www/bejne/eXfKkJWrp7KNZ5I

@ngills6218 Жыл бұрын

Thanks bro

@Amit.Thinks Жыл бұрын

@ashwinisalunke135 8 ай бұрын

Sir execute krne ke bad mera result jo aa raha hai us table me data nhi aa raha hai kya kru?

@Amit.Thinks 8 ай бұрын

Aisa nhi ho sakta

@ashwinisalunke135 8 ай бұрын

Sir hua hai...apka koi email id ho to send krna me apko photo send krti hu

@Amit.Thinks 8 ай бұрын

amit@studyopedia.com

@prashantkumar9754 7 ай бұрын

where can I ask questions, if I have doubt?

@Amit.Thinks 7 ай бұрын

amit_2010@outlook.com amit@studyopedia.com

@leena-pu5rb Жыл бұрын

Sir if we execute and they show the database name is incorrect then what will we do? Please sir ans me

@Amit.Thinks Жыл бұрын

That means you did not followed the video properly.

@Amit.Thinks Жыл бұрын

show database or show databases;

@gaikwadpremkumar5830 6 ай бұрын

1:05:00

@Amit.Thinks 6 ай бұрын

Yes?

@Bilal-tn8lf 2 ай бұрын

how much it is similar with myql ?

@Amit.Thinks 2 ай бұрын

SQL-based databases are the following: - MySQL: kzbin.info/www/bejne/nHfKlaGJZtGUd5I - Microsoft SQL Server: kzbin.info/www/bejne/aZ7YnHqPn9ucrqc SQL is a query programming language that manages RDBMS. MySQL is a relational database management system that uses SQL.