180
LESSONS
ALL
SKILL LEVEL
13 hr
DURATION
ENGLISH
AUDIO
ENG
SUBTITLES
OVERVIEW
This course is the foundation for the Oracle Database SQL 1Z0-171 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is also suitable if you want to enter the 1Z0-071 certification.
On completion, you will know what how to:
- Manipulate numbers, strings, and dates.
- Create database and tables.
- Insert data and create analyses.
- And have an appreciation of how they can all be used in Oracle SQL.
.
WHO IS THE COURSE FOR?
You don’t need any prior knowledge of Oracle database.
The course is also suitable for those who want an SQL refresher.
.
LEARNING PATH
THE SELECT STATEMENT.
DATA TYPES AND FUNCTIONS
- Install Oracle Express Edition and Oracle SQL Developer.
- The 6 principal clauses of the SELECT statement:
- SELECT
- FROM
- WHERE
- GROUP BY
- HAVING
- ORDER BY
- Create tables.
- String, date and number data types and functions.
THE SELECT STATEMENT IN DETAIL
- Revisit the SELECT statement in more detail.
- JOIN tables.
DATA, TRANSACTIONS, AND CONSTRAINTS
- Look for missing data.
- Delete and update data.
- Implicit and explicit transactions.
- Constraints, including primary and foreign keys.
V
- Views.
- Combining tables.
- Totals.
- Subqueries.
EXPANDING QUERIES
- The WITH clause.
- Self-joins.
- TIME ZONE.
- INTERVAL.
T
- SEQUENCE.
- INDEX.
- Users and roles.
.
REVIEWS
“Well explained in depth course. A+++!” – Fernando
“Instructor has excellent command on the subject and has laid out the content and examples very well” – Gagan
“I liked the instructor approach in presenting the material. He is organized and clear.” – Kholoud
.
