Overview

This course has been designed to give you the knowledge and skills to become an expert SQL Server Database Administrator. If you want to become a SQL database administrator, then this is the course for you. Here is the course outline:Section 1 - IntroductionIntroductionWhat is SQL ServerSection 2 - Setting Up Your EnvironmentSQL Server EditionsInstalling SQL Server 2022Install Management StudioSQL Server Configuration ManagerWorking With SQL Server in DockerSection 3 - Database Creation & ConfigurationSQL Server System DatabasesDatabase Storage StrategiesCapacity and growth considerationsConfiguring Model DatabaseCreating a DatabaseSQL Server contained databaseSection 4 - Securing Your SQL ServerManaging Users & LoginManaging Contained UsersImplementing Instance-Level SecurityImplementing Database-Level SecuritySQL Server Audit SpecificationsConfiguring Server and Database AuditData Discovery & ClassificationSQL Vulnerability AssessmentSection 5: Backup & RestoreIntroduction to Backup and RestoreUnderstanding Recovery ModelsHow to Perform Full BackupsHow to Perform a Differential BackupTransaction log backupsPerforming RecoveryBackup StrategiesSection 6: Automating Maintenance RoutinesWhat is SQL Server Job AgentAutomating Processes with SQL Server AgentConfiguring and Sending Database MailAutomating database backupsSection 7: Performance & MonitoringReviewing server logsExposing Dynamic Management Views (DMVs)Database Console Commands for SQL ServerSQL Server Activity MonitorIndexes for performance tuningIntroduction to the SQL Server Query StoreSection 7: Migrate & Import DataIntroductionMigrating Databases to Amazon Web Services (AWS)Detaching and Attaching Databases to an InstanceMigrating to Azure and Docker using bacpac archiveImporting and exporting dataWho 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 ITAnyone who wants to advance his/her careerCollege students looking to pursue database administration. IT Infrastructure Professionals

Skills

Reviews