SQL SERVER & T-SQL COURSE - SQL Server | SQL DBA | MSBI



SQL DBA (includes Server, T-SQL)

Inhouse Classroom Training

Complete Practical & Real-time Training Sessions

|[pic] |

|A Unit of SequelGate Innovative Technologies Pvt. Ltd. |

| |

Training Highlights

✓ Complete Practical and Real-time Scenarios

✓ Session wise Material and Practice Labs

✓ Session wise Notes & Doubts Clarifications

✓ Certification Material & Resume Preparation

✓ 24x7 LIVE Server Access with Real-time Databases

✓ Technical Support and Placements Assistance

✓ One Real-time Project and FAQs with Answers

✓ Mock Interview and Course Completion Certificate

| |

| |

| All Training Sessions are Completely Practical & Real-time . |

|Every Session includes Lab Work, Tasks and Study Material. Total of SEVEN Weeks. |

|Total Course Fee: INR 10000/- payable in TWO equal installments. |

MODULE 1 - SQL SERVER, T-SQL SESSIONS

All Our Training Sessions are COMPLETELY PRACTICAL & REALTIME with Hands-On Lab.

| | |

|DAY 0: SQL Server (2016, 2014) Installation |DAY 1: SQL SERVER ARCHITECTURE |

| | |

|What is Database? Need for DB Admins |SQL Server Architecture - Client/Server |

|SQL Server - Advantages and Editions |Encrypted Data Communication & TDS |

|SQL Server Versions – Course Plan |Data Provider and SQL Connection Types |

|Roles, Responsibilities, Levels - SQL DBA |Architecture: Query Processor, Threads |

|How to install SQL Server - Step by Step |Architecture: Storage Engine, File System |

|SQL Server 2016,2014,2012 Installation |Architecture: Parser, Optimizer, Mini LSN |

|Common Installation Errors, Solutions |Architecture: SQL Engine, MDAC, Buffers |

|Windows Updates, XML Errors, REGEDIT |Architecture: SQLOS Schedules, CLR |

|SQL Server Management Studio (SSMS) |Write Ahead Log, Lazy Writer, Checkpoints |

|DBA Checklist - Routine DBA Activities |Memory Manager & SQL Server Manager |

|DBA Checklist - Maintenance Activities |Query Optimizer (QO) and Execution Plans |

|DBA Checklist - Emergency Activities |Catalogs & CLR / PowerShell Integrations |

|DAY to DAY Course Plan - Time Table |SQL Database Architecture - RAID Levels |

|Online Lab Access (24x7 LIVE Server) |SQL DB Architecture: Files and Filegroups |

|Mini Project @ Course: L1 DBA Activities |Log File Architecture: Virtual Log Files |

|Real-time Project Implementation Plan |Log File Architecture: Mini LSN & DOP |

|Level 1, Level 2 and Level 3 DBA Activities |Windows Components for DBA |

| | |

|DAY 2: BASIC DDL, DML, DCL, TCL, STATS |DAY 3: SQL SERVER DATABASE DESIGN |

| | |

|DDL, DML, DCL, TCL Queries. Types |SQL Server Database Architecture |

|Basic Databases, Tables, SQL Concepts |SQL Server Database Design Concepts |

|Creating Databases (Basic Level) & Tables |Database Properties, Storage Options |

|Data Store, Data INSERT Variants, Rules |Data Files : Purpose, Sizing, Options |

|Data Retrieval Query Plans - Table Scan |Filegroups : Placement, Usage & Options |

|Table UPDATEs, Structure Updates, Plans |Log files : Sizing, Placement, Growth |

|DELETE Versus TRUNCATE. DROP Options |Database Creation - GUI & T-SQL Scripts |

|SYSTEM DATABASES & MSDB, TempDB |Filegrowth, Autogrowth and MAXSIZE |

|Query Execution Statistics, Basic EXEC Plans |Planning, Designing Very Large Databases |

|Wait Times, Client Statistics @ Queries |Database Structure Modifications, ALTER |

|Implementing TDS @ SQL Server Queries |Adding New Filegroups, Files to Database |

|Query Execution Stats with TDS Packets |Capacity Planning, Dedicated Log Storage |

|Client and Server Processing Time - Stats |Data File Architecture - Pages, Extents |

|Query Waits and Performance Factors |Log File Architecture - VLF, Mini LSN |

| | |

|DAY 4: TABLE DESIGN & SIMPLE QUERIES |DAY 5: CONSTRAINTS and KEYS |

| | |

|Table Design - Creating Tables, Options |Constraints and Keys - Purpose, Usage |

|Routing Tables to Database File Groups |Normal Forms, Relational DB Design |

|Schemas - Purpose, Usage in Tables |OLTP Database Model & BCNF - Relations |

|Table Design @ T-SQL Scripts, Variants |NULLABILITY Property and Importance |

|Table Design @ GUI (SSMS) - Usage |UNIQUE KEY Constraints and Importance |

|Naming Conventions - Table Columns |PRIMARY KEY Constraints and Limitations |

|Single Row Inserts - Multi-Row Inserts |FOREIGN KEY References and Relations |

|Table Aliases, Column Aliases, Usage |FOREIGN KEY Constraints - Limitations |

|INSERT, UPDATE, DELETE, TRUNCATE |Schema Level and Table Level Relations |

|SELECT Queries with Schema References |CHECK Constraints - Usage, Limitations |

|T-SQL Data Types, NULL Comparison |DEFAULT Column Constraints and Usage |

|Database Log Files for DML Operations |Identity Property with PRIMARY KEY |

|DML UPDATES and Design Limitations |Composite Primary Keys Concept, Usage |

|DELETE Versus TRUNCATE Statements |Constraints with Naming Conventions |

| | |

|DAY 6: JOINS & TUNING OPTIONS |DAY 7: VIEWS and SUB QUERIES |

| | |

|Need for Joins and Use Case Scenarios |Views on Tables, Security Advantages |

|JOIN - Types, Queries and Usage Options |Purpose of Views for Data Access, Admin |

|CROSS JOIN - Examples and Scenarios |Views as Stored SELECT Statements |

|INNER JOIN - Examples and Scenarios |SCHEMABINDING & ENCRYPTION Options |

|OUTER JOINS - Types and Scenarios |Issues with Views For Data Validations |

|SELF JOINS with Self References, Types |Cascaded Views, WITH CHECK OPTION |

|Query Tuning & Optimization Options |Orphan Views - Scenarios in Real-world |

|HASH JOIN Examples, Scenarios, HEAPS |Common System Views, Metadata Access |

|MERGE JOIN Examples, Scenarios, Uses |Views with Multi Level Tables - Joins |

|LOOP JOIN Examples, Scenarios, Cautions |Queries - GROUP BY, HAVING Conditions |

|Sub Queries and Joins. Alternate Syntax |Queries with GROUPING() and HAVING |

|End User Access to Queries - Interfaces |ROLLUP Options & Column Aggregations |

| |CUBE on Table Data - Purpose & Usage |

| |HAVING Vs WHERE - Usage, Performance |

| |Query Execution Order @ ROLLUP, CUBE |

| | |

|DAY 8: FUNCTIONS & SUB QUERIES |DAY 9: STORED PROCEDURES - BASICS |

| | |

|Functions: Types, Purpose and Usage |Stored Procedures - Purpose and Usage |

|Scalar Value Returning Functions - Usage |Execution Options and Variants, Batch |

|Inline Table Value Returning Functions |Variables, Parameters in Stored Procedures |

|Multi-line Table Value Returning Functions |Stored Procedures For Data Validations |

|Table Variables and Usage with Functions |Stored Procedures For Dynamic Queries |

|Function Arguments - Usage and Options |Important System Procedures, Metadata |

|SCHEMABINDING & ENCRYPTION Options |Extended Procedures For App. Access |

|System Functions and Metadata Access |IF.. ELSE, ELSE IF, IIF, IS Conditions |

|Date & Time Formats, Styles, DATEDIFF |Error Handling: TRY, CATCH, THROW |

|SOUNDEX, DIFFERENCE, CASE, ISNULL |Usage of THROW - Performance Issues |

|CAST, CONVERT, TRY_PARSE, COALESCE |Precompilation of Stored Procedures |

|String Functions, ROW_NUMBER, RANK |Cached Plans, Compiled Plans, PC Cache |

|CASE, MERGE, PIVOT, DENSE_RANK |Need for Recompilations, Outdated Plans |

|Views for Sub Queries and Functions |Dynamic SQL Parameters and Variables |

|Functions, Sub Queries, Date & Time Functions |Default Parameter Values, Usage Types |

|Real-time Case Study on Joins, Views, Sub Queries and Data Formatting |OUTPUT Parameters and Query Options |

|Options |RECOMPILE Option & ENCRYPTION Option |

| | |

| | |

|DAY 10: STORED PROCEDURES, CURSORS, CTEs |DAY 11: TRIGGERS & TRANSACTIONS |

| | |

|Cursor Types - Benefits and Options |Use of Triggers - Use and Performance |

|FORWARD_ONLY & SCROLL Cursors |FOR / AFTER Triggers - Importance |

|STATIC and DYNAMIC Cursors - Memory |INSTEAD OF Triggers - Importance |

|LOCAL, GLOBAL Cursors Usage Scope |INSERTED and DELETED Memory Tables |

|KEYSET DRIVEN Cursors, Performance |Triggers for DML Audits, Data Sampling |

|SPs with Joins, Temp Tables & Cursors |Database Level & Server Level Triggers |

|Nested Sub Queries with Stored Procedures |Bulk Operations & Updatable Views |

|Common Table Expressions (CTE) & Uses |ACID Properties and Transaction Types |

|Using CTE, Data Retrieval in Stored Procedures |EXPLICIT Transaction Types, Advantages |

|CTEs and Query Tuning Options with SPs |IMPLICIT Transactions Types, Advantages |

|CTEs with Tuning Options inside SPs |Open Transactions - Query Blocking |

|CTEs for Avoiding Self Joins, Scenarios |AUTOCOMMIT Transactions - Advantages |

|In-Memory Benefits of CTEs, Query Tuning |Nesting Transactions and Save Points |

|Compilations and Recompilations - CTE |LOCK HINTS: READPAST, NOLOCK, etc.. |

|Real-world Memory Issues with CTEs | |

| | |

|DAY 12: INDEXES & QUERY TUNING | |

| |STATISTICS - Types and Tuning Options |

|Indexes Types - B Tree Architecture |STATISTICS with Index Query Conditions |

|Clustered Indexes - Architecture |Materialized Views (Indexed Views) Usage |

|Non Clustered Indexes - Architecture |Indexes with MERGE JOINS, Issues |

|Execution Plans & Query Optimization |Indexes with LOOP JOINS, HASH JOINS |

|Table Scan, Index Scan, Index Seek |Indexes with Temp Tables, Triggers |

|SORT_IN_TEMPDB and Index Memory |Indexes with Sub Queries, Table Variables |

|FILLFACTOR, PAD_INDEX, Fragmentation |Indexes For TVP [Table Variable Parameters] |

|INCLUDED Indexes and Performance |Detecting Fragmentation of Index Pages |

|COLUMN STORE Indexes - Advantages |Index Fragmentations and Precautions |

|FILTERED Indexes - Query Performance |When to use Indexes? Precautions? |

|Indexes with Merge and Loop Joins |Role of Indexes in Query Tuning |

|Unique Clustered, Non Clustered Indexes |Primary Key Index, Composite Indexes |

|Clustered Versus Non Clustered Indexes |ONLINE Indexes and OFFLINE Indexes |

MODULE 2 – BASIC DBA SESSIONS

All Our Training Sessions are COMPLETELY PRACTICAL & REALTIME with Hands-On Lab.

| | |

|DAY 13: BACKUPS - DB, FILEGROUP, FILE |DAY 14: RESTORES & DATABASE RECOVERY |

| | |

|Backups - Background Threads, MSDB |Data Recovery using Backups, Log Files |

|Backups - Types, Importance, Options |Restore Phases - COPY, REDO, UNDO |

|Data Backups, Checkpoints, Page Level |Database Restores & FILELIST Options |

|File Backups, Filegroup Backups - Extents |File Restores and Filegroup Restores |

|Log Backup Mechanism, Data Truncates |FILELISTONLY, VERIFYONLY, REPLACE |

|Partial Backups with Read Only Filegroups |PARTIAL & PIECEMEAL Restores - Tuning |

|Tuning Database Backup Operations |Tail Log Backups & DB Recovery Options |

|Mirrored Backups, FORMAT, SKIP, STATS |REDO Phase with T-Log Backups, Purpose |

|Tape Backups - LOAD, UNLOAD, ERRORS |Tail Log Backup Restores, UNDO Phase |

|COMPRESSION, CHECKSUM, DB VERIFY |Partial Backups - STATS, VERIFY Options |

|CONTINUE_ON_ERROR, Backup Validation |Strategies: Piecemeal/Piecemeal Restores |

|Backup History From MSDB Database |SQL Server 2012 to 2014,2016 Restores |

|Backup Audits - Media Set, Media Family |Recovery Models: Choosing Correct Models |

|Remote Backups and Security Options |Point-In-Time Restores and Log Recovery |

|Compatibility, Recovery Model Options |Restores From Backup Devices & Mirrors |

|COPY_ONLY Backups and Importance |Restores From existing Databases, Files |

|Important Queries for Backup Audits |Restores using SQL Server T-SQL Script |

|Backup Verification, Security KEYS |Restores using GUI. Data & Log Options |

|Backups using GUI and T-SQL Scripts |Transaction Undo Files (TUF) Purpose |

|Backup Devices - Purpose, Options |Restore Audits and Standby Databases |

| |Checkpoint LSN and Restore Positions |

| | |

|DAY 15: JOBS, SQL SERVER AGENT, DB MAIL |DAY 16: REPLICATION For HA & DR -- LEVEL 1 |

| | |

|SQL Server Agent Service, Agent XPs |Replication Architecture and Entities |

|SQL Agent Jobs - GUI Options, MSDB |Replication Topology, Plan, Connections |

|Job Steps: T-SQL, SSIS, Replication |Distributor Server Configurations, Options |

|Job Schedules and Frequency Options |Distribution DB Components and Options |

|Job Schedules and Email Notifications |Distribution DB Configuration, Snapshots |

|Job Executions, Disable/Enable Options |Publication Types - Purpose, Importance |

|Job History and Job Activity Monitor |DB Articles, Publications, Subscriptions |

|Windows Event Notifications, Operators |PULL Subscription Options and Types |

|DB Mail Configurations, Database Profiles |Snapshot Replication and Replication Agents |

|SMTP Accounts, Email Settings, Ports |Configure, Secure, Schedule Snapshots |

|Default Public Profiles, DB Mail Security |Snapshot Subscriptions and Replica DB |

|Import & Export (SSIS) Operations |Transactional Replication Configuration |

|OLE-DB, SQLNCLI and MS Jet Drivers |Log Reader Agent - Configuration, Keys |

|SSIS Packages for Data Import/Export |Tracer Tokens - Latency and Ranking |

|SSIS Package Store - File System, MSDB |Replication Monitor - Usage and Options |

|SSIS Jobs - Scheduling SSIS Packages |Read Only Subscribers and Load Balancing |

|Backup Strategies For Minimal Data Loss |Replication Jobs and Verification Options |

|SQL Server Agent – Job Types |Adding Articles to Existing (LIVE) Replica |

|Startup Jobs – Configuration, Usage |Adding Subscribers to Existing Replica |

|Onetime – Scenarios, Precautions, Events |Schema Level Replication, DDL Operations |

|Recurring Jobs – Schedules and Agent Service |Stopping, Starting Replication Agents |

|Monitoring SQL Agent Jobs, Schedules |Scripting Replication Jobs, Publications |

|Job Activity Monitor Usage – Status, History |Disable/Enable Replication, Agent Stops |

| | |

|DAY 17: REPLICATION For HA & DR -- LEVEL 2 |DAY 18: LOG SHIPPING - DISASTER RECOVERY |

| | |

|Transactional Replication, Tracer Tokens |Log Shipping Topology, Operation Modes |

|Merge Replication and Merge Agent Job |Primary and Secondary: Recovery Plan |

|Replication Conflicts and ROWGUIDCOL |Log Shipping Monitor Settings, Alerts |

|Peer-Peer Replication - Configurations |NORECOVERY Configuration and Usage |

|Peer-Peer Replication Connections, Nodes |STANDBY Mode Configuration, Purpose |

|Adding Peer Nodes, Node ID Conflicts |Log Shipping Jobs & Restore Schedules |

|Replication across Lower/Higher Versions |Copy and Restore Jobs with Secondary |

|Replication Conflicts - Options, sp_MSRepl |Log Shipping Monitor Status Reports |

|IDENTITY Property & Schema Replication |Manual Failover Process: Recovery Options |

|PUSH and PULL Subscriptions - Options |Log Shipping Topology - Limitations |

|Domain Account Security in Replication |Versioning Issues, Data Traffic. Data Loss |

|Merge, Snapshot Replication Limitations |Log Shipping for DB Recovery Procedures |

|Replica Initialization with Backups, Issues |Log Shipping Jobs - Errors and Solutions |

|Transactional Versus Snapshot Replication |Log Shipping Reports and Data Recovery |

|Peer-Peer Versus Merge Replication For HA |Log Shipping Standby: Delay Restores |

|Load Balancing Options with Replication |Scripting Log Shipping Configurations |

|Replica Server @ Appl Connection Strings |Standby Disconnections, Latency Options |

|Replication Conflicts, Errors and Solutions |Errors and Solutions @ LS Copy, Restore |

|Replication Warnings and Agent Alerts |Log Shipping for HA and DR - Strategies |

|Replication Errors, Events and Solutions | |

|Replication Errors @ DB Engine, Solutions | |

|Replication for HA and DR - Strategies | |

|Replication Limitations and Precautions | |

| | |

|DAY 19: DATABASE MIRRORING - HA & DR |DAY 20: SECURITY MANAGEMENT - LEVEL 1 |

| | |

|DB Mirroring Architecture For HA,DR |Authentication Types - WINDOWS, SQL |

|DB Mirroring Configuration Scenarios |Windows Logins and REGEIDT Settings |

|Backups and Restores for DB Mirroring |SQL Server Logins, POLICIES, EXPIRY |

|TCP Endpoints and TCP Network Security |Default Databases, Keys, Languages |

|Heartbeat and Polling Concepts in DM |LOGINS: Server Level Security, Options |

|Service Accounts Configurations, Use |USERS: Database Level Security, Options |

|Automatic Fail-Over Procedures, Tests |SCHEMAS: Object Level Security, Options |

|Manual Failover Options and Scenarios |System Server Roles, Database Roles |

|PARTNER OFFLINE Conditions & Options |User Server Level Roles & Permissions |

|DB Mirroring Monitors and Commit Loads |User Database Level Roles & Permissions |

|SYNCHRONOUS & ASYNCHRONOUS Modes |Schemas and DB User Mappings - Usage |

|Manual Failover and HA Partner Roles |GRANT, WITH GRANT, DENY, REVOKE |

|Mirroring Monitor, Stop/Resume Options |CONTROL, OWNERSHIP, AUTHORIZATION |

|Real-World Considerations & DR Options |Testing Security Operations, Scripting |

|DR & HA with DB Mirroring Advantages |Common Security Functions & Queries |

|Need for Always-On & Higher Availability |DMVs for Server and DB Security Audits |

|DB Mirroring Errors and Solutions |Useful Security Audit Queries (DMVs) |

MODULE 3 – ADVANCED DBA SESSIONS

All Our Training Sessions are COMPLETELY PRACTICAL & REALTIME with Hands-On Lab.

| | |

|DAY 24: PERFORMANCE TUNING - LEVEL 1 |DAY 25: PERFORMANCE TUNING - LEVEL 2 |

| | |

|Big Data - Performance Considerations |Index Internals and Execution Plans |

|Table Partitions and Tuning Options |Index Fragmentation - Issues, Solutions |

|Partition Functions - Range Selectivity |SAMPLED & DETAILED Query Scans |

|Partition Schemes and Reusability |Filtered Indexes and Sizing Options |

|Deciding Partition Ranges & Functions |Analyzing Work Load Tables and Scans |

|Partitioned Data For Complex Queries |Statistics Updates and Query Tuning |

|Partitioning Un-partitioned Structures |Index Management Options & Statistics |

|Aligned Partitions and Performance |Statistics - AUTO CREATE, AUTO UPDATE |

|Fill Factor Options and Index Tuning |Stats Updates (Manual) - Table Issues |

|Partitions for Query Tuning Operations |Index Reorganization Process and Uses |

|Data Compression with Row Partitions |Data Pages - Fragmentation Solutions |

|Page Compression & Row Compression |Index Pages - Fragmentation Solutions |

|Partitions & Compressions, Performance |Index Rebuilds and Table Page Rebuild |

|Managing Partitions and Tuning Options |Page, Row Compressions with Indexes |

|LIKE Operator - Limitations & Wild-cards |FILLFACTOR, PADINDEX Index Options |

|Full Text Search (FTS) Configurations |Filtered Indexes, Online Indexes, Views |

|Database Catalogs (FTC) and Storage |Understanding Workload Files in Profiler |

|Full Text Indexes (FTI) for Tuning |SQL Profiler Workload Tables & Queries |

|Full Text Columns and Primary Index |SQL Profiler Tuning and Lock Templates |

|Full Text Index and Searching Queries |Index Selectivity Options and Statistics |

|CONTAINS() and FREETEXT() Functions |Page Compressions, Resource Optimize |

|CHANGE_TRACKING Options, Limitations |DDM – Purpose, Security with DDM |

|New Tuning Options @ SQL 2016 |Dynamic Data Masking (DDM) – |

|Stretch Databases @ SQL 2016 |Performance Issues in SQL 2016 |

|Temporal Tables, Tuning: SQL 2016 | |

| | |

|DAY 26: PERFORMANCE TUNING - LEVEL 3 |DAY 27: PERFORMANCE TUNING - LEVEL 4 |

| | |

|Memory Optimized Tables & Usage |Distributed Replay Controller, SCOM |

|LIVE QUERY STATS Analysis in SQL 2016 |System Monitor Tool & Activity Monitor |

|Database Tuning Advisor (DTA) - Usage |PERFMON Counters and PSSDIAG Tools |

|DTA for Long Running Queries, DB Caching |Counters for Query Stats, Agent Stats |

|DTA for Parallel/Concurrent Queries, Traces |SQL Browser Service and Dump Files |

|DTA Tool with Profiler, Trace Tables, Logs |Log Space Issues & Query Performance |

|DTA Tool with Procedure (Plan) Cache |Tempdb Issues & Query Performance |

|Real-world Considerations for DTA Tool |Memory Issues & Query Performance |

|Resource Governor and Query Tuning |Automated Alerts and Counter Traces |

|Resource Pools Configuration, MODES |Log Space, Tempdb Issues - Solutions |

|Workload Groups & Resource Allocation |MEMORY, PAGE LATCH, WAITS: Solutions |

|Classifier Functions - Query Load Plans |Memory Buckets, VM Space Performance |

|Query Priority, CPU/Memory Limits |Database Consistency Errors, Solutions |

|Query Memory, Index Memory Settings |Procedure Cache Issues and Solutions |

|Thread Level Architecture - CPU Nodes |DB State Events, Issues and Solutions |

|Windows Fibers, Priority Boost Options |Network Usage Audit and Optimization |

|MSDB Space Issues - Agent Performance |SQL Buffer, MEMORY TABLES and Usage |

|DOP - Degree Of Parallelism & Options |Index Fragmentation with Temp Tables |

|PDS Options with Indexes For Tuning |Index Management Options @ SQL 2016 |

|Choosing PDS for Efficient Tuning | |

| | |

|DAY 28: DB MAINTENANCE PLANS, REPAIRS |DAY 29: DATABASE MIGRATIONS, DMA TOOL |

| | |

|Database Maintenance Plans (SSIS) |Database Migration Options with SSIS |

|DB Maintenance Strategies & Schedules |DB Design Audits @ File System Store |

|MSDB History Management Options |Database Detach Options and Downtime |

|Backup Files and Space Management |Database Attach Options and Scripting |

|Reorganizing Indexes with Maint. Plans |Scripting: Schemas, Object, Keys, Data |

|Stats Updates (Automatic) and Jobs |Scripting Security Logins, Permissions |

|Modifying SSIS DB Maintenance Plans |Copy Database Wizard (SSIS) Tool Usage |

|Scheduling and Maintaining SSIS Plans |File System, SQL Server Package Store |

|Log File Issues & Shrinking Operations |Migration Schedules, Jobs, Alerts, Logs |

|SQL DB Engine Properties & Guidelines |Corrupted Logs, FORATTACH, REBUILDS |

|Service Configuration Manager Options |Linked Server Security, Management |

|Distributed Transactions & Connections |Memory Dashboard and Buffer Cache |

|Policy Based Management (PBM), Facets |Server Dashboard, Connection Audits |

|Database Properties and Conditions |Policy Management Options and Agent |

|Policy Management, Events, Schedules |Facets and Conditions : On Demand |

|PAGE REPAIRS - suspect pages @ MSDB |Facets and Conditions : On Change |

|FILE REPAIRS, FILEGROUP REPAIRS |Policy Based Management (PBM) Reports |

|DATABASE REPAIRS - DB Consistency |Data Migration Assistant (DMA) Tool |

|DATABASE REPAIRS - Data Allocation |Using DMA Tool for Database Analysis |

|DB Modes, Emergency, NOWAIT Options |DMA Tool for Database Upgrades, Precautions |

|Managed DB Backups @ SQL Server 2016 |Contained Databases - Orphan User Prevention |

| | |

|DAY 30: PATCH UPDATES, SERVER UPGRADES |DAY 31: CLUSTERING CONFIGURATION - HA |

| | |

|Establishing Downtime For Maintenance |Understanding SQL Clustering Service |

|Precautions for Maintenance Activities |SQL Server Clustering Architecture |

|Service Packs and Patch/hotfix Activities |Windows and SQL Server Licensing |

|Instance Selectivity for Updates, Cautions |Windows Server Installation Options |

|Pre & Post Patch Operations. Process |Service Pack and Patch Installations |

|Verifications, Smoke Test and Rollbacks |QUORUM Options for Windows Clusters |

|Upgrade Advisor Tool - Analysis Reports |SQL Server Cluster Plan - Licensing |

|Upgrade Advisor Issues and Warnings |Installing Windows MSCS Service, Tests |

|Server Upgrades and Precautions |Ping Tests and Heart-beat Checks, DC |

|Planning for Maintenance Activities |Domain Configurations, Precautions |

|Rebuilding System Databases & Objects |MSCS - Microsoft Cluster Services, Nodes |

|Pre Database Maintenance Activities |MSCS Service Startup Options, Issues |

|Post Database Maintenance Activities |Verifying SQL Server Cluster Installation |

|Real-world Management Considerations |Real-world Recommendations for Clusters |

| | |

|DAY 32: CLUSTERING: ACTIVE DIRECTORY, DTC |DAY 33: SQL SERVER CLUSTERS, ALWAYS-ON |

| | |

|Need for Centralized Authentication |Need for Always - On Availability |

|Domain Controller (DC) Configuration |Always-On Prerequisites, Node Configuration |

|Active Directory Settings and Usage |SQL Server Cluster Installation |

|DCPROMO Settings for Active Directory |Cluster Configurations - Active/Active |

|Server Configuration Manager, Options |Cluster Configurations - Active/Passive |

|Configuration Manager Features, Users |SQL Group & AD Sync-up Operations |

|Configuration Manager, Adding Groups |SAN System for Shared Data Storage |

|Working with Active Directory (AD) Edits |MS DTC Configurations (Local/Remote) |

|Network Configurations and Precautions |Smoke Test Procedures in Real-time |

|PING Configurations and DTC Options |Fail-Over Disk & RAID Implementation |

|QUORUM settings and SAN Options |Cluster Connection Issues and Drains |

|SAN & NAS – Differences, Storage Environment |Network Security Issues with Solutions |

|Infra Requirements with Storage @ Clusters |RAID, Storage Issues with Solutions |

| |Installing Updates - SQL Server Clusters |

| | |

|DAY 34: SQL CLUSTERS, ALWAYS-ON |DAY 35: SQL CLUSTERS, ALWAYS-ON |

|Add Nodes to SQL Cluster - Active/Active |Active-Passive Cluster Configurations |

|SQL Server Cluster Utilities & Quorum |Flexible Failover Policy, HA/DR Process |

|Cluster Working and Operative Modes |Availability Replica - Readable Secondary |

|Configuration Settings, SQL Monitors |Active Secondary, SYNC, ASYNC (AAG) |

|Always-On Availability Groups (AAG) |Port Settings and Replica Config in AAG |

|Prerequisites for Always-On for HA/DR |IP Configurations & WSFC Settings |

|Primary & Secondary Configurations |Node Majority, Disk & File Share Majority |

|Synchronization Settings, HA Options |SQL Server 2016 - Whats new @ AAG |

|Replica Recommendations for Always-On |Routine DBA Challenges for AAG - HA/DR |

|Backup Storage and Types – Strategies |Temporal Tables - AAG : SQL 2016 |

Pre-requisites for this SQL DBA Course:

This is a starter course, no pre-requisites required. Course includes free orientation class for starters. Course includes Study Material, Interview & Certification guidance along with one Real-time Project.

About Trainer:

Mr. Sai Phanindra Tholeti is a Database Consultant working for his own company - SequelGate Innovative Technologies Pvt. Ltd. With more than 11 years of expertise and passion for SQL Server, Administration (SQL DBA) and Business Intelligence (MSBI) - Mr. Sai provides Data Hosting, Business Consulting and Technical Support Services for Corporate Clients. All his training sessions are completely practical, real-time and highly interactive. Complete profile of the trainer available @

For Free Demo / Further Clarifications, please reach us.

INDIA: Country Code - 0091 0 9666440801 (Mobile) / 040 64577244 (Office)

USA: Country Code - 001 (510) 400-4845 (Office)

Mail: contact@

Skype: SQL School Training Institute

[pic]

[pic]

[pic]

ISO Certified Training Institute Microsoft Certified Partner

__________________________________________________________________

ALL OUR TRAININGS SESSIONS ARE COMPLETELY PRACTICAL & REALTIME

__________________________________________________________________

-----------------------

( ISO Certified Training Institute ( Microsoft Certified Partner

Real-time Case Study: An Online Medical DB System @ Query Tuning Options

ALL TRAINING SESSIONS ARE COMPLETELY PRACTICAL, REAL-TIME.

Register Today!



(0091) 9666440801 [India]

(001) 510-400-4845 [USA]

Address 1: INDIA

#108/2RT, Road #1, Street #2, Beside Bus Station, SR Nagar, Hyderabad - 500038

Address 2: INDIA

Sai Anu Avenue, Street #3, Patrika Nagar, HITECH City, Hyderabad - 500081

Office #3: USA

300 East Royal Lane

Suite # 113

Irving TX 75039 - USA

USA.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download