Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero

Metla Sudha Sekhar

88 Lessons 6 Hours

2. Course Curriculum

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 yo...

No suggested offers right now

Continue through the course and check back later for relevant recommendations.

View Downloads

Course Content

0% Completed

Introduction

1. Introduction 3m 2. Course Curriculum 6m 3. How to get course requirements 1m 4. Getting started on Windows, Linux or Docker 1m 5. How to ask great questions 1m 6. FAQ’s 1m 7. source code file 8m

SQL Server setting up

8. Section Introduction 1m 9. Microsoft SQL Server Installation 18m 10. SQL Server Management Studio (SSMS) Installation 8m 11. How to connect MS SQL (Windows Authentication) 3m 12. How to connect MS SQL (SQL Server Authentication) 3m 13. Download and Restore Sample Database 7m

SQL Database Basic

14. Section Introduction 1m 15. Overview of Databases 10m 16. Creating Database 4m 17. SQL Data Types 3m 18. Column Data Types on SSMS 3m 19. Creating Table 9m 20. Overview of Primary Key and Foreign Key 4m 21. Primary Key 4m 22. Foreign Key 6m 23. Creating Temporary tables 6m

SQL DML ( Data Manipulation Language)

24. Section Introduction 1m 25. Insert statement 8m 26. Update statement 5m 27. Delete statement 3m

SQL DDL ( Data Defination Language)

28. Section Introduction 1m 29. CREATE table statement 2m 30. DROP statement 2m 31. ALTER statement 5m 32. TRUNCATE statement 4m 33. COMMENT in query 1m 34. RENAME 1m

SQL DCL ( Data Control Language)

35. Create Database user 3m 36. GRANT permissions 6m 37. REVOKE permissions 4m

SQL Statement Basic

38. Section Introduction 1m 39. SQL Statement basic 3m 40. SELECT Statement 7m 41. SELECT DISTINCT 2m 42. SELECT with column headings 2m 43. Column AS statement 2m

Filtering Data rows

44. SELECT WHERE Clause – theory 3m 45. SELECT WHERE Clause – practical 7m

Aggregate functions

46. Sum() 8m 47. Min()-Max() 5m

SQL Query statements

48. Order By statement 5m 49. SELECT TOP clause in SQL 4m 50. BETWEEN command 8m 51. IN operator 4m 52. Wildcard Characters and LIKE 4m

SQL Group by statement

53. Section Introduction 1m 54. Group by – theory 3m 55. Group by – practical 5m 56. HAVING statement 3m

JOINS

57. Overview of Joins 1m 58. What are Joins 2m 59. Inner join 7m 60. Left outer join 2m 61. Right outer join 2m 62. Full outer join 1m 63. Union 2m 64. Cross join 3m 65. Query Exercise 1m 66. Solution for Query Exercise 1m

SQL Constraints

67. Section introduction 1m 68. Check constraint 6m 69. NOT NULL constraint 8m 70. UNIQUE constraint 5m

Views

71. Creating Views 3m 72. Reporting with multiple tables 3m

Advanced SQL Commands

73. Section Introduction 1m 74. Timestamp 4m 75. Extract from timestamp 3m 76. Mathematical scalar functions 3m 77. String functions 4m 78. Sub Query 3m 79. SELECT with calculations 6m

SQL Stored Procedures

80. Create stored procedure 4m 81. Stored procedure with parameter 4m

Import & Export data

82. Section Introduction 1m 83. Import Flat File 5m 84. Import .csv or excel file 2m 85. Export Data to Excel or any format 6m

Backup and Restore Database

86. Section Introduction 1m 87. Creating Database backup 3m 88. Restoring Database backup 3m

Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero

Ready for the next lesson?

2. Course Curriculum

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar