Loading Course Schedule...
PT7007
Summary
This training course book helps prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed. This training course book is a common starting point in the Oracle database curriculum for administrators, developers and business users.
Prerequisites
-Enterprise Architectures for Executives-Relational Database Design & Data Modeling
Duration
3 Days/Lecture & Lab
Audience
The target audience for this training course is all Oracle professionals, both business and systems professionals, who wish to pass the Oracle certification exams and need a "how to" guide to acquire the knowledge of SQL. Among the specific groups for whom this course will be helpful are:-Application designers and developers-Database administrators-Business users and non-technical senior end use
Topics
- Relational Databases & SQL
- Choosing a SQL & Pl/SQL Interface
- Building a Select Statement
- Restricting Data with the Where Clause
- Sorting Data with the Order by Clause
- Pseudo Columns & Functions
- Joining Tables
- Using the Set Operators
- Summary Functions
- Using Sub-Queries
- Aggregating Data within Groups
- Build Simple SQL
- Use Data Definition Language to Create & Manage Tables
- Use Data Manipulation Language to Manipulate Data
- Appendix A