Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero

Metla Sudha Sekhar

88 Lessons 6h 11m

5. How to ask great questions

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

Lesson assistant

Ask about what you’re watching

Subscriber benefit

See something confusing? Subscribe to ask the lesson assistant about it.

Ask about what’s on screen. The assistant uses the current video frame and available subtitles.
Get clear answers to up to 5 lesson questions each day.
Enrol in up to 4 included courses each month and learn while subscribed.
Save 75% on eligible courses outside the subscription.

Already subscribed? Sign in

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 4m 2. Course Curriculum 7m 3. How to get course requirements 2m 4. Getting started on Windows, Linux or Docker 1m 5. How to ask great questions 2m 6. FAQ’s 2m 7. source code file 9m

SQL Server setting up

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

SQL Database Basic

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

SQL DML ( Data Manipulation Language)

24. Section Introduction 1m 25. Insert statement 9m 26. Update statement 6m 27. Delete statement 4m

SQL DDL ( Data Defination Language)

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

SQL DCL ( Data Control Language)

35. Create Database user 4m 36. GRANT permissions 7m 37. REVOKE permissions 5m

SQL Statement Basic

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

Filtering Data rows

44. SELECT WHERE Clause – theory 4m 45. SELECT WHERE Clause – practical 8m

Aggregate functions

46. Sum() 9m 47. Min()-Max() 6m

SQL Query statements

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

SQL Group by statement

53. Section Introduction 2m 54. Group by – theory 4m 55. Group by – practical 6m 56. HAVING statement 4m

JOINS

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

SQL Constraints

67. Section introduction 1m 68. Check constraint 7m 69. NOT NULL constraint 9m 70. UNIQUE constraint 6m

Views

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

Advanced SQL Commands

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

SQL Stored Procedures

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

Import & Export data

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

Backup and Restore Database

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

Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero

Ready for the next lesson?

5. How to ask great questions

Ask about what you’re watching

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar