Easy to Learn Data Modeling: From Basics to Practical Table Design (DASP/DAP)

Through a hands-on curriculum using MariaDB and HeidiSQL, you can learn the core concepts of SQL and how to use it in practice while collecting, preprocessing, and analyzing data.

I have created a course titled 'Introduction to MySQL Performance Optimization & Practice (SQL Tuning Edition)' that is easy for non-majors to understand and can be applied immediately in practice!

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.

Learn how to model data in a distributed database environment.

mongoDB, NoSQL You hear a lot these days, but is it still an unfamiliar database? Aren't you using it like a relational database (RDS/SQL)? No matter how good the technology is, if it's not used correctly, it will have the opposite effect. That's why we often see cases of failure in using MongoDB. This lecture will teach you everything from basic concepts to practical know-how so that you can use MongoDB as MongoDB-like as possible.

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

This course was created based on my personal experience passing the very first revised Information Processing Engineer practical exam, which had a pass rate of only 5.34%. The Information Processing Engineer practical exam can no longer be prepared for through simple memorization alone. In particular, the ability to read the execution flow of C, Java, Python, and SQL code to track results, as well as the ability to accurately distinguish short-answer concepts and write them as answers, has become crucial. This course is structured to help even beginners who are new to programming follow along step-by-step, covering everything from creating variable tables to tracking C, Java, Python, and SQL code, core practical terminology, and written exam subjects 1 through 5. Rather than being a video-centered course, this is a text-based course designed for fast reading and repeated review. It makes it easy to look up necessary parts again and focuses on practicing how to derive answers at the testing center by following the code and explanations directly. The 1st update covers the practical programming sections: C, Java, Python, and SQL. The 2nd update will organize core terms and concepts required for the short-answer practical questions and provide a "Stepper Simulator" to practice code tracking directly. The 3rd update will sequentially expand to cover written exam subjects 1 through 5. The Stepper Simulator is designed so that you don't just stop at reading explanations; you can understand how variable values change as the code executes line by line by following along yourself. If you have any questions while taking the course, please leave them in the Q&A. I will respond as quickly as possible to ensure your learning doesn't get stuck.

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

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

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.

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 🚀

For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

Channel Talk interviewers will directly analyze the difference between failing and passing answers to the same questions, and help you prepare for actual follow-up questions.

Does game backend development feel vaguely difficult? Based on know-how gained from numerous hands-on projects, I will show you how to perfectly integrate complex Firebase features into an actual game. We will connect Firebase to a Unity 6 "Suika Game" to implement online features such as login, Cloud Database (Firestore) save/load, rankings, message boards, and mailboxes. This is a practical course that covers everything from security rules and Remote Config operations to code separation for each feature.

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

This is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

Learning by Doing: 정보처리산업기사 I have prepared everything for passing the 정보처리산업기사 course-evaluation practical exam.

Learn common components of global-scale services through popular papers, books, and articles.