Oracle Database 19c: SQL Fundamentals Course
The Oracle Database 19c: SQL Fundamentals course is designed to introduce students to Oracle Database 19c technology and the powerful SQL programming language. Throughout the course, participants will develop essential SQL skills that allow them to write queries against single and multiple tables and manipulate data effectively.
Course Highlights:- Retrieving Data Using the SQL SELECT Statement.
- Restricting and Sorting Data.
- Customizing Output with Single-Row Functions.
- Utilizing Conversion Functions and Conditional Expressions.
- Aggregating Data Using Group Functions.
- Joining Data from Multiple Tables.
- Solving Queries with Subqueries.
- Employing Set Operators.
- Managing Tables with DML Statements.
This course equips students with the practical skills necessary to harness the capabilities of Oracle Database 19c effectively. Join us to enhance your SQL proficiency!
Course Contents:
-
Introduction
- Welcome
- Audiance
-
Retrieving Data with SELECT STATEMENT
- SELECT STATEMENT for Retrieving Data
- SELECT STATEMENT on Advanced views