Check out what classmates have to say!
From SQL basics to practical skills and SQLD certification for non-majors!
What happens when you don't know SQL
โI need to make reports and meeting materials...โ
โI want to pick the top 5 monthly sales trends for this year...โ
โWhat do customers who bought two or more of our products usually buy?โ
๐ When that happens, how do you deal with it?
- Send a work request email to the IT department.
- Don't hesitate to wait until the data comes in.
- After a long wait, I finally got a reply! Open the data received in Excel.
- Ah.. This isn't the data I wanted!!!
- Back to number 1... (infinite repetition)
๐ What if I could handle data directly with SQL in this vicious cycle?!
Actually clear 'question'If only, there is no data that cannot be extracted with SQL. Most of the data required for this kind of work is stored in the company DB. All you need to do is pull it out of that DB and use it, but it's frustrating not knowing how to do that.
What you need at this point is SQL. Knowing how to use SQL means being able to write company reports and meeting materials based on in-house data. And even if it's not necessarily for reporting purposes, I can always pull out the data when I need it and in the desired form and use it for work.
Now, without further delay, it's time to develop data competency through SQL.
The ability companies want, SQL!
๐ SQL empowers my opinions, planning, and rationale.
Being able to handle SQL means being able to freely use a lot of data stored in the DB for work. You'll be able to find supporting data to support your claims, or verify flashy ideas with data.
In the past, Excel was sufficient, and the ability to use Excel was important when getting a job, but nowadays, SQL ability to directly extract and process data required for work is required for more accurate decision-making.
โถ ๏ธ Dealing with data is now a requirement rather than an option for everyone.
In fact, existing large companies and midsize companies *Digital transformationAs this accelerates, it is now easy to see job postings that favor SQL in most departments and occupations (planning, marketing, sales, business management, service operations, management support, etc.).
[โ Explanation of terms]
*Digital transformation (abbreviated as DT or DX): In order for companies to create new business models, products, and services By harnessing digital capabilities An ongoing process of adapting to or driving disruptive changes in customers and markets.
SQL, I recommend it to people like this.
โถ ๏ธ Can people who don't know about coding or programming learn SQL?
- Beginners who are learning SQL for the first time, or beginners who have trouble using SQL should listen to it. For those who are learning SQL for the first time, I will gradually explain everything from very basic content to advanced grammar and usage.
- It's a great class for non-IT majors to take. In fact, more than 90% of people who come to take my offline classes are non-majors. Even if you have never learned coding or programming separately, if you have a little experience dealing with Excel, you can fully follow the lessons.
- It's not just about learning SQL syntax, I also recommend it to current employees who want to learn practical skills using SQL together. Even now, I use SQL every day in my work, and I am reviewing various SQL types. Therefore, in the class, I will also point out practical usage tips and frequently made mistakes when writing SQL.
- It can also be of great help to DB professionals, students wishing to have a career in data analysis, and students preparing to obtain SQLD qualifications. Since everything from beginner to advanced is covered as an all-in-one class, it is a great class where you can prepare for a certificate naturally if you take the course properly.
These are handwritten reviews from offline course students!
๐ The most common reviews say it was optimized for getting started.
But when it comes to missing practice, that's definitely not the case. Working principles, concepts, rich examples, A to Z curriculum, etc.. Get to know SQL through proven courses.
The advantages of consultant Kim Gyung-soo's SQL practical class!
๐ To make it easier for non-majors, but full of content, to be applied to practice.
- Organize unfamiliar terms in a presentable manner and understand them as examples.
- You can solve SQL from basic to intermediate to advanced in one shot.
- It is not just a line reading, but a schematic explanation of how the actual data is processed.
- In addition to following the SQL syntax, it also fosters the ability to write SQL directly.
- We provide hands-on materials so that you can directly understand data requirements and write SQL.
- Learn about common mistakes in practice in advance to reduce trial and error and develop practical skills.
Like this How to understand and address data requirements yourselfIt was configured as. You will gain real skills while taking classes, and your career will upgrade to a level where you can put your skills to work after being stubborn.
I'm Kim Gyung-soo, a consultant who will teach me SQL.
๐ Currently, I use SQL in my practice, review, and guide every day!
I am interested in various industries and fields of knowledge related to data, and I like to acquire and spread practical knowledge that can be used directly in practice.
๐จ๐ปโ๐ Experience and qualifications
- National Accredited SQLP and DAP Qualification Test Advisors
- <National Certified SQLD Qualification Test Key Notes>Co-author
- <SQL Expert Guide (2020 Revision) > Co-author
- Current Data Consulting Company Responsible Consultant
- Former IT team leader for an education startup
- Former DBA of a major IT company in Korea
- Former data consulting firm consultant
- 6th SQL Developer (SQLD) Qualification Acquired (Passed the first level)
- 9th SQL Professional (SQLP) Qualification Acquisition (Senior Passed)
- Acquired the 29th Data Architecture Professional (DAP) certification
๐ Major lecture history
- Running Spoons SQL Course for Using Business Data (2018~present)
- Foreign Global Company P Company Management Information Team SQL Lecture (2019)
- SQL optimization lecture for developers of Company M, a major domestic financial company (2018)
- SQL lecture for all new employees of Company G, a major company in the domestic retail industry (2018)
- Special Lecture on SQL for Undergraduate Students in the Department of Information Protection at Baehwa Women's University (2017-2018)
- In-house SQL training for new employees of large IT companies in Korea (2017)
- Korea Data Industry Promotion Agency Special Lecture on SQLD Qualification Test for University Students (2016)
- Gyeonggi-do Big Data Professional Training Course SQL, PL/SQL Lecture (2015)
The last SQL lesson for those who gave up trying to learn SQL,
Meet us at Class101 SQL!
๐ You know the data of what you do best.
Because This is because the people in that department know the meaning and characteristics of data best. I don't know what data I want to see, so if you only know how to handle SQL, it's much easier to extract it yourself.
The moment you have already made a request to someone, the chance that the desired data will be selected decreases. The moment you analyze inaccurate data instead of the data you want, the probability that your decision will go wrong increases.
Since I have given lectures to many non-majors so far, I can teach you SQL in an easier way for non-majors to understand than any other lecturer.
I'll give you a solid foundation so that you can study SQL on your own and use it in your work even after the class is over!
SQL (Structured Query Language).
The moment you know the meaning contained in the data, it becomes a very powerful tool.
If students and practitioners learn how to use tools that can handle data well,
I am sure that the improvement in work efficiency and career will be beyond your imagination.
We'll see you in class!
๐ 1:1 SQL coaching with consultant Kim Gyung-soo! (2 times)
- You can ask a total of 2 questions per coaching ticket.
- For each question, we will write an answer of around 250 characters and send it to you.
- First, after solving the practical problems, you can get feedback and corrections on the SQL you wrote yourself. (Recommended)
- Second, you can use it if you need additional explanations related to the course content.
- Third, you can ask questions about problems or questions that arise when applying SQL to actual work.
- Fourth, we will provide detailed coaching on learning methods for obtaining SQLD qualifications, preparing for the certification, and questions that arise during the course of study.
- For other class-related questions, we will wholeheartedly coach you within the limits of your answers.
- Coaching is answered sequentially by the borrower based on the date the questions were received. This may take at least 7 to 10 days.
- The coaching ticket can be used for 20 weeks from the date of purchase.
- If not used within the period, no refund will be given.
๐ฉ The kit is subject to some changes, and we will be fully informed if there are any changes.
Curriculum
Creator
Kyungsoo Kim
Nice to meet you, I'm a SQL expert and consultant Kim Gyung-soo.
๐จ๐ปโ๐ Experience and qualifications
- National Accredited SQLP and DAP Qualification Test Advisors
- <National Certified SQLD Qualification Test Key Notes>Co-author
- <SQL Expert Guide (2020 Revision) > Co-author
- Current Data Consulting Company Responsible Consultant
- Former IT team leader for an education startup
- Former DBA of a major IT company in Korea
- Former data consulting firm consultant
- 6th SQL Developer (SQLD) Qualification Acquired (Passed the first level)
- 9th SQL Professional (SQLP) Qualification Acquisition (Senior Passed)
- Acquired the 29th Data Architecture Professional (DAP) certification
๐ Major lecture history
- Running Spoons SQL Course for Using Business Data (2018~present)
- Foreign Global Company P Company Management Information Team SQL Lecture (2019)
- SQL optimization lecture for developers of Company M, a major domestic financial company (2018)
- SQL lecture for all new employees of Company G, a major company in the domestic retail industry (2018)
- Special Lecture on SQL for Undergraduate Students in the Department of Information Protection at Baehwa Women's University (2017-2018)
- In-house SQL training for new employees of large IT companies in Korea (2017)
- Korea Data Industry Promotion Agency Special Lecture on SQLD Qualification Test for University Students (2016)
- Gyeonggi-do Big Data Professional Training Course SQL, PL/SQL Lecture (2015)
SQL, it's important to learn it properly.
Of course, it's a good thing that SQL is widely used, but there are some things to be aware of. If you tinker with SQL and use it incorrectly, you may unknowingly derive incorrect data values, and even make decisions based on incorrect data if someone doesn't point them out. That's why it's really important to learn and use it properly when you first learn!
I'll definitely let you know the know-how I've taught so far.
Since I have given lectures to many non-majors so far, I can teach you SQL in an easier way for non-majors to understand than anyone else.
On the other hand, no matter how good the content of the class is, it doesn't mean anything if you can't use it in practice after the class is over, right? Because in my class, I only tell you what you really use in practice and what is essential We'll help you apply what you've learned to your work right away.
Thank you:)
