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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.