Image

Azure SQL DBA

By coacha Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Course Highlights

This Azure SQL DBA Online Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities : Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management and Security Management.

This SQL DBA Online Training also practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters as well as in LINUX Clusters. Additionally, this SQL DBA Training Course extents to Microsoft (Cloud) SQL Azure Migrations, Geo Replication, Azure DB Sync, Azure Database Tuning and Security Management. Study Material, MCSA SQL DBA Certification (DP 300) with Real-time Projects for your Resume as also a part of this SQL DBA Training Course. Versions: SQL Server 2014, 2016, 2017 and 2019.

Show More

Course Content

Course 1: SQL DBA Training Content For Plan B, C
Module I: SQL Server & T-SQL Installation, Architecture, DB Basics

  • Ch 1: DATABASE INTRO & SQL DBA
  • Ch 2: SQL SERVER INSTALLATIONS
  • Ch 3: SSMS Tool, SQL BASICS – 1
  • Ch 4: SQL BASICS – 2
  • Ch 5: SQL Basics – 3, T-SQL INTRO
  • Ch 6 : CONSTRAINTS, INDEXES
  • Ch 7: JOINS & LINKED SERVERS
  • Ch 8: VIEW, SPs, FUNCTIONS BASICS
  • Ch 9: Triggers & Transactions
  • Ch 10: DB Architecture & Group By

Course 1: SQL DBA Training Content For Plan B, C
Module II: Basic SQL DBA Backup-Restores, Jobs, Performance Tuning, Security

Course 1: SQL DBA Training Content For Plan B, C
Module III: Advanced SQL DBA HA-DR, Errors & Solutions, Always-On, SLA

Course 2: Azure DBA Training ContentFor Plan A, B, C

Course 3: ETL Admin Training Content [For Plans C]
Part 1: Azure Data Factory, Synapse Analytics

Course 3: ETL Admin Training Content [For Plans C]
Part 2: Data Lake Storage, Stream Analytics

Course 3: ETL Admin Training Content [For Plans C]
Part 3: Databricks, Spark, Python

Student Ratings & Reviews

No Review Yet
No Review Yet