Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle SQL - From Beginner to Pro
Rating: 4.1 out of 5(222 ratings)
8,214 students
Created byRick Phillips
Last updated 2/2017
English

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.

Course content

9 sections27 lectures6h 39m total length
  • Introduction11: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.

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.