Download appDownload App

Oracle SQL From Beginner to Pro

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...

  • All levels
  • English

Course 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...

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.

What you’ll learn
  • facets of Oracle SQL
  • data definition components of SQL
  • data manipulation components of SQL

Covering Topics

1
Section 1 : Course Overview and Foundation
2
Section 2 : Software Setup
3
Section 3 : Relational Database Theory
4
Section 4 : Schema Creation
5
Section 5 : Data Manipulation Language
6
Section 6 : Queries
7
Section 7 : PL/SQL
8
Section 8 : Less Frequently Used Oracle Constructs
9
Section 9 : Summary and Conclusion

Curriculum

      Section 1 : Course Overview and Foundation
1
Introduction
      Section 2 : Software Setup
2
Download and Install Toolset
      Section 3 : Relational Database Theory
3
Relational Database Terminology
4
Interview the Data Preview
5
Normalization
6
ER Diagrams
      Section 4 : Schema Creation
7
Schema Creation Part 1
8
Schema Creation Part 2 Preview
9
Schema Creation Part 3
10
Schema Modification
      Section 5 : Data Manipulation Language
11
Data Manipulation Language
      Section 6 : Queries
12
Single Table Selects Part 1
13
Single Table Selects Part 2
14
Multi-table Queries
15
Subqueries
16
Set Operators Translate and Replace
17
Advanced Queries
      Section 7 : PL/SQL
18
PL/SQL Procedures
19
PL/SQL Functions
20
PL/SQL Triggers and Packages
      Section 8 : Less Frequently Used Oracle Constructs
21
User-Defined Types
22
Collections
23
LOBs
24
XML
25
Performance Part 1
26
Performance Part 2
      Section 9 : Summary and Conclusion
27
Wrap up

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.