1Z0-171 exam prep: Oracle AI Database SQL Associate

About this course

This course is the foundation for the Oracle AI Database SQL 1Z0-171 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access.Please note: This course is not affiliated with, endorsed by, or sponsored by Oracle. Also note: The name of the Oracle Database is "Oracle AI Database". The 1Z0-171 certification does not require the knowledge of any AI.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 hav