강의

멘토링

로드맵

Inflearn brand logo image
Data Science

/

Data Analysis

[ITⓔCoaching] Practical Data Management with Oracle

Extract and utilize data through Oracle 18c and become a database expert!

(5.0) 2 reviews

52 learners

  • ubob
Oracle
SQL
DBMS/RDBMS

What you will learn!

  • Various features of Oracle

  • Oracle DBMS-based data handling technology

  • SQL statements using key functions

Learning with Oracle
Real-world data management 📈

What if you could learn the latest version of Oracle 18c from a working programmer?
We've compiled the essential, practical, and immediately applicable knowledge, incorporating real-world application know-how. Become a database expert right away with Oracle 18c!

Advances in IT and communications technology are leading to the digitization and mass production of vast amounts of information. In this era of big data, the need to minimize data duplication and structure data for efficient data management has emerged. This has led to a need for training courses that can enhance work efficiency by enabling effective data analysis and management using Oracle, the leading database management program .

While mastering the concepts of Oracle is important, hands-on learning is even more crucial for mastering it. For a more in-depth understanding, try the practice files provided in the course!

What you can gain from the lecture ✔️

  • You can install and configure Oracle 18c.
  • You can acquire and use data handling technology based on Oracle DBMS.
  • You can write SQL statements that utilize SQL's main functions.
  • You can understand and utilize the parts added in Oracle 18c.

Lecture Features ✨

[1] Representative data management program, Oracle 🌿
Oracle is the most widely used program in data management. This course is based on the 18c version, the most widely used version, to enhance practical application!

[2] Let’s learn Aegis and use it right away!
From Oracle basics to an introduction to DBMS, Oracle installation, and theories and practices to become a database expert, we've designed this course for collaborative use!

[3] Direct lecture by data veteran, instructor Hong Hyeong-gyeong 🙆‍♂️
Instructor Hong Hyeong-gyeong, a working programmer and author of numerous SQL books, delivers practical, hands-on knowledge to practitioners in an easy-to-understand and accurate way!


Learn this 📚

#1 Introduction to RDBMS and Oracle 18c Installation

  • DBMS Overview
  • Introduction to RDBMS
  • Oracle Concepts and Installation

#2 Installing SQL Developer and Setting Up Oracle

  • SQL*Plus and SQL Developer
  • Oracle 18c Express Architecture
  • Configuring the 18c Express environment

#3 Definition and types of SQL

  • What is a table?
  • How to define a table
  • Constraints on table columns

#4 Digging into tables as data storage

  • What is SQL?
  • SQL types
  • Create, modify, and delete tables

#5 SQL's flagship, the basic SELECT statement

  • SELECT statement
  • WHERE clause
  • ORDER BY clause

#6 SQL Operators and Expressions

  • SQL operators
  • SQL expressions
  • Doctor's Column

#7 SQL Function 1 - Character/Numeric/Date Type Functions

  • What is a function?
  • Numeric function
  • Character type functions
  • Date type functions

#8 SQL Function 2 - Type Conversion/Other Functions

  • Type conversion function
  • Null handling and other functions
  • Function practice

#9 Aggregate Queries - Aggregate Functions and the GROUP BY Clause

  • GROUP BY clause and aggregate functions
  • GROUP BY clause and aggregate function practice
  • HAVING clause and DISTINCT

#10 Aggregate Queries - Aggregate Functions and the GROUP BY Clause

  • Set queries
  • set operators
  • Set operator practice

#11 Relationships Between Tables - Join 1 (Inner Join, Outer Join)

  • signature
  • inner join
  • outer join
  • Internal and external join practice

#12 Using subqueries

  • Types of subqueries
  • Subquery practice

#13 Building Relationships Between Tables - Join 2 (ANSI Join, Semi-Join)

  • ANSI join
  • Semi-join, anti-join, self-join
  • Join practice

#14 Data Entry/Modification/Deletion - INSERT, UPDATE, DELETE Statements

  • INSERT, UPDATE, DELETE statements
  • INSERT, UPDATE, DELETE practice

#15 Transaction Processing

  • Transaction processing and views
  • Indexes and data dictionary
  • Transaction, View, and Index Practice

#16 Exploring Database Objects - Views, Indexes

  • Shinonim
  • Sequence
  • Sequence practice with Shinonim


Expected Questions Q&A 💬

Q. Are study-related practice files provided?

Yes! Practice files are provided in the relevant sections :)


Recommended for
these people

Who is this course right for?

  • Database Administrator

  • Application Developer

  • DB Construction/Operation Manager

Need to know before starting?

  • Oracle

  • SQL Functions

Hello
This is

608

Learners

61

Reviews

2

Answers

4.8

Rating

32

Courses

Curriculum

All

64 lectures ∙ (6hr 49min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

2 reviews

5.0

2 reviews

  • 서유희(미원)님의 프로필 이미지
    서유희(미원)

    Reviews 1

    Average Rating 5.0

    5

    31% enrolled

    • Eunhee Na님의 프로필 이미지
      Eunhee Na

      Reviews 1

      Average Rating 5.0

      5

      63% enrolled

      중요한 부분만 알기쉽게 설명해주셔서 도움이 많이 되었습니다.

      $84.70

      ubob's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!