Complete Microsoft SQL Server Database Administration Course

BY
Udemy

Master the Microsoft SQL Server Database Administration by taking this course by Udemy.

Mode

Online

Fees

₹ 699 4099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Complete Microsoft SQL Server Database Administration Course is online short certification, created by Imran Afzal and Abbas Mehmood, that helps the learners to understand the administration of the Microsoft SQL Server Database and get the certifications of MCSA and MTA. The course curriculum will walk the students through enough knowledge and skills to be professional database administrators and to prepare well for the SQL Server MCSA certification. 

Complete Microsoft SQL Server Database Administration Course online certification, provided by Udemy, will cover all the aspects of Microsoft SQL Server database administration such as Database fundamentals and design, SQL commands, MSSQL database architecture, different types of JOINS, and many more. The programme could be pursued by anyone who is interested in the field and there are no specific prerequisites except having a laptop with internet access. 

Complete Microsoft SQL Server Database Administration Course certification also provides the participants with a certificate of completion adding a unique advantage of having professional exposure to the Microsoft SQL Server Database which is one of the topmost databases in their resume. The learners will also be given a 30-day money-back guarantee and unlimited access to the course content. Learners who are interested in leaving the administration of the database can join the programme by paying the fee.

The highlights

  • 100% Online course 
  • Offered by Udemy 
  • 30-Day Money-Back Guarantee
  • Downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Program offerings

  • 32 hours on-demand video
  • 77 downloadable resources
  • Full lifetime access
  • Access on mobile and tv
  • Certificate of completion

Course and certificate fees

Fees information
₹ 699  ₹4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Database management Sql knowledge

By the end of the Complete Microsoft SQL Server Database Administration Course by Udemy, the learners will acquire a solid understanding of the Microsoft SQL Server database administration and will develop the capacity of managing the SQL server in a corporate environment. Plus, the programme will facilitate the students to brace themselves with knowledge enough to appear for the MCSA and MTA certification exams and get certified. 

The syllabus

Introduction

  • Introduction
  • Course overview
  • Introduction to Database
  • What is RDBMS ?
  • What is SQL ?
  • Top 5 RDBMS using SQL
  • Introduction to Microsoft SQL Server
  • Different Editions of Microsoft SQL
  • Quiz

Download, Install and Configure Windows

  • Welcome to Download, Install and Configure Windows
  • MS SQL Server Pre-requisite
  • Lab Setup
  • What is Virtualization?
  • Download and Install VMWare Workstation Player
  • Optional - Download and Install Oracle Virtualbox
  • Create a Virtual Machine
  • Download and Install Windows Server
  • Virtual Machine Management

Download, Install and Configure MS SQL Server

  • Welcome to Download, Install and Configure Microsoft SQL
  • Prerequisites for MSSQL Installation
  • Download and Install Chrome/FireFox Browser
  • Download MSSQL and SQL Server Management Studio
  • Install and Configure MSSQL
  • Install SQL Server Management Studio
  • Download and Install AdventureWorks Database

Database Fundamentals and Design

  • What is Data and Database?
  • What is Data?
  • What is Database?
  • How data is stored?
  • What is a Table, COLUMN and ROW ?
  • What is a Key?
  • What is a primary key, Foreign Key, Unique Keys etc.
  • What is Relational Database and Relational Database Management System (RDBMS)?
  • What is a Transaction and ACID properties?
  • Database Normalization AND Different forms of Database Normalization
  • Create your first Database, Table and Populate table with data…

Introduction to SQL commands

  • Welcome to Basic SQL Commands
  • What is a SQL Statement and types of SQL statements
  • DML Statement with examples
  • DDL Statements with examples
  • DCL Statement with examples
  • TCL Statement with examples

Query and Manipulation of Data using SQL

  • Welcome to Query and Manipulation of Data using SQL Commands
  • Create TABLE(s) and Temp Table(s)
  • What Is a View?
  • SELECT Statement in detail
  • Operators, Expressions and Conditions
  • WHERE Clause, ORDER BY Clause , HAVING By Clause, GROUP BY Clause
  • Select from two tables - JOINS
  • Different Types of JOINS
  • What is a Sub Query?
  • INSERT Statement in detail
  • UPDATE Statement in detail
  • DELETE Statement in detail
  • Difference between DELETE and Truncate Statement
  • What is a Store Procedure
  • What is a Function
  • What is a Trigger
  • What is an INDEX
  • Clustered ,NonClustered Indexes and Index Design considerations
  • Index Fragmentation and Lab for Index

Microsoft SQL Database Administration and System databases

  • Welcome to Microsoft SQL Database Administration and System Databases
  • Overview of MSSQL Management Tools
  • Exploring SQL Server Management Studio (SSMS) (part -1)
  • Exploring SQL Server Management Studio (SSMS) (part -2)
  • Exploring SQL Server Configuration Manager
  • MSSQL System Databases, DO's and DONT's of System databases
  • What is master Database?
  • What is tempdb Database ?
  • What is msdb Database ?
  • Other system Databases (model,distribution)

Deep Dive into MSSQL Working

  • Welcome to Deep Dive into MSSQL working
  • What are Pages, Extents, Page Architecture, and PFS?
  • MSSQL Architecture
  • MSSQL Database Architecture
  • Operation and working of transaction log

MSSQL Backup and Restore

  • Welcome to MSSQL Backup and Restore
  • Backup of a Database, Importance for DBA and Different Media used for Backups
  • Recovery Models in MSSQL and how that impact backups an restore
  • Full Backups
  • Differential Backups
  • Transaction Log Backups, Log Backup Chain and Tail-log Backup
  • Lab for Full, Differential and Transaction Log Backups
  • Restore and Recovery Overview
  • Full, Differential and Transaction Log database restore
  • Point in time restore of a database
  • Complete Backup , Restore and Restore in Time Lab
  • MS SQL Server DBCC CHECKDB command
  • Page Level Restore / Recovery using Full Backups
  • Creating Maintenance Plan Backups/Re-indexing etc.

MSSQL User Management

  • Welcome to MS SQL User Management
  • MSSQL Security Model
  • MSSQL Server Authentication Modes
  • Principals (Part-1) : Server Logins, Server Roles
  • Principals (Part-2) : Database Users, Database Roles
  • Permissions (GRANT , DENY , REVOKE)

MSSQL Server Agent Management

  • Welcome to Overview of MSSQL Server Agent
  • SQL Server Agent Introduction
  • SQL Server Agent Jobs and Schedules
  • Agent Alerts ,Operators , Database Mail and Activity Monitor

Advanced SQL Server Administration Topics

  • Introduction to Advanced Topics in MSSQL Server Administration
  • High Availability and its Types
  • What Is Replication and Transactional Replication Setup
  • Transactional Replication Setup (LAB)
  • Log Shipping and Configuring Log Shipping
  • SQL Server Encryption and Encryption Types
  • Transparent Data Encryption (TDE) , Configuration and Restore of TDE Databases

Course Recap

  • SQL Queries We Have Learned
  • Congratulations
  • Don't Give Up!
  • Bonus lecture

Instructors

Mr Abbas Mehmood

Mr Abbas Mehmood
Instructor
Udemy

Mr Imran Afzal 1

Mr Imran Afzal 1
Instructor
Freelancer

Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books