DISCLOSURE: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
 |
| 1Z0-071 Learn Oracle SQL: prepare for Certified Associate |
Session 1
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.
Session 2
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 SQL.
Session 3
In session 3, we'll 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.
Session 4
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 as UNION, INTERSECT and MERGE. Then we'll look at analytical functions using the OVER clause.
Session 5
Session 5 starts off by adding 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. Finally, we'll look at the self-joins, which are useful when you have hierarchies.
Session 6
Session 6 starts off with two additional data types, 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 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.
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.
- Get the course
