
Oracle SQL Beginner's Course
JeongTaeHyun
This is an Oracle DBMS SQL course for beginners.
Beginner
SQL, Oracle, DBMS/RDBMS
In this lecture, you will learn the basic terms and principles of query tuning for MySQL/MariaDB, and then improve your tuning skills by analyzing dozens of malicious queries.
227 learners
Level Basic
Course period 12 months


Reviews from Early Learners
5.0
리나
I think it's really great that you explained in an easy-to-understand way how to optimize the index search. The only thing I'm disappointed about is that the course duration is 12 months 😭,😭 I wish you could let me take the course for life even if I have to pay more. :)
5.0
우디
I read the book well, so I bought the lecture. Thank you for making a good book. I am watching the lecture.
5.0
이재호
Thank you.
How to write queries in RDBMS
Query Optimization (Tuning) in MySQL/MariaDB
Terminology and knowledge about query tuning
For those who are new to query tuning or are unsure how to tune (optimize) slow SQL, we share knowledge and know-how that will help you take the next step forward.
Anyone can easily start tuning SQL as long as they can write SQL statements.
After understanding the basic principles and terminology, take it to the next level with some common bad SQL statements you see in the field.
Improve your basic skills with learning content directly taught by the author of the book, "SQL Tuning for Work"!
Difficult IT terms can be understood through everyday vocabulary. Using everyday analogies and easy-to-understand examples, query tuning becomes less of a barrier to entry.
Example) Similarity between navigation and optimizer makes it easy to understand the optimizer, the brain of the DB.
Navigation vs. DB Optimizer
After learning about tuning, we will tune dozens of problematic queries that are frequently seen in the field.
Let's take some time to think together about where and how to start and what to think about.
Tuning queries together
Operating System and Version (OS): Windows
Target DBMS: MySQL
Practice Area: Query Tuning for SQL Targets
Other: Guides for other OSes, including Mac, and MariaDB, similar to MySQL.
Those who can write SQL can take the course smoothly.
Practice materials are shared through GitHub.
Providing raw data and ERD for performing the main curriculum, individual difficulty levels, and practical exercises through Git.
Provides all practical SQL included in the course content
Who is this course right for?
For those who are just starting out with SQL tuning
For those who want to transform slow queries into fast queries
For those who want to determine whether the query I wrote is fast or slow
Need to know before starting?
SQL
227
Learners
36
Reviews
4.9
Rating
1
Course
A guider who explains complex IT in simple terms.
National-level exam question developer, grader, and reviewer
Author of 3 IT-related books and contributor of various published articles
15 years of experience in the IT industry
All
57 lectures ∙ (7hr 11min)
1. 0-1. Greetings
02:43
All
36 reviews
4.9
36 reviews
Reviews 3
∙
Average Rating 4.3
Reviews 7
∙
Average Rating 5.0
5
I think it's really great that you explained in an easy-to-understand way how to optimize the index search. The only thing I'm disappointed about is that the course duration is 12 months 😭,😭 I wish you could let me take the course for life even if I have to pay more. :)
I am even more grateful that it helped you understand. I will try harder to make it a useful lecture. :)
Reviews 5
∙
Average Rating 5.0
Reviews 5
∙
Average Rating 5.0
Explore other courses in the same field!