SQLD Certification Preparation Course

Course Guide

1. This is a course aimed at obtaining the nationally certified SQLD certification.

• SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

  
  

2. An increasing number of companies and public sector organizations are giving preference to SQLD certificate holders when hiring, and relational databases occupy the majority of data storage in corporate or organizational informatization. SQL usage is essential when using database-based information systems. For performance optimization, we recommend obtaining the SQLP (SQL Professional) certification.

Course Introduction

1. You can achieve efficient learning by studying the core theories of frequently tested sections in the SQLD certification exam.

• We provide lesson plan PDFs and problem PDFs.

• You can practice by copying and pasting the code used in the exercises directly into livesql for hands-on learning.

• I have organized and solved the problems from the yellow textbook published by the Korea Data Agency (testing organization) by topic.

  
  

2. We maximized learning effectiveness by operating a QnA open chat room.

• Provides CBT-style problem solving links

• Operating an open chat room for Q&A (please refer to the learning guide!)

Educational Objectives

1. You can obtain the SQLD certification.

2. Understand data modeling and be able to communicate through ERD.

3. You can write queries for basic and advanced SQL usage and analyze their operations.

Instructor Introduction ✒

Yoon So-young (CEO of EduAtoz)

Instructor Yoon So-young is an IT professional instructor who has been conducting SW lectures for 24 years.

Lecture History

• Samsung and LG SW training for new employees and current staff

• Central Information Processing Academy

• Incheon Girls' Commercial High School (Industry-Academia Adjunct)

• Korea Chamber of Commerce and Industry

• Gimcheon University, Sungkyunkwan University (Suwon), Soongsil University, Seoul National University, etc.

• Multicampus and others

Certifications Held

• Vocational Training Instructor License (Information Processing Level 2)

• Information Processing Engineer Level 1

• Data Analysis Associate, Data Analysis Expert

• Big Data Analytics Engineer

• SQLD

Main Course Curriculum

• [Certifications] Associate Data Analyst, Big Data Analytics Engineer, SQLD, Information Processing Engineer, Industrial Engineer

• [Algorithm] Data Structures (Beginner, Intermediate), Algorithms (Samsung employees and new hires, LG employees)

• [Programming] C language, JAVA, HTML/CSS/JavaScript, Android Application, Python (basics, data processing, data analysis)

• [AI] Machine Learning (supervised, unsupervised learning), Deep Learning (tensorflow, CNN, RNN basics)