Query Optimization Techniques in SQL
This is an advanced course which embodies an aggregation of all the neccessery techniques to write optimized queries in SQL
PostgreSQL Database Administration (DBA) for Beginners - Full Course
☞ https://morioh.com/p/065acd2366c1
MySQL Database - Full Course from Zero to Hero
☞ https://morioh.com/p/752aa713e91d
SQL vs NoSQL or MongoDB vs MySQL? Which Database is Better?
☞ https://morioh.com/p/f2eba211e16d
This course is designed for people who want to master SQL at the middle and senior levels. We will discuss the Oracle database as an example, but all the working and research methods can be applied to other relational databases.
In our course, we will talk about such an important aspect as query optimization and will deeper analyze the theoretical questions that may be useful not only for successful work, but also for the interviews. The focus will be on the technical implementation of the acquired knowledge, paying the most attention to the "under the hood" operation.
What you should already be able to do
- write basic SQL queries
⁃ use aggregate functions
⁃ use analytical functions
⁃ write your own functions (in PLSQL or, speaking of Oracle, using the with construction: a new feature introduced by Oracle, and according to the presentation, it should work 4 times faster than PLSQL variant).
In this course we will go through:
- query plan and how to read it
- join algorithms
- hints and statistics
- indexing
- caching
- partitioning
- use of temporary, intermediate tables and materialized views
Mastering the topics mentioned above will drastically improve an overall perfomance of your SQL queries and will allow you to properly time manage your applications with the most efficient use of available resources.
What you’ll learn
To learn how to read and use the query plan in SQL.
To study different join algorithms and best conditions of it application.
To master the optimal usage of indexing depending on the task
To master superior features and functionality of SQL by using partitioning, hints, caching, e.t.c
Are there any course requirements or prerequisites?
Basic SQL knowledge including the ability to write basic SQL queries, to use aggregate and analytical functions and to write your own functions.
Who this course is for:
Developers/analysts who are working with databases and want to do it more efficiently.
#SQL #Database #Morioh
Note: If you have any copyright issue with the content used in our channel or you find something that belongs to you, before you claim it to Youtube, SEND US A MESSAGE and the respective content will be DELETED right away. Thanks for understanding.
Watch video Query Optimization Techniques in SQL online without registration, duration hours minute second in high quality. This video was added by user DataZ 13 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 21 once and liked it 1 people.