Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero

$37.10

~~$105.99~~

Description

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.

Requirements

No prior experience is necessary. A computer with Windows OS is recommended.

Who This Course is For

This course is for anyone looking to start a career in database management or enhance their existing skill set.

What You Will be Learn

You will learn how to install SQL Server, create and manage databases, write SQL queries, optimize database performance, and implement security measures.

Introduction

7 Lessons

0H 24M

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

SQL Server setting up

6 Lessons

0H 43M

8. Section Introduction

1m 42s

9. Microsoft SQL Server Installation

18m 35s

10. SQL Server Management Studio (SSMS) Installation

8m 28s

11. How to connect MS SQL (Windows Authentication)

3m 40s

12. How to connect MS SQL (SQL Server Authentication)

3m 13s

13. Download and Restore Sample Database

7m 27s

SQL Database Basic

10 Lessons

0H 54M

14. Section Introduction

1m 16s

15. Overview of Databases

10m 47s

16. Creating Database

4m 54s

17. SQL Data Types

3m 23s

18. Column Data Types on SSMS

3m 55s

19. Creating Table

9m 10s

20. Overview of Primary Key and Foreign Key

4m 5s

21. Primary Key

4m 6s

22. Foreign Key

6m 52s

23. Creating Temporary tables

6m 29s

SQL DML ( Data Manipulation Language)

4 Lessons

0H 17M

24. Section Introduction

49s

25. Insert statement

8m 25s

26. Update statement

5m 7s

27. Delete statement

3m 12s

SQL DDL ( Data Defination Language)

7 Lessons

0H 18M

28. Section Introduction

54s

29. CREATE table statement

2m 58s

30. DROP statement

2m 10s

31. ALTER statement

5m 28s

32. TRUNCATE statement

4m 4s

33. COMMENT in query

55s

34. RENAME

1m 41s

SQL DCL ( Data Control Language)

3 Lessons

0H 14M

35. Create Database user

3m 55s

36. GRANT permissions

6m 9s

37. REVOKE permissions

4m 11s

SQL Statement Basic

6 Lessons

0H 19M

38. Section Introduction

1m 14s

39. SQL Statement basic

3m 19s

40. SELECT Statement

7m 24s

41. SELECT DISTINCT

2m 42s

42. SELECT with column headings

2m 35s

43. Column AS statement

2m 5s

Filtering Data rows

2 Lessons

0H 10M

44. SELECT WHERE Clause – theory

3m 40s

45. SELECT WHERE Clause – practical

7m 15s

Aggregate functions

2 Lessons

0H 13M

46. Sum()

8m 1s

47. Min()-Max()

5m 48s

SQL Query statements

5 Lessons

0H 26M

48. Order By statement

5m 26s

49. SELECT TOP clause in SQL

4m 6s

50. BETWEEN command

8m 9s

51. IN operator

4m 4s

52. Wildcard Characters and LIKE

4m 53s

SQL Group by statement

4 Lessons

0H 13M

53. Section Introduction

1m 10s

54. Group by – theory

3m 11s

55. Group by – practical

5m 28s

56. HAVING statement

3m 32s

JOINS

10 Lessons

0H 26M

57. Overview of Joins

1m 56s

2m 16s

7m 55s

2m 50s

2m 19s

1m 21s

2m 46s

3m 10s

1m 6s

66. Solution for Query Exercise

1m 9s

SQL Constraints

4 Lessons

0H 21M

67. Section introduction

55s

68. Check constraint

6m 54s

69. NOT NULL constraint

8m 29s

70. UNIQUE constraint

5m 2s

Views

2 Lessons

0H 7M

71. Creating Views

3m 58s

72. Reporting with multiple tables

3m 6s

Advanced SQL Commands

7 Lessons

0H 26M

73. Section Introduction

51s

74. Timestamp

4m 27s

75. Extract from timestamp

3m 11s

76. Mathematical scalar functions

3m 50s

77. String functions

4m 55s

78. Sub Query

3m 9s

79. SELECT with calculations

6m 18s

SQL Stored Procedures

2 Lessons

0H 9M

80. Create stored procedure

4m 36s

81. Stored procedure with parameter

4m 29s

Import & Export data

4 Lessons

0H 14M

82. Section Introduction

1m 8s

83. Import Flat File

5m 3s

84. Import .csv or excel file

2m 40s

85. Export Data to Excel or any format

6m 8s

Backup and Restore Database

3 Lessons

0H 8M

86. Section Introduction

59s

87. Creating Database backup

3m 52s

88. Restoring Database backup

3m 35s

Metla Sudha Sekhar

Dragon Zap Instructor

0.00 Star Rating

24 Courses

Dragon Zap Instructor

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.

0.0

Course Rating

Students Feedback (0)

Sort by:

$37.10

~~$105.99~~

65% off

5 days and 16 hours at this price

This course includes:

Full Lifetime Access
30 Days Money Back Guarantee
Free Exercises File
Watch online or offline
Certificate of Completion