There is a difference between using the SQL language in the classroom or in a prototype environment and successfully deploying it as part of a production application. This textbook goes beyond the basics of the SQL language and considers topics that must be addressed in a real-world environment.
Certification
This textbook and the others within this series consider subjects applicable to certification as an Oracle Database Certified SQL Expert. The topics considered are included within "Exam 1Z0-047: Oracle Database: SQL Certified Expert".
The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are:
• Application designers and database developers
• ETL, BI and data analytics developers
• Database and data warehouse administrators
• Web server administrators
Prerequisites
ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II) is a prerequisite to this one. Note further that in order to complete all of the workshop exercises, one will need support from an Oracle 12c database administrator versed in the topics considered in ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP II – ADVANCED ADMINISTRATION.
*Course Cost listed does not include the cost of courseware. Please refer to your Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course subject to minimum enrollment. Courses maybe run as a LDL - Live Distance Learning if minimum enrolled is not met.
In a continuous integration (CI) or continuous deployment (CD) application environment, how does one properly handle disruptive schema changes using the editioning feature?
What best practices should SQL developers employ to achieve optimum performance?
What advanced table types and index types should be included in the schema design to gain performance benefits.
How can complex data scenarios be handled, such as the processing of hierarchies, multimedia object types and others?