Oracle SQL - From Beginner to Pro
4.2 (141 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,874 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL - From Beginner to Pro to your Wishlist.

Add to Wishlist

Oracle SQL - From Beginner to Pro

Professional Advancement through Structured Query Language Readiness
4.2 (141 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,874 students enrolled
Created by Dr. Rick Phillips
Last updated 2/2017
English
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 45 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • The perfect student is relatively new to programming and is seeking to interface their programs to an Oracle, or other, relational database via SQL.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
06:39:44
+
Course Overview and Foundation
1 Lecture 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.

Preview 11:28
+
Software Setup
1 Lecture 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.

Download and Install Toolset
13:45
+
Relational Database Theory
4 Lectures 59:14

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

Relational Database Terminology
11:29

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

Relational Database Terminology Quiz
3 questions

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.

Preview 16:42

Interview the Data Quiz
3 questions

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
16:26

Normalization Quiz
4 questions

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

Preview 14:37

ER Diagram Quiz
3 questions
+
Schema Creation
4 Lectures 01:11:48
Schema Creation Part 1
19:46

Schema Creation Part 1 Quiz
3 questions

Schema Creation Part 2
16:39

Schema Creation Part 2 Quiz
3 questions


Schema Creation Part 3 Quiz
3 questions

Schema Modification
19:30

Schema Modification Quiz
3 questions
+
Data Manipulation Language
1 Lecture 18:56
Data Manipulation Language
18:56

DML Quiz
3 questions
+
Queries
6 Lectures 01:28:16

Single Table Select Part 1 Quiz
3 questions

Single Table Selects Part 2
16:18

Single Table Queries Part 2 Quiz
3 questions

Multi-table Queries
15:32

Joins Quiz
3 questions


Subqueries Quiz
4 questions

Set Operators, Translate and Replace
10:36

Set Operators, Translate and Replace Quiz
3 questions

Advanced Queries
13:58

Advanced Queries
3 questions
+
PL/SQL
3 Lectures 40:36
PL/SQL Procedures
13:33

PL/SQL Procedures Quiz
3 questions


PL/SQL Functions Quiz
3 questions

PL/SQL Triggers and Packages
15:09

PL/SQL Triggers and Packages Quiz
3 questions
+
Less Frequently Used Oracle Constructs
6 Lectures 01:21:56
User-Defined Types
13:58

User-Defined Types Quiz
3 questions

Collections
14:37

Collections Quiz
3 questions

LOBs
12:01

LOBs Quiz
3 questions


XML Quiz
3 questions


Performance Part 2
11:40

Performance Quiz
3 questions
+
Summary and Conclusion
1 Lecture 13:45
Wrap up
13:45
About the Instructor
Dr. Rick Phillips
4.2 Average rating
206 Reviews
11,479 Students
4 Courses
PhD with 25+ years computer industry experience

I received my Ph.D. from the University of Wisconsin in Visual Psychophysics with a minor in Computer Science.  I worked my entire professional career within the computer industry specializing in relational database design and large-scale international databases.

Out of school, I went to work for VeriFone the credit card processing company because they were headquartered in Hawaii and I yearned to get out of the cold of Wisconsin.  I started as employee #36.  By the time I left, they were publically traded, had thousands of employees and billions in revenue.  At the time of my departure, I was VeriFone's Database Design Manager and oversaw a technical staff of 125+.

I subsequently served as MIS Manager for Family Health International, Database Manager for A4 Health Systems, and CTO and President of Castle Worldwide.  I retired from Castle in 2014 at the age of 55.

After retirement I was searching for a great means to keep my hands in technology.  Teaching with Udemy has provided that venue.  I enjoy creating the courses and interacting with the students.  It is my new passion.  Middle aged and young people are my favorite students - seeing them better utilize their new toys and skills gives me great pleasure, such energy.

I am a huge advocate of life-long learning and love this opportunity to share that passion with others.  Remember, "keep on learning."