ChatGPT 고급 활용법 – 남들보다 100배 더 잘 쓰는 ChatGPT 비법 클래스
Masocampus
AI는 사람을 대체하지는 못할 것입니다. 하지만 ‘AI를 활용하는 당신’이 활용하지 못하는 모든 사람을 대체할 것입니다.
입문
ChatGPT, 인공지능(AI), 프롬프트엔지니어링
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
SQL essential grammar + core competencies only quickly 💯
SQL for databases,
Let's use only the key points quickly and easily!
In Maso Campus ' "SQL: Easily Acquire Only the Core", you can develop the following capabilities:
A concept you absolutely cannot avoid if you learn SQL!
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 will guide you through the entire process from downloading to setting up MySQL 8.0 Community Edition, an essential tool for SQL practice, in the simplest and most user-friendly way possible so that you can freely install it whenever you need it.
Let's upload the Excel file to the DB server!
The main purpose of SQL is to freely extract desired data from the database. After a simple and quick look at the theoretical explanation of creating a schema and table and individually entering, deleting, and modifying data, we will follow the process of uploading 3,000 customer information and 25,000 sales information in an Excel file to the DB server.
Real data that fits each situation can be used in practice at any time in the same way.
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 content for actual work, such as setting conditions on data, aggregating, and limiting, 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 will combine multiple tables into one, output complex conditional statements, and insert subqueries that insert queries within queries and inner joins that combine multiple data into one.
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 course
Check it out.
💡 If you take this course step by step, you will learn the essential SQL grammar and have sufficient practical skills to extract and organize the desired data from the company database. In addition, at the end of the course, we will introduce tips to better handle SQL using AI services so that each student can understand in-depth SQL utilization, how to optimize SQL performance to handle big data, and more, according to their individual situations.
STEP 1. Is SQL very different from Excel?
No! SQL can easily and quickly create repetitive tasks in Excel through queries, and even if there is a large amount of data, it can quickly extract only the data you need because it utilizes a database. I will explain the core concepts and operating principles of SQL step by step. As you listen, you will be completely captivated by the charm of SQL, which is easier than Excel.
STEP 2. Upload the file to the DB and get only the data I want!
If you ever wanted to extract only the data you need in Excel for work or daily life, but you were tired or annoyed by having to create pivot tables and filters every time, try using SQL! You can easily and quickly extract only the data you want with the core grammar that will be used repeatedly in the lecture.
STEP 3. When you need to create a query with complex conditions but can't think of a solution, use AI!
If you were told, "I live in Seoul, I'm a woman in my 30s, I'm interested in data analysis, and I'm taking a Maso Campus class. Please write a query!" Wouldn't you feel lost? Then ask AI! Have you heard of Cha GPT, which is so hot these days? With ChatGPT, you can easily create difficult query syntax.
After listening to all the lectures
You can acquire these capabilities.
After taking the course “SQL: Easily Acquire Only the Core” , you will be able to acquire the following capabilities:
- ✅ Understand key terms and operating principles to properly utilize SQL
- ✅ Ability to upload files to DB and extract data
- ✅ Ability to find insights from large amounts of data
- ✅ Securing practical capabilities by utilizing various conditions and aggregations
From the definition and terminology of databases to core usage methods, we will teach you all the essential information about SQL . Master this course and become a professional who uses SQL in earnest!
Make SQL queries easy with AI
Q&A 💬
Q. Is prior knowledge of SQL required?
No, you don't need to have any prior knowledge of SQL. The instructor has structured the course so that you can get a feel for SQL, from basic understanding of DB to SQL installation and practice, so don't worry.
Q. Are there any requirements or prerequisites for taking the course?
Since this is a hands-on lecture, it would be a good idea to prepare a dual monitor or extra device that can separate the lecture screen and the hands-on screen. Also, since the hands-on training will be conducted based on Windows OS, we recommend taking the lecture in a Windows environment.
💾 Please check before taking the class!
- Since this is a hands-on lecture, it would be a good idea to prepare a dual monitor or an extra device that can separate the lecture and practice screens.
- Since the training will be 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
6,272
Students
709
Reviews
80
Answers
4.7
Rating
83
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
masocampus's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[ITⓔ코칭] Oracle로 배우는 실전 데이터관리강의 썸네일](https://cdn.inflearn.com/public/courses/327587/cover/8133dede-51cb-4410-949c-cd95aa80b7d6/327587-eng-original.jpg?f=avif&w=420)
![[2025] 비전공자도 한 번에 합격하는 SQLD 올인원강의 썸네일](https://cdn.inflearn.com/public/files/courses/336953/cover/01jr02gfpt2km3k50amyw7sttt?f=avif&w=420)
![[C#과 유니티로 만드는 MMORPG 게임 개발 시리즈] Part5: 데이터베이스강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
![[2025] SQLD 문제가 어려운 당신을 위한 노랭이 176 문제 풀이강의 썸네일](https://cdn.inflearn.com/public/files/courses/336270/cover/01jr03fxecqc2z7spwsjxhpc80?f=avif&w=420)
