BigQuery(SQL) 活用編(ファネル分析、リテンション分析)

This is a course for PMs who want to utilize data. This course covers the entire process of utilizing data in the PM role, including the flow of work from day 1 of a job change through the start and end of a project. It is an introductory data course that covers data-driven thinking, logical thinking, metric definition, log design, experiment design, creating a data culture, and more, to help you develop critical thinking skills. Although created as a course for PMs, it is structured with content that data analysts would also find beneficial (in fact, many analysts have taken the course). In addition, many people in marketing, design, and business planning roles are also taking the course.

This is a lecture for those who want to consistently write a technical blog. Starting is easy, but trying to do it consistently leads to many trials and errors. This lecture compiles what I've tried and the know-how gained from operating a technical blog for over 7 years. It contains all my 7 years of experience, including SEO, technical blog writing strategies, writing process, etc.

This is an introductory BigQuery (SQL) course for beginners. Recommended for those curious about data processing methods. We teach SQL from a data analysis and data engineering perspective rather than a backend development perspective.

Make the most of relational database systems!

Datalian's SQL basics lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn SQL basics theory and solve 10 HackerRank problems together.

This is an introductory BigQuery (SQL) course for beginners. Recommended for those curious about data processing methods. We teach SQL from a data analysis and data engineering perspective rather than a backend development perspective.

Skip the complicated theories and concepts and just write SQL statements, practice, and follow along!

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.

Through detailed lectures and hands-on practice on the core elements of SQL, we will provide you with a solid foundation to grow into a SQL analysis expert.

This is an introductory lecture on the most famous data analysis tool, GA4. This is a practical GA4 course prepared by a current marketer with over 10 years of marketing experience in Korea and abroad. It is a practical lecture that will help anyone from aspiring marketers who dream of becoming (digital) marketers to current business owners and those interested in data analysis to take this lecture and apply it to real-world situations right away.

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

Learn various features of Looker Studio (formerly Google Data Studio) using GA4 demo data. This includes explanations and hands-on practice with Looker Studio's visualization elements. In particular, marketers and planners who are not familiar with SQL can learn easy ways to integrate and use BigQuery data with Looker Studio. You can learn methods to create dashboards using Looker Studio.

"A course that allows you to build essential data analysis capabilities for marketers at once through Google Analytics! Let's learn the core functions of GA4, the latest version of Google Analytics!"

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

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

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

In this lecture, we will implement various server systems such as chat, party, trade, guild, ranking, and auction house step-by-step using Photon and Firestore.

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!

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

Supabase: Giving Wings to Full-stack Development! Through 3 clone projects, you will quickly learn how to build practical-level full-stack applications using Next.js 14 and Supabase.

This course aims to acquire the state-authorized SQLD certification. SQLD refers to a developer who, based on database and data modeling knowledge, can write accurate SQL for manipulating and extracting data while developing application software.

The basic steps to learn SQL injection attacks, the flower of web hacking! This is a lecture on basic SQL grammar!