Summary
Keywords
Full Transcript
This video covers the Microsoft SQL Server course using the free and open-source Microsoft SQL Server. The course consists of 40 lessons. SQL Notes: https://studyopedia.com/tutorials/sql Below topics covered in this SQL course: Course Introduction 00:00 1. SQL Introduction & Overview 01:06 2. SQL vs NoSQL 03:31 3. Install SQL Server 2022 on Windows 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 #SQLTutorial #MicrosoftSQLServer #AmitThinksSQL ------------------------------------------------------------------------------------------------------------- 👉 Follow me LinkedIn - https://bit.ly/3C1CY4v Instagram - https://bit.ly/3z8Fg1d Telegram - https://bit.ly/3wWBh5i ✔️ Website - https://studyopedia.com ► Get SkillShare - 1 Free Month https://skl.sh/3AkrsAW ------------------------------------------------------------------------------------------------------------- ► Top Free Video Tutorials Python Tutorial (English)⭐️ https://youtu.be/HakXpkXcjdI Python Tutorial (Hindi)⭐️ https://youtu.be/b97WsOM9BYg Google Colab Tutorial ⭐️ https://youtu.be/iMlMfrXJYSg Anaconda Tutorial ⭐️ https://youtu.be/ovlID7gefzE PyCharm Tutorial ⭐️ https://youtu.be/nixcq6mEGWQ MySQL Tutorial ⭐️ https://youtu.be/fFgdnS1laA0 SQL Tutorial ⭐️ https://youtu.be/7dcYlJcGhqk VS Code Tutorial ⭐️ https://youtu.be/mK17Tel7dA8 Visual Studio Tutorial ⭐️https://youtu.be/REG-p_eFNIw HTML Tutorial ⭐️ https://bit.ly/3Ts696N Bootstrap Tutorial: https://youtu.be/nahewStckVU VS Code Tutorial: https://youtu.be/mK17Tel7dA8 Visual Studio Tutorial: https://youtu.be/REG-p_eFNIw ► Free Notes (Downloadable) Python ⭐️ https://studyopedia.com/tutorials/python3 Numpy ⭐️ https://studyopedia.com/tutorials/numpy Pandas ⭐️ https://studyopedia.com/tutorials/pandas Matplotlib ⭐️ https://studyopedia.com/tutorials/matplotlib Java ⭐️ https://studyopedia.com/tutorials/java C ⭐️ https://studyopedia.com/tutorials/c-programming C++ ⭐️ https://studyopedia.com/tutorials/cpp/ Numpy ⭐️ https://studyopedia.com/tutorials/numpy Android ⭐️ https://studyopedia.com/tutorials/android HTML5 ⭐️ https://studyopedia.com/tutorials/html5 PHP ⭐️ https://studyopedia.com/tutorials/php WordPress ⭐️ https://studyopedia.com/tutorials/wordpress Drupal ⭐️ https://studyopedia.com/tutorials/drupal Magento ⭐️ https://studyopedia.com/tutorials/magento Computer Networks ⭐️ https://studyopedia.com/tutorials/computer-networks/ Bootstrap⭐️ https://studyopedia.com/tutorials/bootstrap/ ► Free Interview QA Python🔥https://studyopedia.com/java/java-interview-questions-and-answers Java 🔥https://studyopedia.com/python3/python-multiple-choice-questions/ Android🔥https://studyopedia.com/android/android-interview-questions/ ReactJS🔥https://studyopedia.com/reactjs/react-interview-questions Bootstrap 🔥https://studyopedia.com/bootstrap/bootstrap-interview-questions SQL 🔥https://studyopedia.com/sql/sql-interview-questions MongoDB 🔥https://studyopedia.com/mongodb/mongodb-interview-questions MySQL 🔥https://studyopedia.com/mysql/mysql-interview-questions ► Attempt Quizzes Android Quiz🔥 https://studyopedia.com/android/android-online-quiz/ PHP Quiz 🔥https://studyopedia.com/php/php-online-quiz/ CSS Quiz 🔥https://studyopedia.com/css/css-online-quiz/ jQuery Quiz 🔥https://studyopedia.com/jquery/jquery-online-quiz/ C Quiz 🔥https://studyopedia.com/c/c-online-quiz/ C++ Quiz 🔥https://studyopedia.com/cpp/cpp-online-quiz/ JAVA Quiz 🔥https://studyopedia.com/java/java-online-quiz/ HTML5 Quiz 🔥https://studyopedia.com/html/html5-online-quiz/ 👉 About Amit Thinks YouTube Channel I am Amit Diwan, a self-made Entrepreneur, running "Amit Thinks", a Tech YouTube Channel. Also running an E-Learning website "studyopedia.com". We publish videos in English and Hindi on Programming, Databases, and Web Dev Technologies. I have left a job offer from Accenture and 3 government jobs to follow my dream of being an entrepreneur. ► Subscribe https://www.youtube.com/@Amit.Thinks/
