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