Danh mục
Development
Web Development Data Storage Git Automation Database Design Web Scraping
Business
Business Analysis Communication Project Management Sales Forecasting Business Strategy Operations Management Human Resources Oil and Gas Industry
Finance & Accounting
IT & Software
Office Productivity
SAP Word Excel PowerPoint Excel VBA SharePoint
Personal Development
Persuasion Notion Workspace Mind Mapping
Design
Design Sketching Typography Game Design Digital Art zBrush 3D Animation
Marketing
SEO Marketing Strategy YouTube Marketing Digital Marketing Facebook Marketing Growth Hacking Twitter Marketing Instagram Marketing
Lifestyle
Beer Brewing Beauty Home Repair Energy Healing Bartending Leather Crafting Makeup Artistry Hypnotherapy
Music
Piano Guitar Singing Music Production Acoustic Guitar Fingerstyle Guitar Music Theory Bass Guitar
Duocmmo Tedu Tin học văn phòng Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Development
Database Design & Development
Oracle SQL
Oracle SQL Performance Tuning Masterclass (2024)

Oracle SQL Performance Tuning Masterclass (2024)

Loại khoá học: Database Design & Development

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!

image
50.000 VND
1.899.000 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

Welcome the most comprehensive SQL Tuning course on the planet that makes you an expert on SQL & Performance Tuning!

Important Notice: This SQL & Performance Tuning course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL Tuning.

The most common problem of working with SQL is performance problems. Most of the developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for both the developer and the company.

This course will teach you how to tune your SQL statements and database step by step for a perfect performance! You will learn how to write fast, reliable, and secure queries. Besides, you will learn the database architecture and will be able to optimize the database workloads.

Once you complete this course, you will recognize the database terms better and will use the most appropriate one for the performance.

Once you complete this course, you will be able to:

  • Find the Poorly Performing SQL Queries

  • Learn Advanced Query Tuning Techniques

  • Understand the Database Architecture to perform Better Tuning Techniques

  • Learn Advanced Indexing Techniques to Maximize Database Performance

  • Learn how to use various Performance Tuning Tools

  • Compare BAD vs GOOD Queries with Hands-on Examples.

  • Learn How to Gather Statistics for bad SQLs

  • Interpret the Execution Plans with different methods

  • Choose an Appropriate SQL Tuning approach

  • Guide the Oracle Optimizer for a better execution

  • Use various tuning techniques like using bind variables, different types of indexes, and much more.

  • Improve the performance of the queries & database

  • Gain Complete Knowledge in Oracle SQL and Performance Tuning!


Briefly, the knowledge of SQL Tuning is a "must" for IT Professionals and this course is the magic pill for that you're seeking for Becoming a Performance Expert!

If you want to step ahead in your career, "SQL & Performance Tuning" should be your next step.

See you in the first lecture!

Bạn sẽ học được gì

Learn How to Solve Critical Performance Problems with Step by Step Approach!

Learn Advanced Indexing Techniques for Ultimate Database Performance!

Learn How to Use Various Performance Tuning Tools for In-Depth Assistance!

Maximize the Query Performance by Using Advanced Tuning Tecniques!

Learn Oracle Database Architecture by "Tuning" aspects.

Identify and Optimize the Performance of poorly performing (bad) SQLs.

Understand SQL Tuning Terminologies

Learn How to Create "Better" Queries

Learn How to Prioritize your SQL Tuning Efforts.

Learn the Details of How an SQL Code is Interpreted

Learn Useful Hints to improve Performance of your Queries

Learn & Improve How to Use Oracle Optimizer and Execution Plans Well

Various Tips and Tricks to make the Oracle SQL queries run faster.

Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.

Learn Efficient Schema Design

Lifetime Support from the Authors.

Weekly Quizzes & Assesment Tests

Working materials and always up to date!

Yêu cầu

  • SQL Knowledge
  • Basic PL/SQL Knowledge

Nội dung khoá học

14 sections

SQL & Perfomance Tuning Course Introduction

3 lectures
SQL & Performance Tuning Course Overview
04:52
UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
05:01
Welcome Gift! + Course Document
00:36

What is SQL (Performance) Tuning and Why We Need?

2 lectures
What is SQL Tuning and Why to Do That?
05:55
What to Know Before Starting the Course?
06:20

Oracle Database Architecture

15 lectures
Do You Have a Running Database in Your PC?
00:31
Why to know the Oracle Database Architecture and how much to know?
02:31
Oracle Database Architecture Overview (Part 1)
09:17
Oracle Database Architecture Overview (Part 2)
06:04
Database Data Blocks in Detail
07:57
What is PGA?
05:32
What is Shared Pool?
06:31
What is Buffer Cache?
05:24
What is Redo Log Buffer?
04:18
What is Undo?
03:49
How a DML is processed and committed
04:28
Automatic Memory Management
02:06
Oracle Database Storage Architecture
03:57
Logical and Physical Database Structure
06:13
Quiz - Database Architecture
8 questions

SQL Tuning Basics

15 lectures
When to Tune?
07:40
What is a Bad SQL?
05:08
Effective Schema Design
08:42
Table Partitioning
07:15
How an SQL Statement is Processed?
09:32
Why do we need the Optimizer?
05:41
Optimizer Overview
03:25
Query Transformer
08:44
Selectivity & Cardinality
08:02
What is "cost" in detail?
04:51
Plan Generator
03:56
Row Source Generator
03:38
SQL Tuning Principles and Strategies
08:10
Query Analysis Strategy
12:58
SQL Tuning Basics Assessment Test
12 questions

Execution Plans & Statistics

17 lectures
Execution Plan and Explain Plan in Details
07:24
Generating Statistics (Part 1)
06:16
Generating Statistics (Part 2)
07:15
Generating Statistics (Part 3)
08:50
Generating Statistics (Code Samples)
00:20
Generating Execution Plan
12:06
Generating Execution Plan (Code Samples)
00:09
Autotrace
12:38
Autotrace (Code Samples)
00:09
V$SQL_PLAN View
11:11
V$SQL_PLAN (Code Samples)
00:23
Reading the Execution Plans (Part 1)
13:12
Reading the Execution Plans (Part 2)
10:29
Reading the Execution Plans (Code Samples)
00:07
Analyzing the Execution Plans
08:18
Analyzing the Execution Plans (Code Samples)
00:14
Execution Plans & Statistics
10 questions

Table & Index Access Paths

18 lectures
What are Indexes and How They work in details?
10:51
Types of Table and Index Access Paths
11:59
Table Access Full
08:35
Table Access Full (Code Samples)
00:11
Table Access by ROWID
06:18
Table Access by ROWID (Code Samples)
00:07
Index Unique Scan
04:48
Index Range Scan
10:40
Index Range Scan (Code Samples)
00:30
Index Full Scan
09:34
Index Full Scan (Code Samples)
01:00
Index Fast Full Scan
06:37
Index Fast Full Scan (Code Samples)
00:29
Index Skip Scan
14:14
Index Skip Scan (Code Samples)
00:25
Index Join Scan
05:37
Index Join Scan (Code Samples)
00:12
Table & Index Access Paths
10 questions

Optimizer Hints

5 lectures
What are Hints and Why to Use Them?
04:04
How to use Hints
16:04
How to use Hints (Code Samples)
01:21
List of Some Useful Hints
00:08
Using Hints
5 questions

Join Operations

19 lectures
Join Methods Overview
05:10
Nested Loop Joins
12:09
Nested Loop Join (Code Samples)
00:31
Sort Merge Joins
10:19
Sort Merge Join (Code Samples)
00:24
Hash Joins
11:08
CODE: Hash Joins
00:09
Cartesian Joins
06:28
CODE: Cartesian Joins
00:03
Join Types Overview
03:00
Equijoins & Nonequijoins
03:36
CODE: Equijoins & Nonequijoins
00:06
Outer Joins
11:16
CODE: Outer Joins
00:31
Semijoins
06:00
CODE: Semijoins
00:10
Antijoins
03:26
CODE: Antijoins
00:19
Join Operations
7 questions

Other Optimizer Operators

25 lectures
Result Cache Operator
11:23
CODE: Result Cache Operator
00:18
View Operator
07:29
CODE: View Operator
00:37
Clusters
14:31
CODE: Clusters
00:31
Sort Operators
07:07
CODE: Sort Operators
00:10
INLIST Operator
04:25
CODE: INLIST Operator
00:17
Count Stopkey Operator
03:34
CODE: Count Stopkey Operator
00:06
First Row Operator
05:15
CODE: First Row Operator
00:08
Filter Operator
01:41
CODE: Filter Operator
00:02
Concatenation Operator
03:06
CODE: Concatenation Operator
00:04
UNION Operators
02:54
CODE: Union Operators
00:07
Intersect Operator
05:20
CODE: Intersect Operator
00:18
Minus Operator
01:49
CODE: Minus Operator
00:11
Other Optimizer Operators
5 questions

SQL Tuning Techniques

59 lectures
How to find a performance problem and its tuning solution?
15:05
Ways of Getting the Execution Plan and the Statistics
16:27
Using the Real-Time SQL Monitoring Tool Part 1
10:35
Using the Real-Time SQL Monitoring Tool Part 2
13:55
Using the Real-Time SQL Monitoring Tool Part 3
12:00
CODE: Using the Real-Time SQL Monitoring Tool
00:17
Using the Trace Files & TKPROF Utility - Part 1
15:56
Using the Trace Files & TKPROF Utility - Part 2
20:21
Using the Trace Files & TKPROF Utility - Part 3
10:22
CODE: Using the Trace Files & TKPROF Utility
00:15
Get What You Need Only
07:13
CODE: Get What You Need Only
00:04
Index Usage
16:24
CODE: Index Usage
00:37
Using Concatenation Operator
03:35
CODE: Using Concatenation Operator
00:05
Using Arithmetic Operators
03:15
CODE: Using Arithmetic Operators
00:06
Using Like Conditions
06:43
CODE: Using Like Conditions
00:13
Using Functions on the Indexed Columns
04:52
CODE: Using Functions on the Indexed Columns
00:11
Handling NULL-Based Performance Problems
08:08
CODE: Handling NULL-Based Performance Problems
00:26
Using EXISTS instead of IN Clause
05:02
Using TRUNCATE instead of DELETE command
04:37
CODE: Using TRUNCATE instead of DELETE command
00:06
Data Type Mismatch
05:35
CODE: Data Type Mismatch
00:13
Tuning Ordered Queries
07:09
CODE: Tuning Ordered Queries
00:14
Retrieving the MIN & MAX Values
10:52
CODE: Retrieving the MIN & MAX Values
00:15
UNION and UNION ALL Operators (Which one is faster?)
03:17
UNION and UNION ALL Operators (Which one is faster?)
00:07
Avoid Using the HAVING Clause!
05:22
CODE: Avoid Using the HAVING Clause!
00:11
Be Careful on Views!
10:22
CODE: Be Careful on Views!
00:38
Create Materialized Views
07:26
CODE: Create Materialized Views
00:28
Avoid Commit Too Much or Too Less!
04:36
Partition Pruning
06:10
CODE: Partition Pruning
00:07
Using BULK COLLECT
10:01
CODE: Using BULK COLLECT
01:06
Tuning the Join Order
06:49
CODE: Tuning the Join Order
00:19
Multitable DML Operations
07:19
CODE: Multitable DML Operations
00:51
Using Temporary Tables
07:18
CODE: Using Temporary Tables
00:35
Combining SQL Statements
04:55
CODE: Combining SQL Statements
00:19
Using "WITH" Clause
08:12
CODE: Using WITH Clause
00:59
Using Analytical Functions
04:49
CODE: Using Analytical Functions
00:15
SQL Tuning Techniques
5 questions

Tuning with ADVANCED Indexing Techniques

29 lectures
Why Indexing is Important?
05:27
Index Selectivity & Cardinality
05:31
B-Tree Indexes in Details
12:13
CODE: B-Tree Indexes in Details
00:27
Bitmap Indexes in Details
19:28
CODE: Bitmap Indexes in Details
00:34
Bitmap Operations
07:21
Composite Indexes and Order of Indexed Columns
10:07
CODE: Composite Indexes and Order of Indexed Columns
00:17
Covering Indexes
08:00
CODE: Covering Indexes
00:12
Reverse Key Indexes
03:37
Bitmap Join Indexes
09:53
CODE: Bitmap Join Indexes
00:29
Combining Bitmap Indexes
08:31
CODE: Combining Bitmap Indexes
00:25
Function-Based Indexes
09:19
CODE: Function-Based Indexes
00:20
Index-Organized Tables
16:47
CODE: Index-Organized Tables
00:29
Cluster Indexes
08:30
CODE: Cluster Indexes
00:31
Invisible Indexes
07:31
CODE: Invisible Indexes
00:09
Index Key Compression- Part 1
05:23
Index Key Compression- Part 2
11:13
CODE: Index Key Compression
00:26
Full-Text Searches
20:20
CODE: Full-Text Search Indexes
00:34

Advanced SQL Tuning Techniques

14 lectures
Tuning Star Queries
07:17
CODE: Tuning Star Queries
00:35
Using Bind Variables
08:16
CODE: Using Bind Variables
00:40
Beware of Bind Variable Peeking
05:53
CODE: Beware of Bind Variable Peeking
00:16
Cursor Sharing
14:14
CODE: Cursor Sharing
00:42
Adaptive Cursor Sharing
16:31
CODE: Adaptive Cursor Sharing
00:27
Adaptive Plans
12:43
CODE: Adaptive Plans
00:12
Dynamic Statistics (Dynamic Sampling)
16:07
CODE: Dynamic Statistics (Dynamic Sampling)
00:22

Appendix: Software Installations

18 lectures
About the Database Installation
03:11
The Ways to Get a Database
14:49
Option 1: Installing VMware and VirtualBox on Windows
07:33
Option 1: How to Install the Virtual Box on Mac OS X?
01:51
Option 1: Downloading Virtual Machine Image (19c)
00:42
Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)
04:11
Option 1: Configuring the VMware Virtualization Software
08:18
Option 1: Configuring the Oracle VirtualBox Virtualization Software
06:45
Option 1: Configuring SQL Developer inside of the Virtual Machine
13:02
Option 2: What is Pluggable Database?
03:13
Option 2: Downloading and Installing the Oracle Database
18:18
Option 2: Unlocking the HR Schema
07:34
Option 2: Configuring and Using Oracle SQL Developer
22:14
Option 2: Installing Sample Schemas in Oracle Database
07:44
Extra: 12c Installation
00:55
Option 2: How to Unlock the HR Schema in the Oracle Database 12c?
01:36
Option 2: Oracle Database 12c Installation into Your Computer
09:20
Option 2: Configuring and Using Oracle SQL Developer for Oracle Database 12c
10:12

Bonus

1 lectures
Bonus Lecture
00:30

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Microsoft Excel - Excel from Beginner to Advanced

Microsoft Excel - Excel from Beginner to Advanced

100 VND
50.000 VND
The Complete Oracle SQL Certification Course

The Complete Oracle SQL Certification Course

155 VND
50.000 VND
Microsoft Project for Project Manager & Civil Engineers -MSP

Microsoft Project for Project Manager & Civil Engineers -MSP

55 VND
50.000 VND
Quantity Surveying Building Estimation,Cad Excel & Planswift

Quantity Surveying Building Estimation,Cad Excel & Planswift

1.399.000 VND
50.000 VND
Microsoft Power BI for Construction Management

Microsoft Power BI for Construction Management

55 VND
50.000 VND
SAP ABAP Programming For Beginners - Online Training

SAP ABAP Programming For Beginners - Online Training

90 VND
50.000 VND
SharePoint 2013 Complete Training

SharePoint 2013 Complete Training

1.049.000 VND
50.000 VND
The Complete Google Drive Course - Mastering Google Drive

The Complete Google Drive Course - Mastering Google Drive

1.399.000 VND
50.000 VND
SAP ABAP : Enhancement & Modification to SAP Standard

SAP ABAP : Enhancement & Modification to SAP Standard

25 VND
50.000 VND
SharePoint - Complete Guide to Microsoft SharePoint Online

SharePoint - Complete Guide to Microsoft SharePoint Online

95 VND
50.000 VND
Administration and Automation with Windows PowerShell

Administration and Automation with Windows PowerShell

1.499.000 VND
50.000 VND
Microsoft Project ALL: BEGINNER to EXPERT 10 Projects 9 PDU

Microsoft Project ALL: BEGINNER to EXPERT 10 Projects 9 PDU

99 VND
50.000 VND
SharePoint Content Management and Content Organizer

SharePoint Content Management and Content Organizer

399.000 VND
50.000 VND
Beginner to pro: use Excel like a management consultant

Beginner to pro: use Excel like a management consultant

999.000 VND
50.000 VND
Excel thực chiến - Nâng cao

Excel thực chiến - Nâng cao

1.799.000 VND
50.000 VND
Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel

Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel

899.000 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi