OFF
IT & SoftwareIT Certifications
1Z0-171: Oracle Database 23ai SQL Associate
★4.7
(900 students)13h 30m
>_ 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
>_ 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?
/ Course Details & Curriculum
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.
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.
Please note: This course is not affiliated with, endorsed by, or sponsored by Oracle.
- 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.
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.
Author and Instructor
P
Phillip Burton, I Do Data Limited
Expert at Udemy
With years of hands-on experience in IT & Software, Phillip Burton, I Do Data Limited has dedicated thousands of hours to teaching and mentorship. This course is the culmination of industry best practices and a proven curriculum that has helped thousands of students transition into professional roles.
Community Feedback
★★★★★
M
Michael Chen
Verified Enrollment
"This 1Z0-171: Oracle Database 23ai SQL Associate course was exactly what I needed. The instructor explains complex IT & Software concepts clearly. Highly recommended!"
S
Sarah Johnson
Verified Enrollment
"I've taken many Udemy courses on IT & Software, but this one stands out. The practical examples helped me land a job."
D
David Smith
Verified Enrollment
"Great value for money. The section on IT Certifications was particularly helpful."
E
Emily Davis
Verified Enrollment
"Excellent structure and pacing. I went from zero to hero in IT & Software thanks to this course. Lifetime access is a huge plus."
Common Questions
Is the "1Z0-171: Oracle Database 23ai SQL Associate" course truly discounted?
Yes. By utilizing our verified 95% coupon, you can enroll in "1Z0-171: Oracle Database 23ai SQL Associate" at a massive discount. This grants you lifetime access to all course materials and updates.
Do I qualify for a certificate upon completion?
Yes. When you enroll with a 95% coupon provided by CoursesWyn, you follow the same path as a paid student and are eligible for the official completion certificate from Udemy.
What happens if the coupon code expires?
Udemy coupons have strict enrollment limits and time windows. If this code expires, we recommend bookmarking this page and checking back daily, as we refresh our deals constantly to find the latest active discounts.
$199.99Save 95%
$9.99
Verified Discount Code
✨Lifetime Access
🏆Official Certificate
📱Access on Mobile/TV
🔄Latest Updated Course
Claim Your Discount Code
XXXXXXXX
CLICK TO SHOW
REVEAL & COPY
$199.99
$9.9995%