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 course for YOU. This training course will provide you all the necessary skills you need to be a successful database administrator. Plus, this course will prepare you for the SQL Server MCSA certification. Here is the course outline: Section 1 - IntroductionIntroduction to DatabaseRDBMSWhat is SQL?Top 5 RDBMSIntroduction to MS SQL ServerDifferent editions of MS SQLSection 2 - Download, Install and Configure WindowsMS SQL Server prerequisiteLab setupWhat is virtualization?Download and Install VMWare Workstation PlayerOptional - Download and Install Oracle VirtualboxCreate a Virtual MachineDownload and Install Windows ServerVirtual Machine ManagementSection 3 - Download, Install and Configure MS SQL ServerPrerequisites for MSSQL InstallationDownload MSSQL and SQL Server Management StudioInstall and Configure MSSQLInstall SQL Server Management StudioDownload and Install AdventureWorks DatabaseSection 4 - Database Fundamentals and DesignWhat 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 NormalizationCreate your first Database, Table and Populate table with data…Section 5 - Introduction to SQL CommandsWelcome to Basic SQL CommandsWhat is a SQL Statement and types of SQL statementsDML Statement with examplesDDL Statements with examplesDCL Statement with examplesTCL Statement with examplesSection 6 - Query and Manipulation of Data using SQLCreate TABLE(s) and Temp Table(s)What Is a View?SELECT Statement in detailOperators, Expressions and ConditionsWHERE Clause, ORDER BY, HAVING BY, GROUP BY ClauseSelect from two tables - JOINSDifferent Types of JOINSWhat is a Sub Query?INSERT, UPDATE, DELETE and Truncate StatementsWhat is a Store Procedure?Function, Trigger and INDEXClustered , Non-clustered Indexes and Index Design considerationsIndex Fragmentation and Lab for IndexSection 7 - Microsoft SQL Database AdministrationOverview of MSSQL Management ToolsExploring SQL Server Management Studio (SSMS)Exploring SQL Server Configuration ManagerMSSQL System Databases, DO's and DONT's of System databasesWhat is master, etmpdb, msdb and other system databases?Section 8 - Deep Dive into MSSQL WorkingWhat are Pages , Extents, Page Architecture and PFS?MSSQL ArchitectureMSSQL Database ArchitectureOperation and working of transaction logConfiguring user DatabaseBest practices while creating user DatabaseSection 9 - MSSQL Backup and RestoreBackup of a Database, Importance for DBA and Different Media used for BackupsRecovery Models in MSSQL and how that impact backups an restoreFull and differential backupsTransaction Log Backups, Log Backup Chain and Tail-log BackupLab for Full, Differential and Transaction Log BackupsRestore and Recovery OverviewFull, Differential and Transaction Log database restorePoint in time restore of a databaseComplete Backup , Restore and Restore in Time LabMS SQL Server DBCC CHECKDB commandPage Level Restore / Recovery using Full BackupsCreating Maintenance Plan Backups/Re-indexing etc. Section 10 - MSSQL User ManagementMSSQL Security ModelMSSQL Server Authentication ModesServer LoginsServer RolesDatabase UsersDatabase RolesPermissions (GRANT , DENY, and REVOKE)Section 11 - MSSQL Server Agent ManagementSQL Server Agent IntroductionSQL Server Agent Jobs and SchedulesAgent AlertsOperatorsDatabase MailActivity MonitorSection 12 - Advanced SQL Server Administration TopicsHigh Availability and its TypesWhat Is Replication and Transactional ReplicationTransactional Replication Setup (LAB)Log Shipping and Configuring Log ShippingSQL Server Encryption and Encryption TypesTransparent Data Encryption (TDE) and configurationSection 13 - Course Re-capCommands we have learned
