β
Accredited by the Council of Higher Education
β
Authorized Exam Center for All Certificates.
β
In-person/Classroom & Online Live Classes
β
Exam Prep Boot Camp
β
Interview & Job Prep Boot Camp
β
Real-Life Working Environment
β
No IT Background Required
β
Excellent supporting team
β
Excellent Success Rate
β
Course completion certificate
Job Title:
β
Database Engineer\ Database Administrator
β
Azure DBA
β
Azure SQL DBA
β
SQL DBA
β
Data Analyst
β
Database Architect
β
Database Developer
β
Report Developer
β
ETL Developer
β
Data Warehouse Administrator
Course Outline:
Chapter 1: Introduction, Installation, Configuration Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β
- Database Administration Overview
- Introduction to the SQL Server Platform Database
- Management Tools and Techniques
- Lab:Β Using SQL Server Administrative Tools
- Installing SQL Server 2012, 2014, 2016, 2019
- Post-Installation Configuration
- Lab:Β Installing SQL Server using different -installation 2014, 2016, 2019
- Lab:Β Post-installation configurations and harden SQL Server
- Lab:Β Create, Configure and manage Databases
Chapter 2: Database Design Configuration
- Introduction to Data Storage for SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
- Data Modeling
- Lab:Β Configuring and managing storage for data and log files
- Lab:Β Managing Database Storage
- Lab: Data Modeling
Chapter 3: DR Solution, Planning & Implementation (Back up)
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using Backup Options Ensuring Backup Reliability
- Checkpoint
- Different types of backup
- Lab:Β Backup strategy, retention policy
- Lab:Β Backing Up SQL Server Databases
- Lab:Β Setup jobs and alert
Restoring DatabasesΒ Β Β Β Β Β Β Β Β Β Β
- Understanding Restore Process
- Restoring Databases
- Advanced Restore Scenarios/Pending Recovery
- Working with Point-in-Time Recovery
- Lab:Β Restoring SQL Server Databases
- Lab:Β Restoring Databases with different recovery options like data loss and no data loss, Point in time recovery
Chapter 4: Automating SQL Server Management and Maintenance
- Implementing SQL Server Agent Jobs
- Managing SQL Server Agent Jobs
- Managing Jobs across Multiple Servers
- Managing Job Step and job security
- Lab: Automate Database Management
- Lab: Setup jobs
- Lab: Automate jobs
- Lab: Setup Alert
- Lab: Manage and Troubleshoot jobs and alert
Configure Database Mail Server
- Create and manage Operators
- Configure and Manage Alerts, and Notifications
- Monitoring Server using notifications and Errors
- Lab:Β Configure Mail Server
- Lab:Β Create and Manage Operators
- Lab:Β Create and Manage Alerts and Notifications
- Lab:Β Monitor Server by Using Alerts and Notifications
- Lab:Β Troubleshooting based on Alerts and Notifications
Chapter 5: Security Introduction to SQL Server Security
- Different options in Securing Server and data in SQL Server
- Deploying different security options
- Managing Server-Level Security
- Managing Database-Level Security
- Managing Database Grants
- Managing Object-level security (Table-level, column-level, row-level)
- Monitoring and troubleshooting security
- Lab:Β Managing SQL Server Security
- Lab:Β Deploying different security options
Introduction to TDE (Transparent Data Encryption)
- Encryption Algorithms
- Deploying and managing Encryption using TDE (Database level & column level)
- Change data capture (CDC)
- Always Encrypted
- Dynamic Data Masking (DDM)
- Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Administer Servers by Using Policy-Based Management
- Lab:Β Encrypting Data
- Lab:Β Auditing Data Access
- Lab: change data capture (CDC)
- Lab: Dynamic Data Masking (DDM)
- Lab: Always Encrypted
- Lab: Policy-Based Management
Chapter 6: HA Solution
Log Shipping
- Introduction to Log Shipping
- The architecture of Log Shipping
- Configure and Deploy Log Shipping
- Additional configuration of jobs, alerts, and notification of Log Shipping jobs
- Failover options process and implementation of Log Shipping
- Upgrading, Applying Service Pack (SP) on Servers deployed Log Shipping
- Troubleshooting and Managing Log Shipping
- Lab:Β Plan and configure Log Shipping
- Lab:Β Troubleshoot and Manage Log Shipping
Mirroring
- Introduction to Database Mirroring
- The architecture of Database Mirroring
- Configure and Deploy Database Mirroring
- Additional configuration of jobs, alerts, and notification of Database Mirroring jobs
- Failover options, process and implementation ofΒ Database Mirroring
- Upgrading, Applying Service Pack (SP) on Servers deployedΒ Database Mirroring
- Troubleshooting and ManagingΒ Database Mirroring
- Lab:Β Plan and configure Database Mirroring
- Lab:Β Troubleshoot and Manage Database Mirroring
Replication
- Β Introduction to Replication
- The architecture of Database Replication
- Different types of replication, options, and compared and each option
- Configure and Deploy Replication technologies
- Additional configuration of jobs, alerts, and notification of Database Replication jobs
- Failover options, process, and implementation ofΒ Database Replication
- Upgrading, Applying Service Pack (SP) on Servers deployedΒ Database Replication
- Troubleshooting and ManagingΒ Database Replication
- Lab:Β Plan and configure Database Replication
- Lab:Β Troubleshoot and Manage Database Replication
Β Β Always on Availability Groups
- Introduction to AlwaysOn Technology
- The architecture of AlwaysOn Technology
- Availability group, Replica in AlwaysOn Technology
- Windows clustering and AlwaysOn
- Configure and Deploy AlwaysOn Technology
- Failover options, process, and implementation inΒ AlwaysOn Technology
- Upgrading, Applying Service Pack (SP) on Servers deployedΒ AlwaysOn Technology
- Troubleshooting and ManagingΒ AlwaysOn Technology
- Lab:Β Plan and configure AlwaysOn Technology
- Lab:Β Set up automated jobs for backup on the secondary instance
- Lab:Β Troubleshoot and Manage AlwaysOn Technology
Windows Β Β Failover Cluster
- Introduction Windows Failover Clustering
- Clustering Resources in Windows and SQL Server Environment
- Installing and Configuring Windows Failover Clustering
- Lab:Β Installing and Configuring Windows Failover Clustering
Failover Cluster Instance
- Introduction Failover Cluster Instance
- Installing and Configuring Failover Cluster Instance
- Lab:Β Installing and Configuring Failover Cluster Instance
Chapter 7: HA using Virtualization/VM Machine
- Virtualization Technology
- VM (Virtual Machine)
- Architecture and configuration of VM
- Hyper-V in Windows Server
- Hyper-V supports in SQL Server
- Hyper-V HA considerations using windows cluster
- Shared volume options for HA
- Lab:Β Configure VM using VMWare
- Lab:Β Migrate Database and Server in VM
Chapter 8: Migration & Upgrade
- Introduction to Moving Data to and from SQL Server Databases
- Importing and Exporting Table Data
- Copying or Moving a Database
- A different way of migration
- Lab:Β Importing from multiple different data sources
- Lab:Β Exporting Data to multiple different sources and format
- Lab: In place upgrade
- Lab: Side-by-side Migration
- Lab: Lower SQL server version of migration
- Lab: Upper SQL server version of migration
- Lab:Β SQL server to MYSQLΒ Β migration
- Lab:Β SQL Server to anΒ Β access database migration
- Lab:Β SQL Server to Azure migration
Chapter 8: PERFORMANCE TUNING _SQL Monitoring & Troubleshooting
- Introduction to Monitoring options
- Monitoring using native tools
- Monitoring using third-party tools
- Using tools and options
- DBCC, Statistics, Wait Β stats , Query store, DMV, Extended Events
- Lab:Β Discover and use different native tools
- Lab:Β Discover and use different third-party tools
- Lab:Β Monitoring SQL Server and databases
- Lab: DBCC
- Lab: Statistics
- Lab: Wait status
- Lab: DMV
Tracing SQL Server Workload Activity
- Using Traces Activity (Trace Flag & SQL profiler)
- Reading and using tracing activity
- Extended events
- Lab:Β Tracing SQL Server Workload Activity
- Lab:Β Applying tracing records
- Lab: Extended events
- Lab: SQL Profiler
Create and Manage Index
- Index space options
- Monitor Index space and fragmentation
- Index Fragmentation Management, Page split
- Statistics
- Lab:Β Explore better Index space options
- Lab:Β Create and Manage Index
- Lab:Β Performing Ongoing Database Maintenance
Transaction Management
- Concurrency, Lock Block, Deadlock
- ACID properties
- Different Types of Reads, Isolation Level
- Lab:Β Lock Block, Deadlock
- Lab:Β Isolation Level, Different Types of Reads,
- Lab:Β Manage transactions, Mange blocking
Query Optimization
- Execution Plan, Query procession
- Lab:Β Execution Plan
- Lab:Β Different ways to optimize the query
Chapter 9: SLA, RPO, RTO, and Available technology in SQL ServerΒ Β Β Β Β Β Β Β
- Understanding SLA (Service Level Agreement)
- Understanding RPO and RTO
- Translating the requirements from SLA, RPO, and RTO to technology
- Compare HA and DR Solutions to meet SLA, RPO, and RTO requirement
- Understanding the eating system, Ticket, work on tickets, and escalating tickets
- ODBC
- Lab:Β Use real-life scenario and understand SLA, RPO, and RTO
- Lab:Β Finding solutions, Licensing, and implementation options
- Lab:Β Use real-life and understand SLA, RPO, and RTO
- Lab:Β Finding solutions, Licensing, and implementation options
- Lab : ODBC
Chapter 10: TSQL Programming
Chapter 11: SQL CMD
Chapter 12: POWERSHELL
Chapter 13: Β SSIS & SSRS
Chapter 14: SQL Azure (IAAS/PAAS/SAAS)
- Planning, and Moving data to and from SQL Server Databases
Introduction to Moving Data to and from SQL Server Databases - Β Importing and Exporting Table Data
- Copying or Moving a Database
- Using Azure cluster technology
- Migrating Live Database in Azure Environment
- Lab:Β Importing from multiple different data sources
- Lab:Β Exporting Data to multiple different sources and format
Chapter 2: Monitoring, Troubleshooting, and Managing SQL Server Databases in the Azure environment
Chapter 3: Tracing, and Troubleshooting SQL Server Databases Activity in AzureΒ Β Β Β Β Β Β Β Β Β Β Β Β Β
Chapter 4: Managing and Troubleshooting Databases Security in Azure
Course Features
- Lectures 28
- Quizzes 0
- Duration 90 weeks
- Skill level All levels
- Language English
- Students 66
- Assessments Yes
