Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171
This course introduces students to the fundamentals of SQL & PL/SQL programming using Oracle Database 23ai database technology. In this course students learn the concepts of relational databases and the powerful SQL and PL/SQL programming languages. This course provides the essential SQL & PL/SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
Certification: This course will help you to pass the Oracle Database 23ai SQL Associate | 1Z0-171 exam.
On successful Completion of this course you will be able to:
- Run data definition language (DDL) statements
- Identify the major structural components of the Oracle Database
- Retrieve row and column data from tables with the SELECT statement
- Create reports of sorted and restricted data
- Employ SQL functions to generate and retrieve customized data
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Create reports of aggregated data
- Use the SET operators to create subsets of data
- Run data manipulation statements (DML) to update data
- Employ SQL & PL/SQL functions to generate and retrieve customized data
- Utilise new JSON features and improvements
- Understand and implement SQL enhancements for DML and DDL
- Create PL/SQL Triggers
- Create PL/SQL Stored Procedures and Functions
- Create PL/SQL Packages
| Course Requirements | |
| Prerequisites | Familiarity with data processing concepts and techniques Knowledge and understanding of Database management systems |
| Target Audience | |
| Audience | Database Administrators Data Warehouse Administrators Database Designers Support Engineers |
Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171
- Brand: Weblearning Publishing
- Product Code: Oracle Database 23ai SQL & PL/SQL Development Workshop
- Reward Points: 150
- Availability: In Stock
- £149.99
-
£124.00
- Price in reward points: 1200
-
- 2 or more £114.00
- 4 or more £94.99
Available Options
Related Products
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 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 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 This covers the Data Modelling and Database Devel..
£23.99 £29.99
Oracle Database 12c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 CBT
Oracle Database 12c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 The WebLearning Oracle D..
£89.99 £129.99
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 CBT
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 The WebLearning Oracle D..
£94.99 £139.99
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 eLearning
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 The WebLearning Oracle D..
£94.99 £139.99
Oracle Database 12c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 eLearning
Oracle Database 12c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 The WebLearning Oracle D..
£89.99 £129.99
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071 CBT
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071 The WebLearning Oracle Database 19..
£79.99 £99.99
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 Training Guide
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 The WebLearning Oracle D..
£36.99 £49.99
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071 eLearning
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071 The WebLearning Oracle Database 19..
£79.99 £99.99
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 CBT & Training Guide Bundle
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083 The WebLearning Oracle D..
£110.99 £159.99
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071 CBT & Training Guide Bundle
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071 The WebLearning Oracle Database 19..
£89.99 £129.99
Oracle Database SQL Workshop I CBT
Oracle Database SQL Workshop I This course will assist in preparation for the Oracle Database SQL..
£59.99 £69.99
Oracle Database 23ai SQL Associate - 1Z0-171
Oracle Database 23ai SQL Associate - 1Z0-171 Oracle Database 23ai SQL Associate is for new Databa..
£79.99 £89.99
Oracle Database 23ai Administration Workshop
Oracle Database 23ai: Administration Workshop This course is targeted at Database Administrators ..
£129.99 £149.99
Oracle Database SQL Workshop II
Oracle Database SQL Workshop II This course will assist in preparation for the Oracle Database SQ..
£64.99 £79.99
Oracle Database SQL Workshop II eLearning
Oracle Database SQL Workshop II This course will assist in preparation for the Oracle Database SQ..
£62.99 £69.99
Oracle Database SQL Workshop II Training Guide
Oracle Database SQL Workshop II This course will assist in preparation for the Oracle Database SQ..
£21.99 £31.99
Oracle Database 12c SQL & PL/SQL Fundamentals
Oracle Database 12c SQL & PL/SQL Fundamentals This course will assist in preparation for the ..
£61.99 £79.99
Oracle Database 12c SQL & PL/SQL Fundamentals eLearning
Oracle Database 12c SQL & PL/SQL Fundamentals This course will assist in preparation for the ..
£61.99 £79.99
Oracle Database 12c SQL & PL/SQL Fundamentals Training Guide
Oracle Database 12c SQL & PL/SQL Fundamentals This course will assist in preparation for the ..
£21.99 £31.99
Oracle Database 19c SQL & PL/SQL Fundamentals CBT
Oracle Database 19c SQL & PL/SQL Fundamentals This course will assist in preparation for the ..
£61.99 £79.99
Oracle Database 19c SQL & PL/SQL Fundamentals eLearning
Oracle Database 19c SQL & PL/SQL Fundamentals This course will assist in preparation for the ..
£61.99 £79.99
Oracle Database 19c SQL & PL/SQL Fundamentals Training Guide
Oracle Database 19c SQL & PL/SQL Fundamentals This course will assist in preparation for the ..
£21.99 £31.99
Financial Management Unlimited
Financial Management Unlimited Cloud Learning Subscription The Financial Management Unlimited Clo..
£700.99 £750.00
Oracle Database 19c PL/SQL Fundamentals CBT
Oracle Database 19c PL/SQL Fundamentals This course introduces students to the fundamentals of PL..
£61.99 £79.99
Oracle Database 19c PL/SQL Fundamentals eLearning
Oracle Database 19c PL/SQL Fundamentals This course introduces students to the fundamentals of PL..
£61.99 £79.99
Oracle Database 19c PL/SQL Fundamentals Training Guide
Oracle Database 19c PL/SQL Fundamentals This course introduces students to the fundamentals of PL..
£21.99 £31.99
Oracle Database 19c PL/SQL Fundamentals Training Guide
Oracle Database 19c PL/SQL Fundamentals This course introduces students to the fundamentals of PL..
£21.99 £31.99
Oracle Database 19c: Program with PL/SQL Units CBT
Oracle Database 19c: Program with PL/SQL Units This Oracle Database: PL/SQL Program Units course ..
£69.99 £89.99
Oracle Database 19c: Program with PL/SQL Units eLearning
Oracle Database 19c: Program with PL/SQL Units This Oracle Database: PL/SQL Program Units course ..
£69.99 £89.99
Oracle Database PL/SQL Developer Workshop
Oracle Database PL/SQL Developer Workshop The Oracle Database 19c: PL/SQL Workshop course provide..
£74.99 £92.99
Developing SQL Queries for Oracle Databases
Developing SQL Queries for Oracle Databases This Oracle SQL Queries training course will help you..
£69.99 £79.99
Oracle Database Development Fundamentals CBT
Oracle Database Development Fundamentals The Oracle Database 19c Development Fundamentals course ..
£76.99 £94.99
Oracle Database Development Fundamentals eLearning
Oracle Database Development Fundamentals The Oracle Database 19c Development Fundamentals course ..
£76.99 £94.99
Oracle Database: Develop PL/SQL Program Units
Oracle Database: Develop PL/SQL Program Units This Oracle Database: Develop PL/SQL Program Units ..
£73.99 £92.99
Enterprise Resource Planning Unlimited Subscription
Enterprise Resource Planning Unlimited Subscription The Enterprise Resource Planning Unlimited Cl..
£1,450.00 £1,520.00
Oracle Database: Develop PL/SQL Program Units eLearning
Oracle Database: Develop PL/SQL Program Units This Oracle Database: Develop PL/SQL Program Units ..
£76.99 £92.99
IBM DB2 11.5 Quickstart for Experienced Relational DBAs
IBM DB2 11.5 Quickstart for Experienced Relational DBAs This course provides cross-training for a..
£69.99 £92.99
IBM DB2 11.5 Quickstart for Experienced Relational DBAs eLearning
IBM DB2 11.5 Quickstart for Experienced Relational DBAs This course provides cross-training for a..
£69.99 £92.99
Oracle 19c and Microsoft SQL Server 2019 Database Development and Administration CBT
Oracle 19c and Microsoft SQL Server 2019 Database Development and Administration The Oracle and M..
£99.99 £129.99
Oracle 19c and Microsoft SQL Server 2019 Database Development and Administration eLearning
Oracle 19c and Microsoft SQL Server 2019 Database Development and Administration The Oracle and M..
£99.99 £129.99
Oracle Database 19c and SQL Server 2019 Data Warehousing
Oracle Database 19c and SQL Server 2019 Data Warehousing The Oracle 19c and Microsoft SQL Server ..
£89.99 £129.99
Oracle Database 19c and SQL Server 2019 Database Administration
Oracle 19c and Microsoft SQL Server 2019 Database Administration The Oracle and Microsoft Databas..
£89.99 £119.99
Querying SQL Server Database using Transact-SQL Workshop CBT
Querying SQL Server Database using Transact-SQL Workshop The Query SQL Server Database using T-SQ..
£59.99 £79.99
Querying SQL Server Database using Transact-SQL Workshop eLearning
Querying SQL Server Database using Transact-SQL Workshop The Query SQL Server Database using T-SQ..
£59.99 £79.99
Developing Microsoft SQL Server Databases Workshop
Developing Microsoft SQL Server DatabasesThis course is designed for beginners and intermediate deve..
£63.99 £79.99
Developing Microsoft SQL Server Databases Workshop eLearning
Developing Microsoft SQL Server DatabasesThis course is designed for beginners and intermediate deve..
£63.99 £79.99
Oracle Database 21c and SQL Server 2022 Database Administration
Oracle 21c and SQL Server 2022 Database Administration The Oracle and Microsoft Database Administ..
£93.99 £129.99
Construction & Engineering Project Management Unlimited Subscription
Construction & Engineering Project Management Unlimited Subscription The Construction & E..
£725.00 £795.00
SQL Server 2022 Database Administration Workshop
SQL Server 2022 Database Administration Workshop This course is designed for beginners and interm..
£79.99 £99.99
Oracle Analytics and Data Warehousing Unlimited Subscription
Oracle Analytics and Data Warehousing Unlimited Subscription The Oracle Analytics and Data Wareho..
£1,050.00 £1,125.00
SQL Server Database Modelling and Design
SQL Server Database Modelling and Design The SQL Server Database Modelling and Relational Databas..
£64.99 £89.99
SQL Server Database Design and Development
SQL Server Database Design and Development The SQL Server Database Design and Development course ..
£64.99 £94.99
Oracle and SQL Server Database Development CBT
Oracle and SQL Server Database Development The Weblearning Oracle and SQL Server Database Develop..
£79.99 £94.99
Oracle and SQL Server Database Development eLearning
Oracle and SQL Server Database Development The Weblearning Oracle and SQL Server Database Develop..
£79.99 £94.99
Oracle and SQL Server Data Warehousing Boot Camp CBT
Oracle and SQL Server Data Warehousing Boot Camp The Oracle and SQL Server Data Warehousing Boot ..
£84.99 £99.99
Oracle and SQL Server Data Warehousing Boot Camp eLearning
Oracle and SQL Server Data Warehousing Boot Camp The Oracle and SQL Server Data Warehousing Boot ..
£84.99 £99.99
Oracle Business Intelligence and Data Warehousing
Oracle Business Intelligence and Data Warehousing The Oracle Business Intelligence, Analytics and..
£69.99 £84.99
Oracle Data Warehousing Fundamentals
Oracle Data Warehousing Fundamentals The Oracle Data Warehousing course provides step-by-step ins..
£79.99 £89.99
IBM DB2 Database Fundamentals CBT
IBM DB2 Database Fundamentals The IBM DB2 Database Fundamentals course provides step-by-step inst..
£69.99 £89.99
IBM DB2 Database Fundamentals eLearning
IBM DB2 Database Fundamentals The IBM DB2 Database Fundamentals course provides step-by-step inst..
£69.99 £89.99
IBM DB2 11.5 Database Administration
IBM DB2 11.5 Database Administration This course is designed for current and aspiring data profes..
£69.99 £92.99
IBM DB2 11.5 Database Administration eLearning
IBM DB2 11.5 Database Administration This course is designed for current and aspiring data profes..
£69.99 £92.99
IBM DB2 Database Design & Development
IBM DB2 Database Design & Development This database training for beginners and advanced devel..
£69.99 £89.99
IBM DB2 Database Design & Development eLearning
IBM DB2 Database Design & Development This database training for beginners and advanced devel..
£69.99 £89.99
IBM DB2 Database SQL Fundamentals CBT
IBM DB2 Database SQL Fundamentals This course provides students with the technical skills require..
£59.99 £89.99
IBM DB2 Database SQL Fundamentals eLearning
IBM DB2 Database SQL Fundamentals This course provides students with the technical skills require..
£59.99 £89.99
IBM DB2 Database Administration for Oracle DBAs
IBM DB2 Database Administration for Oracle DBAs This course provides cross-training for a DB2 Adm..
£79.99 £97.99
Oracle WebLogic Server 11g: Administration Fundamentals
Oracle WebLogic Server 11g: Administration Fundamentals This course teaches Web administrators on..
£57.99 £87.99
Oracle Business Intelligence 11g Administration
Oracle Business Intelligence 11g Administration The Oracle Business Intelligence 11g Administrati..
£49.99 £69.99
Oracle 19c Data Warehousing Fundamentals
Oracle 19c Data Warehousing Fundamentals The Oracle 19c Data Warehousing course provides step-by-..
£69.99 £89.99
Oracle 21c Data Warehousing Fundamentals
Oracle 21c Data Warehousing Fundamentals The Oracle 21c Data Warehousing course provides step-by-..
£69.99 £89.99
Oracle Analytics and Data warehousing
Oracle Analytics and Data warehousing The Oracle Analytics and Data Warehousing course provides s..
£72.99 £89.99
Oracle Advanced Analytics: Concepts and Techniques
Oracle Advanced Analytics: Concepts and Techniques The Oracle Advanced Analytics: Concepts and Te..
£79.99 £99.99
Introduction to Machine Learning Algorithms
Introduction to Machine Learning Algorithms This course introduces you to the most commonly used ..
£59.99 £89.99
Predictive Analytics using SQL Server Machine Learning
Predictive Analytics using SQL Server Machine Learning The course begins with an introduction to ..
£69.99 £89.99
Oracle Database Administration for Microsoft SQL Server DBAs
Oracle Database Administration for Microsoft SQL Server DBAs The Oracle Database Administration f..
£91.99 £129.99
IBM DB2 Database Administration for SQL Server DBA's
IBM DB2 Database Administration for SQL Server DBA's The IBM DB2 Administration for SQL Server&nb..
£89.99 £119.99
Microsoft SQL Server Database Administration for Oracle DBAs
Microsoft SQL Server Database Administration for Oracle DBAs The Microsoft SQL Server Database Ad..
£84.99 £129.99
Oracle WebLogic Server 11g: Advanced Administration
Oracle WebLogic Server 11g: Advanced Administration This course teaches Developers and Web admini..
£67.99 £99.99
Oracle WebLogic Server 11g: System Administration I
Oracle WebLogic Server 11g: System Administration I This course teaches Developers and Web ..
£69.99 £99.99
Oracle WebLogic Server 12c: Administration I
Oracle WebLogic Server 12c: Administration I This course teaches administrators the most im..
£69.99 £99.99
Oracle WebLogic Server 12c: Administration I I
Oracle WebLogic Server 12c: Administration I I This course teaches Developers and Web administrat..
£79.99 £129.99
Oracle Identity and Security Management Essentials
Oracle Identity and Security Management Essentials The WebLearning Oracle Identity and Security M..
£69.99 £89.99
Fundamentals of the Java Programming Language, Java SE
Fundamentals of the Java Programming Language, Java SE This course will assist in preparation for..
£59.99 £69.99
SQL Server Data Warehousing Fundamentals
SQL Server Data Warehousing Fundamentals The Microsoft SQL Server Data Warehousing Fundamentals c..
£69.99 £89.99
SQL Server 2019 Database Administration Workshop
SQL Server 2019 Database Administration Workshop This course is designed for beginners and interm..
£79.99 £99.99
Business Analytics Unlimited
Business Analytics Unlimited The Business Analytics Unlimited Cloud Learning Subscription is a co..
£1,100.00 £1,299.00
Business Intelligence Unlimited
Business Intelligence Unlimited Subscription The Business Intelligence Unlimited Cloud Learn..
£255.00 £288.00
Peoplesoft Financials Unlimited
Peoplesoft Financials Unlimited Cloud Learning Subscription The Peoplesoft Financials Unlimi..
£740.99 £799.00
Microsoft Analytics and Data Warehouse Unlimited
Microsoft Analytics and Data Warehouse Unlimited The Microsoft Analytics & Data Warehousing U..
£470.00 £525.00
Oracle BI and Data Warehouse Unlimited
Oracle BI and Data Warehouse Unlimited Subscription The Oracle BI and Data Warehousing Unlim..
£250.00 £299.00
Supply Chain Management Unlimited
Supply Chain Management Unlimited Subscription The Supply chain management Unlimited Cloud L..
£1,100.00 £1,250.00
Oracle Database 23ai PL/SQL Workshop
Oracle Database 23ai PL/SQL Workshop This course is designed for Developers and Database Administ..
£124.99 £139.99
Oracle Database 23ai New Features for Developers - 1Z0-171
Oracle Database 23ai: New Features for Developers - 1Z0-171 This course focuses on the lates..
£119.99 £149.99
Tags: Database Management, Oracle, Database, 23ai, RAG, SQL, PL/SQL, DBA, AI, Artificial Intelligence, Machine Learning, LLM