- 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
Online
₹ 455 3,499
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
certificate availability
certificate providing authority
What you will learn
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
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
Instructor
Udemy
Mr Imran Afzal 1
Instructor
Freelancer