Oracle 11g SQL Fundamentals I

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

Related Scheduled Courses