통계 분석 마스터 클래스
Masocampus
이제 경험보다는 데이터를 기반으로 대답할 때! 통계 지식으로 신뢰성을 수치화하여 근거로 제시한다면 여러분의 설득력은 무한대로 UP!
Basic
통계
SQL that makes it easy to learn the core
Skip the complicated theories and concepts and just write SQL statements, practice, and follow along!
What you will learn!
Basic concepts of databases and schemas
General theory and format of SQL
Build SQL skills by using various functions
Practical SQL application skills using AI
Quickly learn SQL essential grammar + core competencies 💯
SQL for databases,
Let's use only the key points quickly and easily!
Maso Campus' "SQL: Easy to Learn with Only the Essentials" course will help you develop the following skills:
A concept you absolutely cannot avoid if you learn SQL!
We will briefly explain key terms and concepts such as DB and schema, table, key, DBMS, and relationship, and learn about the types and licenses of DBML (Database Markup Language).
We'll walk you through the entire process, from downloading to setting up, in the simplest and most user-friendly way possible, so you can freely install MySQL 8.0 Community Edition, an essential tool for SQL practice, whenever you need it.
Let's upload the Excel file to the DB server!
The primary purpose of SQL is to freely extract desired data from a database. After a brief and quick theoretical overview of creating schemas and tables and individually entering, deleting, and modifying data, we'll walk through the process of uploading 3,000 customer records and 25,000 sales records from an Excel file to a database server.
You can always use real data that fits your situation in the same way in your work.
Let's learn and use the core grammar of SQL!
Covers the core syntax of SQL for extracting, selecting, and applying various conditions to the data you want.
We will teach you only the essential information for practical work, such as setting conditions, aggregating, and limiting data, focusing on SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT.
Complex conditions at once with subqueries + joins !
SQL statements within SQL statements? We'll explore combining multiple tables into one, including subqueries that insert queries within queries and inner joins that combine multiple data sets, and output complex conditional statements.
At this time, we will look at various common mistakes that everyone makes and learn together what to keep in mind in practice.
Features of this lecture
Check it out.
💡 By diligently completing this course, you'll master essential SQL syntax and gain the practical skills to extract and organize data from your company's database. Furthermore, at the end of the course, we'll introduce tips for better SQL proficiency, leveraging AI services to help you understand SQL in more depth, optimize SQL performance for big data, and more, tailored to your individual needs.
STEP 1. Is SQL very different from Excel?
No! SQL allows you to quickly and easily create repetitive tasks in Excel through queries. Even with large amounts of data, it leverages a database, allowing you to quickly extract only the data you need. We'll explain the core concepts and operating principles of SQL step by step. As you listen, you'll be captivated by the ease of SQL, which is even easier than Excel.
STEP 2. Upload the file to the DB and extract only the data I want!
If you've ever wanted to extract just the data you need in Excel, whether for work or in your daily life, but found it tiresome or inconvenient to create pivot tables and filters every time, try SQL! Using the core syntax we'll use repeatedly in this course, you can quickly and easily extract just the data you need.
STEP 3. When you need to create a query with complex conditions but can't think of a solution, use AI!
If someone asked you, "I'm a woman in my 30s living in Seoul, interested in data analysis, and taking a Maso Campus course, write a query!" wouldn't you feel overwhelmed? Then ask AI! Have you heard of the hot new ChatGPT? ChatGPT lets you easily create even difficult query syntax.
After listening to all the lectures
You can acquire these capabilities.
After taking the "SQL: Easy to Understand the Essentials" course, you will gain the following capabilities:
- ✅ Understand key terms and operating principles to properly utilize SQL
- ✅ Ability to upload files to the DB and extract data
- ✅ The ability to find insights from large amounts of data
- ✅ Develop practical skills by utilizing various conditions and aggregations.
From database definitions and terminology to core usage techniques, we'll provide you with the essential SQL knowledge you need . Master this course, fully utilize SQL, and become a professional SQL user!
Easily create SQL queries with AI
Q&A 💬
Q. Is prior knowledge of SQL required?
No, you don't need any prior knowledge of SQL. The instructor will guide you through everything from basic database understanding to SQL installation and hands-on practice, so don't worry.
Q. Are there any requirements or prerequisites for taking the course?
Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens. Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course in a Windows environment.
💾 Please check before taking the class!
- Since this is a practice-oriented lecture, it would be a good idea to prepare a dual monitor or extra device that can separate the lecture and practice screens.
- Since the training is conducted based on Windows OS , we recommend taking the course in a Windows environment.
- Lecture notes and practice files are attached to the <0. Textbook Download Center> section.
Recommended for
these people
Who is this course right for?
For those interested in data and data analysis
For those who want to analyze data using tools other than Excel
For those who want to learn and master the basics of SQL, starting from databases.
For those who want to write SQL statements directly and extract only the data they need
7,026
Learners
857
Reviews
96
Answers
4.7
Rating
85
Courses
"어제보다 성장하겠습니다. 그리고, 어제보다 성장하려는 사람을 돕겠습니다."
마소캠퍼스의 진심과 소망을 담은 Actionable Content로,
2013년부터 온오프라인으로 함께해 온 누적 강의 1억시간!
이 소중한 경험과 시간은 언제나 마소캠퍼스와 수강생 모두의 성장의 원천입니다.
마소캠퍼스 팀은 우리의 모두의 성장을 위해 두 가지 원칙을 반드시 지킵니다.
1. 배우면 반드시 쓸 수 있는 Actionable Content
2. 참여자의 시간과 수고를 존중하는 Time-Saving Curriculum
마소캠퍼스의 Actionable and Time-Saving Curriculum으로 성장의 길을 함께 걸어나가길 기원합니다.
Curriculum
All
15 lectures ∙ (5hr 30min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
1 reviews
$26.40
Masocampus's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![자바의 정석부터 Oracle sql까지 완전정복 부트캠프 [Full vers.]Course Thumbnail](https://cdn.inflearn.com/public/files/courses/336223/cover/01k2j32xzj93q4a4mhs8ra9q4b?f=avif&w=420)
![[2025] 비전공자도 한 번에 합격하는 SQLD 올인원Course Thumbnail](https://cdn.inflearn.com/public/files/courses/336953/cover/01jr02gfpt2km3k50amyw7sttt?f=avif&w=420)
![[C#과 유니티로 만드는 MMORPG 게임 개발 시리즈] Part5: 데이터베이스Course Thumbnail](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
