Oracle 12c Advanced SQL
Oracle 12c Advanced SQL Course Details:
In this course, you will receive a hands-on introduction to advanced SQL concepts, especially as they relate to Oracle's implementation of the SQL Language. Topics necessary to the development and administration of an Oracle 12c database are covered. This course is specifically designed for those who know generic SQL but are not familiar with SQL*Plus and more importantly, Oracle's implementation of SQL.
No classes are currenty scheduled for this course.
Call (919) 283-1674 to get a class scheduled online or in your area!
- Understanding the Difference Between SQL, SQL*Plus, and PL/SQL
- Understanding the SQL Developer Environment and Commands
2. SQL MODEL Statements
- Symbolic cell addressing
- Symbolic array computation
- Wildcard dimension specification
- Iterative rule evaluation
- Partition wise computation
3. Analytical Functions
- Single Row Analytic Functions
- Aggregating Analytic Functions
- PIVOT / UNPIVOT
- The MODEL clause
4. SQL*Plus Reporting
- SQL*Plus Report Writing Commands
- COLUMN Command / Titles, System Variables
- Master-Detail Report with TITLE and COLUMN Commands
- Control Breaks, Computing Aggregate Amounts
- Using SET Variables in SQL*Plus, SQL to Generate SQL
- Creating, Deferrable, Dropping, Disabling/Enabling Constraints / Displaying Constraint Information
- Handling Exceptions
- Views, Synonyms, Sequences, Indexes, Virtual Columns
- Temporary Tables, External Tables
5. Data Manipulation Language (DML) Commands
- MERGE Command
- Use of Subqueries
- Transaction Control Commands / Read Consistency / Locking
- Flashback Queries
6. Data Definition Language (DDL) Commands
- TRUNCATE, COMMENT, RENAME Command
- Views, Synonyms, Sequences, Indexes, Virtual Columns
- Temporary Tables, External Tables
7. Security
- Users
- Privileges
- Roles
- Authentication Methods
8. Multiple Table Inserts
- Unconditional Insert ALL
- Conditional Insert All
- Conditional Insert First
- Pivoting Insert
- With Statement
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- Create and drop tables, views and indexes
- Understand Structured Query Language
- Format reports using SQL*Plus commands
- Extract and organize information from the database
- Insert, update, and delete information in database tables
Lab 1: Creating Tables And Constraints
Lab 2: Creating Views
Lab 3: Data Manipulation
Lab 4: Single Row Functions
Lab 5: Advanced Joins
Lab 6: Subqueries
Lab 7: Group Functions
Lab 8: Analytic Functions
Lab 9: SQL*Plus Reporting
Lab 10: Advanced DDL
Lab 11: Advanced DML
- Application designers
- Developers
- Database administrators