本物のORACLE SQLの活用
y2kdba
リレーショナルデータベースで使用される言語であるSQLを全体的に学ぶ機会を提供したいと思います。具体的には、実行例をORACLE環境で作成しました。 学習内容は大きく2つのPart、合計11強で構成されています。 全内容を学習した後は、SQLといえる全般的な知識とともにデータベースでの業務ㅁ遂行能力を培養する でき、国家公認の SQL 開発者資格も準備できます。
초급
Oracle, SQL
SQLD Practice Problem Solution (1 subject)
Completely prepare for one subject of the exam for nationally certified SQL developer qualification using the Korea Data Industry Promotion Agency's SQL qualification exam practice questions as a textbook.
What you will gain after the course
Understanding Data Modeling
Data Model and Performance
SQLD, meticulously executed with practical problems!
SQL Developer Certification Exam
Be perfectly prepared.
What is SQLD ?
The SQLD exam, a nationally certified SQL developer qualification exam, evaluates job performance skills related to database design and implementation and SQL utilization, including 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 .
Learn each part thoroughly
Complete preparation for the nationally certified SQLD
💡 I worked at Samsung SDS from 1992 to 2002, and until 2020, I personally taught DB technology courses on Oracle SQL utilization and tuning. Based on my many years of experience, I will provide you with the essential knowledge you need to obtain the SQLD certification .
Part 1 - Understanding Data Modelers
- Understanding the data model
- entity
- attribute
- relationship
- identifier
Part 2 - Data Models and Performance
- Overview of Performance Data Modeling
- Normalization and Performance
- Denormalization and Performance
- Performance on large amounts of data
- Database structure and performance
- Distributed Databases and Performance
📢 Please check before taking the class.
- The problems solved in this lecture are not provided as course materials. Please purchase the textbook "SQL Certification Exam Practice Questions" (Korea Data Promotion Agency) separately.
Recommended for
these people
Who is this course right for?
For those preparing for the SQL Developer (SQLD) qualification
Available to both IT majors and non-IT majors
101
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
9 lectures ∙ (2hr 48min)
Published:
Last updated:
Reviews
All
1 reviews
$68.20
y2kdba's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[2025]非専攻者でも一発合格するSQLD Part1강의 썸네일](https://cdn.inflearn.com/public/files/courses/335958/cover/01jr03edmsxc1eq8nrwjv3jpax?f=avif&w=420)
![[2025] 非専攻者でも一発合格するSQLD オールインワン강의 썸네일](https://cdn.inflearn.com/public/files/courses/336953/cover/01jr02gfpt2km3k50amyw7sttt?f=avif&w=420)
