RelationalDBDesign  
prev next prev next
  Course navigation
 
Lesson 1
Course introduction
Module introduction
   
Welcome to the second course in the Introduction to Oracle Certification Series, Programming in PL/SQL.
As the name implies, this series focuses on preparing you for certification in Oracle.
What is this series about?
The information covered in this series helps you get started on the Oracle8 Certified Database Administrator and/or Certified Application Developer tracks. Another important goal of this series is to enable you to create advanced SQL queries, write beginning to intermediate PL/SQL blocks, and familiarize you with Oracle's unique SQL extensions.
PL/SQL is an integral part of the Oracle database engine.
This course will introduce you to PL/SQL and explain how you can build PL/SQL programming structures. PL stands for Procedural Language.
This language offers procedural techniques to build your SQL (Structured Query Language) commands.
You can use this language to construct procedures, triggers, functions, packages, and more.
Course goals
After completing the course, you will be able to:
  1. Describe the basic structure of a PL/SQL block
  2. Create a nested PL/SQL block
  3. Describe the different PL/SQL and non-PL/SQL variables
  4. Identify the scope of variables when using nested blocks
  5. Apply best practices for naming conventions and commenting your code
  6. Gain an overview of the different PL/SQL datatypes, including composite datatypes such as PL/SQL RECORD and TABLE
  7. Place identifiers and use literals and operators within a PL/SQL block
  8. Build logic by using PL/SQL control structures, including loops, labels, and the GOTO statement
  9. Use explicit cursors to process multiple records
  10. Raise implicit and explicit exceptions
Learning Technologies
In this course, you will learn and practice PL/SQL skills with many kinds of applets, including MouseOvers, and Slide Shows.
The series
Programming in PL/SQL is the second of three courses in the Introduction to Oracle Certification Series.
In the next lesson, the Oracle PL/SQL Course Prerequisites will be discussed.
Advanced Structured Query Language  
Characteristics of SQL Group By Clause Sub-Select Statements Sub-Select Equals Clause
Basic Structured Query Language  
DB Normalization - Exercise Relational DB Analogy Relational vs. Flatfile Customer Table Example
SQL Approaches - Quiz SQL-92
Database Creation Architecture    
Oracle Describe Command Oracle Spool Command Oracle Exit Command desc oracle command
Start Server Manager Locating Oracle Home Server Manager Executable Server Manager HELP Command
Set output off - Oracle
Managing Database Objects   
Oracle Segment Role Alter extent size table Tablespace Fragmentation Quiz Operating system blocks
Oracle Extents Free Diction-Quiz Oracle Storage Concepts Describing Columns View
Coalesce Tablespace Oracle Tablespace Default Storage Fragmented TableSpace Oracle Extents Data Dictionary
Oracle Dictionary Extents Oracle storage management concepts Oracle free space Auction House Database
Oracle Network Topology  
Location Independence Transparent NS Distributed Databases Searching Oracle Topology
Hardware Independence
Oracle SQL Tuning  
Heuristics Based Optimizer Oracle Explain Plan Utility SQL Tuning Quiz Decode ansi standard sql
PL/SQL Programming   
dbms_out.put_line in sql Petstore schema pl sql dbms_output Building Queries with PL/SQL
non pl/sql variables bind and host (PGA) Program Global Area Pet Store DataModel Adding PL/SQL Comments
PL/SQL Block Conclusion Oracle Naming Conventions
Define: Truth Table Define: Unary Define: Pragma
Relational Database Analysis  
Define Primary Key Concatenated Keys Normalization First Normal Form Exercise
DB Tables Characteristics Database Design Diagram Second Normal Form - Exercise Normalization Process - Quiz
Referential Integrity Defining Foreign Keys Functional Dependencies - Exercise Normalization Database - Quiz
Relational Theory Notation Achieving 2nd Normal Form
Relational Database Design  
Design Stages in DBLC ERD Modeling CaseStudy Three Schema Architecture Database LifeCycle
Database Design - Quiz Database Design Strategy RDBMS Functions Relational DB Design
Relational DB Design Quiz Post Database Design Stages Top Down Design Relational Database Course Project
ERD Exercise Bottom-up Design