강의

N
챌린지

멘토링

N
클립

커뮤니티

Programming

/

Database

Practical Oracle SQL Utilization

We would like to provide an opportunity to learn SQL, a language used in relational databases, in general. In particular, we wrote the execution examples in the ORACLE environment. The learning content is largely divided into 2 parts and a total of 11 lectures. After learning the entire content, you can cultivate the ability to perform tasks in a database along with the general knowledge of SQL, and you can also prepare for the nationally certified SQL developer qualification.

(4.0) 4 reviews

42 learners

Level Basic

Course period 2 months

  • y2kdba
Oracle
Oracle
SQL
SQL
Oracle
Oracle
SQL
SQL

What you will gain after the course

  • You can learn SQL expertise in an Oracle environment.

  • You can develop your skills in database management.

What if I feel like my SQL knowledge is lacking?
Let's take a look at everything from basics to practical use 🏃

Lecture Topics 📖

SQL is a language used in relational databases. Anyone who wants to work in a relational database environment must be able to use SQL. Learning and using SQL, from its types to its various functions, will help you gain comprehensive knowledge and confidence in the field.

This course is designed to cultivate specialized knowledge of SQL and build database-related skills. Anyone currently working on or planning to build a system in an Oracle environment is encouraged to take this course. We also recommend this course to anyone preparing for the SQLD 2 course.

This course covers SQL, an essential language for performing various tasks in relational databases. To cultivate specialized knowledge of SQL, the course focuses on DDL, DML, TCL, functions, joins, hierarchical queries, index basics, and window functions .

Learn SQL in detail in Oracle. You'll learn about SQL types like DDL, DML, and TCL, as well as WHERE clauses, string/number/date/conversion/null/default functions, group functions, joins, subqueries, standard joins, hierarchical queries, index basics, window functions, and more.

✔️ Please check before taking the class!

  • There are no separate hands-on exercises in this course. If you wish to practice on your own, please use Windows as your operating system and install Personal Oracle.

I recommend this to these people 🙋

Expert knowledge of SQL
Those who want to learn

In an Oracle environment
A person performing a job

2 subjects related to SQLD
Those who need to learn

I have SQL experience myself.
Those who feel inadequate

Lecture Features ✨

Even without prior knowledge
Learning is possible!

By example
Understand SQL commands!

From SQL basics to application
All at once!

Detailed Curriculum (Table of Contents)

Part 1. SQL Basics

      • Lecture 1. DDL
        • 1. Object End
        • 2. Object-related DDL
        • 3. Constraints
        • 4. View, sequence, synergy, index
      • Lesson 2. DML and TCL
        • 1. SELECT/INSERT/DELETE/UPDATE
        • 2. MERGE
        • 3. COMMIT
        • 4. ROLLBACK
      • Lesson 3. WHERE clause
        • 1. Comparison operators
        • 2. NULL comparison
        • 3. Logical operators
        • 4. NOT speaker
      • Lesson 4. Single-row functions
        • 1. Character function
        • 2. Numeric functions
        • 3. Date functions
        • 4. Conversion function
        • 5. General functions
      • Lesson 5. Multi-row functions
        • 1. GROUP function
        • 2. GROUP BY clause
        • 3. HAVING clause
        • 4. ROLLUP, CUBE,
        • 5. Grouping Sets
        • 6. ORDER BY clause

Part 2. Using SQL

    • Lecture 6. Join
      • 1. Join concept
      • 2. Cartesian product
      • 3. EQUI Join
      • 4. Non-Equi Join
      • 5. Outer join
    • Lesson 7. Standard Joins
      • 1. Standard join
      • 2. UNION, UNION ALL, INTERSECT, MINUS
      • 3. Hierarchical queries
    • Lesson 8: Subqueries and Joins
      • 1. Types of subqueries
      • 2. Associated subqueries
      • 3. Semi-join
      • 4. Scalar subquery
      • 5. Inline View
    • Lesson 9. Join Techniques
      • 1. NL join
      • 2. SM Join
      • 3. HASH JOIN
      • 4. Join comparison
    • Lesson 10: Index Basics
      • 1. B-Tree index
      • 2. Index Scan
      • 3. Index selection
      • 4. How to use
      • 5. Defect Index
    • Lesson 11. Window Functions
      • 1. Configuring the window function
      • 2. Windowing section
      • 3. Calculating accumulated salary
      • 4. Calculating salary percentage
      • 5. Find immediately/just before
      • 6. Finding the rank/order

Expected Questions Q&A 💬

Q. I lack knowledge and experience with SQL. Can I still learn it?

Yes, you can learn it without difficulty.

Q. How long is the study period?

Once you register for a course, you can study for two months.

Q. Can non-majors also study?

Yes, you can learn it without much difficulty.

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)

external lectures

  • Leveraging Oracle SQL
  • Oracle SQL Tuning

Certificate

  • ORACLE 7.3 Database Administrator (obtained in June 1998)
  • ORACLE 8.0 Database Administrator (obtained in January 1999)

Recommended for
these people

Who is this course right for?

  • A person who performs duties related to databases

  • For those who want to learn SQL for the first time

  • For those preparing for the nationally recognized SQL qualification

  • Even those without a background (non-major) can apply

Hello
This is

101

Learners

6

Reviews

4.3

Rating

3

Courses

1. Work and Teaching History:
   1) Worked at Samsung SDS (Samsung Everland IS Team, 1992.06 ~~ 2002.04)
   2) Lectured at Samsung SDS Multicampus (Database Technology field, 2002.04 ~~ 2020.12)

2. Areas of Instruction:
1) Oracle SQL Utilization
2) Oracle SQL Tuning

3. Certifications: ORACLE 7.3 Database Administrator (Acquired 1998.06) ORACLE 8.0 Database Administrator (Acquired 1999.01) -------------------- SQL Certification Exam

3. Certifications:
   ORACLE 7.3 Database Administrator (Acquired 1998.06)
   ORACLE 8.0 Database Administrator (Acquired 1999.01)

----------------------------------------

This course covers both the practice problem sets for the SQL Certification and general SQL learning.

Especially for exam preparation to obtain the SQLD certification,

"SQL Qualification Exam Practical Questions - Korea Data Agency" has been adopted as the textbook.

🔔 Subject 1

🗒 Videos: M1 ~ M9

🗒 Questions: 52 questions in total

🗒 Time: 2 hours 48 minutes 38 seconds

In addition to this, we have prepared materials summarizing the most essential basic knowledge related to learning SQL.

I have also prepared materials summarizing the most essential content to help you build foundational knowledge.

It is also a bit regrettable that the SQL learning is being conducted solely for the purpose of obtaining the SQLD certification.

Of course, we have taken these points into consideration, and to further enhance practical SQL application skills,

I am planning to provide a wide range of information.

To everyone who wishes to learn SQL

I will strive to provide you with useful information.

Thank you.

Curriculum

All

11 lectures ∙ (5hr 42min)

Published: 
Last updated: 

Reviews

All

4 reviews

4.0

4 reviews

  • it22809993님의 프로필 이미지
    it22809993

    Reviews 3

    ∙

    Average Rating 5.0

    5

    36% enrolled

    • 216220258412님의 프로필 이미지
      216220258412

      Reviews 1

      ∙

      Average Rating 5.0

      5

      36% enrolled

      • taejisoon9036님의 프로필 이미지
        taejisoon9036

        Reviews 1

        ∙

        Average Rating 5.0

        5

        100% enrolled

        A clean, no-frills lecture that gets right into your ears.

        • thson2260님의 프로필 이미지
          thson2260

          Reviews 6

          ∙

          Average Rating 3.3

          1

          64% enrolled

          I understand the basic content because I already know it, but when the difficulty level increases a little, there are many jumps in the explanation of concepts, so it is difficult to understand. It would be better if you could follow the practice. I don't recommend it for beginners. If you are an intermediate level who can understand it, you don't have to listen to it.

          $84.70

          y2kdba's other courses

          Check out other courses by the instructor!

          SQLD Practice Problem Solutions (2 subjects)講義サムネイル

          SQLD Practice Problem Solutions (2 subjects)

          y2kdba

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

          初級

          初級

          SQLD

          SQLD Practice Problem Solutions (2 subjects)講義サムネイル

          SQLD Practice Problem Solutions (2 subjects)

          y2kdba

          SQLD Practice Problem Solution (1 subject)講義サムネイル

          SQLD Practice Problem Solution (1 subject)

          y2kdba

          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.

          初級

          初級

          SQLD

          SQLD Practice Problem Solution (1 subject)講義サムネイル

          SQLD Practice Problem Solution (1 subject)

          y2kdba

          Similar courses

          Explore other courses in the same field!

          Database - SQL講義サムネイル

          Database - SQL

          kjlee

          This course is for those who are learning database programming for the first time or those who have some knowledge but want to learn systematically. From concepts to practical exercises, you will master the database query language by organizing examples of types that frequently occur in real life.

          初級

          初級

          SQL, Data Engineering

          Database - SQL講義サムネイル

          Database - SQL

          kjlee

          Oracle PL/SQL Just This Much.. [Concept + Practice]講義サムネイル

          Oracle PL/SQL Just This Much.. [Concept + Practice]

          itpaul

          This course provides developers/operators using Oracle with PL/SQL concepts and practical skills that can be immediately applied in the field.

          初級

          初級

          PL/SQL, SQL, Oracle

          Oracle PL/SQL Just This Much.. [Concept + Practice]講義サムネイル

          Oracle PL/SQL Just This Much.. [Concept + Practice]

          itpaul

          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)講義サムネイル

          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

          WHIZ

          This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

          初級

          初級

          SQL, sql-query, bigquery

          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)講義サムネイル

          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

          WHIZ

          Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]講義サムネイル

          Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

          youngcodikimssam

          From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

          入門

          入門

          Java, JSP, Spring

          Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]講義サムネイル

          Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

          youngcodikimssam

          [The concept is easy~, the practice is intense] SQL data analysis, utilization!講義サムネイル

          [The concept is easy~, the practice is intense] SQL data analysis, utilization!

          hongpark

          SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

          初級

          初級

          SQL, PostgreSQL, DBMS/RDBMS

          [The concept is easy~, the practice is intense] SQL data analysis, utilization!講義サムネイル

          [The concept is easy~, the practice is intense] SQL data analysis, utilization!

          hongpark

          SQL data analysis learned through various cases講義サムネイル

          SQL data analysis learned through various cases

          dooleyz3525

          By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

          中級以上

          中級以上

          SQL, PostgreSQL, DBMS/RDBMS

          SQL data analysis learned through various cases講義サムネイル

          SQL data analysis learned through various cases

          dooleyz3525

          3. Web Development Course [Spring Framework + e-Government Standard Framework]講義サムネイル

          3. Web Development Course [Spring Framework + e-Government Standard Framework]

          vmproductor0202

          This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

          入門

          入門

          Spring, eGovFrame, spring-framework

          3. Web Development Course [Spring Framework + e-Government Standard Framework]講義サムネイル

          3. Web Development Course [Spring Framework + e-Government Standard Framework]

          vmproductor0202

          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]講義サムネイル

          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

          Hong

          This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

          入門

          入門

          Java, SQL, MySQL

          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]講義サムネイル

          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

          Hong

          For those who haven't even started with SQL, come here講義サムネイル

          For those who haven't even started with SQL, come here

          coddatg

          Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

          入門

          入門

          SQL, bigquery

          For those who haven't even started with SQL, come here講義サムネイル

          For those who haven't even started with SQL, come here

          coddatg

          High-Performance SQL for JPA (ORM) Developers講義サムネイル

          High-Performance SQL for JPA (ORM) Developers

          Vlad Mihalcea

          Make the most of relational database systems!

          中級以上

          中級以上

          SQL, performance-tuning, sql-query

          High-Performance SQL for JPA (ORM) Developers講義サムネイル

          High-Performance SQL for JPA (ORM) Developers

          Vlad Mihalcea

          SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions講義サムネイル

          SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

          Masocampus

          From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

          入門

          入門

          SQL, SQLD

          SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions講義サムネイル

          SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

          Masocampus

          [MMORPG Game Development Series with C# and Unity] Part 5: Database講義サムネイル

          [MMORPG Game Development Series with C# and Unity] Part 5: Database

          Rookiss

          This course teaches MS-SQL through baseball/company databases.

          初級

          初級

          SQL, DBMS/RDBMS

          [MMORPG Game Development Series with C# and Unity] Part 5: Database講義サムネイル

          [MMORPG Game Development Series with C# and Unity] Part 5: Database

          Rookiss

          DBT with a Silicon Valley Engineer講義サムネイル

          DBT with a Silicon Valley Engineer

          altoformula

          Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

          初級

          初級

          SQL, Data Engineering, data-analysis

          DBT with a Silicon Valley Engineer講義サムネイル

          DBT with a Silicon Valley Engineer

          altoformula