49회만에 실무 SQL 완전정복 II - 심화 과정 (실습자료 및 문제풀이 포함)
비박
'49회만에 실무 SQL 완전정복 II - 심화 과정'은 기본 과정에 이어 진행됩니다. 실무형 데이터베이스를 사용하여 학습을 진행함으로써 바로 현업에서 응용이 가능하고, 이론 설명, 실습과 더불어 총 200여개의 응용 문제 풀이를 통해 학습 내용을 충분히 익힐 수 있게 구성되어 있습니다.
초급
SQL, MSSQL
Complete Mastery of Practical SQL in 49 Sessions I - Basic Course (Including Practice Materials and Problem Solving)
'Complete Mastery of Practical SQL in 49 Sessions I - Basic Course' contains essential content that you must know for SQL. By learning using a practical database, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems. For intuitive understanding, practice is conducted using a database written in Korean.
Reviews from Early Learners
What you will learn!
Installing SQL Server
Create DB with external dataset
SQL Basic Grammar
SQL single row functions (string functions, numeric functions, date functions, etc.)
Aggregate function
signature
Data manipulation language, data definition language
SQL, from beginner to expert!
Fundamentals + Application + Problem Solving all at once.
📣 Please check before taking the class!
- The new SQL Mastery Series, available in just 49 lessons, consists of two lectures (Basic and Advanced). This course is a basic course. It covers approximately 49 SQL topics across two lectures.
Attention, these people !
Starting from the basics
I want to learn SQL thoroughly.
It is difficult to understand with just general textbooks
I want to learn intermediate to advanced skills easily.
SQLD, SQLP, data analysis expert, etc.
I would like help in obtaining a certificate .
SQL in the field of data handling
I want to develop capabilities that I can utilize .
For learning SQL
Transfer of optimal know-how.
- ✅ If you are working on data-related tasks or want to use SQL in your work,
- ✅ If you want to start from the beginner level of data and advance to the advanced level,
- ✅ If you want to use SQL freely as a developer ,
- ✅ If you are preparing for a data-related certification (SQLD, SQLP, Data Analysis Specialist, etc.)
- ✅ If you are interested in data science
The "From Beginner to Expert in 49 Sessions! Master Practical SQL" course covers the essential fundamentals of SQL and provides hands-on practice with databases based on real-world applications . Solving practical practice problems not found in any textbook will help you rapidly improve your skills, and the goal is to immediately apply SQL in real-world situations.
We've compiled the best know-how we've accumulated over many years of practical experience and training at universities, companies, and educational institutions. Starting with the basics, anyone can learn, we'll help you build a solid foundation in SQL!
SQL Basics You Must Know
We handle it carefully.
Fully packed with 3-step structure
The course progresses through three stages: theoretical explanation, practical training, and application problem solving. After completing the entire course, you'll be able to write SQL fluently, and you can also choose to study selectively based on your efficiency.
I think about how to utilize it
This course not only prepares you for data qualifications using SQL, but also helps you develop your ability to utilize public data. Furthermore, it focuses on writing intermediate to advanced SQL statements necessary for program development.
Vivid hands-on experience with a practical DB
We use external data used in the field to enable practical training in an environment similar to actual work. Specifically, we've structured the program with Korean table and column names for intuitive understanding.
Solutions to over 200 application problems
By solving over 200 application problems of various difficulty levels and types, ranging from beginner to intermediate to advanced, you will develop the ability to solve problems using SQL according to the situation.
Complete Mastery of Practical SQL in 49 Sessions
In each section
You will learn these things :
Section 0:
SQL basic grammar
- SQL Overview, Installing SQL-Server Express 2019
- Install SSMS (SQL-Server Management System)
- Importing data from outside Excel
- Introduction to the Korean Language Database Dataset
- SQL basic query syntax, conditional clauses, and operators
- Sort data and remove duplicates
Section 1:
single row functions
- Single-row functions used in SQL Server: string functions, numeric functions, date functions, and system functions.
- String replacement functions: TRANSLATE, REPLACE, STUFF comparison
- String concatenation/dividing functions: STRING_SPLIT, STRING_AGG
- Conditional processing functions: IIF, CHOOSE, Conditional processing statements: CASE...END
- NULL replacement functions: ISNULL, COALESCE comparison
Section 2:
Aggregate functions
- Grammar using aggregate functions and types of aggregate functions
- How to count the number of records with duplicates removed
- How to summarize by grouping and aggregating by specifying conditions
- Comparison of WHERE and HAVING clauses
- How to calculate subtotals and grand totals at once using ROLLUP, CUBE, and GROUPING SETS
- How to distinguish NULL using GROUPING and replace NULL resulting from GROUPING with a string
- PIVOT and UNPIVOT clauses #2 that change rows to columns and columns to rows.
Section 3:
signature
- Definition and principles of joins, comparison of ANSI-SQL joins and T-SQL joins
- Understanding the structure of the North Wind database used in practice
- Cross join, equi join, non-equi join, self join, outer join
- Common Table Expressions (CTEs) - Non-recursive and Recursive CTEs
- How to write hierarchical queries using recursive CTEs
Section 4:
data manipulation language,
Data Definition Language
- DML (INSERT, UPDATE, DELETE) and DDL (CREATE, ALTER, DROP) syntax
- How to create, alter, and delete a database
- Basic table creation syntax
- How to create auto-value and auto-calculated columns, IDENTITY property, uniqueidentifier data type
- How to create a table using an existing table
- Constraints - PRIMARY KEY, NOT NULL, UNIQUE, CHECK, FOREIGN KEY, DEFAULT
- FOREIGN KEY Attributes - ON DELETE, UPDATE CASCADE, SET NULL, SET DEFAULT, NO ACTION Comparison
- Comparing Column-Level and Table-Level Constraint Settings
- How to add/change/delete columns, add/delete constraints, and delete tables
- Setting Constraints on the North Wind Database and Creating an ERD in SSMS
Q&A 💬
Q. Why should I learn SQL?
They say data is the oil of the 21st century. It's virtually impossible to find an industry that doesn't utilize data. Therefore, data-handling skills are essential these days, and SQL is considered one of the most common means of accessing data. Furthermore, cloud-based machine learning services are increasingly utilizing SQL. Furthermore, SQL skills are increasingly required for IT recruitment.
Q. Can non-IT majors learn it too?
Of course. Data itself isn't limited to IT majors. Data handling skills are essential for a wide range of talents across all industries, regardless of their major.
Q. What are the main features of the class?
This course aims to teach skills that can be immediately applied in the workplace. Therefore, we use a database similar to those used in the field as our practice database. Furthermore, to enhance students' intuitive understanding, we use Korean for table and column names. Solving approximately 200 application problems on your own and working together to solve them will also be of great help.
Q. Who uses SQL and where?
It will primarily be used by IT developers. It's also essential for those who specialize in data analysis, visualization, and other data-intensive tasks. Anyone who handles any type of data in the workplace will find a solid understanding of SQL very helpful.
Q. What is the level of the class?
The entire course consists of eight sections, including both basic and advanced sections. Section 0 is the introductory course . As the course progresses, it gradually covers intermediate and advanced skills .
Q. Is it very different from ORACLE or MySQL?
Standard SQL is the same. Depending on the DBMS, some features, such as functions, may differ. Therefore, even if you learn with MS-SQL, Microsoft's DBMS with its excellent accessibility and online help, you'll have no trouble using SQL in ORACLE, MySQL, or other relational databases.
Recommended for
these people
Who is this course right for?
People who want to apply and apply SQL directly to their field of work
People who want to analyze or utilize data in the field
IT Developer
People preparing for data-related certifications such as SQLD, SQLP, and data analysis specialist
People interested in data science
Need to know before starting?
Section 0 is an introductory course and requires no prior knowledge.
206
Learners
14
Reviews
1
Answers
4.8
Rating
2
Courses
학력)
- 컴퓨터공학박사
연구)
-개인화 추천시스템을 위한 모델에 관한 연구
-키워드 기반 추천시스템 데이터 셋 구축 및 분석
-능동적 원본 도메일 선택을 이용한 교체 도메인 추천에 관한 연구
-협업필터링의 희박 행렬 문제를 위한 이행적 유사도 평가
-퍼지 질의 처리를 위한 시스템 구현
-Adaptive Cross-Domain Recommendation Model based on Association Analysis , etc.
실무 경력)
-㈜한국 BMG뮤직/MIS팀
-㈜딜로이트경영컨설팅/시스템사업부
-㈜Ernst & Young Management Consulting/솔루션팀
주요 업무 및 수행 프로젝트)
PM, 데이터베이스 설계, 구축 및 시스템 개발, 패키지 운영, 데이터분석 및 시각화
-SOLOMON PACKAGE 운영 관리(G/L, A/P, A/R, INVENTORY, P/O, ESI)
-SAMIS(Sales and Marketing Information System) 개발 및 관리
-한국 BMG뮤직 고객관리시스템, 저작권심의관리시스템 개발 및 운영
-안건 회계법인 인사급여, 고정자산 시스템 개발
-㈜대덕전자 인사급여, 복지기금, 우리사주시스템 개발
-㈜미원 VOC(Voice Of Customer) 시스템 ISP
-국내C기업 인사관리 시각화 분석 프로젝트 외 다수 프로젝트 진행
강의 분야)
-데이터베이스 및 데이터 분석 분야: 데이터베이스, 데이터베이스 설계 및 구축, 데이터베이스 실습(SQL-Server, ORACLE, MySQL), 파이썬과 R을 활용한 데이터 분석, 엑셀을 활용한 데이터 분석 및 시각화
-데이터 시각화 분야 : POWER BI
-프로그래밍 언어 분야: 파이썬, 비주얼베이직 닷넷, 자바스크립트, VueJS, C#, 웹프로그래밍실습, 모바일프로그래밍, 자바 등
저서)
-난생처음 MySQL (한빛아카데미, 2024-01-17)
Curriculum
All
35 lectures ∙ (13hr 1min)
Course Materials:
Lecture resources
Published:
Last updated:
$68.20
topdatastudio's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[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)
![[웹 개발 풀스택 코스] 넷플릭스와 당근마켓 분석을 통해서 배우는 데이터베이스 기초강의 썸네일](https://cdn.inflearn.com/public/courses/330079/cover/c142fdb2-b4fa-4b6a-9e8f-7bd48aed7635/fullstack-db-1.jpg?f=avif&w=420)
![가장 쉽고 깊게 알려주는 MongoDB 완벽 가이드 [ By. 비전공자 & Kakao 개발자 ]강의 썸네일](https://cdn.inflearn.com/public/files/courses/337578/cover/01jwt82r7jn3c9mzybfn00mdnh?f=avif&w=420)
