SQL SERVER & T-SQL COURSE
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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- sql server data classification
- sql server data classification tool
- sql server data types
- azure sql server hyperscale
- sql server 2016 string functions
- sql server connection strings
- sql server localhost connection string
- sample sql server connection string
- sql server trusted connection string
- sql server trusted connection true
- sql server connection string trusted connection
- connection string c sql server examples