SQL Server Database Administrator Part-1 - Druckversion +- Forum Rockoldies (https://rockoldies.net/forum) +-- Forum: Fotobearbeitung - Photoshop (https://rockoldies.net/forum/forumdisplay.php?fid=16) +--- Forum: E-Learning, Tutorials (https://rockoldies.net/forum/forumdisplay.php?fid=18) +--- Thema: SQL Server Database Administrator Part-1 (/showthread.php?tid=41075) |
SQL Server Database Administrator Part-1 - Panter - 02.12.2021 SQL Server Database Administrator Part-1 Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz Language: English | Size: 7.79 GB | Duration: 19h 21m What you'll learn Learn SQL Server database administration step by step. Installation, Configuration, Working with databases, Security, Database Backups and Restores, DB Mail. Installing and Configuration SQL Server Working with Databases and database architecture and common database issues Working with Security, Backups and automation, Database Mail Description SQL Server Database Administration Part-1 covers all necessary topics to enter as a DBA. This course covers the administration basics including the following concepts. This course is the startup course to become SQL Server Database Administrator. You can opt for Part-2 to become complete SQL Server DBA. In Part-2 I will discuss all high availability concepts including Log Shipping, Database Mirroring, Always On, Replication, Clustering and Performance Tuning concepts along with troubleshooting common issues. Introduction to SQL Server Application Architecture DBA - Roles and Responsibilities Introduction to SQL Server Introduction to SQL SQL Server Tools SQL Server Services How to Start/Stop Services SQL Server Instances Default and Named Instances Instance Summary Installation Pre-Requisites SQL Server Installation Installing using Configuration File Working with Configurations Verifying Installation using summary.txt file Configuring Data and Log File Locations Configuring ErrorLogs Using Trace Flags Configuring Backup Folder Paths Patching SQL Server How to rollback the patches Configuring Memory Configuring CPU Configuring Remote Connections Basic Query Life Cycle Stages Configuring DAC Working with Databases both System and User Defined System Databases Moving master, msdb and TempDB databases Database Architecture Log File Architecture- VLFs, Blocks, LSN Data File Architecture - Extents, Pages Page Architecture Types of Pages Database States Database Suspect Mode scenarios Errors 17207, 17204 Rebuilding master database Troubleshooting common database issues Working with Transaction Log file and its common issues Working with Security Features Users, Permissions and Role management Server Roles Database Roles Orphan users, how to resolve orphan users Creating users with passwords from SQL Server 2012 Encryptions Recovery Models Checkpoints Types of Checkpoints Backups and Restores Different Types of Backups Full, Differential, T.Log backups File, Filegroup Backups Copy-only backups Backup Compression Restoring databases Database Recovery States How to take tail log backup checksum and SQL Server Backups checksum and restores common backup and restore issues Who this course is for: Freshers, SQL Server developers, Oracle DBAs, any student who wants to become SQL DBA Download from RapidGator Download from Rapidgator: Download from Keep2Share |