• Oracle Database 23ai SQL Associate - 1Z0-171

Oracle Database 23ai SQL Associate - 1Z0-171

Oracle Database 23ai SQL Associate is for new Database Professionals such as Database Developers, Database Administrators, Data Warehouse Administrators, Database Designers or Support Engineers seeking an entry level understanding of the Oracle Database. 

The Oracle Database 23ai SQL Associate course will help you with the understanding of fundamental SQL concepts needed to interact with database tables and other objects. 

This course will help you to pass the Oracle Database 23ai SQL Associate | 1Z0-171 exam which illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. You will acquire a working knowledge of select , insert, update, delete and merge SQL statements as well as some Data Definition Language and Data Control Language statements. Additionally, this course demonstrates your knowledge of working with database objects such as tables, indexes, views and sequences. 

By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language, ER Models and using SQL to create and manipulate tables in an Oracle Database. Qualified candidates have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.

On successful Completion of the Fundamentals of Modelling course you will be able to:


  • Relational Database Concepts
  • Retrieving Data using the SQL SELECT Statement and Restricting and Sorting Data
  • Using Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using SET Operators
  • Managing Tables using DML statements
  • Managing Indexes Synonyms and Sequences
  • Use DDL to manage tables and their relationships
  • Controlling User Access
  • Managing Objects with Data Dictionary Views and Data in Different Time Zones
Course Requirements
Prerequisites Working knowledge of Data Processing or Relational databases.
Target Audience
Audience Database Developers Database Administrators Business Intelligence Developers

Write a review

Please login or register to review

Oracle Database 23ai SQL Associate - 1Z0-171

  • Brand: Weblearning Publishing
  • Product Code: Oracle Database 23ai SQL Associate - 1Z0-171
  • Reward Points: 100
  • Availability: In Stock
  • £89.99
  • £79.99

  • Price in reward points: 1200

  • 2 or more £69.99
  • 4 or more £63.99

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai SQL Workshop

Oracle Database 23ai SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Big Data Unlimited

Big Data Unlimited

Big Data Unlimited Cloud Learning SubscriptionThe Big Data  Unlimited Cloud Learning Subsc..

£365.00 £399.00

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..

£249.00 £279.00

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..

£124.00 £149.99

Tags: Database Management, Oracle Database, SQL, DBA