MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Oracle Database 12c Certified Professional - SQL Foundations

Course Summary

A step-by-step guide to introduce you to Oracle's unique SQL requirements and prepare you for the first official exam.


  • +

    Course Syllabus

    • Introduction
      • Important - Download These First - Working Files
      • What You Should Expect From This Course
      • How To Access Your Working Files
    • The Oracle Relational Database
      • The Relational Database
      • The Oracle 12C RDBMS
      • Structured Query Language
      • Setting Up SQL Developer
      • Setting Up Oracle APEX
    • The SQL SELECT Statement
      • The Syntax Of SQL
      • Projecting Columns In A SQL Statement
      • Using DESCRIBE
      • Using Aliases In SQL
      • Arithmetic Operators
      • Displaying Unique Values With DISTINCT
      • Concatenating Values
    • Conditionals In SQL Statements
      • Selectivity And WHERE Clause Syntax
      • Conditions Of Equality
      • Conditions Of Non-Equality
      • Range Conditions With BETWEEN
      • Set Conditions With IN
      • Pattern Matching With LIKE
      • Boolean Conditions
      • Sorting Data With ORDER BY
      • Sort Ordering And Secondary Sorts
      • Ampersand Substitution
    • Row Level Data Transformation
      • Understanding Single-Row Functions
      • Case Conversion Functions
      • Basic String Manipulation Functions
      • Advanced String Manipulation Functions
      • Date Functions
      • Arithmetic Functions
    • Conversion Functions And Conditional Expressions
      • Date To Character Conversion
      • Character To Date Conversion
      • Numeric Conversion
      • Conditional Expression Functions
    • Aggregate Data Transformation
      • Group Functions
      • Grouping Data With GROUP BY
      • Row Exclusion With HAVING
      • Using SQL Clauses Together
    • Combining Data
      • Explicit Versus Implicit Join Notation
      • Implicit Cartesian Joins
      • Implicit Equijoins
      • Implicit Outer Joins
      • Explicit Cross Joins
      • Ambiguous Explicit Joins With NATURAL JOIN
      • Explicit Column Joins With JOIN USING
      • Fully Specified Explicit Joins With JOIN ON
      • Self Joins And Non-Equijoins
      • 0810 Multi-Table Joins
    • Subqueries And Set Operators
      • Solving Problems With Subqueries
      • Basic Scalar Subqueries
      • Advanced Scalar Subqueries
      • Multi-Row Subqueries
      • Correlated Subqueries
      • Multi-Column Subqueries
      • Nested Subqueries
      • Using Set Operators
    • Data Manipulation And DML
      • Create Data With INSERT
      • Modify Data With UPDATE
      • Remove Data With DELETE And TRUNCATE
      • Transaction Control
    • Data Definition Language
      • The Purpose Of DDL
      • Oracles Schema Based Approach
      • Database Objects
      • Column Datatypes
      • The CREATE TABLE Statement
      • Avoiding Datatype Errors
      • Modifying Tables With ALTER TABLE
      • The NOT NULL Constraint
      • PRIMARY KEY Constraint
      • FOREIGN KEY Constraint
      • UNIQUE Constraint
      • CHECK Constraint
    • Certification Exam Preparation
      • About The Exam
      • Hints And Strategies For Preparation
    • Conclusion
      • Wrap Up


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top