Oracle Database 11g R2: SQL Fundamentals I
- 2h 52m
- Sideris Courseware Corporation
- Sideris
- 2011
This Oracle 11g courseware training guide book will provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.
Audience
Target audience for this course is all Oracle professionals. 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 users
In this Book
-
Course Introduction
-
Workshop Setup Guide
-
About Database Technologies & Relational Databases
-
Using the Database Interface
-
Using the Database Interface
-
About SQL & Building a SELECT Statement
-
About SQL & Building a SELECT Statement
-
Restricting Data with the WHERE Clause
-
Restricting Data with the WHERE Clause
-
Sorting Data with the ORDER BY Clause
-
Sorting Data with the ORDER BY Clause
-
Pseudo Columns & Functions
-
Pseudo Columns & Functions
-
Joining Tables
-
Joining Tables
-
Using the Set Operators
-
Using the Set Operators
-
Summary Functions
-
Summary Functions
-
Using Sub-Queries
-
Using Sub-Queries
-
Aggregating Data within Groups
-
Aggregating Data within Groups
-
Build Simple SQL*Plus Reports
-
Build Simple SQL*Plus Reports
-
Use Data Definition Language to Create & Manage Tables
-
Use Data Definition Language to Create & Manage Tables
-
Use Data Manipulation Language to Manipulate Data
-
Use Data Manipulation Language to Manipulate Data
SHOW MORE
FREE ACCESS
