In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Course content

• Introducing Oracle Database 11g
• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Displaying Data From Multiple Tables
• Using Sub-queries to Solve Queries
• Using the SET Operators
• Manipulating Data
• Using DDL Statements to Create and Manage Tables
• Creating Other Schema Objects
• Controlling User Access
• Managing Schema Objects
• Managing Objects with Data Dictionary Views
• Manipulating Large Data Sets
• Managing Data in Different Time Zones
• Retrieving Data Using Sub-queries
• Regular Expression Support

• Oracle Database 11g: SQL Fundamentals I
• Previous programming experience
• Oracle Database 11g: SQL Fundamentals II
• Oracle Database 11g: SQL Fundamentals I