SQL SERVER & T-SQL COURSE - SQL School



SQL DBA (includes Server, T-SQL)

On-demand Video Training Course – 24x7

Complete Practical & Real-time Training Videos

|[pic] |

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

| |

Training Highlights

✓ Complete Practical and Real-time Scenarios

✓ Video wise Material and Practice Labs

✓ Video 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 video includes Lab Work, Tasks and Study Material. Course includes total of 40 Videos. |

|Total Course Fee: INR 18000/- (USD 300$) payable in three equal installments. |

MODULE 1 - SQL SERVER, T-SQL VIDEOS

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

|Free Demo: SQL SERVER INSTALLATION |VIDEO 1: SQL SERVER DATABASE DESIGN |

|SQL Server 2016 Installation, Tools |Advantages of SQL Server Databases |

|SQL Server 2014, 2012 Installation, Tools |Database Logical Design and Physical Design |

|Components: WMI,MSXML,MDAC,Firewall |Database Architecture - Files, File Groups |

|Roles, Responsibilities, Levels - SQL DBA |Database Properties and Storage Options |

|How to install SQL Server - Step by Step |Data Files : Pages, Extents and Sizing Options |

|Common Installation Errors, Solutions |Filegroups : Purpose, Usage and Options |

|Windows Updates, XML Errors, SETUP |Log files : Size Planning and Placement |

|SQL Server Management Studio (SSMS) |Database Creation Options using GUI |

|DBA Checklist - Routine DBA Activities |Database Creation using T-SQL Scripts |

|DBA Checklist - Maintenance Activities |Data File Locations and Sizing Options |

|DBA Checklist - Emergency Activities |File / Autogrowth and MAXSIZE Options |

|Online Lab Access (24x7 LIVE Server) |Planning Very Large Databases (VLDB) |

|Mini Project @ Course: L1 DBA Activities |Database Structure Modifications, ALTER |

|Real-time Project: L2, L3 DBA Prod Roles |Adding New Database Files, Filegroups - GUI |

|Video wise Course Plan, Server Access |DB Modifications and Options – Script Options |

|VIDEO 2: SQL SERVER TABLE DESIGN |VIDEO 3: CONSTRAINTS, KEYS, NORMALIZTION |

|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 |

|VIDEO 4: VIEWS, JOINS & TUNING OPTIONS |VIDEO 5: INDEXES & QUERY TUNING |

|Views in SQL Server - Purpose, Security |Indexes Architecture, Types and Purpose |

|SELECT Query Types, Variants in Views |Clustered Indexes - Architecture, Usage |

|WHERE, IN, EXISTS and BETWEEN |Non Clustered Indexes - Architecture |

|SCHEMABINDING, ENCRYPTION Options |Execution Plans & Query Optimizations |

|Views with ALTER TABLE, TOP Clause |Table Scan, Index Scan, Index Seek Plans |

|Issues with Views For Data Validations |SORT_IN_TEMPDB, Primary Key Indexes |

|Preventing Orphan Objects with Views |Fragmentation: FILLFACTOR, PAD_INDEX |

|Database Diagrams and Entity Relations |INCLUDED and COLUMN STORE Indexes |

|Views for Enforcing Data Level Security |FILTERED, ONLINE / OFFLINE Indexes |

|Common System Views For Audits |Indexes & JOINS, Merge, Loop Options |

|Cross Join, Inner Joins - Comparisons |STATISTICS - Types and Tuning Options |

|LEFT and RIGT Outer Joins - Usage |STATISTICS with Indexes, Query Columns |

|Joins with multiple tables, Basic Reports |Materialized Views (Indexed Views), Queries |

|Using JOINS with Cascaded Views |Query Tuning and Query Optimizer (QO) |

|Views on Multi Table Joined Queries |Index Limitations: Performance, Fragmentation |

|VIDEO 6: FUNCTIONS - QUERIES - VIEWS |VIDEO 7: STORED PROCEDURES - BASICS |

|Scalar Value Functions - Purpose, Usage |Stored Procedures - Purpose and Usage |

|Inline Table Value Functions & Usage |Variables - Usage in Stored Procedures |

|Multi-line Functions - Scope, Usage |Parameters - Usage in Stored Procedures |

|CROSSAPPLY and CONVERT, CAST Options |Stored Procedures for Data Validations |

|SCHEMABINDING, ENCRYPTION Options |Stored Procedures for Dynamic Queries |

|Embedding Functions in SELECT Queries |Stored Procedures for Data Reporting |

|System Functions and Metadata Audits |System Procedures For Metadata Access |

|Date-Time, String, Aggregate Functions |Extended Procedures For App Access |

|Row_Number, Rank, DenseRank, Grouping |IF.. ELSE, IF .. ELSE IF, IIF Conditions |

|Date Functions and CONVERT() Styles |Error Handling: TRY, CATCH, THROW |

|Using CROSSAPPLY, ROLLUP, GROUP BY |Dynamic SQL Parameters and Variables |

|Comparing HAVING & WHERE in SELECT |Default Parameter Values, Usage Types |

| |Stored Procedures with Variables, Parameters |

| |Import System SPs for Dynamic SQL Queries |

| |Stored Procedures with System Views, Audits |

|VIDEO 8: STORED PROCEDURES, CTEs, TUNING |VIDEO 9: CURSORS, JOINS & TUNING OPTIONS |

|Stored Procedures for Dynamic Sub Queries |Working with Cursors, Stored Procedures |

|Stored Procedures for Recursive Queries |Cursor Types - Benefits, Purpos, Options |

|OUTPUT Parameters, Nested Sub Queries |FORWARD_ONLY, SCROLL Cursors Types |

|Common Table Expressions (CTE) & Uses |STATIC, DYNAMIC Cursors & Queries |

|CTE & Data Retrieval in Stored Procedures |LOCAL and GLOBAL Cursor & Queries |

|CTE & Conditional DML in Stored Procedures |KEYSET DRIVEN Cursor & Performance |

|Using Recursive CTEs with Procedures |Embedding Cursors in Procedures, UDFs |

|Recursive CTEs and Query Performance |SPs with Cursors For Dynamic Data Loads |

|Tuning Operations with CTE, Self Joins |Query Tuning & Optimization Options |

|CTE Queries with Sub Queries and Row Updates |HASH JOIN - Example, Scenario and Usage |

|CTE Limitations and Self Join Alternatives |MERGE JOIN - Example, Scenario, Usage |

|Dynamic Parameters and Variables in SPs |LOOP JOIN - Example, Scenario and Usage |

|Cached Plans & Memory for Stored Procedures |Sub Queries and Joins. Alternate Syntax |

|RECOMPILE Option. ENCRYPTION Option |End User Access to Queries - Options |

|VIDEO 10: TRANSACTIONS & TRIGGERS | |

|Use of Triggers - Purpose and Scope |VIDEO 11: SQL SERVER ARCHITECTURE |

|DML Triggers and Performance Impact | |

|FOR / AFTER Triggers: Usage, Importance |SQL Server Architecture - Client/Server |

|INSTEAD OF Triggers: Usage, Importance |Encrypted Data Communication (TDS) |

|INSERTED and DELETED Memory Tables |CLIENT – SERVER Architecture, TDS Packets |

|Triggers for DML Audits, Data Sampling |SQL Architecture - TDS Packet Sizing Options |

|Database Level, Server Level Triggers |SQL Architecture - Batch & Client Stats |

|Bulk Operations and Updatable Views |SQL Architecture - Protocols, DB Engine |

|Triggers for Data Distribution & JOINS |Memory Manager and SQL Server Manager |

|ACID Properties and Transaction Types |Query Optimizer (QO) and Execution Plans |

|EXPLICIT, IMPLICIT, AUTOCOMMIT Types |Index Scans, Index Seeks and Table Scan |

|IMPLICIT Transaction Usage, DB Settings |Data Provider and SQL Connection Types |

|AUTOCOMMIT Transactions, Advantages |Catalogs & CLR / PowerShell Integrations |

|Open Transactions and Query Blocking |SQL Database Architecture - RAID Levels |

|Nested Transactions, Save Points and Use |SQL DB Architecture - Files and Filegroups |

|Transactions Levels, Performance, LOCK HINTS |Log File Architecture - Virtual Log Files |

| |Log File Architecture - Mini LSN & DOP |

MODULE 2 – BASIC DBA VIDEOS

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

|VIDEO 12: LOCKS, DEADLOCKS, LIVE LOCKS |VIDEO 13: BACKUPS – TYPES, STRATEGIES |

|Locks: Types, Importance, Management |Backups Concept - Purpose, Mechanism |

|SP_WHO2, SP_WHO, SP_LOCK Monitoring |Data Backups - Syntax, Types, (NO)SKIP |

|Lock Types, Resources, Scope, File & Page |Log Backup Mechanism and Precautions |

|Lock Monitor Concepts, Lock Escalations |CHECKPOINT and Log TRUNCATE Options |

|Avoiding LOCK WAITS on PAGE and TABLE |File Backups, Filegroup Backups, STATS |

|Isolation Levels - Types and Purpose |COMPRESSION, CHECKSUM, Validations |

|READ COMMITED, SERIALIZABLE - Issues |COPY_ONLY, CONTINUE_AFTER_ERROR |

|READ UNCOMMITED, REPEATABLE - Issues |Partial Backups with Read Only Filegroups |

|SNAPSHOT, READCOMITTED SNAPSHOT |Remote Backups and Security Options |

|Isolation Levels, Hints For OLTP Databases |VERIFYONLY, Appended Backups, File IDs |

|Statement Locks and Transaction Locks |HEADERONLY, FILELISTONLY Options |

|TempDB Issues with Isolation Options |Backup Sets, MediaSets and Media Family |

|Locking Hints to Avoid Query Blocking |MSDB History Tables and Audit Types |

|A DEADLOCK Scenario and DML Audits |DB Backup Jobs and SQL Agent Service |

|A LIVELOCK Scenario and DML Audits |Scheduling Backups and DR Strategies |

|Lock Detections, Avoidance, Precautions |Backup Files - Mirrors, Usage, Limitations |

|LIVE Locks Vs Deadlocks – Real-time Scenario |Tuning Database, Log Backup Operations |

|VIDEO 14: BACKUPS & RESTORES - I |VIDEO 15: BACKUPS & RESTORES - II |

|Backup Verification Options, Precautions |Mirrored Backups and Restore Options |

|Recovery Paths and Restores - Strategies |Split Backups, Files - Restore Options |

|Database Restores & RECOVERY Options |Media Set, Media Family and Options |

|File Restores and File Group Restores |FORMAT, NOFORMAT, INIT and NOINIT |

|FILELISTONLY and VERIFYONLY Options |SQL 2012 to SQL 2014/2016 Restores |

|MOVE and REPLACE Options For Restores |Partial Backups, STATS, Password Options |

|Metadata Restores and PRIMARY Restores |Tape Backups, (Remote) Network Backups |

|PARTIAL Restore & Piecemeal Restores |CHECKSUM & CONTINUE_AFTER_ERROR |

|Tail Log Backups and Database States |DB Compatibility Options with Restores |

|Re-Restoring REDO Log Backups, Purpose |DB Recovery Models and Backups/Restores |

|Preparing Databases for Pending Restores |Working with Recovery Models, Backups |

|Compressed Tail Log Backup Restores |Choosing correct DB Recovery Models |

|Re-Restoring (REPLACE) Backups Sets |Backups using GUI Versus TSQL Scripts |

|Restores for Partial Online Databases |COPY_ONLY Backups and Isolated Entries |

|Choosing Right Backups for Restores |Point-In-Time Restores and Log Recovery |

|Restore Chains and LSN, CHECKPOINT |Overwrite Options for Database Restores |

|Real-world Scenarios for Partial Restores |Backup Devices Creation and Advantages |

| |Backup Devices Usage and Limitations |

|VIDEO 16: REPLICATION For HA DR - I |VIDEO 17: REPLICATION For HA DR - II |

|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 and Subscriptions |Replication across Lower/Higher Versions |

|PUSH - PULL Subscriptions Types, Options |Replication Conflicts - Options, sp_MSRepl |

|Snapshot Replication and Replication Agents |IDENTITY Property & Schema Replication |

|Configure, Secure, Schedule Snapshots |PULL Subscription Configuration Options |

|Snapshot Subscriptions and Replica Database |Domain Account Security in Replication |

|Transactional Replication Configuration Issues |Merge, Snapshot Replication Limitations |

|Log Reader Agent – Configuration and Keys |Replica Initialization with Backups, Issues |

|Tracer Tokens - Latency and Repl Ranking |Transactional Versus Snapshot Replication |

|Replication Monitor - Usage and Options |Peer-Peer Versus Merge Replication For HA |

|Read Only Subscribers and Load Balancing |Load Balancing Options with Replication |

|Replication Jobs and Verification Options |Replica Server @ App Connection Strings |

|Adding Articles to Existing (LIVE) Replication |Replication Conflicts, Errors and Solutions |

|Adding Subscribers to Existing Replication |Replication Warnings and Agent Alerts |

|Schema Level Replication, DDLs in Replication |Replication Errors, Events and Solutions |

|Stopping, Starting Replication Agents |Replication Errors @ DB Engine, Solutions |

|Scripting Replication Jobs and Publications |Replication For HA and DR - Strategies |

|Disable/Enable Replication, Agent Stops |Replication Limitations and Precautions |

|VIDEO 18: LOG SHIPPING – HA & DR |VIDEO 19: DATABASE MIRRORING – HA & DR |

|Log Shipping Architecture, Modes of Operation |DB Mirroring Architecture For HA,DR |

|Choosing Primary, Standby Servers - Recovery |Mirroring Configuration Scenarios |

|Log Shipping Monitor Configuration, Alerts |Backups & Restores for Mirrors |

|NORECOVERY Configuration and Usage |TCP Endpoints & Network Security |

|STANDBY Mode Configuration and Usage |Heartbeat and Polling Concepts in DM |

|Log Shipping Jobs - Backup, Restore Schedules |Service Accounts Configurations, Use |

|Log Shipping Jobs - Errors and Solutions |Automatic Fail-Over Procedures, Tests |

|Copy and Restore Jobs with Secondary DB |Manual Failover Options & Scenarios |

|Log Shipping Monitor Status Reports, Refresh |PARTNER OFFLINE Conditions & Options |

|Manual Failover Process and Recovery Options |DB Mirroring Monitors, Commit Loads |

|Log Shipping Topology – Recovery Limitations |SYNCHRONOUS, ASYNCHRONOUS Modes |

|Versioning Issues and Data Traffic. Data Loss |Manual Failover Process, Partner Roles |

|Log Shipping for DR Procedures. Precautions |Mirroring Monitor, Stop/Resume Options |

|Log Shipping Reports, Data Recovery. Usage |Real-World Considerations & DR Options |

|Scripting Log Shipping Configurations, Jobs |DR & HA with DB Mirroring Advantages |

|Standby Disconnections and Latency Options |Need for Always-On & Higher Availability |

|Errors and Solutions @ LS Copy, Restore |DB Mirroring Errors and Solutions |

|VIDEO 20: SECURITY MANAGEMENT - I |VIDEO 21: SECURITY MANAGEMENT - II |

|Authentication Types – WINDOWS and SQL |A Real-world Security Scenario (complete) |

|Windows Logins – Config, Registry Settings |KEYS and Passwords for Data Level Security |

|SQL Server Logins, POLICY CHECKS, EXPIRY |CERTIFICATES with 3-DES Algorithm, Usage |

|Default Databases, Keys, Language, Collation |Master Passwords and DB Level Encryption |

|LOGINS: Server Level Security and Options |Testing Database Encryption Levels |

|USERS: Database Level Security and Options |Master Passwords and Certificate IDs |

|SCHEMAS: Object Level Security and Options |Basic Job Level Security and Options |

|System Level Server Roles, Database Roles |SQL Server Credentials and User Mapping |

|User Defined Server Level Roles, Permissions |Proxies - Purpose, Usage and Options |

|User Defined DB Level Roles, Permissions |Server Credentials for Agent Proxies |

|Schemas and User Mappings - Precautions |SSIS Proxies for Job Level Sub Systems |

|GRANT, WITH GRANT, DENY and REVOKE |Scripting Logins, Users, Roles, Schemas |

|CONTROL, OWNERSHIP, AUTHORIZATION |Scripting Login - User Mappings, Securables |

|Testing Security Operation with Scripting |Scripting User and Role Permissions |

|Common Security Functions and Queries |Login Errors – Audits and Server Logs |

|DMVs for Server and DB Security Audits |SQL Server Management Logs, 18456 Error |

|Server Principals and Database Principals |Possible Logon Failure Errors, Scenarios |

|Security Audits @ GUI Tools Versus Queries |Password Resets and Disabling Logins |

|VIDEO 22: DATABASE AUDITS, SERVER AUDITS | |

|Activity Monitor (AM) Tool - CPU, Memory |VIDEO 23: DATA IMPORT/EXPORT & DB MAIL |

|Database File IO, Processes, Query Stats | |

|SQL Profiler Tool Usage, Audit Trace Files |Import and Export (SSIS) Wizard - Usage |

|SQL Profiler Templates: Standard, Tuning |OLE-DB, SQLNCLI, Microsoft Jet Drivers |

|Event Extraction Settings, Filters, Columns |SQL Server and Other Database Sources |

|DB ID Filters, CPU Filters, SSID(SID) Filters |Database / Non-Database Destinations |

|Profile Trace File Rollover, Size Settings |Choosing Correct Data Providers For SSIS |

|Comparing Profiler Trace Files and Tables |Encrypting SSIS Package Connections |

|Database Health Check - DBCC Commands |File System and MSDB Package Store |

|Allocation Errors and Consistency Errors |MSDB System Tables for SSIS Packages |

|ESTIMATEONLY, NO_INFOMSGS, Tempdb |Scheduling SSIS Packages (dtsx) @ Jobs |

|Log Space & Tempdb Audits with DMVs/DMFs |Credentials, SSIS Proxies, Authentication |

|Memory Usage & Disk Usage Audit DMVs |SSIS Proxies - MSDB SSIS Job History |

|Audit Long Running Queries - DMV/DMF |Database Scripting & Encryption Options |

|Query Audits and DMVs / DMFs with Joins |Database Cloning Procedures & Cautions |

|Storage Allocation Issues (Page, Extent) |Linked Servers: Configurations, Purpose |

|DBCC Usage in Real-world - Precautions |Linked Servers: Remote Servers, Logins |

|Deadlock Graphs with SQL Profiler Tool |Database (DB) Mail Configurations & Use |

|Considerations Using SQL Profiler Tool |Securing DB Profiles : SMTP Accounts |

| |Operators in SQL Agent and and Emails |

| |SQL Job Failures and Email Notifications |

MODULE 3 – ADVANCED DBA VIDEOS

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

|VIDEO 24: QUERY TUNING – SQL SERVER 2016 |VIDEO 25: QUERY TUNING – SESSOIN 2 |

|New Tools, Techniques: SQL Server 2016 |Big Data - Performance Considerations |

|Memory Optimized Tables - Performance |Table Partitions & Query Tuning Options |

|Temporal Tables & SYSTEM_VERSIONING |Partition Functions For Tuning - Usage |

|Dynamic Data Masking(DDM) Advantages |Partition Schemes, Reusability Options |

|Dynamic Data Masking Use, Precautions |Partition Ranges, Values and Sort Orders |

|Secured Column Access - DDM Functions |Partitioned Data, Long Running Queries |

|Managed Backups & Performance Issues |Partitioning Un-partitioned Structures |

|Index Management Options - SQL 2016 |Aligned Partitioning and Performance |

|Distributed Replay Controller Tool, SCOM |Fill Factor, Pad Index and Query Tuning |

|Data Migration Assistant (DMA) Tool |Partitions for Query Tuning Operations |

|Using DMA Tool for DB Analysis, Upgrades |Statistics with Table & Index Partitions |

|Server and Database Analysis, SSIS |Statistics for Query Conditions, Purpose |

|PSSDIAG Tool - Performance Monitoring |Stats Audits, Metadata, Manual Updates |

|SQL Browser Server - TCP IP, Trace Flags |Data Compression Types and Options |

|CPU, Threads, Windows Fibers, Priority |ROW & PAGE Compressions. Differences |

|Performance Tuning - Checklist Activities |Performance Issues - Data Compressions |

|Backup Encryptions: SQL 2014 Vs 2016 |Partition Numbers, Filtered Compressions |

|Stretch Databases - Cloud Integration |Managing Partitions and Tuning Options |

|VIDEO 26: QUERY TUNING – SESSION 3 |VIDEO 27: QUERY TUNING – SESSION 4 |

|LIKE Operator - Limitations & Wild-cards |Index Internals and Execution Plans |

|Full Text Search (FTS) Configuration |Index Fragmentation - Issues, Solutions |

|Full Text Search Service and Importance |SAMPLED & DETAILED Query Scans |

|Filter Daemon Launcher Server - Options |Index Rebuilds, Query Tuning Options |

|Database Catalogs (FTC) and Storage |Table Rebuild Options - CI, NCI Indexes |

|Full Text (FT) Indexes for Query Tuning |Index Reorganization Process and Uses |

|Full Text Columns and Primary Index |Page, Row Compressions with Indexes |

|Full Text Index and Searching Queries |FILLFACTOR & PADINDEX Index Options |

|Full Population, Incremental Population |Filtered Indexes, Online Indexes, Views |

|CONTAINS() and FREETEXT() Functions |Understanding Workload Files in Profiler |

|Token Search, Inflectional Forms Search |Understanding Workload Tables in Profiler |

|Manual Data Populations, Index Loads |SQL Profiler Tuning and Lock Templates |

|Backups, Restores with FT Catalog Files |Index Selectivity Options and Statistics |

|CHANGE_TRACKING Options, Limitations |Database Tuning Advisor (DTA) - Usage |

|Securing FT Catalogs and FT Indexes |Choosing Correct Option (PDS) for Tuning |

|Performance Tuning with FT Indexes |GAM, SGAM Pages, Metadata Header Info |

|Filtered Indexes and Size Limitations |Analyzing Work Load Tables and Scans |

|Understanding PDS Options with Indexes |Table Statistics & Query Tuning Options |

| |Statistics Role in Query Tuning Process |

|VIDEO 28: MAINTENANCE PLANS (DMP, SSIS) |VIDEO 29: ALTERS, ISSUES, SOLUTIONS |

|Database Maintenance Plans (SSIS) |LOG File Issues, Usage and Solutions |

|DB Maintenance Strategies & Schedules |TEMPDB Space Issues with Solutions |

|MSDB History Management Options |MEMORY Management Issues - Solutions |

|Backup Files and Space Management |OS Level Memory Clerks and Monitoring |

|Reorganizing Indexes with Maintenance Plans |Memory Leaks, Cache Hits and Solutions |

|Modifying SSIS Database Maintenance Plans |Logical and Physical Memory Architecture |

|Scheduling and Maintaining SSIS Plans |Procedure Cache Issues and Solutions |

|Log File Issues and Shrinking Operations |DB State Events, Issues and Solutions |

|SQL DB Engine Properties and Guidelines |Network Usage, Monitoring, Optimization |

|SQL Service Configuration - Properties |Performance Monitor PERFMON Counters |

|Distributed Transactions & Connections |Replication Threshold Values & Agents |

|Query Governor Usage and DOP Options |Database Settings and Downtime Plans |

|Policy Based Management (PBM) & Facets |Database States Alerts and DB Events |

|SQL Database Properties and Conditions |DBCC Commands and Database Repairs |

|Scheduling Policies & Event Management |Rebuild Operations and Considerations |

|Considerations for Policy Management |Important DMVs and DMFs for Audits |

|VIDEO 30: PATCH, SERVER PACKS, UPGRADES |VIDEO 31: WINDOWS CLUSTER INSTALLATION |

|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 |

|Verifications, SmokeTest and Rollbacks |Windows Server Installation Options |

|Instance Selectivity for Updates, Cautions |Service Pack and Patch Installations |

|Pre & Post Patch Operations. Process |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 |Cluster Installation Steps, Issues, Solutions |

|VIDEO 32: MAINTENANCE PLANS (DMP, SSIS) |VIDEO 33: ALWAYS-ON AVAILABILITY (AAG) |

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

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

|Active Directory Settings and Usage |SQL Server 2012/2104/2016 Clusters |

|DCPROMO Settings for Active Directory |Verifying Cluster Node Configurations |

|Server Configuration Manager, Options |Add Nodes to SQL Server Cluster |

|Configuration Manager Features, Users |SQL Group and AD Syncup 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 |

| |VIDEO 36: DB MIGRATION, MANAGEMENT |

|VIDEO 34,35: MAINTENANCE PLANS (DMP,SSIS) |Database Migration Options with SSIS |

|Network Security Issues with Solutions |DB Design Audits @ File System Store |

|RAID, Storage Issues with Solutions |Database Detach Options and Downtime |

|Installing Patch Updates in SQL Clusters |Database Attach Options and Scripting |

|QUORUM, Storage Issues: SAN / NAS |Scripting: Schemas, Object, Keys, Data |

|SQL Server Cluster Utilities and Usage |Scripting Security Logins, Permissions |

|Cluster Working and Operative Modes |Copy Database Wizard (SSIS) Tool Usage |

|Configuration Settings - AAG Monitors |File System, SQL Server Package Store |

|Always-On Availability Groups (AAG) |Migration Schedules, Jobs, Alerts, Logs |

|Prerequisites for Always-On for HA/DR |Corrupted Logs, FORATTACH, REBUILDS |

|Primary and Secondary Configurations |Linked Server Security, Management |

|DB Synchronizations, Always-On Options |Memory Dashboard and Buffer Cache |

|Replica Recommendations for Always-On |Server Dashboard, Connection Audits |

|Backup Storage and Types - Strategies |Policy Management Options and Agent |

|Port Settings and Replica Config in AAG |Facets and Conditions : On Demand |

|Active-Passive Cluster Configurations |Facets and Conditions : On Change |

|Flexible Failover Policy, HA/DR Process |Policy Based Management (PBM) Reports |

|Availability Replica - Readable Secondary |AAG - Insight with SQL Server Clusters |

|Active Secondary, SYNC, ASYNC (AAG) | |

|IP Configurations and WSFC Settings | |

|Node Majority, Disk & File Share Majority | |

|Routine DBA Challenges for AAG (HA-DR) | |

|Temporal Tables - AAG : SQL 2016 | |

|VIDEO 37: CHANGE DATA CAPTURE, ALIASES |VIDEO 38: DB MANAGEMENT, 3RD PARTY TOOLS |

|Need for CDC - Table Audits, CT Tables |Transparent Data Encryption (TDE) |

|CDC Enable Databases, Tables, Columns |Master Key Encryptions For Security |

|CDC Audits, Capture Job, Cleanup Job |Server Certificates @ TDE Implementation |

|Change Tracking (CT) Tables - DML Events |Database Key Encryptions & File Security |

|Change Tracking (CT) Tables - DDL Events |Certificate Backups, Key Backups, Usage |

|LSN Mapping, Time, State Value Changes |DB Migrations: Encrypted File Structures |

|Performance Impact with CDC, Truncates |Database Scripting Tools & Data Scripts |

|Limitations and Precautions with CDC |Backups: SQLCMD & SSMS Comparisons |

|SQL Server Configuration Tool & Usage |Need for 3rd Party Tools Recommendations |

|SQL Configuration Management Options |Tools Installation & Server Registrations |

|XML and BLOB Data - OPENROWSET |Backups with 3rd Party Tools, Advantages |

|BLOB Data Store: Performance Issues |Reading SQL Server Log Files, Audits |

|Server Aliases, Use and Protocols, Ports |REDO, UNDO, ROLLFORWARD @ Log Files |

|Services & Minimal Configuration Modes |Multi Database Backups, HA & DR Process |

|DAC - Dedicated Administration Console |Ticketing Tools - REMEDY, CornerStone |

|DAC - Precautions, Usage and Scenarios |Understanding SLA and OLA Process |

|Contained Databases - Purpose, Usage |Ticket Allocations, Escalations, Process |

|Contained Databases - Considerations |Real-world Knowledge Base (KB) Articles |

| |Notifier Tools, SLA Reports, PRI Tickets |

| |Server Dashboards and Database Audits |

Pre-requisites for this SQL DBA Course:

This is a starter course, no pre-requisites required. Course includes free orientation video 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]

Courses from SQL School Training Institute:

[pic]

[pic]

ISO Certified Training Institute Microsoft Certified Partner

__________________________________________________________________

ALL OUR TRAININGS SESSIONS ARE COMPLETELY PRACTICAL & REALTIME

__________________________________________________________________

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

( ISO Certified Training Institute ( Microsoft Certified Partner

OPTIONAL: Real-time Case Study with Functions, Queries, Tuning Query: Medicare DB

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