SQL DBA Training
SQL DBA (includes Server, T-SQL)
LIVE Online Training - Instructor Led
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 Course Fee For Plan A: INR 15000/- (USD 250$) payable in TWO equal installments. |
|Total Course Fee For Plan B: INR 18000/- (USD 300$) 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 1: SQL Server (2016, 2014) Installation |DAY 2, 3: BASIC DDL, DML - ARCHITECTURE |
| | |
|What is Database? Need for DB Administrators |Testing Installation, Server Connections |
|SQL Server Advantages, Editions, Versions |Understanding SSMS Tool. Object Explorer |
|Roles, Responsibilities, Levels - SQL DBA |Defining Sessions for Queries. Session IDs |
|How to install SQL Server - Step by Step |Basic SQL with Databases and Tables |
|SQL Server 2016,2014,2012 Installation |DDL, DML, DCL and TCL Statements |
|SQL Server Management Studio (SSMS) |Basic Table Creation - Column Data Types |
|SSMS and SQLCMD Tool Configurations |INSERT / Store Data into SQL Tables |
|DBA Checklist - Routine DBA Activities |Single and Multiple Row Inserts with NULL |
|DBA Checklist - Maintenance Activities |SELECT Queries. Operators: IN, AND, OR |
|DBA Checklist - Emergency Activities |IS, UNION, UNION ALL, NOT, BETWEEN |
|Course Plan and Takeaways from Course |UPDATE & DELETE Statements. Conditions |
|Weekly Mock Interviews, Resume |DELETE Versus TRUNCATE. DROP Table |
|Placement Assistance, Course Certificates |SYSTEM DATABASES - Importance, Usage |
|MCSA Certification Pattern - Course Plan |MSDB, TempDB, Resource and Model |
|Online Lab Access (24x7 LIVE Server) |Local Temp Tables. Global Temp Tables |
| |Wait Times, Client Statistics @ Queries |
| |CLIENT - SERVER Architecture (TDS) |
| |SQL Native Client (SNAC), Client Statistics |
| |Implementing TDS @ SQL Server Queries |
| | |
|DAY 4: DATABASE & TABLE DESIGN |DAY 5: CONSTRAINTS and KEYS |
| | |
|SQL Server Database Architecture |Constraints and Keys - Purpose, Usage |
|SQL Server Database Design Concepts |Normal Forms, Relational DB Design |
|Database Properties, Storage Options |OLTP Database Model & BCNF - Relations |
|Data Files : Purpose, Sizing, Options |NULLABILITY Property and Importance |
|Filegroups : Placement, Usage & Options |UNIQUE KEY Constraints and Importance |
|Log files : Sizing, Placement, Growth |PRIMARY KEY Constraints and Limitations |
|Database Creation - GUI & T-SQL Scripts |FOREIGN KEY References and Relations |
|Filegrowth, Autogrowth and MAXSIZE |FOREIGN KEY Constraints - Limitations |
|Planning, Designing Very Large Databases |Schema Level and Table Level Relations |
|Database Structure Modifications, ALTER |CHECK Constraints - Usage, Limitations |
|Adding New Filegroups, Files to Database |DEFAULT Column Constraints and Usage |
|Capacity Planning, Dedicated Log Storage |Identity Property with PRIMARY KEY |
|Data File Architecture - Pages, Extents |Composite Primary Keys Concept, Usage |
|Log File Architecture - VLF, Mini LSN |Constraints with Naming Conventions |
|Routing Tables to File Groups, Advantages |DB Design with Constraints, Schemas |
|Schemas - Purpose and Usage with Tables |Data Types, Aliased Queries with Schemas |
|CHAR versus VARCHAR Differences |Default Schema, Aliases for Table Design |
|DB Log Files - Logged, NonLogged Options | |
| | |
|DAY 6: JOINS & SUB QUERIES |DAY 7,8: VIEWS, FUNCTIONS, SUB QUERIES |
| | |
|Need for Joins and Use Case Scenarios |Views on Tables, Security Advantages |
|JOIN - Types, Queries and Usage Options |Views as Stored SELECT Statements |
|CROSS JOIN - Examples and Scenarios |SCHEMABINDING & ENCRYPTION Options |
|INNER JOIN - Examples and Scenarios |Cascaded Views, WITH CHECK OPTION |
|OUTER JOINS - Types and Scenarios |Orphan Views - Scenarios in Real world |
|SELF JOINS with Self References, Types |Common System Views, Metadata Access |
|Joins with / without SCHEMA References |sys.databases, sys.tables, sys.views |
|Joining Multiple Tables and Join Types |INFORMATION SCHEMA views, Definitions |
|Joining Tables across Schemas, Filegroups |Views with Multi Level Tables - Joins |
|Basic Aggregations with Joins. Aliasing |Queries - GROUP BY, HAVING Conditions |
|Comparing Inner Join and Outer Joins |Queries with GROUPING() and HAVING |
|Comparing Inner Join and Cross Joins |ROLLUP Options & Column Aggregations |
|Deciding the best Join Type, Options |CUBE on Table Data - Purpose & Usage |
|Sub Queries and Joins. Alternate Syntax |HAVING Vs WHERE - Usage, Performance |
|End User Access to Queries - Interfaces |Query Execution Order @ ROLLUP, CUBE |
|Sub Queries and Simple Aggregations |Functions: Types, Purpose and Usage |
|Sub Queries with UNION, UNION ALL |Scalar Value Returning Functions - Usage |
| | |
|DAY 7,8: VIEWS, FUNCTIONS, SUB QUERIES |DAY 9: STORED PROCEDURES - Level 1 |
| | |
|Inline Table Value Returning Functions |Stored Procedures - Purpose and Usage |
|Multi-line Table Value Returning Functions |Execution Options and Variants, Batch |
|RETURNS and RETURN Values. Options |Variables, Parameters in Stored Procs |
|BEGIN..END and IIF Functions, CASE |Stored Procedures For Data Validations |
|Function Arguments - Usage and Options |Stored Procedures For Dynamic Queries |
|Variables and Function Parameters |Important System Procedures, Metadata |
|Static Variables and Dynamic variables |Extended Procedures For App. Access |
|Table Variables, WHILE LOOP Concepts |IF.. ELSE, ELSE IF, IIF, IS Conditions |
|System Functions and Metadata Access |Error Handling: TRY, CATCH, THROW |
|Date & Time Formats, Styles, DATEDIFF |Usage of THROW - Performance Issues |
|CAST, CONVERT, RANK, ROW_NUMBER |Precompilation of Stored Procedures |
|Views for Sub Queries and Functions |Cached Plans, Compiled Plans, PC Cache |
|Views for Aggregations and Calculations |Need for Recompilations, Outdated Plans |
| |Dynamic SQL Parameters and Variables |
| |Default Parameter Values, Usage Types |
| |OUTPUT Parameters and Query Options |
| |RECOMPILE Option & ENCRYPTION Option |
| | |
| | |
|DAY 10: STORED PROCEDURES - Level 2 |DAY 11: TRIGGERS & TRANSACTIONS |
| | |
|Stored Procedures for Dynamic Queries |Use of Triggers - Use and Performance |
|Recursive Queries: OUTPUT Parameters |FOR / AFTER Triggers - Importance |
|Common Table Expressions, In-Memory |INSTEAD OF Triggers - Importance |
|Stored Procedures for CTE (Sub) Queries |INSERTED and DELETED Memory Tables |
|Using CTE for Table Data Operations |Triggers for DML Audits, Data Sampling |
|CTE for DML & DDL in Stored Procedures |Database Level & Server Level Triggers |
|Using Stored Procedures with Cursors |Bulk Operations & Updatable Views |
|FORWARD_ONLY and SCROLL Cursors |ACID Properties and Transaction Types |
|STATIC and DYNAMIC Cursors. ABSOLUTE |EXPLICIT Transaction Types, Advantages |
|LOCAL and GLOBAL Cursor. Reusability |IMPLICIT Transactions Types, Advantages |
|KEYSET Cursor & Performance Options |Open Transactions - Query Blocking |
|Embedding Cursors in Procedures |AUTOCOMMIT Transactions - Advantages |
|Memory Limitations with Cursors, SPs |Nesting Transactions and Save Points |
| |LOCK HINTS: READPAST, NOLOCK, etc.. |
| | |
|DAY 12: SQL SERVER ARCHITECTURE |DAY 13: QUERY TUNING (INDEXES) |
| | |
|Architecture: Query Processor, Threads |Indexes Types - B Tree Architecture |
|Architecture: Storage Engine, File System |Clustered Indexes - Architecture |
|Architecture: Parser, Optimizer, Mini LSN |NonClustered Indexes - Architecture |
|Architecture: SQL Engine, MDAC, Buffers |Execution Plans & Query Optimization |
|Architecture: SQLOS Schedules, CLR |Table Scan, Index Scan, Index Seek |
|Write Ahead Log, Lazy Writer, Checkpoints |SORT_IN_TEMPDB and Index Memory |
|Query Optimizer (QO) and Execution Plans |FILLFACTOR, PAD_INDEX, Fragmentation |
|SQL DB Architecture: Files and File groups |INCLUDED Indexes, HEAP Performance |
|Virtual Log Files & Mini LSN & DOP |COLUMN STORE Indexes - Advantages |
|Query Processing and Optimizer (QO) |FILTERED Indexes - Query Performance |
|Client - Server Architecture of SQL Server |ONLINE Indexes and OFFLINE Indexes |
|TCP / IP, Named Pipes, Shared Memory |Indexes with Merge and Loop Joins |
|SQL Native Client (SNAC), OLE DB Drivers |Primary Key Index, Composite Indexes |
|SQL Database Architecture - RAID Levels |Materialized Views (Indexed Views) Usage |
|Log Sequence Numbers (LSN), Mapping |Unique Clustered, NonClustered Indexes |
|Log File Architecture - Virtual Log Files |Common Table Expressions (CTE) & Uses |
|Log File Architecture - Mini LSN, Usage |Using CTE, Data Retrieval in Stored Procs |
|DB Catalogs, CLR Integration, MDAC |CTEs for Avoiding Self Joins, Scenarios |
|LSN Timestamps, Background Threads | |
MODULE 2 – BASIC DBA SESSIONS
All Our Training Sessions are COMPLETELY PRACTICAL & REALTIME with Hands-On Lab.
| | |
|DAY 14: BACKUPS - DB, FILEGROUP, FILE |DAY 15: 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 ReadOnly 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 |Choosing correct DB Recovery Model |
|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 |
|Real-time Errors and Solutions |Checkpoint LSN and Restore Positions |
| |Real-time Errors and Solutions |
| | |
| | |
|DAY 16: JOBS, SQL SERVER AGENT, DB MAIL |DAY 17: PERFORMANCE TUNING - 1 |
| | |
|SQL Server Agent Service, Agent XPs |Identifying Long Running Queries |
|SQL Agent Jobs - GUI Options, MSDB |Dynamic Management Objects: DMV, DMF |
|Job Steps: T-SQL, SSIS, Replication |Audit Long Running Queries - DMV/DMF |
|Job Schedules and Frequency Options |Audit Frequent Running Queries - DMF |
|Job Schedules and Email Notifications |Query Audits and DMVs / DMFs with Joins |
|Job Executions, Disable/Enable Options |Query Statistics & LIVE Execution Plans |
|Job History and Job Activity Monitor |CROSSAPPLY with Dynamic Views |
|Windows Event Notifications, Operators |Avoiding Sub Queries and Conditions |
|DB Mail Configurations, Database Profiles |Comparing Sub Queries and Query Joins |
|SMTP Accounts, Email Settings, Ports |Query Tuning and Resource Optimization |
|Default Public Profiles, DB Mail Security |STATISTICS - Purpose and Tuning Options |
|Import & Export (SSIS) Operations |Column Statistics - Usage Advantages |
|OLE-DB, SQLNCLI and MS Jet Drivers |Index Statistics - Auto Index Creations |
|SSIS Packages for Data Import/Export |Manual Update of Column Statistics |
|SSIS Package Store - File System, MSDB |Statistics in Query Tuning Process |
|SSIS Jobs - Scheduling SSIS Packages |STATISTICS in Indexes, Query Conditions |
|Backup Strategies For Minimal Data Loss |LIVE Query Statistics, Table Statistics |
|Startup Jobs, Onetime, Recurring Jobs |HASH JOIN Examples and Precautions |
|Job Activity Monitor, Agent Threads |MERGE JOIN Examples and Precautions |
| |LOOP JOIN Examples and Precautions |
| |OUTER APPLY and Multi - Level Joins |
| | |
| | |
|DAY 18: PERFORMANCE TUNING - 2 |DAY 19: PERFORMANCE TUNING - 3 |
| | |
|Table Partitions and Query Tuning Options |Index Internals and Execution Plans |
|Partition Functions and Partition Schemes |Execution Plans, Statistics, Query Cost |
|Partition Ranges, Values and Sort Orders |Index Fragmentation Issues, Performance |
|Partition Un-partitioned Tables: Indexes |SAMPLED and DETAILED Scans. FillFactor |
|Aligned / Indexed Partitions - Importance |Index Rebuilds (Online/Offline), Tuning |
|Data Compression - ROW & PAGE Levels |Index Reorganization and Advantages |
|Partition Numbers & Filtered Compression |Page, Row Compressions with Indexes |
|Managing Partitions and Tuning Options |Filtered & Online Indexes, Indexes Views |
|LIKE Operator - Using Wild-cards |GAM, SGAM Pages, Metadata Info |
|Full Text Search Service Configuration |Filtered Indexes and Size Limitations |
|Full Text Search - Database Settings |Table Statistics, Query Tuning Options |
|Database Catalogs (FTC) and Storage |Heaps, Clustered, Nonclustered Indexes |
|Full Text (FT) Indexes for Query Tuning |Fill Factor, Pad Index and Query Tuning |
|Full Text Columns and Primary Key Index |Memory Pages and IO Performance |
|Full Text Index - Search Query Issues |MEMORY LEAKS and PAGE WAITS |
|Full Population, Incremental Population |LATCH WAITS and Performance Impact |
|CONTAINS() and FREETEXT() Functions | |
|Token Search and Inflectional Forms | |
|Performance Tuning @ Full Text Indexes |MORE PERFORMANCE TUNING: DAYs 34, 35 |
|New Tuning Options @ SQL 2016 | |
| | |
|DAY 20: REPLICATION For HA & DR -- LEVEL 1 |DAY 21: REPLICATION For HA & DR -- LEVEL 2 |
| | |
|Replication Architecture and Entities |Transactional Replication, Tracer Tokens |
|Replication Topology, Plan, Connections |Merge Replication and Merge Agent Job |
|Distributor Server Configurations, Options |Replication Conflicts and ROWGUIDCOL |
|Distribution DB Components and Options |Peer-Peer Replication - Configurations |
|Distribution DB Configuration, Snapshots |Peer-Peer Replication Connections, Nodes |
|Publication Types - Purpose, Importance |Adding Peer Nodes, Node ID Conflicts |
|DB Articles, Publications, Subscriptions |Replication across Lower/Higher Versions |
|PULL Subscription Options and Types |Replication Conflicts: Options, sp_MSRepl |
|Snapshot Replication and Repl Agents |IDENTITY Property & Schema Replication |
|Configure, Secure, Schedule Snapshots |PUSH and PULL Subscriptions - Options |
|Snapshot Subscriptions and Replica DB |Domain Account Security in Replication |
|Transactional Replication Configuration |Merge, Snapshot Replication Limitations |
|Log Reader Agent - Configuration, Keys |Replica Initialization with Backups, Issues |
|Tracer Tokens - Latency and Ranking |Transactional Versus Snapshot Replication |
|Replication Monitor - Usage and Options |Peer-Peer Vs Merge Replication For HA |
|Read Only Subscribers & Load Balancing |Load Balancing Options with Replication |
|Replication Jobs and Verification Options |Replica Server @ Appl Connection Strings |
|Adding Articles to Existing (LIVE) Replica |Replication Conflicts, Errors and Solutions |
|Adding Subscribers to Existing Replica |Replication Warnings and Agent Alerts |
|Schema Level Replication, DDLs in Repl |Replication Errors, Events and Solutions |
|Stopping, Starting Replication Agents |Replication for HA and DR - Strategies |
|Scripting Replication Jobs, Publications |Replication Limitations and Precautions |
|Disable/Enable Replication, Agent Stops |Replication Errors & Solutions |
|Real-time Errors and Solutions | |
| | |
|DAY 22: LOG SHIPPING - DISASTER RECOVERY | |
| | |
|Log Shipping Topology, Operation Modes |Versioning Issues, Data Traffic. Data Loss |
|Primary and Secondary: Recovery Plan |Log Shipping for DB Recovery Procedures |
|Log Shipping Monitor Settings, Alerts |Log Shipping Jobs - Errors and Solutions |
|NORECOVERY Configuration and Usage |Log Shipping Reports and Data Recovery |
|STANDBY Mode Configuration, Purpose |Log Shipping Standby: Delay Restores |
|Log Shipping Jobs & Restore Schedules |Scripting Log Shipping Configurations |
|Copy and Restore Jobs with Secondary |Standby Disconnections, Latency Options |
|Log Shipping Monitor Status Reports |Real-time Errors and Solutions |
|Manual Failover Process and Recovery | |
|Log Shipping Topology - Limitations | |
MODULE 3 – ADVANCED DBA SESSIONS
All Our Training Sessions are COMPLETELY PRACTICAL & REALTIME with Hands-On Lab.
| | |
|DAY 24, 25: SECURITY MANAGEMENT | |
| | |
|Authentication Types - WINDOWS, SQL |DMVs for Server and DB Security Audits |
|Windows Logins and REGEIDT Settings |Useful Security Audit Queries (DMVs) |
|SQL Server Logins, POLICIES, EXPIRY |KEYS, Passwords - Data Level Encryption |
|LOGINS: Server Level Security, Options |CERTIFICATES & TRIPLE-DES Algorithm |
|USERS: Database Level Security, Options |Master Passwords and Data Encryption |
|SCHEMAS: Object Level Security, Options |SQL Server Credentials, Job Security |
|System Server Roles, Database Roles |Proxies - Purpose, Usage and Options |
|User Server Level Roles & Permissions |Server Credentials for Agent Proxies |
|User Database Level Roles & Permissions |SSIS Proxies for Job Level Subsytems |
|Schemas and DB User Mappings - Usage |Password Resets and Disabling Logins |
|GRANT, WITH GRANT, DENY, REVOKE |Scripting Logins, Users, Roles, Schemas |
|CONTROL, OWNERSHIP, AUTHORIZATION |Security Audits, Role Membership |
|Testing Security Operations, Scripting |Containment Databases and Purpose |
|Common Security Functions & Queries |Contained Database Users and Roles |
| | |
| | |
|DAY 26: DB HEALTH CHECK, AUDIT, LOCKS |DAY 27: DB MAINTENANCE PLANS, DB REPAIRS |
| | |
|Query Resources - CPU, IO and Memory |Database Maintenance Plans (SSIS) |
|Activity Monitor (AM) Tool - CPU, Memory |DB Maintenance Strategies & Schedules |
|Database File IO, Processes, Query Stats |MSDB History Management Options |
|SQL Profiler Tool Usage, Audit Trace Files |Backup Files and Space Management |
|SQL Profiler Templates: Standard, Tuning |Reorganizing Indexes with Maint. Plans |
|Event Extraction Settings, Filter Columns |Stats Updates (Automatic) and Jobs |
|DB ID Filters, CPU Filters, SSID Filters |Modifying SSIS DB Maintenance Plans |
|Profile Trace File Rollover, Size Settings |Scheduling and Maintaining SSIS Plans |
|Database Health Check: DBCC Commands |Log File Issues & Shrinking Operations |
|Allocation Errors and Consistency Errors |SQL DB Engine Properties & Guidelines |
|ESTIMATEONLY, NO_INFOMSGS, Tempdb |Service Configuration Manager Options |
|Log Space Audits and Tempdb Audits |PAGE REPAIRS - suspect pages @ MSDB |
|Dynamic Management Views (DMVs) |FILE REPAIRS, FILEGROUP REPAIRS |
|Important Dynamic Management Functions |DATABASE REPAIRS - DB Consistency |
|Memory Usage & Disk Usage Audit DMVs |DATABASE REPAIRS - Data Allocation |
|Storage Allocation Issues (Page, Extent) |DB Modes, Emergency, NOWAIT Options |
|LOCKS - Types, Impact, Monitoring |Managed DB Backups @ SQL 2016 |
|Shared Locks, Exclusive Locks, WAITS | |
|Deadlock Graphs with SQL Profiler Tool | |
|DEADLOCKS - Avoidance, Prevention | |
|LIVELOCKS - Avoidance, Prevention | |
|Deadlock Graphs @ SQL PROFILER, XDL | |
|Isolation Levels For OLTP - TempDB | |
| | |
| | |
|DAY 28: DATABASE MIGRATIONS, DMA TOOL |DAY 29: PATCHES, SERVER UPGRADES |
| | |
|Database Migration Options with SSIS |Establishing Downtime For Maintenance |
|DB Design Audits @ File System Store |Precautions for Maintenance Activities |
|Database Detach Options and Downtime |Service Packs and Patch/hotfix Activities |
|Database Attach Options and Scripting |Instance Selectivity for Updates, Cautions |
|Scripting: Schemas, Object, Keys, Data |Pre & Post Patch Operations. Process |
|Scripting Security Logins, Permissions |Verifications, SmokeTest and Rollbacks |
|Copy Database Wizard (SSIS) Tool Usage |Upgrade Advisor Tool - Analysis Reports |
|File System, SQL Server Package Store |Upgrade Advisor Issues and Warnings |
|Migration Schedules, Jobs, Alerts, Logs |Server Upgrades and Precautions |
|Corrupted Logs, FORATTACH, REBUILDS |Planning for Maintenance Activities |
|Linked Server Security, Management |Rebuilding System Databases & Objects |
|Server Dashboard, Connection Audits |Pre Database Maintenance Activities |
|Data Migration Assistant (DMA) Tool |Post Database Maintenance Activities |
|Using DMA Tool for DB Analysis, Upgrades |Real-world Management Considerations |
|DMA Tool: DB Assessment, Migration | |
| | |
| | |
|DAY 30: CLUSTERING CONFIGURATION - HA |DAY 31: CLUSTERING: ACTIVE DIRECTORY |
| | |
|Understanding SQL Clustering Service |Need for Centralized Authentication |
|SQL Server Clustering Architecture |Domain Controller (DC) Configuration |
|Windows and SQL Server Licensing |Active Directory Settings and Usage |
|Windows Server Installation Options |DCPROMO Settings for Active Directory |
|Service Pack and Patch Installations |Server Configuration Manager, Options |
|QUORUM Options for Windows Clusters |Configuration Manager - Users & Groups |
|SQL Server Cluster Plan - Licensing |Working with Active Directory (AD) Edits |
|Installing Windows MSCS Service, Tests |Network Configurations and Precautions |
|Ping Tests and Heart-beat Checks, DC |PING Configurations and DTC Options |
|Domain Configurations, Precautions |QUORUM settings and SAN Options |
|MSCS - Microsoft Cluster Services, Nodes |SQL Server Cluster Installation |
|MSCS Service Startup Options, Issues |Cluster Configurations - Active/Active |
|Verifying SQL Server Cluster Installation |Cluster Configurations - Active/Passive |
| |MS DTC Configurations (Local/Remote) |
| | |
|DAY 32: CLUSTERS NODES, ALWAYS-ON |Applicable for PLAN B Registrations: |
| | |
|Install SQL Server Clusters |DAY 33*: SQL CLUSTERS, ALWAYS-ON |
|Clustering Nodes : Install, Update | |
|Need for Always - On Availability |IP Configurations & WSFC Settings |
|Always-On Prerequisites, Node Config |Node Majority, Disk & File Share Majority |
|SQL Group & AD Syncup Operations |Active-Passive Cluster Configurations |
|SAN System for Shared Data Storage |Network Security Issues with Solutions |
|Smoke Test Procedures in Real-time |RAID, Storage Issues with Solutions |
|Fail-Over Disk & RAID Implementation |Availability Replica - Readable Secondary |
|Cluster Connection Issues and Drains |Active Secondary, SYNC, ASYNC (AAG) |
|Installing Updates - SQL Server Clusters |Replica Recommendations for Always-On |
|Add Nodes to SQL Cluster - Active/Active |Routine DBA Challenges for AAG - HA/DR |
|SQL Server Cluster Utilities & Quorum |SLA/OLA Challenges, Tickets in Always-On |
|Cluster Working and Operative Modes |Temporal Tables - AAG : SQL 2016 |
|Configuration Settings, SQL Monitors |Stretch Databases @ SQL 2016 |
|Always-On Availability Groups (AAG) | |
|Prerequisites for Always-On for HA/DR | |
|Primary & Secondary Configurations | |
|Synchronization Settings, HA Options | |
|Port Settings, Backup Strategies in AAG | |
| | |
|DAY 34*: PERFORMANCE TUNING - LEVEL 4 |DAY 35*: PERFORMANCE TUNING - LEVEL 5 |
| | |
|Memory Optimized Tables & Usage |PERFMON Counters and PSSDIAG Tools |
|LIVE QUERY STATS Analysis in SQL 2016 |Dynamic Data Masking DDM Performance |
|Real-world Considerations for DTA Tool |Secured Column Access - DDM Functions |
|Workload Groups & Resource Allocation |Impersonation with Data Masking (DDM) |
|Query Priority, CPU / Memory / IO Limits |Index Management Options - SQL 2016 |
|Windows Fibres, Priority Boost and DOP |Distributed Replay Controller Tool, SCOM |
|Processor Settings, Counters & Thresholds |Data Migration Assistant (DMA) Tool |
|Recommended Thread Counts and Fibres |PSSDIAG Tool - Performance Monitoring |
|Query Memory, Memory Leaks, Pagination |SQL Browser Server - TCP IP, Trace Flags |
|Thread Level Architecture - CPU Nodes |CPU Thread Management, Windows Fibres |
|Windows Fibres, Priority Boost Options |Priority Boosting and Windows Kernel |
|DOP - Degree Of Parallelism & Options |Machine Code Usage in Queries |
|Temporal Tables, SYSTEM_VERSIONING |%%COLNAME%% Query Performance |
|Temporal Tables @ DML Audit Performance |Index Management Options - SQL 2016 |
|In-Memory Tables Creation, Index Options |New Tuning Options - SQL Server 2016 |
|Extended Events & Performance Impact |Performance Tuning - Checklist Activities |
|LIVE Query Statistics - Monitoring Options | |
|LIVE Query Statistics - Baseline Creation | |
|LIVE Execution Statistics, Hash Plans | |
|Natively Compiled Procedure Performance | |
|System Versioned Temporal Tables | |
|Querying VERSIONS from Temporal Tables | |
| | |
|DAY 36*: POLICY BASED MANAGEMENT, TOOLS |DAY 37*: XML Databases, DB Encryptions |
| | |
|Distributed Transactions & Connections |Storing XML Data in SQL Server |
|Policy Based Management (PBM), Facets |FOR XML Statement and XQuery |
|Database Properties and Conditions |Shredding XML. Determining to use XML |
|Policy Management, Events, Schedules |Testing XML Data Storage in Variables |
|Policy Management Options and Agent |Using XML Schemas; FOR XML Queries |
|Facets and Conditions : On Demand |Recompilation Issue with TVP - LIVE DB |
|Facets and Conditions : On Change |Natively Compiled Stored Procedures |
|Policy Based Management (PBM) Reports |SQL Injection Attacks & Vulnerables |
|3rd Party Tools, Server Registrations |Enabling Encryption for LIVE Databases |
|3rd Party Tools : Dell Litespeed |Data Encryptions and Backup Security |
|Multi Database Backups, Log Readers |Replicating Encrypted Databases |
|Reading backup Files, Recovery | |
|Server Aliases, Configuration Manager | |
|Server Dashboards, DB Management | |
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.