Oracle Database 11g R2: SQL Fundamentals

PT9438
Summary
This courses teaches all of the necessary coding skills to write basic SQL statements, subqueries and multiple queries. Students will gain an understanding of Relational Databases and learn about the data types used in Oracle database tables, how to modify data and execute queries through the use of Oracle SQL's Data Manipulation Language (DML). It will also prepare students for the Oracle certification exams (OCP).
Prerequisites
No mandatory prerequisites exist for this course. However, one or more of the following courses are suggested prerequisites: ENTERPRISE ARCHITECTURES FOR EXECUTIVES or DATA MODELING: LOGICAL DATABASE DESIGN
Duration
5 Days/Lecture & Lab
Audience
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. Further, this course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. Among the specific groups for whom this course will be helpful are application developers and database administrators.
Topics
  • Relational databases and SQL
  • Choosing an SQL & PL/SQL Interface
  • Building Select Statement
  • Restricting Data with the Where clause
  • Using the Set operators
  • Summary functions
  • Using Sub-queries
  • Aggregating data within groups
  • Build sample SQL*Plus reports
  • Use data definition language to create and manage tables
  • Use data manipulation language to manipulate data
  • SQl99 Join Techniques
  • Enhancing groups with Rollup and Cube
  • Using the Case expression SQL functions: Character
  • SQL functions
  • Database objects
  • Data integrity using constraints
  • Managing constraint definitions
  • Advanced SQL*Plus reports
  • Building SQL*Plus scripts
  • SQL*Plus session control

Related Scheduled Courses