Oracle Database 12C Certified Professional
SQL Foundations
By Steve Ries
Publisher: Infinite Skills
Final Release Date: November 2014
Run time: 5 hours 33 minutes

In this Oracle Database 12c Certified Professional - SQL Foundations training course, expert author Steve Ries will teach you the fundamentals of the SQL programming language, as well as prepare you for the first test in the Oracle certification track. This course is designed for the absolute beginner, meaning no experience with Oracle 12c is required.
You will start by learning about the Oracle relational database, then jump into learning about the SQL SELECT statement. From there, Steve will teach you about conditionals in SQL, conversion functions, and implicit and explicit joins. This video tutorial also covers subqueries, data manipulation, and data definition language. Finally, you will learn about the exam, and Steve will provide you with hints and strategies to help you prepare.
Once you have completed this computer based training course, you will be fully capable of using the SQL programming language. You will also have gained the knowledge necessary to prepare for the Oracle Database 12c SQL Fundamentals exam. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents
Product Details
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyOracle Database 12C Certified Professional
 
4.0

(based on 2 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 2 customers

Displaying reviews 1-2

Back to top

 
3.0

Nice, but not suffieciently deep

By pkaluski

from Warsaw, Poland

Verified Reviewer

Pros

  • Accurate
  • Concise
  • Easy to understand

Cons

  • Too basic

Best Uses

  • Novice
  • Student

Comments about oreilly Oracle Database 12C Certified Professional:

If this product was not advertised as a preparation for SQL Foundation exam, I would give it 5 stars without any hesitation. The material is rightly paced, nicely and clearly presented. The problem is, the coverage of the subject is not sufficiently deep for SQL Foundation exam. This video explains echo topic in a clear way, however it misses pointing out several nuances, which are important during the exam.
If you would like to have a good idea about the scope of the exam, this is a good material for you. If you are looking for a position, which will prepare you for the exam, this video is unsufficient. Use "OCA: Oracle Database 12c Administrator Certified Associate Study Guide" book instead (http://shop.oreilly.com/product/9781118643952.do) instead

(2 of 2 customers found this review helpful)

 
5.0

I wish I had this years ago!

By sandyboy55

from Bangalore, India

Verified Reviewer

Pros

  • Accurate
  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Intermediate
    • Novice
    • Student

    Comments about oreilly Oracle Database 12C Certified Professional:

    Clear explanation, no boring slides, to the point without any fluff, and simple flow. This is such a good video on Oracle SQL that I wish I had it years ago. The videos are perfectly divided into 3-4 minutes duration by sub-topics so you don't have to dig through a large video to get to what you want to learn. I devoted 15-20 minutes every day and really refreshed my understanding of some of the things that I had forgotten. This is great for job interview prep as well.

    Displaying reviews 1-2

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Video:  $99.99
    (Streaming, Downloadable)