COURSE OBJECTIVE
This course helps you write subqueries, combine multiple queries into a singlequery using SET operators and report aggregated data using group functions. Learn this and more through hands-onexercises.
WHO CAN BENEFIT
- Application Developers
- System Analysts
- Business Analysts
- Forms Developer
- Developer
- Data Warehouse Administrator
- PL/SQL Developer
GAINING SKILLS
After completing this course, students will be able to:
- Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Learn Advanced Features of SQL
- This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction. Use Development Tools The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g and 11g audience.
COURSE CERTIFICATION
OCA
PREREQUISITE
Before attending this course, students must have:
- Data processing
- Familiarity with data processing concepts and techniques
COURSE CONTENT
- Introduction to Oracle Database
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to Customize Output
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data From Multiple Tables Using Joins
- Use Sub-queries to Solve Queries
- The SET Operators
- Data Manipulation Statements
- Use of DDL Statements to Create and Manage Tables
- Other Schema Objects
- Control User Access
- Management of Schema Objects
- Manage Objects with Data Dictionary Views
- Manipulate Large Data Sets
- Data Management in different Time Zones
- Retrieve Data Using Sub-queries
- Regular Expression Support
ABOUT INSTRUCTOR
