Published 12/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.25 GB | Duration: 2h 9m
SQL Server Database Administration What you'll learn How to install and configure SQL Server on a server as well in a docker container How to manage instance level and database level security. How to perform backups and restores How to perform point-in- restores How to automate repetitive task with SQL Server Agent How to perform vulnerability assessment Troubleshooting and monitoring using logs and DMVs Requirements No experience needed Description This course has been designed to give the Knowlege and skill to become an expert SQL Server Database Administrator. If you want to become 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 StratsCapacity 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 Differential BackupTransaction log backupsPerfog RecoveryBackup StratsSection 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)Using database console commands (DBCC)Who this course is for:Anyone who wants to start a career in SQL database administrationAnyone 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 Overview Section 1: Introduction Lecture 1 Introduction Lecture 2 What is SQL Server Section 2: Setting Up Your Environment Lecture 3 SQL Server Editions Lecture 4 Installing SQL Server 2022 Lecture 5 Installing Management Studio Lecture 6 SQL Server Configuration Manager Lecture 7 Working With SQL Server in Docker Section 3: Database Creation & Configuration Lecture 8 SQL Server System Databases Lecture 9 Database Storage strats Lecture 10 Capacity and growth considerations Lecture 11 Configuring Model Database Lecture 12 Creating a Database Lecture 13 SQL Server contained database Section 4: Securing Your SQL Server Lecture 14 Managing Users & Login Lecture 15 Demo: Managing Users & Logins Lecture 16 Managing Contained Users Lecture 17 Implementing Instance-Level Security Lecture 18 Implementing Database-Level Security Lecture 19 SQL Server Audit Specifications Lecture 20 Configuring Server and Database Audit Lecture 21 Data Discovery & Classification Lecture 22 SQL Vulnerability Assessment Section 5: Backup & Restore Lecture 23 Introduction Lecture 24 Understanding Recovery Models Lecture 25 How to Perform Full Backups Lecture 26 How to Perform Differential Backup Lecture 27 Transaction log backups Lecture 28 Perfog Recovery Lecture 29 Backup Strats Section 6: Automating Maintenance Routines Lecture 30 What is SQL Server Job Agent Lecture 31 Automating Processes with SQL Server Agent Lecture 32 Configuring and Sending Database Mail Lecture 33 Automating Database Backups Section 7: Performance & Monitoring Lecture 34 Reviewing SQL Server Logs Lecture 35 Understanding how Dynamic Management Views Works Developer,Database Administrator,I.T and Computer Science graduates,Aspiring Database Administrators HomePage:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.