Complete Microsoft SQL Server Database Administration Course

Focused View

Imran Afzal,Abbas Mehmood

32:09:41

30 View

01 - Introduction

001 Introduction.mp4

02:25

002 Course overview.mp4

04:06

003 Introduction to Database.mp4

03:00

004 What is RDBMS.mp4

02:50

005 What is SQL.mp4

03:19

006 Top 5 RDBMS using SQL.mp4

03:58

007 Introduction to Microsoft SQL Server.mp4

05:18

008 Different Editions of Microsoft SQL.mp4

02:52

02 - Download, Install and Configure Windows

001 Welcome to Download, Install and Configure Windows.mp4

00:07

002 MS SQL Server Pre-requisite.mp4

02:43

003 Lab Setup.mp4

02:18

004 What is Virtualization.mp4

04:51

005 Download and Install VMWare Workstation Player.mp4

07:10

006 Optional - Download and Install Oracle Virtualbox.mp4

04:47

007 Create a Virtual Machine.mp4

05:37

008 Download and Install Windows Server (2016).mp4

16:10

009 Download and Install Windows Server (2019).mp4

07:23

010 Virtual Machine Management.mp4

04:51

03 - Download, Install and Configure MS SQL Server

001 Section-3-Intro.pdf

001 Welcome to Download, Install and Configure Microsoft SQL.mp4

01:43

002 Prerequisites for MSSQL 2016 Installation.mp4

03:34

002 Section-3-Lec-1.pdf

003 Prerequisites for MSSQL 2022 Installation.mp4

02:59

003 SQLServer2022-prerequisites.pdf

004 Download and Install Chrome Browser.mp4

05:31

005 Download MSSQL and SQL Server Management Studio.mp4

07:42

005 Section-3-Lec-2.pdf

006 Install and Configure MSSQL 2016.mp4

21:29

006 Section-3-Lec-3.pdf

007 Install and Configure MSSQL 2019.mp4

38:36

008 Donload-Install-SQL-Server-2022.pptx

008 Download and Install MSSQL 2022.mp4

31:08

009 Install 2016 SQL Server Management Studio.mp4

05:24

009 Section-3-Lec-4.pdf

010 Install 2018 SQL Server Management Studio.mp4

11:26

011 Install 2019 SQL Server Management Studio.mp4

05:39

012 Download and Install AdventureWorks Database.mp4

05:44

012 Section-3-Lec-5.pdf

external-links.txt

04 - Database Fundamentals and Design

001 Section-4-Intro.pdf

001 Welcome to Database Fundamentals and Design.mp4

01:17

002 Section-4-Lec-1.pdf

002 What is Data.mp4

02:26

003 Section-4-Lec-2.pdf

003 What is Database.mp4

04:34

004 How Data is Stored.mp4

02:33

004 Section-4-Lec-3.pdf

005 Section-4-Lec-4.pdf

005 What is a Table, COLUMN and ROW.mp4

06:43

006 WhatIsAKeyAndTypes.pdf

006 What is a Key.mp4

03:19

007 WhatIsPrimaryForeignKey.pdf

007 What is Primary Key , Foreign Key, Unique Key etc.mp4

11:38

008 WhatIsRDBMS.pdf

008 What is Relational Database and Relational Database Management System (RDBMS).mp4

07:50

009 WharAreACIDProperties.pdf

009 What is a Transaction and ACID properties.mp4

13:28

010 Database Normalization AND Different forms of Database Normalization.mp4

11:53

010 WhatIsNormalizationAndFormsOfNormalization.pdf

011 CreateYourFirstDatabase.pdf

011 Create your first Database, Table and Populate table with data.mp4

27:39

05 - Introduction to SQL Commands

001 WelcomeToBasicSQLCommands.pdf

001 Welcome to Basic SQL Commands.mp4

00:35

002 What is a SQL Statement and types of SQL statements.mp4

05:41

002 What-is-a-SQL-Statement-and-types-of-SQL-statements.pdf

003 DMLStatementswithexamples.pdf

003 DML Statement with examples.mp4

04:48

004 DDLStatementswithexamples.pdf

004 DDL Statements with examples.mp4

10:09

005 DCLStatementsWithExamples.pdf

005 DCL Statement with examples.mp4

02:52

006 TCLStatementsWithExamples.pdf

006 TCL Statement with examples.mp4

08:56

06 - Query and Manipulation of Data using SQL

001 WelcomeQueryandManipulationofDatausingSQL.pdf

001 Welcome to Query and Manipulation of Data using SQL Commands.mp4

01:44

002 CreateTABLE-s-andTempTable-s.pdf

002 Create TABLE(s) and Temp Table(s).mp4

28:53

002 ResourceForTableTempTable.txt

003 WhatIsAView.pdf

003 What Is a View.mp4

15:04

003 view.txt

004 SELECTStatementWithDetails.pdf

004 SELECT Statement in detail.mp4

19:00

004 selectqueries.zip

005 OperatorsExpressionsandConditions.pdf

005 Operators, Expressions and Conditions.mp4

08:22

006 WHEREClauseOrderByClauseGroupByClauseHavingClause.pdf

006 WHERE Clause, ORDER BY Clause , HAVING By Clause, GROUP BY Clause.mp4

47:25

006 selectwithoperators.zip

007 Select from two tables - JOINS.mp4

26:03

007 Select-from-two-tables-JOINS.pdf

007 SlectFrom2Tables.txt

008 DifferentTypesOfJoin.txt

008 Different Types of JOINS.mp4

23:45

009 What is a Sub Query.mp4

18:06

009 subquery.txt

010 INSERTStatementindetail.pdf

010 INSERT Statement in detail.mp4

27:32

010 insert.txt

011 UPDATEStatementindetail.pdf

011 UPDATE Statement in detail.mp4

26:55

011 update.txt

012 DELETEStatementindetail.pdf

012 DELETE Statement in detail.mp4

27:15

012 delete.txt

013 DeleteVSTruncate.pdf

013 Difference between DELETE and Truncate Statement.mp4

18:01

013 truncate.txt

014 What is a Stored Procedure.mp4

29:27

014 storedprocedure.txt

015 WhatisAFunction.pdf

015 What is a Function.mp4

28:02

015 functions.txt

016 WhatisATrigger.pdf

016 What is a Trigger.mp4

17:29

016 trigger.txt

017 WhatIsAnIndexandItsType.pdf

017 What is an INDEX.mp4

12:32

018 Clustered ,NonClustered Indexes and Index Design considerations.mp4

15:41

018 Clustered-NonClusteredIndex.pdf

019 IndexFragmenationAndLab.pdf

019 Index Fragmentation and Lab for Index.mp4

30:37

019 dmvindexfragmentation.txt

019 index.txt

019 restoreadventureworkstest.txt

07 - Microsoft SQL Database Administration and System databases

001 Welcome to Microsoft SQL Database Administration and System Databases.mp4

01:36

002 OverviewofMSSQLManagementTools.pdf

002 Overview of MSSQL Management Tools.mp4

22:59

003 69.Exploring-SQL-Server-Management-Studio-SSMS-part-1.docx

003 ExploringSQLServerManagementStudio.pdf

003 Exploring SQL Server Management Studio (SSMS) (part -1).mp4

34:32

004 70.Exploring-SQL-Server-Management-Studio-SSMS-part-2.docx

004 ExploringSQLServerConfigurationManager.pdf

004 ExploringSQLServerManagementStudio.pdf

004 Exploring SQL Server Management Studio (SSMS) (part -2).mp4

25:26

005 ExploringSQLServerConfigurationManager.pdf

005 Exploring SQL Server Configuration Manager.mp4

16:10

006 MSSQL System Databases, DOs and DONTs of System databases.mp4

11:51

006 SystemDatabases.pdf

007 WhatIsMasterDatabase.pdf

007 What is master Database.mp4

36:29

008 74.What-is-tempdb-Database.docx

008 WhatIsTempDB.pdf

008 What is tempdb Database.mp4

38:28

009 75.What-is-msdb-Database.docx

009 WhatIsMSDB.pdf

009 What is msdb Database.mp4

32:37

010 76.Other-system-Databases-model-distribution.docx

010 ModelandResourceSystemDatabases.pdf

010 Other system Databases (model,distribution).mp4

32:27

08 - Deep Dive into MSSQL Working

001 Deep-Dive-into-MSSQL-Working.pdf

001 Welcome to Deep Dive into MSSQL working.mp4

01:38

002 78.What-are-Pages-Extents-Page-Architecture-and-PFS.docx

002 WhatarePagesAndExtentsandtheirArchitecture.pdf

002 What are Pages , Extents, Page Architecture and PFS.mp4

25:59

003 MSSQLArchitecture.pdf

003 MSSQL Architecture.mp4

39:32

004 80.MSSQL-Database-Architecture.docx

004 MSSQLDatabaseArchitecture.pdf

004 MSSQL Database Architecture.mp4

31:56

005 Operation and working of transaction log.mp4

15:42

005 TheOperationAndWorkingOfTransactionLog.pdf

09 - MSSQL Backup and Restore

001 Welcome to MSSQL Backup and Restore.mp4

02:32

002 BackupofaDatabaseanditsImportanceforDBA.pdf

002 Backup of a Database, Importance for DBA and Different Medias used for Backups.mp4

22:03

003 RecoveryModelinMSSQL.pdf

003 Recovery Models in MSSQL and how that impact backups and restore.mp4

29:05

004 FullBackups.pdf

004 Full Backups.mp4

24:34

005 DifferentialBackups.pdf

005 Differential Backups.mp4

15:44

006 TransactionLogBackups.pdf

006 Transaction Log Backups, Log Backup Chain and Tail-log Backup.mp4

19:09

007 Lab for Full, Differential and Transaction Log Backups.mp4

30:33

007 backuprestorequeries.txt

008 RestoreAndRecoveryOverview.pdf

008 Restore and Recovery Overview.mp4

13:23

009 FullDatabaseRestore.pdf

009 Full, Differential and Transaction Log database restore.mp4

13:18

010 Point in time restore of a database.mp4

11:56

011 92.Complete-Backup-Restore-and-Restore-in-Time-Lab.docx

011 Complete Backup , Restore and Restore in Time Lab.mp4

55:19

012 93.MS-SQL-Server-DBCC-CHECKDB-command.docx

012 DBCCCheckDB.pdf

012 MS SQL Server DBCC CHECKDB command.mp4

23:36

013 94.Page-Level-Restore-Recovery-using-Full-Backups.docx

013 Page Level Restore Recovery using Full Backups.mp4

18:56

014 95.Restore-Master-Database.docx

014 ResourceMasterRestore.txt

014 Restore Master Database.mp4

24:49

015 Creating Maintenance Plan Backups Re indexing etc.mp4

29:39

10 - MSSQL User Management

001 MSSQL-User-Management.pdf

001 Welcome to MS SQL User Management.mp4

01:54

002 MSSQL Security Model.mp4

18:20

002 SecurityModel.pdf

003 AuthenticationModes.pdf

003 MSSQL Server Authentication Modes.mp4

22:05

004 100.Principals-Part-1-Server-Logins-Server-Roles.docx

004 Principals (Part-1) Server Logins, Server Roles.mp4

42:40

004 SQLServerLoginsandSQLServerRoles.pdf

005 101.Principals-Part-2-Database-Users-Database-Roles.docx

005 DatabaseUsersAndDatabaseRoles.pdf

005 Principals (Part-2) Database Users, Database Roles.mp4

30:10

006 102.Permissions-GRANT-DENY-REVOKE.docx

006 Permissions.pdf

006 Permissions (GRANT , DENY , REVOKE).mp4

22:52

11 - MSSQL Server Agent Management

001 Welcome to Overview of MSSQL Server Agent.mp4

02:06

002 SQLServerAgentIntro.pdf

002 SQL Server Agent Introduction.mp4

08:27

003 105.SQL-Server-Agent-Jobs-and-Schedules.docx

003 SQLServerAgentJobsSchedules.pdf

003 SQL Server Agent Jobs and Schedules.mp4

36:59

004 Agent Alerts ,Operators , Database Mail and Activity Monitor.mp4

29:57

004 SQLServerAgentAlertsOperators.pdf

12 - Advanced SQL Server Administration Topics

001 AdvancedTopicsSQLServer.pdf

001 Introduction to Advanced Topics in MSSQL Server Administration.mp4

02:55

002 AvailabilityAndItsTypes.pdf

002 High Availability and its Types.mp4

22:27

003 Replication.pdf

003 What Is Replication and Transactional Replication Setup.mp4

31:22

004 110.Transactional-Replication-Setup-LAB.docx

004 Transactional Replication Setup (LAB).mp4

36:31

005 111.Log-Shipping-and-Configuring-Log-Shipping.docx

005 Log Shipping and Configuring Log Shipping.mp4

36:29

006 Query-Tuning.pdf

006 SQL Server Query Tuning.mp4

14:34

007 Query Optimization Lab.mp4

18:59

007 querytuninglab.zip

008 115.Transparent-Data-Encryption-TDE-Configuration-and-Restore-of-TDE-Databases.docx

008 LogShippingAndConfiguringLogShipping.pdf

008 SQLServerEncryptionAndTypes.pdf

008 SQL Server Encryption and Encryption Types.mp4

19:15

009 TDEEncryption.pdf

009 Transparent Data Encryption (TDE) , Configuration and Restore of TDE Databases.mp4

39:23

13 - Course Recap

001 MSSQLSlides.zip

001 SQLCheatSheat.docx

001 SQLServerDBAQuestions.docx

001 SQL Queries We Have Learned.mp4

12:26

002 Congratulations.mp4

00:08

003 Dont Give Up!.mp4

01:12

004 Bonus Lecture.mp4

03:38

Description

Mastering Database Management and Security with Microsoft SQL Server

What You'll Learn?

By the end of this course you will be a professional SQL database administrator and be able to apply for SQL jobs
Administration of SQL database through Microsoft Windows
You will learn 150+ SQL queries
You will be able to troubleshoot everyday SQL related issues
You will manage SQL servers in a corporate environment
You will write basic to advance SQL queries
Troubleshoot everyday SQL database related issues
Know how to answer specific business questions by using SQL’s aggregate functions
Students will be able to run reports for management so they can make financial decisions

Who is this for?

Anyone who wants to start a career in SQL database administration

Anyone who wants to have complete SQL database training to get a job in IT

Anyone who wants to advance his/her career

Anyone who wants to master the SQL command line skills

College students

IT professionals

Teachers and instructors

What You Need to Know?

Positive attitude and desire to learn

Passion to become SQL database administrator

A PC or MAC with at least 4-8G of RAM

More details

Description
Microsoft SQL Server continues to be one of the world's most popular and top databases.Â DatabaseÂ is a heart of IT which is needed to stored all critical data and information.Â

If you want to become SQLÂ database administrator then this is the PERFECT course for YOU.Â This training course will provide you all the necessary skills you need to be a successful database administrator.Â The "Complete Microsoft SQL Server Database Administration Course" is designed to provide a comprehensive understanding of database administration using Microsoft SQL Server. This course is ideal for IT professionals, database administrators, and anyone interested in learning about SQL Server infrastructure. It covers key aspects such as installation, configuration, maintenance, security, and performance tuning of SQL Server databases

Here is the course outline:
Section 1 - Introduction
Introduction to Database
RDBMS
What is SQL?
Top 5 RDBMS
Introduction to MS SQL Server
Different editions of MS SQL

Section 2 - Download, Install and Configure Windows
MS SQL Server prerequisite
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

Section 3 - Download, Install and Configure MS SQL Server
Prerequisites for MSSQL Installation
Download MSSQL and SQL Server Management Studio
Install and Configure MSSQL
Install SQL Server Management Studio
Download and Install AdventureWorks Database

Section 4 - Database Fundamentals and Design
What is Data and Database?
How is data stored?
What is a Table, COLUMN and ROW ?
What is a key? primary, foreign, 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â€¦

Section 5 - 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

Section 6 - Query and Manipulation of Data using SQL
Create TABLE(s) and Temp Table(s)
What Is a View?
SELECT Statement in detail
Operators, Expressions and Conditions
WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause
Select from two tables â€“ JOINS
Different Types of JOINS
What is a Sub Query?
INSERT, UPDATE, DELETE and Truncate Statements
What is a Store Procedure?
Function, Trigger and INDEX
Clustered ,Non-clustered Indexes and Index Design considerations
Index Fragmentation and Lab for Index

Section 7 - Microsoft SQL Database Administration
Overview of MSSQL Management Tools
Exploring SQL Server Management Studio (SSMS)
Exploring SQL Server Configuration Manager
MSSQL System Databases, DO's and DONT's of System databases
What is master, etmpdb, msdb and other system databases?

Section 8 - Deep Dive into MSSQL Working
What are Pages , Extents, Page Architecture and PFS?
MSSQL Architecture
MSSQL Database Architecture
Operation and working of transaction log
Configuring user Database
Best practices while creating user Database

Section 9 - 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 and 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.

Section 10 - MSSQL User Management
MSSQL Security Model
MSSQL Server Authentication Modes
Server Logins
Server Roles
Database Users
Database Roles
Permissions (GRANT , DENY, and REVOKE)

Section 11 - MSSQL Server Agent Management
SQL Server Agent Introduction
SQL Server Agent Jobs and Schedules
Agent Alerts
Operators
Database Mail
Activity Monitor

Section 12 - Advanced SQL Server Administration Topics
High Availability and its Types
What Is Replication and Transactional Replication
Transactional Replication Setup (LAB)
Log Shipping and Configuring Log Shipping
SQL Server Encryption and Encryption Types
Transparent Data Encryption (TDE) and configuration

Section 13 - Course Re-cap
Commands we have learned
Who this course is for:
Anyone who wants to start a career in SQL database administration
Anyone who wants to have complete SQL database training to get a job in IT
Anyone who wants to advance his/her career
Anyone who wants to master the SQL command line skills
College students
IT professionals
Teachers and instructors

User Reviews

Rating

average 0

Total votes0

Focused display

Best-selling Instructor with 500k+ students worldwide, CEO, Educational Content Creator, Mentor, IT Professional, Entrepreneur (MBA)Imran Afzal has over 20 years of experience in Systems administration/engineering, leadership, entrepreneurship, training, and public speaking.Currently Imran manages a large team of systems engineers, administrators and team leads globally. He started his career with Time Warner (New York City) in 2000 as a systems administrator. That is where he began his IT career.He has utilized IT skills in many fortune 500 companies such as financial firm, fashion industry, tech media industry etc. He spearheaded projects like datacenter migration, introduction and deployment of VMWare, monitoring tools implementation, Amazon cloud migration and many more.Imran earned his bachelor’s in Computer Information Systems from Baruch College, City University of New York as an honor student. He earned his Master of Business Administration (MBA) from New York Institute of Technology (NYIT).Some of his certifications are in Linux Systems Management, UNIX Operating Systems, Linux System Administration, System Internals, VMWare Certified Professional, RHCSA and Windows Server CertifiedImran has been training since 2010 and provides onsite and online training on many IT subjects. He has some of the bestselling and highest rated online courses with over 400,000 students worldwide. He has helped almost 1000+ students to land a job of their dream in IT.He believes in education and giving back. He also established a non-profit school for children from pre-K till 10th grade.Here is what students have to say:Hi Imran, I have completed this course twice. It was more than just wonderful. It proved to be life changer for me, I had zero knowledge about Linux and now i am working as Linux SysAdmin as i have acquired my dream job. Thank you so much for the wonderful course. I am looking forward to see some more exciting courses from you.Regards, -- Hasan RazaTo all of you that are looking for a REALLY GOOD LINUX course, THIS IS IT, SERIOUSLY I promise you won't find a course on LINUX here that is THIS GOOD. -- T.J. MarstillerHi Imran, I am so glad to inform you that i got two offers as a Linux engineer. Through your course I gained lot of confidence and your interview tips really helped me a lot to crack the technical rounds. I have recommended your courses to my friends as well. Thank you so much for your efforts in sharing your knowledge to learners like us. -- SubhasreeHi Sir Imran,Greetings to you. I am writing this email to give good feedback regarding your course materials that I have watched from Udemy. I have completed your Linux course and I would like to mention that it has been nothing but awesome. Your course has allowed me to obtain a Linux certification and I would like to give a big thanks you for that. Please continue what you're doing and I wish you the very best. -- Yusuf IshkandershaImran is a very knowledgeable and engaging instructor. As others have said, you can tell that he is not just trying to sell a course, but that he is invested in giving his students a strong career foundation with a positive and approachable attitude. He is also entertaining with his use of pop culture and practical work examples. It really feels like you're in a classroom with him. I'm taking this course mainly as a hobbyist, but got a lot from it already. The homework assignments, quizzes, and handouts help reinforce the material. -- Raymond B.- Main thing about course is its simplicity and the hierarchy. Design is very good and easy which helps to understand things better. -- Akash Garg (Udemy Student)- I just love the teaching ad the learning experience I am getting -- Jacob Samba (Udemy Student)- Imran Afzal might be my favorite teacher I've EVER had. He is funny, and engaging. The course was easy to follow, and with no experience starting I am now extremely comfortable with Linux, and actually really like it. He does make you do your googles, but this is not a bad thing especially considering the nature of IT and documentation to solve your own problems. I highly recommend. -- Vanessa Diaz-Goumond (Udemy Student)- The course is run very well and I really like the handouts and the homework that is assigned. The homework helps me learn and continue with the learning process even when adult life is still progressing forward. -- Thomas Rogers (Udemy Student)- Such an amazing instructor. Imran must have put in a lot of effort in structuring the course and taking the student step by step, he takes his time in explaining everything, from what Linux is, how to down load it, coding, etc. I have taken other courses from Imran. I am a student for life. Keep it up and please keep preparing more courses for please like us who can benefit from your way of teaching, knowledge and experience. Thank you. -- Ali Shiekh (Udemy Student)- In the first place I say a big thank you to the instructor for making such a great course. I was afraid to learn Linux. I now feel very comfortable with Linux. I have understood both the concept behind and the practical as well. I would recommend every one who is NEW to Linux and wants to grab it once and for all without wasting time to go ahead and ERNOLL. You will not regret it. I would like the instructor to do same for WINDOWS SERVER ADMIN., I don't seem to find any better and beginner oriented course out there that could be matched with this course. To me, it is the BEST Linux Course on Online. I just started some real world projects with Linux after this great course, I was new to Linux and in just a month I am on the command line always playing. -- Opoku Bright (Udemy Student)- I genuinely look forward to additional courses in the future. This has been so informative. You hear the name oracle all the time, but this was well put in layman’s terms -- Atoofa Hasan (Classroom Student)- Imran Afzal eats, breathes and sleeps Linux! He really knows his stuff. I feel like he has brought me from a novice level education to masters level in a short time period. Anyone who is looking to get a job in Linux should definitely take this course. -- TJ Walker (Mentor)- I find it very easy to understand & learn Linux. Even if you are beginner in Linux you will understand the material. Imran has done a great job explaining every topic in detail in each course. This course has provided me with a great deal of knowledge about Linux. This course is worth every penny of yours. -- Mohammad Jalani (Classroom Student)

Abbas Mehmood

Instructor's Courses

I am working in IT since 2005 in various roles , I started my career as System Engineer and later worked as a developer. Couple of years after working as .net developer I finally changed my career to be Data Base Administrator which was my specialization in my MS . I did MS in CS from CUNY. In last 15 years I have worked with Government and Private organization in different capacities mostly working on Data Base administration and development.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.