1Z0-171 exam prep: Oracle AI Database SQL Associate

Name: 1Z0-171 exam prep: Oracle AI Database SQL Associate
Rating: 4.6 (210 reviews)

The SELECT statement, functions and more. Oracle Database 19c, 21c, 23c, 23ai using Oracle SQL Developer. 1Z0-171 exam.

Highest Rated

Created byPhillip Burton • over one million students so far, I Do Data Limited

Last updated 3/2026

English

What you'll learn

Relational Database Concepts
Retrieving Data using the SQL SELECT Statement and Restricting and Sorting Data
Using Functions
Displaying Data from Multiple Tables, including using SET operators
Using Subqueries to Solve Queries
Managing Indexes Synonyms and Sequences
Manage tables and their relationships using DDL and DML statements
Control User Access
Managing Objects with Data Dictionary Views and Data in Different Time Zones

Course content

30 sections • 175 lectures • 13h 17m total length

Introduction2:24
Welcome to Udemy0:37
The Udemy Interface3:05
Do you want auto-translated subtitles in more languages?1:20
Curriculum4:19
Resources0:07

5. The SELECT and FROM clauses6:31
4. Renaming fields (using column aliases), including using the AS keyword6:20
5. Semicolons and comments3:20
5, 9. The WHERE clause6:10
Learn how the where clause filters results in Oracle SQL, using equals, greater than, less than, and not equal operators, with examples on col_hash and column_number.
5, 6d. The GROUP BY clause and the DISTINCT keyword6:19
5, 21. The HAVING clause, and information about error messages.4:19
Learn how the having clause filters grouped results after a group by using count. Understand why where cannot apply to aggregates and how to diagnose errors like Ora 00934.
13a, 13c. The ORDER BY clause5:18
Master the order by clause, the sixth clause of the select statement, to sort by one or multiple columns in ascending or descending order with best practices for column names.
Remembering the order of the clauses2:08
Learn the six clause order in SQL: select, from, where, group by, having, and order by, using a keyboard mnemonic and practice activities in Oracle SQL Developer.
Practice Activity Number 10:23
Practice Activity Number 1 - The Solution3:14

7, 8. Using the DUAL table, and rules of precedence for arithmetic expressions5:22
Practice Activity Number 3 - Writing mathematical queries0:21
Practice Activity Number 3 - The Solution2:15
Practice Oracle SQL arithmetic by evaluating four plus nine and 24 times four plus three, with aliases like my answer and balance, noting precedence and parentheses, from dual by version.
40. Creating sample table; Run Script v Run Statement4:15
41. The NUMBER data type7:53
Do you want to use the comma as a decimal point?3:24
8a. FLOATing data types4:16
Explore Oracle SQL float data types, including binary float and binary double, and why they store decimal numbers imprecisely, versus number, numeric, or decimal for accurate storage.
Practice Activity Number 40:19
Practice Activity Number 4 - The Solution3:12
Practice activity demonstrates creating a table, inserting and viewing data, and removing data and the table using create table, insert into, select, delete or truncate, and drop table.

Numeric functions: POWER, SQRT, EXP, LN, LOG, ABS, SIGN and trigonometric6:30
Explore Oracle numeric and trigonometric functions, including power, square root, exp, ln, log, abs, sign, and trig and hyperbolic functions, with practical examples and radians considerations.
15. Rounding functions, including ROUND, TRUNC and MOD functions7:42
Practice Activity Number 50:30
Practice Activity Number 5 - The Solution2:44

6. Using CHAR and VCHAR with concatenation operator, literal character strings8:17
Explore char and varchar2 string types, their fixed vs variable lengths, and concatenation using the || operator; learn about literal strings, the alternative quote operator, and length versus lengthb.
NCHAR and NVARCHAR Character Data Types8:57
13. String Functions8:12
7b. NULL - an introduction5:57
7b, 17. Useful NULL functions6:11
Practice Activity Number 50:45
Practice Activity Number 5 - The Solution4:31

18. Joining a string to a number using implicit conversions4:06
19a, 20. Converting a number to a string - Part 16:05
19a. Converting a number to a string - Part 24:59
19b. Converting a string to a number, including the CAST function4:50
5a, 14b. International conversions6:28
Explore how to convert text to numbers and numbers to strings in non-american formats using to_number, to_char, and the NLS parameters for currency and numeric characters.
Practice Activity Number 60:22
Practice Activity Number 6 - The Solution2:45
Practice conversion to char and formatting with a dollar format to display numbers rounded to two decimals, using fm to trim spaces, and convert back with to_number using dollar 99999.99.

DATE and TIMESTAMP() data types7:04
14, 16. Date extraction functions8:02
19a. Converting dates to strings7:19
Explore converting dates to strings by formatting with to_char, combining with strings, and controlling year, month, day displays using fill mode, case, and iso options.
19a. Converting times to strings4:37
19c. Converting strings to timestamps using the TO_DATE conversion function6:58
Master converting strings to dates with Oracle's to_date, craft custom format models, handle locales, and use RR and FF options to interpret two-digit years and ensure exact matches.
Practice Activity Number 70:50
Practice Activity Number 7 - The Solution3:58

Requirements

You need to know how to use a computer, and hopefully know how to use a spreadsheet.
No prior knowledge of Oracle SQL Database or any other database required - although the more knowledge you do have, the better.
To install Oracle SQL Database on your computer, you will need a 64-bit machine.
Oracle SQL Database cannot easily be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
You don't even need Oracle SQL Database installed - I'll show you have to install it on your computer for free!
Why not have a look at the curriculum below and see what you can learn?

Description

This course is the foundation for the Oracle AI Database SQL 1Z0-171 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access.

Please note: This course is not affiliated with, endorsed by, or sponsored by Oracle. Also note: The name of the Oracle Database is "Oracle AI Database". The 1Z0-171 certification does not require the knowledge of any AI.

We'll install for free Oracle Express Edition and Oracle SQL Developer. Then we'll take a look at the 6 principal clauses of the SELECT statement: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
Then we'll start creating tables, but find that we can't get very far without understanding data types. We'll then look at string, date and number types and functions, together with looking at functions converting between them.
We'll revisit the SELECT statement and go into more detail. We'll create tables and JOIN them together. Once you have finished this session, you should be secure in your knowledge of the 6 principal clauses of the SELECT statement, the most important part of Oracle SQL.
We'll then looking for missing data, and find out how to delete and update data. We'll look at the difference between implicit and explicit transactions, and various constraints, including primary and foreign keys.
We'll start off by saving our queries in views. Then we'll combine tables, not by adding additional columns using JOINS, but adding additional rows such Oracle SQL set operators such as UNION, INTERSECT and MERGE.
We'll add totals to our SELECT queries. We'll then look at subqueries, and how you can add them into the FROM, SELECT and WHERE clauses, and also into the WITH clause. We'll also look at Oracle SQL self-joins, which are useful when you have hierarchies.
Finally, TIME ZONE and INTERVAL data types and functions. We'll then have a look at SEQUENCEs and INDEXes, together with how these are shown in the Data Dictionary. We'll then create new users, and assign privileges and roles to them, and we'll finish with the last few requirements for the exam.

No prior knowledge is required - we'll even install Oracle Database and Oracle SQL Developer on your computer for free!

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in Oracle SQL.

Who this course is for:

This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required.

1Z0-171 exam prep: Oracle AI Database SQL Associate

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 12min

Install Oracle Express Edition and SQL Developer3 lectures • 18min

The SELECT statement - an overview10 lectures • 44min

8b. Session 1 - Creating tables - First pass5 lectures • 13min

Session 1 - The DUAL table and Number types9 lectures • 31min

Session 1 - Number functions4 lectures • 17min

Session 1 - String data types and functions7 lectures • 43min

Session 1 - Converting numbers to strings, and strings to numbers7 lectures • 30min

Session 1 - Date data types and functions7 lectures • 39min

Creating and querying part of a table5 lectures • 40min

Requirements

Description

Who this course is for: