Oracle Sql From Beginner To Pro

Professional Advancement through Structured Query Language Readiness

Last updated 2022-01-10 | 4.5

- By the end of the course the student will be proficient in relational theory
- all facets of SQL including data definition
- data manipulation and queries
- as well as introduced to PL/SQL
- Oracle XML
- user-defined objects and performance.

What you'll learn

By the end of the course the student will be proficient in relational theory

all facets of SQL including data definition

data manipulation and queries

as well as introduced to PL/SQL

Oracle XML

user-defined objects and performance.

* Requirements

* Successful students should be familiar with at least one programming language.

Description

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.

Who this course is for:

The perfect student is relatively new to programming and is seeking to interface their programs to an Oracle, or other, relational database via SQL.

Course content

9 sections • 50 lectures

Course Overview and Foundation 1 lectures

Introduction Preview 11:28

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 1 lectures

Download and Install Toolset Preview 13:45

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 8 lectures

Relational Database Terminology Preview 11:29

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

Relational Database Terminology Quiz

Entities are represented within a schema through ________ whereas attributes are realized by _______ and instances by ____________.

Interview the Data Preview 16:42

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.

Interview the Data Quiz

Normalization Preview 16:26

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.

Normalization Quiz

ER Diagrams Preview 14:37

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