Database - SQL

This course is not focused on C# grammar. It focuses on understanding and creating classes. It covers basic grammar, but it also includes a lot of practical program writing tips because it goes through many examples.

This course is an easy-to-understand explanation of database design theory, focusing on practical exercises. Most people who have experienced it through books, etc. have probably felt that database theory was difficult and given up. I did the same. However, if you know it, you will find that it is an easy and very interesting field. In this course, the design content is organized so that you can understand it just by looking at it.

This course was created for those who find databases challenging, making it easy to understand concepts and build your skills through practice. This lecture covers database fundamentals and SQL language usage. For learning how to create databases, you can take the database design course. Since most program developers encounter databases in their work, I've made an effort to explain in detail how to approach databases from a programmer's perspective.

This is the second lecture following the Database Design Fundamentals course. This is a practical course that focuses on real-world projects from start to finish. After understanding all the lecture content, you will be able to freely design databases.

This course does not teach the grammar of C#. It simply uses C# as a tool for designing object-oriented programs. This course covers in depth the essential content that intermediate and higher level programmers need to know, as well as the content that is essential to developing programs that are linked to databases.

This course is mainly about ADO.NET and will be practiced with WinForms programs using the C# language. In addition, it will explain various fields such as database design, SQL writing, stored procedure writing, and libraries and transactions created with ADO.NET through practical programming through sample projects.

This course is for those who are learning programming for the first time. The lectures are not boring at all. Most of the lectures proceed through examples after a simple explanation.

We would like to provide an opportunity to learn SQL, a language used in relational databases, in general. In particular, we wrote the execution examples in the ORACLE environment. The learning content is largely divided into 2 parts and a total of 11 lectures. After learning the entire content, you can cultivate the ability to perform tasks in a database along with the general knowledge of SQL, and you can also prepare for the nationally certified SQL developer qualification.

You can learn how to handle data frames (tables) using Python, similar to the SELECT statement in SQL.

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

If you want to be recognized as a machine learning expert based on large-scale data, from understanding the core framework of Spark machine learning, to SQL-based data processing through difficult practical problems, to data analysis through business domain analysis, and to the ability to implement optimized machine learning models, please join this course.

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

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 is a code lab-based class where you will directly build a big data system or distributed processing system cluster (HDFS, Zookeeper, Spark, Zeppelin) that guarantees high availability.

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

Make the most of relational database systems!

This course teaches MS-SQL through baseball/company databases.

From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

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 🚀

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!