Oracle SQL Database

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.

A lecture directly taught by the author of the SQL 200 Questions book (PL/SQL) published by Jeongbo Munhwasa! This is a PL/SQL lecture by Oracle instructor Yoo Yeon-soo, who has trained numerous DBAs and PL/SQL developers. After taking this course, you will clearly feel the difference between before and after using PL/SQL.

Easy explanations and examples are provided so that you can apply them directly to your work.

You will be able to extract the data you want directly without the help of a developer. We will comfortably cover everything needed for analysis, from simple queries to joins. Start learning SQL with a lecture directly from the author of the book <SQL for Product Managers>.

Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

Make the most of relational database systems!

This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

This is a course for learning MS-SQL through baseball and corporate databases.

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.