Practical Oracle SQL Utilization

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.

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 ✨

Expected Questions Q&A 💬

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)