Brief Introduction
Index maintenance, Query Tuning, dealing with TempDb issues and many more.Description
You will get a conceptual understanding of various SQL Server database performance issues and learn about different places to check for the performance information along with tuning approach.
Broadly this course will cover following:
Understanding SQL Server waits and how to resolve it.
Tempdb contention issues.
Learn about database statistics, optimizer and maintenance plan for tables and indexes.
SQL Tuning techniques.
Partition in SQL Server.
General guidelines for avoiding performance issues in SQL database.
Requirements
- Requirements
- Basic understanding of SQL Server and some experience in writing T-SQL.
MySQL: The Ultimate MySQL Course
- 4.8
-
![]()
![]()
![]()
![]()
![]()
You'll learn MySQL skills, and leverage the power of MySQL to build powerful databases. Welcome to this course: MySQL: The Ultimate MySQL Course....
PostgreSQL High Performance Tuning Guide
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Tips for Tuning PostgreSQL 12 like a Pro | Learn how to prevent Postgres performance problems PostgreSQL is one of the most powerful and easy-to-use database management systems....
Oracle Exadata X5 Administration | 1Z0-070
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Pass Oracle Exadata X5 Administration | 1Z0-070 on the first attempt. 2 Practice test. Course in Pre-Launch Mode, a total number of questions will be around 85+....
Introduction to Data Engineering
- 4.7
-
![]()
![]()
![]()
![]()
![]()
This course introduces you to the core concepts, processes, and tools you need to know in order to get a foundational knowledge of data engineering....
