Complete Microsoft SQL Server Database Administration Course

سرفصل های دوره

Mastering Database Management and Security with Microsoft SQL Server

01 - Introduction

001 Introduction

002 Course overview

003 Introduction to Database

004 What is RDBMS

005 What is SQL

006 Top 5 RDBMS using SQL

007 Introduction to Microsoft SQL Server

008 Different Editions of Microsoft SQL

02 - Download, Install and Configure Windows

001 Welcome to Download, Install and Configure Windows

002 MS SQL Server Pre-requisite

003 Lab Setup

004 What is Virtualization

005 Download and Install VMWare Workstation Player

006 Optional - Download and Install Oracle Virtualbox

007 Create a Virtual Machine

008 Download and Install Windows Server (2016)

009 Download and Install Windows Server (2019)

010 Virtual Machine Management

03 - Download, Install and Configure MS SQL Server

001 Section-3-Intro.pdf

001 Welcome to Download, Install and Configure Microsoft SQL

002 Prerequisites for MSSQL 2016 Installation

002 Section-3-Lec-1.pdf

003 Prerequisites for MSSQL 2022 Installation

003 SQLServer2022-prerequisites.pdf

004 Download and Install Chrome Browser

005 Download MSSQL and SQL Server Management Studio

005 Section-3-Lec-2.pdf

006 Install and Configure MSSQL 2016

006 Section-3-Lec-3.pdf

007 Install and Configure MSSQL 2019

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

008 Download and Install MSSQL 2022

009 Install 2016 SQL Server Management Studio

009 Section-3-Lec-4.pdf

010 Install 2018 SQL Server Management Studio

011 Install 2019 SQL Server Management Studio

012 Download and Install AdventureWorks Database

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

002 Section-4-Lec-1.pdf

002 What is Data

003 Section-4-Lec-2.pdf

003 What is Database

004 How Data is Stored

004 Section-4-Lec-3.pdf

005 Section-4-Lec-4.pdf

005 What is a Table, COLUMN and ROW

006 WhatIsAKeyAndTypes.pdf

006 What is a Key

007 WhatIsPrimaryForeignKey.pdf

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

008 WhatIsRDBMS.pdf

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

009 WharAreACIDProperties.pdf

009 What is a Transaction and ACID properties

010 Database Normalization AND Different forms of Database Normalization

010 WhatIsNormalizationAndFormsOfNormalization.pdf

011 CreateYourFirstDatabase.pdf

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

05 - Introduction to SQL Commands

001 WelcomeToBasicSQLCommands.pdf

001 Welcome to Basic SQL Commands

002 What is a SQL Statement and types of SQL statements

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

003 DMLStatementswithexamples.pdf

003 DML Statement with examples

004 DDLStatementswithexamples.pdf

004 DDL Statements with examples

005 DCLStatementsWithExamples.pdf

005 DCL Statement with examples

006 TCLStatementsWithExamples.pdf

006 TCL Statement with examples

06 - Query and Manipulation of Data using SQL

001 WelcomeQueryandManipulationofDatausingSQL.pdf

001 Welcome to Query and Manipulation of Data using SQL Commands

002 CreateTABLE-s-andTempTable-s.pdf

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

002 ResourceForTableTempTable.txt

003 WhatIsAView.pdf

003 What Is a View

003 view.txt

004 SELECTStatementWithDetails.pdf

004 SELECT Statement in detail

004 selectqueries.zip

005 OperatorsExpressionsandConditions.pdf

005 Operators, Expressions and Conditions

006 WHEREClauseOrderByClauseGroupByClauseHavingClause.pdf

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

006 selectwithoperators.zip

007 Select from two tables - JOINS

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

007 SlectFrom2Tables.txt

008 DifferentTypesOfJoin.txt

008 Different Types of JOINS

009 What is a Sub Query

009 subquery.txt

010 INSERTStatementindetail.pdf

010 INSERT Statement in detail

010 insert.txt

011 UPDATEStatementindetail.pdf

011 UPDATE Statement in detail

011 update.txt

012 DELETEStatementindetail.pdf

012 DELETE Statement in detail

012 delete.txt

013 DeleteVSTruncate.pdf

013 Difference between DELETE and Truncate Statement

013 truncate.txt

014 What is a Stored Procedure

014 storedprocedure.txt

015 WhatisAFunction.pdf

015 What is a Function

015 functions.txt

016 WhatisATrigger.pdf

016 What is a Trigger

016 trigger.txt

017 WhatIsAnIndexandItsType.pdf

017 What is an INDEX

018 Clustered ,NonClustered Indexes and Index Design considerations

018 Clustered-NonClusteredIndex.pdf

019 IndexFragmenationAndLab.pdf

019 Index Fragmentation and Lab for Index

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

002 OverviewofMSSQLManagementTools.pdf

002 Overview of MSSQL Management Tools

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

003 ExploringSQLServerManagementStudio.pdf

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

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)

005 ExploringSQLServerConfigurationManager.pdf

005 Exploring SQL Server Configuration Manager

006 MSSQL System Databases, DOs and DONTs of System databases

006 SystemDatabases.pdf

007 WhatIsMasterDatabase.pdf

007 What is master Database

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

008 WhatIsTempDB.pdf

008 What is tempdb Database

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

009 WhatIsMSDB.pdf

009 What is msdb Database

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

010 ModelandResourceSystemDatabases.pdf

010 Other system Databases (model,distribution)

08 - Deep Dive into MSSQL Working

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

001 Welcome to Deep Dive into MSSQL working

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

002 WhatarePagesAndExtentsandtheirArchitecture.pdf

002 What are Pages , Extents, Page Architecture and PFS

003 MSSQLArchitecture.pdf

003 MSSQL Architecture

004 80.MSSQL-Database-Architecture.docx

004 MSSQLDatabaseArchitecture.pdf

004 MSSQL Database Architecture

005 Operation and working of transaction log

005 TheOperationAndWorkingOfTransactionLog.pdf

09 - MSSQL Backup and Restore

001 Welcome to MSSQL Backup and Restore

002 BackupofaDatabaseanditsImportanceforDBA.pdf

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

003 RecoveryModelinMSSQL.pdf

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

004 FullBackups.pdf

004 Full Backups

005 DifferentialBackups.pdf

005 Differential Backups

006 TransactionLogBackups.pdf

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

007 Lab for Full, Differential and Transaction Log Backups

007 backuprestorequeries.txt

008 RestoreAndRecoveryOverview.pdf

008 Restore and Recovery Overview

009 FullDatabaseRestore.pdf

009 Full, Differential and Transaction Log database restore

010 Point in time restore of a database

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

011 Complete Backup , Restore and Restore in Time Lab

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

012 DBCCCheckDB.pdf

012 MS SQL Server DBCC CHECKDB command

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

013 Page Level Restore Recovery using Full Backups

014 95.Restore-Master-Database.docx

014 ResourceMasterRestore.txt

014 Restore Master Database

015 Creating Maintenance Plan Backups Re indexing etc

10 - MSSQL User Management

001 MSSQL-User-Management.pdf

001 Welcome to MS SQL User Management

002 MSSQL Security Model

002 SecurityModel.pdf

003 AuthenticationModes.pdf

003 MSSQL Server Authentication Modes

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

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

004 SQLServerLoginsandSQLServerRoles.pdf

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

005 DatabaseUsersAndDatabaseRoles.pdf

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

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

006 Permissions.pdf

006 Permissions (GRANT , DENY , REVOKE)

11 - MSSQL Server Agent Management

001 Welcome to Overview of MSSQL Server Agent

002 SQLServerAgentIntro.pdf

002 SQL Server Agent Introduction

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

003 SQLServerAgentJobsSchedules.pdf

003 SQL Server Agent Jobs and Schedules

004 Agent Alerts ,Operators , Database Mail and Activity Monitor

004 SQLServerAgentAlertsOperators.pdf

12 - Advanced SQL Server Administration Topics

001 AdvancedTopicsSQLServer.pdf

001 Introduction to Advanced Topics in MSSQL Server Administration

002 AvailabilityAndItsTypes.pdf

002 High Availability and its Types

003 Replication.pdf

003 What Is Replication and Transactional Replication Setup

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

004 Transactional Replication Setup (LAB)

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

005 Log Shipping and Configuring Log Shipping

006 Query-Tuning.pdf

006 SQL Server Query Tuning

007 Query Optimization Lab

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

009 TDEEncryption.pdf

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

13 - Course Recap

001 MSSQLSlides.zip

001 SQLCheatSheat.docx

001 SQLServerDBAQuestions.docx

001 SQL Queries We Have Learned

002 Congratulations

003 Dont Give Up!

004 Bonus Lecture

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy