강의

멘토링

커뮤니티

Data Science

/

Data Analysis

IT Essential Knowledge - Database and SQL

This course is designed to provide step-by-step learning from the basic concepts of database systems to the utilization of Relational Database Management Systems (RDBMS) and SQL. Learners will understand the principles of databases and be able to create systematic data structures through data modeling and design methods. Additionally, they will experience actual data processing by practicing data manipulation and management techniques using SQL. Through this course, students can go beyond simple theoretical learning to build a foundation that can be utilized for both practical work and certification exam preparation by acquiring efficient data management and application skills.

(4.8) 9 reviews

4,825 learners

Level Beginner

Course period 12 months

  • usefulit
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL

Reviews from Early Learners

Reviews from Early Learners

4.8

5.0

Waraukuma

100% enrolled

Essential nourishment that becomes flesh and blood

5.0

KwangKwon Ryu

60% enrolled

I had been using databases a bit without understanding the theory, but now I think I'll be able to use them well. Thank you so much for the great lecture.

5.0

안지영

100% enrolled

It seems that combining theory and practice has been very helpful in learning about databases.

What you will gain after the course

  • You can design database structures that meet requirements by utilizing data modeling techniques.

  • You can write queries to effectively retrieve, add, modify, and delete data from databases using SQL, and can process complex data by utilizing various SQL features.

Essential IT Knowledge - Database and SQL

This course is structured to enable step-by-step learning from the fundamental concepts of database systems to relational database management systems (RDBMS) and SQL utilization.

Learners will understand the principles of databases and be able to create systematic data structures through data modeling and design methods. Additionally, they will experience actual data processing by practicing data manipulation and management techniques using SQL.

Through this course, students will go beyond simple theoretical learning and develop efficient data management and application skills, building a foundation that can be utilized for both practical work and certification exam preparation.

You'll learn this content

This course is a systematic program that allows you to learn from database fundamentals to hands-on practice step by step. It covers database concepts, design, and SQL utilization, structured to provide comprehensive understanding for learners ranging from beginners to those preparing for practical application.

Through this process, learners will acquire both database design skills and SQL utilization capabilities. Beyond simply understanding theory, you'll gain hands-on experience working with data in an Oracle environment, strengthening both practical adaptability and certification exam preparation skills.

🔹 Theory and Concept Learning

  • Understanding Database Fundamentals & Systems: Learning the Necessity of Data Management and the Role of DBMS

  • Data Modeling & ERD: How to structure real-world data, Entity-Relationship model design

  • Relational Data Model & Operations, Normalization: Understanding the structure of relational databases and methods to eliminate data anomalies

🔹 Practice and SQL Application

  • Oracle Installation and Environment Setup: Setting Up the Practice Environment

  • SQL-DDL: Data Definition (Table Creation, Modification, Deletion)

  • SQL-DML: Data Manipulation (Insert, Update, Delete)

  • DQL & DML Function: Data Query and Utilizing Various Built-in Functions

  • SQL-TCL & DCL: Transaction Control and Permission Management

  • SQL-JOIN: Data Combination and Applied Queries Using Multiple Tables

Notes Before Enrollment

This course does not provide Q&A support from the instructor

Learning Materials

Weekly lesson plans are provided as PDF files

Recommended for
these people

Who is this course right for?

  • A student with no foundational knowledge of databases

  • IT-related major students and general public interested in database management

Hello
This is

8,278,676

Learners

6,372

Reviews

4.6

Rating

309

Courses

I will help you grow through useful IT lectures.

Curriculum

All

15 lectures ∙ (13hr 51min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

9 reviews

4.8

9 reviews

  • jhseo808님의 프로필 이미지
    jhseo808

    Reviews 12

    Average Rating 3.5

    4

    100% enrolled

    I really enjoyed your great lecture.

    • waraukuma945911님의 프로필 이미지
      waraukuma945911

      Reviews 5

      Average Rating 5.0

      5

      100% enrolled

      Essential nourishment that becomes flesh and blood

      • spacebar님의 프로필 이미지
        spacebar

        Reviews 27

        Average Rating 5.0

        5

        27% enrolled

        • ykk09o991481님의 프로필 이미지
          ykk09o991481

          Reviews 7

          Average Rating 5.0

          5

          60% enrolled

          I had been using databases a bit without understanding the theory, but now I think I'll be able to use them well. Thank you so much for the great lecture.

          • s1121238291님의 프로필 이미지
            s1121238291

            Reviews 74

            Average Rating 4.9

            5

            100% enrolled

            $48.40

            usefulit's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!