강의

멘토링

로드맵

Inflearn brand logo image
Data Science

/

Certificate (Data Science)

SQLD Practice Problem Solutions (2 subjects)

A guide to the exam for nationally recognized SQL qualifications! Establish a comprehensive knowledge system related to SQL.

(5.0) 1 reviews

23 learners

  • y2kdba
SQLD
자격증
문제풀이
sql
시험

What you will learn!

  • Prepare for the exam for the nationally recognized SQL qualification

  • SQL

SQLD, meticulously executed with practical problems!

SQL Developer Certification Exam
Be perfectly prepared.

What is SQLD ?

The SQLD nationally certified SQL developer qualification exam is an exam that evaluates job performance skills related to database design and implementation and SQL utilization, such as writing SQL and optimizing performance based on knowledge of data modeling.

National Certified SQL Developer Qualification Exam
It helps you prepare.

Regardless of whether you are a development major or not
Anyone can apply .

In this course, you'll learn a comprehensive understanding of the SQL language to facilitate your work in a database. You'll also prepare for the nationally recognized SQL certification exam .

I used "SQL Certification Exam Practice Questions," published by the Korea Data Industry Promotion Agency (KDIA), commonly known as the "Yellow Book," as a recommended textbook for those preparing for the nationally recognized SQL certification exam. I've compiled 26 video explanations for all 146 questions across two subjects in the textbook.

While there are answer sheets for every problem, those who study on their own often find some of the solutions difficult, and most of the content is written in text format. To address this, we 've incorporated graphical explanations to enhance learners' understanding.


I recommend this to these people 🙋

People who have never encountered SQL but want to obtain SQLD certification

Those who have attempted the SQLD exam multiple times but failed to pass

Those who have difficulty understanding the explanations in the SQLD textbook

From the SQL language to the SQLD certification exam ✍️

After taking this course, you will have the SQL knowledge necessary for a career in databases. This course is also open to anyone who wants to learn SQL, even if it's not specifically for the certification exam.

To achieve a high score on the exam, you need to plan ahead and study repeatedly. To ensure sufficient study, we recommend setting aside at least a month for preparation. If you have any questions, please actively utilize the Q&A section.


What you'll learn 📚

This course is divided into three parts, and you will learn Parts 1, 2, and 3 in that order. The structure and content of each part are as follows:

Learn at a glance 🔎

1️⃣

Learn about the types of SQL you can use, SQL-related tasks, components of the SELECT statement, SQL functions, null-related functions, and join concepts.

2️⃣

Learn about data models, self-joins, standard joins, outer joins, set operators, hierarchical queries, GROUP functions, window functions, GRANT and REVOKE, and more.

3️⃣

Learn about the basic principles of SQL optimization, including optimizers, execution plans, execution plan analysis, index basics, index and DML performance, and types of indexes.

Are you curious about the detailed curriculum?

Part 1. SQL Basics and Utilization

  1. Types of SQL
  2. DDL Syntax
  3. Definition of Null Value
  4. DML operations
  5. FOREIGN KEY and DML
  6. DELTE, TRUNCATE
  7. Transaction characteristics
  8. SELECt related to null
  9. WHERE clause of SELECT
  10. SQL functions
  11. Understanding the Date type
  12. SUM(CASE ~ END)
  13. NULL related functions
  14. GROUP function and null
  15. GROUP BY clause
  16. HAVING clause
  17. ORDER BY clause
  18. TOP-N queries
  19. Join concept
  20. Non-equi join

Part 2. Using SQL

  1. Pure relational operators
  2. Data Model and Join
  3. GROUP BY, HAVING
  4. Standard join
  5. Cartesian Product
  6. Results from outer join
  7. set operators
  8. Subqueries and output results
  9. Subqueries and set operators
  10. Set operators and output results
  11. Types of set operators
  12. Hierarchical queries and output results
  13. Understanding hierarchical queries
  14. Writing hierarchical queries
  15. Comparing Hierarchical Queries in Oracle and SQL Server
  16. Self-join
  17. Accumulated value processing
  18. Types of subqueries
  19. Subqueries and joins
  20. Subqueries and UPDATE
  21. View and View Utilization
  22. ROLLUP function, CUBE function, GROUPING SETS
  23. Composition and characteristics of window functions
  24. RANK, DENSE_RANK, ROW_NUMBER
  25. Understanding Window Functions
  26. Window functions and output results
  27. LEAD, LAG
  28. GRANT and REVOKE, ROKE
  29. Distinguishing between permissions and possible actions for GRAN/REVOKE
  30. PL/SQL, stored procedures, triggers, user-defined functions

Part 3. Basic Principles of SQL Optimization

  1. Optimizer and Execution Plan
  2. Execution Plan Analysis
  3. Index Basics
  4. Index and DML performance
  5. Types of indexes
  6. Combined index
  7. Join technique
  8. Subqueries and joins

Expected Questions Q&A 💬

Q. Can I take the course even if I have no background (i.e., no SQL-related knowledge)?

Yes, it is possible.

Q. How much time should I devote to preparing for the exam?

Some people say it takes as little as two weeks, but if you want to pass, you need to prepare for at least a month.

Q. What is the difference between SQLD and SQLP?

SQLD requires passing two subjects, including subject 1 and subject 2. And SQLP can be taken by those who have passed SQLD, in which case you must pass subject 1, subject 2, subject 3, etc.


Introducing the Knowledge Sharer ✒️

History

  • Worked at Samsung SDS (Samsung Everland IS Team, June 1992 - April 2002)
  • Samsung SDS Multicampus Lecture (Database Technology, April 2002 - December 2020)

Things to note before taking the course 📢

Practice environment

  • No separate practical training is conducted in class.

Player Knowledge and Precautions

  • Prior knowledge of SQL fundamentals is helpful, but not required.
  • It is recommended that you memorize the key points summarized in [SQL Qualification Exam Practice Questions], which was adopted as a textbook, as well as the key points additionally explained in the video.

Recommended for
these people

Who is this course right for?

  • For those who want to learn SQL

  • Those preparing for the nationally recognized SQL qualification exam

Need to know before starting?

  • Introduction to SQL

  • Data Modeling

Hello
This is

99

Learners

6

Reviews

4.3

Rating

3

Courses

1. 업무 및 강의 이력 :
   1) 삼성SDS 근무 (삼성 에버랜드 IS팀,  1992.06 ~~ 2002.04
   2) 삼성SDS 멀티캠퍼스 강의 (데이터베이스 기술 분야, 2002.04 ~~ 2020.12)

 

2. 강의 분야 :
   1) 오라클 SQL 활용
   2) 오라클 SQL 튜닝

 

3. 자격증 :
   ORACLE 7.3 Database Administrator (1998.06 취득)
   ORACLE 8.0 Database Administrator (1999.01 취득)

 

 

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ

 

 

SQL자격검정 실전문제 풀이는 물론 SQL 학습과 관련한 과정입니다.  

특히, SQLD 자격을 위한 시험 준비를 위해

"SQL 자격검정 실전문제 - 한국 데이터진흥원"를 교재로 채택했습니다. 

 

 

🔔  1과목

      🗒 영상 : M1 ~ M9

      🗒 문항 : 총 52 문항

      🗒 시간 : 2시간 48분 38초

 

 

이 외에도 SQL에 대한 학습과 관련하여 기본 지식을  

쌓을 수 있도록 가장 필수적인 내용을 정리한 자료도  함께 마련했습니다. 

SQLD 자격을 취득하기 위한 SQL 학습으로  진행되는 것이 아쉽기도 합니다. 

물론 이러한 점을 고려했고 더 나아가 실무적인 SQL 활용 스킬(skill)의 향상을 위해

다양한 정보를 제공할 수 있도록 계획하고 있습니다.

 

 

SQL을 학습하고자 하는 여러분 모두에게 

유익한 정보를 제공할 수 있도록 노력하겠습니다.

 

 

감사합니다.

Curriculum

All

21 lectures ∙ (4hr 47min)

Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • 이동욱님의 프로필 이미지
    이동욱

    Reviews 14

    Average Rating 5.0

    5

    62% enrolled

    $93.50

    y2kdba's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!