Oracle SQL - From Beginner to Pro

Visit Tutorial Page ( Report)
This course introduces the learner to all facets of Oracle SQL programming. The course begins with a section on relational database theory, moves onto cover the data definition components of SQL, the data manipulation components of SQL and then does a deep dive on queries. The course culminates with a overview of user-defined objects, collections, XML, large objects and performance. The course is fast paced and targeted toward aggressive learners. Each of Dr. Phillips' examples, as well his lecture scripts, are provided as resource materials. Dr. Phillips shares many valuable experiences from both his academic and real-world careers. This course is highly recommended for anyone seeking to advance their career by adding Oracle SQL programming to their technical toolbox as well as those seeking Oracle certification.
  • Course Overview and Foundation
    • Introduction

      This lecture will introduce the student to the course and layout a roadmap for moving forward. Rick Phillips, the instructor, will introduce himself and explain his background before providing an outline of the course. This lecture will culminate with a brief discussion of Rick's presentation style as well as the expectations placed on students.

  • Software Setup
    • Download and Install Toolset

      In this lecture the student will learn how to download and install Oracle Express Edition, SQL*PLUS, SQL Developer and MySQL Workbench. These free software tools will be used throughout the remainder of the course.

  • Relational Database Theory
    • Relational Database Terminology

      This lecture will introduce the student to common relational database terminology.

    • Interview the Data

      In this lecture the student will be shown how to "interview the data." This process involves interviewing the data owners and also reviewing all historical system in an effort to establish a preliminary list of entities, attributes and relationships. This information is then validated against the data owner and documented in preparation for normalization.

    • Normalization

      In this lecture the student will learn how to take entity, attribute and relationship information and normalize it through Boyce-Codd 3NF. The normalization process is required to ensure proper SQL execution.

    • ER Diagrams

      In this lecture the student will learn how to graphically document a schema design using standard ER Diagramming techniques; i.e. Entity-Relationship

  • Schema Creation
    • Schema Creation Part 1
    • Schema Creation Part 2
    • Schema Creation Part 3
    • Schema Modification
  • Data Manipulation Language
    • Data Manipulation Language
  • Queries
    • Single Table Selects Part 1
    • Single Table Selects Part 2
    • Multi-table Queries
    • Subqueries
    • Set Operators, Translate and Replace
    • Advanced Queries
  • PL/SQL
    • Advanced Queries
    • PL/SQL Functions
    • PL/SQL Triggers and Packages
  • Less Frequently Used Oracle Constructs
    • User-Defined Types
    • Collections
    • LOBs
    • XML
    • Performance Part 1
    • Performance Part 2
  • Summary and Conclusion
    • Wrap up
Write Your Review