LinkedIn – Advanced SQL for Query Tuning and Performance Optimization 2023-10

Advanced SQL for Query Tuning and Performance Optimization course. SQL queries can be fast and very efficient, but they can also be slow and require too much CPU and memory resources. For many SQL programmers, occasional encounters with long-running queries and poor performance are commonplace. But by better understanding how databases translate SQL queries into executables, you can take steps to avoid these problems. In this course, Dan Sullivan shows you how to analyze query execution plans and use data modeling strategies to increase query performance. Dan describes how to execute SQL queries, highlights the different types of indexes and how they play a role in query tuning, covers several methods for performing joins, and how to use partitioning and materialized views to improve Discusses performance. Additionally, Dan shows you how to implement PostgreSQL on GitHub Codespaces so you can start learning faster.

What you will learn

• How to analyze query execution plans to identify performance issues
• How to use indexes to improve query speed
• How to choose the right attachment method for your queries
• How to use partitioning and materialized views to scale your queries
• How to run PostgreSQL on GitHub Codespaces for query development and testing

This course is suitable for people who

• SQL programmers who want to optimize their queries
• Database administrators who are responsible for the operation of the database
• Data analysts who use SQL to extract information from databases

Advanced SQL for Query Tuning and Performance Optimization course specifications

• Publisher: LinkedIn
• Instructor: Dan Sullivan
• Training level: advanced
• Training duration: 2 hours and 9 minutes

Course headings

Course images

Sample video of the course

download link

Download file – 196 MB

File(s) password: www.downloadly.ir

Size

196 MB