Oracle SQL Performance Tuning Masterclass [5/2023, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Oracle SQL Performance Tuning Masterclass (2025)

Год выпуска: 5/2023
Производитель: Udemy
Сайт производителя: https://www.udemy.com/course/sql-performance-tuning-masterclass/
Автор: Database Masters Training, Code Star Academy
Продолжительность: 20h 8m 45s
Тип раздаваемого материала: Видеоурок
Язык: Английский
Субититры: Английский
Описание:

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!
[spoiler="What you'll learn"]
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!
[/spoiler]
Requirements SQL Knowledge
Basic PL/SQL Knowledge Description

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!

Who this course is for: SQL Developers
Data Analysts
Data Scientists
PL/SQL Developers
Oracle DBAs
Oracle BI Developers Формат видео: MP4
Видео: avc, 1280x720, 16:9, 30.000 к/с, 455 кб/с
Аудио: aac lc sbr, 44.1 кгц, 62.8 кб/с, 2 аудио
[spoiler="MediaInfo"]
General
Complete name : D:\2\Udemy - Oracle SQL Performance Tuning Masterclass (2025) (5.2023)\05 - Execution Plans & Statistics\002 Generating Statistics (Part 1).mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 23.5 MiB
Duration : 6 min 17 s
Overall bit rate : 524 kb/s
Frame rate : 30.000 FPS
Movie name : 002 Generating Statistics (Part 1)

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : [email protected]
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, Reference frames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 6 min 16 s
Bit rate : 455 kb/s
Nominal bit rate : 600 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.016
Stream size : 20.4 MiB (87%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=600 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=600 / vbv_bufsize=1200 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Codec configuration box : avcC

Audio
ID : 2
Format : AAC LC SBR
Format/Info : Advanced Audio Codec Low Complexity with Spectral Band Replication
Commercial name : HE-AAC
Format settings : Explicit
Codec ID : mp4a-40-2
Duration : 6 min 17 s
Bit rate mode : Constant
Bit rate : 62.8 kb/s
Channel(s) : 2 channels
Channel layout : L R
Sampling rate : 44.1 kHz
Frame rate : 21.533 FPS (2048 SPF)
Compression mode : Lossy
Stream size : 2.82 MiB (12%)
Default : Yes
Alternate group : 1
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]