![[Spring Batch Introduction] Learning the core of Spring Batch through examples講義サムネイル](https://cdn.inflearn.com/public/courses/328680/cover/11f45144-5848-4365-8de8-d8054dbebddd/대지)
[Spring Batch Introduction] Learning the core of Spring Batch through examples
mjcoding
Learn the core concepts and use Spring Batch right away! Lower the barrier to entry to Spring Batch and use Spring Batch directly.
初級
Spring Batch
BEST
SQL that you can use yourself - from basics to practical use
We will learn databases and SQL step by step, from the basics to utilization (theory + practice), so that you can extract the data you need in actual work.
Reviews from Early Learners
What you will gain after the course
Essentials for using SQL (from SELECT statements to subqueries)
SQL practice to directly extract the data you need
Learn the flow of reading data by looking at ERD
SQL, 200% usable in real-world work! 📊
SQL , why do you actually use it?
Will it feel difficult? 🤔
When extracting data using SQL, it's difficult to directly apply basic concepts to practical applications. Because the tables where data is stored and the relationships between them vary from project to project, simply extracting data using SELECT-FROM from a textbook isn't easy. Writing queries without understanding SQL concepts and analyzing the project doesn't guarantee the desired data.
Seeing these difficulties, I started this course to teach SQL properly and quickly with the essential content .
SQL, right and fast!
So you can read the flow of data and extract the data as you want!
Learn SQL through general concept learning + practical training similar to real-world practice .
Ultimately, you need to understand the flow of data and the relationships between tables to extract the data you want using STEP BY STEP. Beyond the basic syntax of SELECT-FROM, this course covers the overall concepts needed to extract data based on various conditions. It also provides practical training through practical problems relevant to real-world use.
To these people
I recommend it ✅
Is this perhaps your concern?
- I studied SQL, but it's difficult to use it directly.
- I studied join, but I can't use it.
- The data I want is not coming out.
- I'm new to learning SQL, but I don't know where to start.
- I want to learn the overall content of SQL in a short period of time.
- I want to learn SQL in an environment similar to real-world data.
Using SQL
Data extraction
Those who want to learn
I learned SQL, but
In practice, writing SQL
Anyone who had difficulties
The database
What is the structure?
Anyone curious
In a short time
Overall SQL capabilities
Someone you want to raise
After taking this course, you can do it too! 🙌
- You can extract the data you want using SQL.
- It creates an eye for reading data flow between tables (+ reading ERD).
- You will want to go to the developer in charge of the table and ask them how the primary key is set up.
- I'm thinking about how data is stacked in tables.
- Feel confident in your SQL extraction.
Key benefits of this course ✨
Clean communication + practical application + practice problems provided!
You will learn fundamental concepts so that you can apply them in practice.
It is structured so that even those who are new to SQL can learn step by step .
We have created practical situations and exercises that can be used in actual work .
The hands-on environment utilizes AWS and DBeaver tools (free of charge). (If you have trouble using AWS, please send me a DM during the lecture.)
Instead of installing a heavy database on your computer, use AWS. (The practical environment guide in the lecture)
It is structured step-by-step from the basics to practical use, so even those new to SQL can learn easily as if they were using real-world examples .
You can extract data by looking at an Enterprise Data Design (ERD) . This will help you adapt to the different database structures of each company and practice reading tables.
Learn how to fish so you can access and extract data directly in your practice, rather than just extracting data suitable for learning.
What you'll learn 📚
1️⃣ From basic essential concepts
- To use SQL, you shouldn't learn it from SELECT-FROM.
- Learn essential concepts such as tables, nulls, constraints, and relationships between tables .
2️⃣ Learn to use SQL
- After learning the fundamental concepts, you can start learning SQL.
- We will learn and practice step by step, starting with the basic SELECT-FROM statement, operators, type conversion, aggregate functions, group by, etc.
- Once you learn a concept, practice problems follow.
- The practice problem involves extracting data by looking at an actual ERD.
3️⃣ Expanding SQL Usage
- Now that you've mastered how to use SQL to extract data, let's learn about joins and subqueries to expand on it.
- Additionally, let's take a look at the contents of the analysis function .
Who created this course
Introducing the Knowledge Sharer ✒️
Myeongjun
- Current Mozilla open source committer
- Former Fintech startup developer
- Former Global Professional Developer at the Ministry of Science and Technology
- Former) Hyosung Billing Development Team (Settlement DB Development)
Check out the vivid reviews of offline classes !
Q&A 💬
Q. I'm learning SQL for the first time. Can I still take this course?
Yes :) Even if you have never studied SQL before, I will teach you step by step from the basics.
Q. Is the practice environment free?
Because we're setting up an AWS environment, it's free for one year. We'll provide support so you won't miss any classes due to the setup of your practice environment.
Q. What level of content is covered in the class?
We'll cover everything from the most basic concepts to JOINs and subqueries. We'll also discuss how to use analytic functions. After completing the course, you should be able to extract the data you need.
Q. I studied SQL, but I can't use JOIN.
JOIN is simply a concept used to connect multiple tables. To effectively use JOIN, you need to learn general SQL concepts and data reading techniques. This lecture will be helpful.
Q. What database does the practice database use?
The practice database uses MySQL. Since all relational databases share the same fundamentals, this course will allow you to extract data from any relational database.
Recommended for
these people
Who is this course right for?
Anyone who has never written SQL but needs SQL
Anyone who needs SQL to develop their skills
I made a query using written SQL, but there are people who need to extract data directly
3,898
Learners
166
Reviews
33
Answers
4.7
Rating
3
Courses
안녕하세요. MJ코딩입니다😀
강의에 관심과 수강을 해주셔서 감사합니다 :)
강의 내용은 처음 접할 때는 가볍지만은 않은 내용이지만, 이해를 하실 수 있고 실제로 사용하실 수 있도록 준비를 하였습니다.
커리어와 실무에 도움이 되셨으면 하는 마음입니다.
프로그래밍 학습을 위한 유튜브 채널도 함께 운영을 하고 있습니다. (유튜브 링크 클릭)
필요한 내용을 보시고 참고 하여 도움이 되셨으면 좋겠습니다.
감사합니다^^
Curriculum
All
34 lectures ∙ (4hr 10min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
17 reviews
4.8
17 reviews
go9504114669Reviews 1
∙
Average Rating 5.0
5
79% enrolledSuddenly, my company asked me to do SQL, so I read a book and listened to a lecture, and I learned a lot. I used to just write without thinking, but now I know how to extract data! In particular, there was no talk about group by verification in the book... ㅠㅠ I will practice more based on the lecture and use it well in my work. Thank you for the great lecture!
- mjcodingInstructor
Hello slee :) I'm grateful that it was helpful 😢 Verification is as important as extraction, so I think it would be good to make it a habit to verify :) I hope you practice more based on what you've studied and improve your skills. Thank you.
- jswi1309
Reviews 32
∙
Average Rating 5.0
5
100% enrolledLet's apply it to practice!
- mjcodingInstructor
Hello, Jinseong :) As emphasized in the lecture, if you write the query step by step instead of writing everything at once, you can extract the data you want!! At first, the actual table will be unfamiliar and it will take time to write the query, but if you write it yourself in the actual work, you will definitely be able to develop better skills😊 Thank you.
- d18982254835156
Reviews 3
∙
Average Rating 3.7
5
97% enrolledIt's good because it's explained in an easy and understandable way. The lecture time is divided into short segments, so it's good because I feel like I'm learning quickly. It's a perfect lecture, except for the instructor's short tongue.
- mjcodingInstructor
Hello, Bureokjam :) I'm glad it was helpful😊 I'll pay more attention to pronunciation ㅜㅜ I hope the lecture content will be helpful for your career or work. Thank you.
- jhkim3293694
Reviews 2
∙
Average Rating 5.0
- clzh12334479
Reviews 1
∙
Average Rating 5.0
5
100% enrolledIt was good.
- mjcodingInstructor
Hello Sangmin :) I'm so glad that the lecture was helpful 😢 I hope the lecture will help you in your career and work as well ㅎㅎㅎ Thank you.
mjcoding's other courses
Check out other courses by the instructor!
![[Introduction to Web Development] HTML and CSS developed by yourself with Carrot Market講義サムネイル](https://cdn.inflearn.com/public/courses/329537/cover/e58304bd-ac81-4ec4-88c8-479cde58188a/329537-eng.png?f=avif&w=420)
Similar courses
Explore other courses in the same field!
![[ITⓔCoaching] Practical Data Management with Oracle講義サムネイル](https://cdn.inflearn.com/public/courses/327587/cover/8133dede-51cb-4410-949c-cd95aa80b7d6/327587-eng-original.jpg?f=avif&w=420)
![[Part 2] Creating Your First Spring Boot Project with Real Understanding Alongside the Developer Next Door講義サムネイル](https://cdn.inflearn.com/public/files/courses/337728/cover/01jxde3521nnchf3z1c845kmd3?f=avif&w=420)
![[MMORPG Game Development Series with C# and Unity] Part 5: Database講義サムネイル](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
