Oracle Database 23ai: SQL Workshop
This course is designed for Developers and Database Administrators, beginning with the foundational concepts of relational databases and the SQL programming language. It covers writing queries against single and multiple tables, manipulating data within tables, and creating database objects. Participants will learn how to create sequences, synonyms, indexes, and views, manage schema objects, and handle data using subqueries. The course also covers controlling user access and managing data in different time zones.
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:
Understand the core concepts of Oracle Database 23ai and its related products
Learn relational database management concepts and terminologies.
Utilise SQL to query databases effectively.
Retrieve, restrict, and sort data using SQL statements.
Customise output using single-row functions.
Convert data types and use conditional expressions.
Report aggregated data using group functions.
Display data from multiple tables using joins.
Solve queries using subqueries.
Use set operators for data manipulation.
Manage tables using DML statements.
Create and manage database objects including sequences, synonyms, indexes, and views.
Control user access and privileges.
Manage data across different time zones.
Course Requirements
Prerequisites
Familiarity with data processing concepts and techniques
Familiarity with programming languages
Knowledge and understanding of Database management systems
Target Audience
Audience
Database Administrators
Data Warehouse Administrators
Database Designers
Support Engineers
Oracle Database 23ai: SQL Workshop
Brand: Weblearning Publishing
Product Code: Oracle Database 23ai: SQL Workshop
Reward Points: 150
Availability: In Stock
£99.99
£84.99
Price in reward points: 1200
2 or more £81.99
4 or more £76.99
Related Products
Oracle Database SQL Workshop
This course is a combination of Oracle Database: SQL Workshop ..
£72.99 £89.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£59.99 £79.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£59.99 £79.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£23.99 £29.99
Add to Cart
Oracle Database 12c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083
The WebLearning Oracle D..
£89.99 £129.99
Add to Cart
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083
The WebLearning Oracle D..
£94.99 £139.99
Add to Cart
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083
The WebLearning Oracle D..
£94.99 £139.99
Add to Cart
Oracle Database 12c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083
The WebLearning Oracle D..
£89.99 £129.99
Add to Cart
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071
The WebLearning Oracle Database 19..
£79.99 £99.99
Add to Cart
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083
The WebLearning Oracle D..
£36.99 £49.99
Add to Cart
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071
The WebLearning Oracle Database 19..
£79.99 £99.99
Add to Cart
Oracle Database 19c: DBA OCA & OCP Certification 1Z0-082 and 1Z0-083
The WebLearning Oracle D..
£110.99 £159.99
Add to Cart
Oracle Database 19c: DBA OCA Certification 1Z0-082 and 1Z0-071
The WebLearning Oracle Database 19..
£89.99 £129.99
Add to Cart
Oracle Database SQL Workshop I
This course will assist in preparation for the Oracle Database SQL..
£59.99 £69.99
Add to Cart
Oracle Database 23ai SQL Associate - 1Z0-171
Oracle Database 23ai SQL Associate is for new Databa..
£69.99 £89.99
Add to Cart
Oracle Database 23ai: Administration Workshop
This course is targeted at Database Administrators ..
£129.99 £149.99
Add to Cart
Oracle Database SQL Workshop II
This course will assist in preparation for the Oracle Database SQ..
£64.99 £79.99
Add to Cart
Oracle Database SQL Workshop II
This course will assist in preparation for the Oracle Database SQ..
£62.99 £69.99
Add to Cart
Oracle Database SQL Workshop II
This course will assist in preparation for the Oracle Database SQ..
£21.99 £31.99
Add to Cart
Oracle Database 12c SQL & PL/SQL Fundamentals
This course will assist in preparation for the ..
£61.99 £79.99
Add to Cart
Oracle Database 12c SQL & PL/SQL Fundamentals
This course will assist in preparation for the ..
£61.99 £79.99
Add to Cart
Oracle Database 12c SQL & PL/SQL Fundamentals
This course will assist in preparation for the ..
£21.99 £31.99
Add to Cart
Oracle Database 19c SQL & PL/SQL Fundamentals
This course will assist in preparation for the ..
£61.99 £79.99
Add to Cart
Oracle Database 19c SQL & PL/SQL Fundamentals
This course will assist in preparation for the ..
£61.99 £79.99
Add to Cart
Oracle Database 19c SQL & PL/SQL Fundamentals
This course will assist in preparation for the ..
£21.99 £31.99
Add to Cart
Financial Management Unlimited Cloud Learning Subscription
The Financial Management Unlimited Clo..
£700.99 £750.00
Add to Cart
Oracle Database 19c PL/SQL Fundamentals
This course introduces students to the fundamentals of PL..
£61.99 £79.99
Add to Cart
Oracle Database 19c PL/SQL Fundamentals
This course introduces students to the fundamentals of PL..
£61.99 £79.99
Add to Cart
Oracle Database 19c PL/SQL Fundamentals
This course introduces students to the fundamentals of PL..
£21.99 £31.99
Add to Cart
Oracle Database 19c PL/SQL Fundamentals
This course introduces students to the fundamentals of PL..
£21.99 £31.99
Add to Cart
Oracle Database 19c: Program with PL/SQL Units
This Oracle Database: PL/SQL Program Units course ..
£69.99 £89.99
Add to Cart
Oracle Database 19c: Program with PL/SQL Units
This Oracle Database: PL/SQL Program Units course ..
£69.99 £89.99
Add to Cart
Oracle Database PL/SQL Developer Workshop
The Oracle Database 19c: PL/SQL Workshop course provide..
£74.99 £92.99
Add to Cart
Developing SQL Queries for Oracle Databases
This Oracle SQL Queries training course will help you..
£69.99 £79.99
Add to Cart
Oracle Database Development Fundamentals
The Oracle Database 19c Development Fundamentals course ..
£76.99 £94.99
Add to Cart
Oracle Database Development Fundamentals
The Oracle Database 19c Development Fundamentals course ..
£76.99 £94.99
Add to Cart
Oracle Database: Develop PL/SQL Program Units
This Oracle Database: Develop PL/SQL Program Units ..
£73.99 £92.99
Add to Cart
Enterprise Resource Planning Unlimited Subscription
The Enterprise Resource Planning Unlimited Cl..
£1,450.00 £1,520.00
Add to Cart
Oracle Database: Develop PL/SQL Program Units
This Oracle Database: Develop PL/SQL Program Units ..
£76.99 £92.99
Add to Cart
IBM DB2 11.5 Quickstart for Experienced Relational DBAs
This course provides cross-training for a..
£69.99 £92.99
Add to Cart
IBM DB2 11.5 Quickstart for Experienced Relational DBAs
This course provides cross-training for a..
£69.99 £92.99
Add to Cart
Oracle 19c and Microsoft SQL Server 2019 Database Development and Administration
The Oracle and M..
£99.99 £129.99
Add to Cart
Oracle 19c and Microsoft SQL Server 2019 Database Development and Administration
The Oracle and M..
£99.99 £129.99
Add to Cart
Oracle Database 19c and SQL Server 2019 Data Warehousing
The Oracle 19c and Microsoft SQL Server ..
£89.99 £129.99
Add to Cart
Oracle 19c and Microsoft SQL Server 2019 Database Administration
The Oracle and Microsoft Databas..
£89.99 £119.99
Add to Cart
Querying SQL Server Database using Transact-SQL Workshop
The Query SQL Server Database using T-SQ..
£59.99 £79.99
Add to Cart
Querying SQL Server Database using Transact-SQL Workshop
The Query SQL Server Database using T-SQ..
£59.99 £79.99
Add to Cart
Developing Microsoft SQL Server DatabasesThis course is designed for beginners and intermediate deve..
£63.99 £79.99
Add to Cart
Developing Microsoft SQL Server DatabasesThis course is designed for beginners and intermediate deve..
£63.99 £79.99
Add to Cart
Construction & Engineering Project Management Unlimited Subscription
The Construction & E..
£725.00 £795.00
Add to Cart
SQL Server 2022 Database Administration Workshop
This course is designed for beginners and interm..
£79.99 £99.99
Add to Cart
Oracle Analytics and Data Warehousing Unlimited Subscription
The Oracle Analytics and Data Wareho..
£1,050.00 £1,125.00
Add to Cart
SQL Server Database Modelling and Design
The SQL Server Database Modelling and Relational Databas..
£64.99 £89.99
Add to Cart
SQL Server Database Design and Development
The SQL Server Database Design and Development course ..
£64.99 £94.99
Add to Cart
Oracle and SQL Server Database Development
The Weblearning Oracle and SQL Server Database Develop..
£79.99 £94.99
Add to Cart
Oracle and SQL Server Database Development
The Weblearning Oracle and SQL Server Database Develop..
£79.99 £94.99
Add to Cart
Oracle and SQL Server Data Warehousing Boot Camp
The Oracle and SQL Server Data Warehousing Boot ..
£84.99 £99.99
Add to Cart
Oracle and SQL Server Data Warehousing Boot Camp
The Oracle and SQL Server Data Warehousing Boot ..
£84.99 £99.99
Add to Cart
Oracle Business Intelligence and Data Warehousing
The Oracle Business Intelligence, Analytics and..
£69.99 £84.99
Add to Cart
Oracle Data Warehousing Fundamentals
The Oracle Data Warehousing course provides step-by-step ins..
£79.99 £89.99
Add to Cart
IBM DB2 Database Fundamentals
The IBM DB2 Database Fundamentals course provides step-by-step inst..
£69.99 £89.99
Add to Cart
IBM DB2 Database Fundamentals
The IBM DB2 Database Fundamentals course provides step-by-step inst..
£69.99 £89.99
Add to Cart
IBM DB2 11.5 Database Administration
This course is designed for current and aspiring data profes..
£69.99 £92.99
Add to Cart
IBM DB2 11.5 Database Administration
This course is designed for current and aspiring data profes..
£69.99 £92.99
Add to Cart
IBM DB2 Database Design & Development
This database training for beginners and advanced devel..
£69.99 £89.99
Add to Cart
IBM DB2 Database Design & Development
This database training for beginners and advanced devel..
£69.99 £89.99
Add to Cart
IBM DB2 Database SQL Fundamentals
This course provides students with the technical skills require..
£59.99 £89.99
Add to Cart
IBM DB2 Database SQL Fundamentals
This course provides students with the technical skills require..
£59.99 £89.99
Add to Cart
IBM DB2 Database Administration for Oracle DBAs
This course provides cross-training for a DB2 Adm..
£79.99 £97.99
Add to Cart
Oracle WebLogic Server 11g: Administration Fundamentals
This course teaches Web administrators on..
£57.99 £87.99
Add to Cart
Oracle Business Intelligence 11g Administration
The Oracle Business Intelligence 11g Administrati..
£49.99 £69.99
Add to Cart
Oracle 19c Data Warehousing Fundamentals
The Oracle 19c Data Warehousing course provides step-by-..
£69.99 £89.99
Add to Cart
Oracle 21c Data Warehousing Fundamentals
The Oracle 21c Data Warehousing course provides step-by-..
£69.99 £89.99
Add to Cart
Oracle Analytics and Data warehousing
The Oracle Analytics and Data Warehousing course provides s..
£72.99 £89.99
Add to Cart
Oracle Advanced Analytics: Concepts and Techniques
The Oracle Advanced Analytics: Concepts and Te..
£79.99 £99.99
Add to Cart
Introduction to Machine Learning Algorithms
This course introduces you to the most commonly used ..
£59.99 £89.99
Add to Cart
Predictive Analytics using SQL Server Machine Learning
The course begins with an introduction to ..
£69.99 £89.99
Add to Cart
Oracle Database Administration for Microsoft SQL Server DBAs
The Oracle Database Administration f..
£91.99 £129.99
Add to Cart
IBM DB2 Database Administration for SQL Server DBA's
The IBM DB2 Administration for SQL Server&nb..
£89.99 £119.99
Add to Cart
Microsoft SQL Server Database Administration for Oracle DBAs
The Microsoft SQL Server Database Ad..
£84.99 £129.99
Add to Cart
Oracle WebLogic Server 11g: Advanced Administration
This course teaches Developers and Web admini..
£67.99 £99.99
Add to Cart
Oracle WebLogic Server 11g: System Administration I
This course teaches Developers and Web ..
£69.99 £99.99
Add to Cart
Oracle WebLogic Server 12c: Administration I
This course teaches administrators the most im..
£69.99 £99.99
Add to Cart
Oracle WebLogic Server 12c: Administration I I
This course teaches Developers and Web administrat..
£79.99 £129.99
Add to Cart
Oracle Identity and Security Management Essentials
The WebLearning Oracle Identity and Security M..
£69.99 £89.99
Add to Cart
Fundamentals of the Java Programming Language, Java SE
This course will assist in preparation for..
£59.99 £69.99
Add to Cart
SQL Server Data Warehousing Fundamentals
The Microsoft SQL Server Data Warehousing Fundamentals c..
£69.99 £89.99
Add to Cart
SQL Server 2019 Database Administration Workshop
This course is designed for beginners and interm..
£79.99 £99.99
Add to Cart
Business Analytics Unlimited
The Business Analytics Unlimited Cloud Learning Subscription is a co..
£1,100.00 £1,299.00
Add to Cart
Business Intelligence Unlimited Subscription
The Business Intelligence Unlimited Cloud Learn..
£255.00 £288.00
Add to Cart
Peoplesoft Financials Unlimited Cloud Learning Subscription
The Peoplesoft Financials Unlimi..
£740.99 £799.00
Add to Cart
Microsoft Analytics and Data Warehouse Unlimited
The Microsoft Analytics & Data Warehousing U..
£470.00 £525.00
Add to Cart
Oracle BI and Data Warehouse Unlimited Subscription
The Oracle BI and Data Warehousing Unlim..
£250.00 £299.00
Add to Cart
Supply Chain Management Unlimited Subscription
The Supply chain management Unlimited Cloud L..
£1,100.00 £1,250.00
Add to Cart
Oracle Database 23ai: New Features for Administrators
This course covers the latest additions and..
£149.99 £179.99
Add to Cart
Tags:
Database Management ,
Oracle ,
Database ,
23ai ,
SQL ,
DBA ,
AI ,
Artificial Intelligence ,
Machine Learning