- 1. Introduction 3m 29s
- 2. Course Curriculum 6m 56s
- 3. How to get course requirements 1m 41s
- 4. Getting started on Windows, Linux or Docker 58s
- 5. How to ask great questions 1m 20s
- 6. FAQ’s 1m 9s
- 7. source code file 8m 47s
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
- 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.
Curriculum
88 Lessons • 6H 10M- 1. Section Introduction 1m 42s
- 2. Microsoft SQL Server Installation 18m 35s
- 3. SQL Server Management Studio (SSMS) Installation 8m 28s
- 4. How to connect MS SQL (Windows Authentication) 3m 40s
- 5. How to connect MS SQL (SQL Server Authentication) 3m 13s
- 6. Download and Restore Sample Database 7m 27s
- 1. Section Introduction 1m 16s
- 2. Overview of Databases 10m 47s
- 3. Creating Database 4m 54s
- 4. SQL Data Types 3m 23s
- 5. Column Data Types on SSMS 3m 55s
- 6. Creating Table 9m 10s
- 7. Overview of Primary Key and Foreign Key 4m 5s
- 8. Primary Key 4m 6s
- 9. Foreign Key 6m 52s
- 10. Creating Temporary tables 6m 29s
- 1. Section Introduction 49s
- 2. Insert statement 8m 25s
- 3. Update statement 5m 7s
- 4. Delete statement 3m 12s
- 1. Section Introduction 54s
- 2. CREATE table statement 2m 58s
- 3. DROP statement 2m 10s
- 4. ALTER statement 5m 28s
- 5. TRUNCATE statement 4m 4s
- 6. COMMENT in query 55s
- 7. RENAME 1m 41s
- 1. Create Database user 3m 55s
- 2. GRANT permissions 6m 9s
- 3. REVOKE permissions 4m 11s
- 1. Section Introduction 1m 14s
- 2. SQL Statement basic 3m 19s
- 3. SELECT Statement 7m 24s
- 4. SELECT DISTINCT 2m 42s
- 5. SELECT with column headings 2m 35s
- 6. Column AS statement 2m 5s
- 1. SELECT WHERE Clause – theory 3m 40s
- 2. SELECT WHERE Clause – practical 7m 15s
- 1. Sum() 8m 1s
- 2. Min()-Max() 5m 48s
- 1. Order By statement 5m 26s
- 2. SELECT TOP clause in SQL 4m 6s
- 3. BETWEEN command 8m 9s
- 4. IN operator 4m 4s
- 5. Wildcard Characters and LIKE 4m 53s
- 1. Section Introduction 1m 10s
- 2. Group by – theory 3m 11s
- 3. Group by – practical 5m 28s
- 4. HAVING statement 3m 32s
- 1. Overview of Joins 1m 56s
- 2. What are Joins 2m 16s
- 3. Inner join 7m 55s
- 4. Left outer join 2m 50s
- 5. Right outer join 2m 19s
- 6. Full outer join 1m 21s
- 7. Union 2m 46s
- 8. Cross join 3m 10s
- 9. Query Exercise 1m 6s
- 10. Solution for Query Exercise 1m 9s
- 1. Section introduction 55s
- 2. Check constraint 6m 54s
- 3. NOT NULL constraint 8m 29s
- 4. UNIQUE constraint 5m 2s
- 1. Creating Views 3m 58s
- 2. Reporting with multiple tables 3m 6s
- 1. Section Introduction 51s
- 2. Timestamp 4m 27s
- 3. Extract from timestamp 3m 11s
- 4. Mathematical scalar functions 3m 50s
- 5. String functions 4m 55s
- 6. Sub Query 3m 9s
- 7. SELECT with calculations 6m 18s
- 1. Create stored procedure 4m 36s
- 2. Stored procedure with parameter 4m 29s
- 1. Section Introduction 1m 8s
- 2. Import Flat File 5m 3s
- 3. Import .csv or excel file 2m 40s
- 4. Export Data to Excel or any format 6m 8s
- 1. Section Introduction 59s
- 2. Creating Database backup 3m 52s
- 3. Restoring Database backup 3m 35s
- 0.00 instructor rating
- 1 courses
- Systems students worldwide
Metla Sudha Sekhar
Learn from DragonZap instructors with practical, build-first lessons focused on systems, low-level programming, compilers, kernels, and real-world engineering fundamentals.
Student reviews
No student reviews have been posted yet.