SQL Analysis Verified with AI and Excel Dashboard

Master intermediate-to-advanced SQL and build solid SQL data analysis skills by solving 101 real-world data analysis problems together.

A lecture taught directly by the author of the book "SQL 200," published by Jungbo Munhwasa! Over the years, numerous data analysts have empowered their data retrieval skills through instructor Yeon-soo Yoo's SQL lectures.

Inflearn's SQL intermediate course by Datarian, with over 30,000 cumulative students and extensive online/offline teaching experience. Learn intermediate SQL theory and solve 20 practice problems together.

Learn how to aggregate and analyze data using PivotTables in Excel 2016.

You can learn various ways to use Excel to adjust, clean, and collate data brought in from outside, as well as how to extract, separate, and transform data from a single cell.

Skip the complex theories and concepts, and jump right into writing, practicing, and following along with SQL syntax!

By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.

This course provides 100% hands-on experience by explaining which functions and features of Excel can be used to solve tasks most quickly and efficiently in these cases through examples used in actual workplaces.

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.

Analyzing customers, markets, and revenue patterns—you no longer need to learn it yourself. Just ask AI, and expert-level analysis and strategies are completed in an instant!

Artificial Intelligence is transforming the way professionals work with data. Microsoft Copilot in Excel allows you to analyze, clean, format, automate, and optimize spreadsheets faster than ever before. But using Copilot effectively requires more than just typing prompts — it requires understanding Excel fundamentals, structured thinking, and prompt engineering. This course gives you exactly that. You will learn how to combine Excel expertise with AI-powered automation to dramatically improve productivity, accuracy, and workflow efficiency. What You Will Gain From This Course • Save hours every week using AI-driven Excel automation • Analyze large datasets in seconds using Copilot • Clean and fix messy data effortlessly • Write powerful formulas with AI assistance • Master prompt engineering for Excel Copilot • Build professional reports and dashboards faster • Improve decision-making with AI-powered insights • Optimize workflows for real-world business scenarios By the end of this course, you will not just “use” Copilot — you will control it. What This Course Covers Foundations What is Microsoft Copilot How to activate and use Copilot in Excel Introduction to Excel basics and navigation Data types and conversions Data entry and validation techniques Excel Core Skills Mathematical, logical, and time functions Nested functions for complex calculations Combining logical and LOOKUP functions Conditional statements and formatting Pivot tables and advanced formatting Data Analysis with Copilot Data general analysis and Q&A Sorting, filtering, and profiling data Handling and fixing missing data Identifying and correcting common data errors Transposing data for trend analysis Date-time formatting techniques AI-Powered Excel Automation Generating synthetic data Adding formula columns with Copilot Subtotals and advanced calculations Optimizing workflows using Copilot Enhancing data presentation Editing spreadsheets intelligently Prompt Engineering for Excel Copilot Writing effective prompts Advanced prompt engineering techniques Evaluating prompt performance Optimizing prompts for better results Customizing Copilot for improved outcomes Real-World Application Creating a travel budget using Copilot Practical exercises and activities Performance evaluation and improvement strategies Why This Course Is Different Most Excel courses teach formulas. Most AI courses teach theory. This course bridges both. You will learn Excel fundamentals and advanced skills alongside AI-powered Copilot usage. That combination makes you significantly more productive than someone who only knows Excel or only knows AI prompts. This course is structured for clarity, practical application, and real-world efficiency. Who This Course Is For • Business professionals who work with Excel daily • Data analysts and aspiring analysts • Managers who want faster reporting • Students preparing for corporate roles • Entrepreneurs handling business data • Anyone who wants to leverage AI inside Excel No prior AI experience is required. Excel basics are covered before advancing into automation and Copilot optimization. Why You Should Enroll Today Microsoft Copilot is becoming a core productivity tool across organizations. Professionals who understand how to use AI effectively inside Excel will have a measurable competitive advantage. Instead of spending hours writing formulas, cleaning data, or building reports manually, you will learn how to work smarter. If you want to future-proof your Excel skills and become significantly more efficient with data, this course is for you. Enroll now and master Microsoft Copilot in Excel with confidence.

Put an end to daunting data analysis with ‘Exploratory Visualization’! Drastically increase the speed of practical analysis without difficult coding.

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

Data Analysis that Determines Online MD Performance! Learn essential data analysis and strategy formulation techniques necessary for MDs to maximize sales and profit in the e-commerce market.

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

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.

"SQLD is an exam where past questions are not officially released." Preparing for the upcoming 60th exam (2026.3.7)— Practical study material featuring 50 vividly reconstructed questions by subject and chapter, based on the latest 59th exam!

This course aims to obtain the state-certified SQLD (SQL Developer) certification. An SQLD refers to a developer who can write accurate SQL to manipulate and extract data while developing application software based on knowledge of databases and data modeling.

Let's understand data analysis tailored for advanced retail businesses and learn how to use the tools utilized in the industry!