Microsoft Sql Server Course: From Beginner To Advanced

MS SQL SERVER

What you'll learn

Introduction to SQL server

Database Fundamentals and Design

Querying and Manipulating Data using SQL

Exploring Advanced Concepts in SQL Server Administration

Requirements

No prior experience or background is required to take this course. It is designed specifically for absolute beginners who are starting from scratch. You'll be guided step-by-step from the basics all the way to advanced SQL Server administration topics. Whether you're completely new to databases or just beginning your journey with SQL Server, this course will help you build the skills and confidence you need.

Description

This comprehensive course covers everything you need to know about Microsoft SQL Server and database systems — from the very basics to advanced concepts. Whether you're completely new to databases or already have some experience, this course is designed to take you step-by-step through the essential topics that every database professional should know.You’ll begin by learning the fundamentals: what a database is, how it works, and why it's such a critical part of nearly every modern application. From there, you’ll move on to writing SQL queries, retrieving and manipulating data, and understanding relational database structures. The course then dives deeper into more advanced topics such as indexing, joins, stored procedures, triggers, transactions, and error handling.As you progress, you’ll also gain valuable hands-on experience with SQL Server administration tasks. This includes user management, security, backup and restore operations, automation using SQL Server Agent, always on availability groups, T-sqlperformance tuning, and working with important system databases like master, msdb, model, and tempdb.By the end of this course, you’ll not only understand how SQL Server works—you’ll be able to confidently use it in real-world scenarios. This course is perfect for aspiring database administrators, developers, analysts, or anyone looking to build a strong foundation in SQL Server and database systems.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Introduction to databases and RDBMS

Section 2: Lab Setup

Lecture 3 SQL Server Eeditions

Lecture 4 Instal SQL Server & SSMS

Lecture 5 Restoring Testing Database

Lecture 6 Instaling Vmware

Section 3: Core Database Concepts

Lecture 7 WHAT IS RAID ?

Lecture 8 Data Types

Lecture 9 Null Value

Lecture 10 What is Column and Row

Lecture 11 SQL Server Keys

Lecture 12 Normalization Forms

Section 4: T-SQL PART 1

Lecture 13 T-SQL Introduction

Lecture 14 Select

Lecture 15 Where

Lecture 16 Between

Lecture 17 AND OR

Lecture 18 LIKE

Lecture 19 String Concatenation

Lecture 20 Mathematical Operators

Lecture 21 Functions

Lecture 22 Date Functions

Lecture 23 Mathematical Functions

Lecture 24 How to use Case

Lecture 25 How to use IIF

Lecture 26 Group by and Order By

Lecture 27 Quering multiple tables

Lecture 28 Left and Right Join

Lecture 29 Full Join

Lecture 30 SubQueries

Lecture 31 Create Table

Lecture 32 Insert Statment

Lecture 33 Update statment

Lecture 34 Delete and Truncate

Lecture 35 Transactions

Lecture 36 Examples part two

Lecture 37 examples

Section 5: T-SQL Part 2

Lecture 38 Using CTE

Lecture 39 Using IF AND ELSE

Lecture 40 While loop

Lecture 41 Error Handling

Lecture 42 What is Cursor

Lecture 43 What is XML

Section 6: System Databases

Lecture 44 Intorduction to system databases

Lecture 45 Master & Model

Lecture 46 MSDB & TempDB

Section 7: Advanced SQL Server Objects and Optimization

Lecture 47 Stored Procedures

Lecture 48 Functions

Lecture 49 Differences Between Procedures and Functions

Lecture 50 What is Index

Lecture 51 What is Views

Lecture 52 What is Trigger

Section 8: MSSQL Backup and Restore

Lecture 53 Database File Structure

Lecture 54 Backup Types

Lecture 55 Recovery Models

Lecture 56 Installing SSMS Edition 20

Lecture 57 Lab Creating Backup System

Section 9: Lab Setup

Lecture 58 Creating Server For Domain Controller

Lecture 59 Creating Virtual Machine For SQL SERVER

Lecture 60 Installing SQL server on Virtual Machine

Section 10: Security and User Managments

Lecture 61 SQL Server Security Model

Lecture 62 Windows Authentification

Lecture 63 SQL Server Authentification

Lecture 64 Database Roles

Section 11: Always On High Availibility

Lecture 65 Starting Failover Cluster Manager

Lecture 66 Starting Services with Doamin User

Lecture 67 Building Always on Availability Group

Lecture 68 Intorduction to Availability Groups

This course is for anyone who wants to learn more about database systems, whether you're just starting out or looking to deepen your understanding.