스몰토크, 소소해서 더 호감가는 대화 치트키
유밥(Ubob)
친밀한 분위기가 필요할 때 꺼내 쓰는 대화법 치트키! 1분만 대화해도 충분하다.
Beginner
자기계발, 대인관계, 조직 관리
Extract and utilize data through Oracle 18c and become a database expert!
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 ✔️
[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!
#1 Introduction to RDBMS and Oracle 18c Installation
#2 Installing SQL Developer and Setting Up Oracle
#3 Definition and types of SQL
#4 Digging into tables as data storage
#5 SQL's flagship, the basic SELECT statement
#6 SQL Operators and Expressions
#7 SQL Function 1 - Character/Numeric/Date Type Functions
#8 SQL Function 2 - Type Conversion/Other Functions
#9 Aggregate Queries - Aggregate Functions and the GROUP BY Clause
#10 Aggregate Queries - Aggregate Functions and the GROUP BY Clause
#11 Relationships Between Tables - Join 1 (Inner Join, Outer Join)
#12 Using subqueries
#13 Building Relationships Between Tables - Join 2 (ANSI Join, Semi-Join)
#14 Data Entry/Modification/Deletion - INSERT, UPDATE, DELETE Statements
#15 Transaction Processing
#16 Exploring Database Objects - Views, Indexes
Q. Are study-related practice files provided?
Yes! Practice files are provided in the relevant sections :)
Who is this course right for?
Database Administrator
Application Developer
DB Construction/Operation Manager
Need to know before starting?
Oracle
SQL Functions
All
64 lectures ∙ (6hr 49min)
Course Materials:
$84.70
Check out other courses by the instructor!
Explore other courses in the same field!