A customized Database Administration Course for Modular Mining
Module 1. SQL Server Performance Monitoring Tools
- Anatomy of a Monitoring Solution
- Dynamic Management Objects (DMV/DMF)
- Extended Events and Tracing
- System and Performance Monitor
- Creating and Analyzing a Baseline
- Query Store in SQL 2016
- Third Party Tools
Module 2. CPU and Scheduling
- Waits and Queues
- Troubleshooting and Tuning
- Resource Governor
Module 3. SQL Server Memory
- Memory Architecture in SQL Server
- Memory Configuration
- Buffer Pool Extension
- Memory Monitoring
Module 4. SQL Server IO
- Troubleshooting tempdb
- Monitoring IO
Module 5. Query Optimization and
- Cardinality Estimation
- Working with Statistics
- Query Optimization
- Query Execution
- Plan Caching and Recompilation
Module 6.SQL Server Indexes and Query Plan Analysis
- Execution Plan Basics
- Index Analysis
- Index Fragmentation
- Analyzing Execution Plans
Module 7. SQL Server Concurrency
- Locking, Latching and Spinlocks
- Deadlocks and Blocking
- Monitoring Concurrency
- Transaction Isolation Levels
- Snapshot Isolation and Row Versioning
- Locking Hints
In this course you will learn how to:
- Use loops and branches in queries
- Create user defined functions and stored procedures
- Manage constraints and triggers
- Control multiple simultaneous updates
Structured Query Language (SQL) is the most popular language used for querying relational databases. SQL supports a number of advanced features that make your queries more intelligent and efficient and take a lot of the work away from the middleware. Databases that are supported include: MySQL, Microsoft SQL Server, Microsoft Access, PostgreSQL and Oracle.
PostgreSQL is a sophisticated open source relational database management system. PostgreSQL supports the structured query language (SQL) with a wide variety of data types and support for: triggers, a number of embedded programming languages, and full transactional processing.
Virtual instructor led or self-taught training course on the administration of the PostgreSQL Relational Database Management System. You will be able to develop and maintain powerful PostgreSQL servers.