SQL Server 2022 Database Administration Essential Training

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