- 4m
- 7m
- 2m
- 4. Getting started on Windows, Linux or Docker 1m
- 5. How to ask great questions 2m
- 2m
- 7. source code file 9m
Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero
About this course
Welcome to the Microsoft SQL Server Bootcamp 2024! This course is designed to take you from a complete novice to a confident SQL Server professional. Whether you are looking to enhance your skills for a new job, or simply want to understand how databases work, this bootcamp provides a comprehensive approach to learning SQL Server.
Throughout this course, you’ll learn how to install SQL Server, develop and manage databases, optimize queries, and implement security measures. By the end of the bootcamp, you'll have the practical knowledge and skills to handle real-world database scenarios effectively.
What you'll learn
- You will learn how to install SQL Server, create and manage databases, write SQL queries, optimize database performance, and implement security measures.
Who this course is for
- This course is for anyone looking to start a career in database management or enhance their existing skill set.
Requirements
- No prior experience is necessary. A computer with Windows OS is recommended.
Curriculum
88 Lessons • 6h 11m estimated learning time- 8. Section Introduction 2m
- 9. Microsoft SQL Server Installation 19m
- 10. SQL Server Management Studio (SSMS) Installation 9m
- 11. How to connect MS SQL (Windows Authentication) 4m
- 12. How to connect MS SQL (SQL Server Authentication) 4m
- 13. Download and Restore Sample Database 8m
- 14. Section Introduction 2m
- 15. Overview of Databases 11m
- 16. Creating Database 5m
- 17. SQL Data Types 4m
- 18. Column Data Types on SSMS 4m
- 19. Creating Table 10m
- 20. Overview of Primary Key and Foreign Key 5m
- 21. Primary Key 5m
- 22. Foreign Key 7m
- 23. Creating Temporary tables 7m
- 24. Section Introduction 1m
- 25. Insert statement 9m
- 26. Update statement 6m
- 27. Delete statement 4m
- 28. Section Introduction 1m
- 29. CREATE table statement 3m
- 30. DROP statement 3m
- 31. ALTER statement 6m
- 32. TRUNCATE statement 5m
- 33. COMMENT in query 1m
- 34. RENAME 2m
- 35. Create Database user 4m
- 36. GRANT permissions 7m
- 37. REVOKE permissions 5m
- 38. Section Introduction 2m
- 39. SQL Statement basic 4m
- 40. SELECT Statement 8m
- 41. SELECT DISTINCT 3m
- 42. SELECT with column headings 3m
- 43. Column AS statement 3m
- 44. SELECT WHERE Clause – theory 4m
- 45. SELECT WHERE Clause – practical 8m
- 46. Sum() 9m
- 47. Min()-Max() 6m
- 48. Order By statement 6m
- 49. SELECT TOP clause in SQL 5m
- 50. BETWEEN command 9m
- 51. IN operator 5m
- 52. Wildcard Characters and LIKE 5m
- 53. Section Introduction 2m
- 54. Group by – theory 4m
- 55. Group by – practical 6m
- 56. HAVING statement 4m
- 57. Overview of Joins 2m
- 58. What are Joins 3m
- 59. Inner join 8m
- 60. Left outer join 3m
- 61. Right outer join 3m
- 62. Full outer join 2m
- 63. Union 3m
- 64. Cross join 4m
- 65. Query Exercise 2m
- 66. Solution for Query Exercise 2m
- 67. Section introduction 1m
- 68. Check constraint 7m
- 69. NOT NULL constraint 9m
- 70. UNIQUE constraint 6m
- 71. Creating Views 4m
- 72. Reporting with multiple tables 4m
- 73. Section Introduction 1m
- 74. Timestamp 5m
- 75. Extract from timestamp 4m
- 76. Mathematical scalar functions 4m
- 77. String functions 5m
- 78. Sub Query 4m
- 79. SELECT with calculations 7m
- 80. Create stored procedure 5m
- 81. Stored procedure with parameter 5m
- 82. Section Introduction 2m
- 83. Import Flat File 6m
- 84. Import .csv or excel file 3m
- 85. Export Data to Excel or any format 7m
- 86. Section Introduction 1m
- 87. Creating Database backup 4m
- 88. Restoring Database backup 4m
- 0.00 instructor rating
- 24 courses
- 3 students worldwide
Metla Sudha Sekhar
Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passionate to teach every single real-time step that leads students as well as professionals to become successful and the vision to impart Good Quality Software Education to all I.T to aspirants make a strong bridge the gap between the software companies requirements and the beginners.
He is Professional about web development and technologies:
* Programming: Python, C# Asp.Net and PHP more..
* UI/UX : HTML, CSS, Bootstrap, JavaScript, AJAX and more...
* Database : MS-SQL, MySQL, PostgreSQL, MongoDB, MariaDB and
more...
* Operating Systems / Servers: Administration of LINUX, Ubuntu,
CentOS, Windows and more...
Start solving your challenge now | Enroll today and learn real world practical example courses.
He is passionate about:
* Teaching students the correct way.
* Making things simple and easy to understand.
* Providing the best audio and video qualities to my courses.
* Real-time Examples who will understand real-time skills easily.
Student reviews
No student reviews have been posted yet.