Session 5 starts off by adding totals to our SELECT queries. Then we'll look at analytical functions using the OVER clause. 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 start off by saving our queries in views. We'll look at the difference between implicit and explicit transactions, and various constraints, including primary and foreign keys.
#Oracle database sql 1z0 071 how to
In session 3, we'll looking for missing data, and find out how to delete and update data. 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 create tables and JOIN them together. We'll revisit the SELECT statement and go into more detail. We'll then look at string, date and number types and functions, together with looking at functions converting between them. Then we'll start creating tables, but find that we can't get very far without understanding data types. Then we'll take a look at the 6 principal clauses of the SELECT statement: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
#Oracle database sql 1z0 071 for free
We'll install for free Oracle Express Edition and Oracle SQL Developer. It is divided into 6 sessions, each of which should take a morning or afternoon to complete. It covers the SELECT statement in detail, with additional requirements for controlling user access.
This course is the foundation for the Oracle Database SQL 1Z0-071 certification.
0 kommentar(er)
