This course is the foundation for the Oracle Database SQL 1Z0–071 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or afternoon to complete.
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.
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.
Courses : 7
Specification: 1Z0-071 Oracle Database SQL Developer: Certified Associate
17 reviews for 1Z0-071 Oracle Database SQL Developer: Certified Associate