Oracle Database 12c SQL Fundamentals

This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.

The target audience is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: 

• Business and non-IT professionals 
• Application designers and database developers 
• Business Intelligence (BI) analysts and consumers 
• Database administrators 
• Web server administrators

Course Outline

1. Relational Databases & Data Models
2. Selection & Setup of the Database Interface
3. Using the Database Interface
4. Introduction to the SQL Language
5. The Select Statement
6. Restricting Results with the Where Clause
7. Sorting Data with the Order By Clause
8. Pseudo Columns, Functions & Top-N Queries
9. Joining Tables
10. Using the Set Operators
11. Summary Functions Using Sub-Queries
12. Aggregating Data within Groups
13. Use DDL to Create & Manage Tables
14. Use DML to Manipulate Data
15. Understanding the Data Models
16. About the SQL-99 Standard
17. Enhancing Groups with Rollup & Cube
18. SQL Functions: Character Handling
19. SQL Functions: Numeric Handling
20. SQL Functions: Date Handling
21. Database Objects: About Database Objects
22. Database Objects: Relational Views
23. Database Objects: Indexes
24. Database Objects: Creating Other Objects
25. Database Objects: Object Management Using DDL
26. Database Objects: Security
27. Data Integrity Using Constraints
28. Managing Constraint Definitions
29. The Data Dictionary Structure