1Z0-171: Oracle Database 23ai SQL Associate
1Z0-171: Oracle Database 23ai SQL Associate
The SELECT statement, functions and more. Oracle Database 19c, 21c, 23c, 23ai using Oracle SQL Developer. 1Z0-171 exam.
Product Brand: Udemy
5
Udemy Coupon Code for 1Z0-171: Oracle Database 23ai SQL Associate Course. The SELECT statement, functions and more. Oracle Database 19c, 21c, 23c, 23ai using Oracle SQL Developer. 1Z0-171 exam.
Created by Phillip Burton | 14.5 hours on-demand video course
Oracle Database Course Overview
1Z0-171: Oracle Database 23ai SQL Associate
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.
- 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.
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
Top Oracle SQL Courses Online for 2024
Oracle SQL Performance Tuning Masterclass (2024) Course
Oracle SQL Performance Tuning Masterclass (2024) Best seller
Welcome the most comprehensive Oracle SQL Performance Tuning Masterclass (2024) course on the planet that makes you an expert on SQL & Performance Tuning! The most common problem of working with SQL is performance problems. Most of the developers don’t know how to write well-performing queries. So in time, this problem grows and becomes a problem for both the developer and the company.
The Complete Oracle SQL Bootcamp (2024) Course
The Complete Oracle SQL Bootcamp (2024) Best seller
In this The Complete Oracle SQL Bootcamp (2024) course, all the subjects are explained in professional order. If you are new to SQL, no problem! You can easily learn all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects. After completing this course, you will learn all that you need to know. If you don’t see something in this course, it means you really don’t need to know it for now. Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.
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.
Recommended Course
PL-300 certification: Microsoft Power BI Data Analyst Best seller
70-461, 761: Querying Microsoft SQL Server with Transact-SQL Best seller
Taught by Phillip Burton
