Oracle Database 12c Certified Professional - SQL Foundations Training Video

Course

Online

£ 98.64 + VAT

*Indicative price

Original amount in AUD:

$ 189

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

A Practical Oracle 12c Training Course That Teaches Real World Skills In this project-based Oracle Database 12c Certified Professional - SQL Foundations video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Oracle Database 12c Certified Professional - SQL Foundations training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Oracle Database 12c Certified Professional - SQL Foundations subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Oracle Database 12c Certified Professional - SQL Foundations tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 5.5 hours to complete this course 76 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time 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...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database
  • SQL
  • Database training
  • Skills and Training

Course programme

  • 01. Introduction
    • What You Should Expect From This Course
    • About The Author
    • 0103 How To Access Your Working Files
  • 02. The Oracle Relational Database
    • The Relational Database
    • The Oracle 12C RDBMS
    • Structured Query Language
    • Setting Up SQL Developer
    • Setting Up Oracle APEX
  • 03. 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
  • 04. Conditionals In SQL Statements
    • 0401 Selectivity And WHERE Clause Syntax
    • 0402 Conditions Of Equality
    • 0403 Conditions Of Non-Equality
    • 0404 Range Conditions With BETWEEN
    • 0405 Set Conditions With IN
    • 0406 Pattern Matching With LIKE
    • 0407 Boolean Conditions
    • 0408 Sorting Data With ORDER BY
    • 0409 Sort Ordering And Secondary Sorts
    • 0410 Ampersand Substitution
  • 05. Row Level Data Transformation
    • 0501 Understanding Single-Row Functions
    • 0502 Case Conversion Functions
    • 0503 Basic String Manipulation Functions
    • 0504 Advanced String Manipulation Functions
    • 0505 Date Functions
    • 0506 Arithmetic Functions
  • 06. Conversion Functions And Conditional Expressions
    • 0601 Date To Character Conversion
    • 0602 Character To Date Conversion
    • 0603 Numeric Conversion
    • 0604 Conditional Expression Functions
  • 07. Aggregate Data Transformation
    • 0701 Group Functions
    • 0702 Grouping Data With GROUP BY
    • 0703 Row Exclusion With HAVING
    • 0704 Using SQL Clauses Together
  • 08. Combining Data
    • 0801 Explicit Versus Implicit Join Notation
    • 0802 Implicit Cartesian Joins
    • 0803 Implicit Equijoins
    • 0804 Implicit Outer Joins
    • 0805 Explicit Cross Joins
    • 0806 Ambiguous Explicit Joins With NATURAL JOIN
    • 0807 Explicit Column Joins With JOIN USING
    • 0808 Fully Specified Explicit Joins With JOIN ON
    • 0809 Self Joins And Non-Equijoins
    • 0810 Multi-Table Joins
  • 09. Subqueries And Set Operators
    • 0901 Solving Problems With Subqueries
    • 0902 Basic Scalar Subqueries
    • 0903 Advanced Scalar Subqueries
    • 0904 Multi-Row Subqueries
    • 0905 Correlated Subqueries
    • 0906 Multi-Column Subqueries
    • 0907 Nested Subqueries
    • 0908 Using Set Operators
  • 10. Data Manipulation And DML
    • 1001 Create Data With INSERT
    • 1002 Modify Data With UPDATE
    • 1003 Remove Data With DELETE And TRUNCATE
    • 1004 Transaction Control
  • 11. Data Definition Language
    • 1101 The Purpose Of DDL
    • 1102 Oracles Schema Based Approach
    • 1103 Database Objects
    • 1104 Column Datatypes
    • 1105 The CREATE TABLE Statement
    • 1106 Avoiding Datatype Errors
    • 1107 Modifying Tables With ALTER TABLE
    • 1108 The NOT NULL Constraint
    • 1109 PRIMARY KEY Constraint
    • 1110 FOREIGN KEY Constraint
    • 1111 UNIQUE Constraint
    • 1112 CHECK Constraint
  • 12. Certification Exam Preparation
    • 1201 About The Exam
    • 1202 Hints And Strategies For Preparation
  • 13. Conclusion
    • 1301 Wrap Up

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

Oracle Database 12c Certified Professional - SQL Foundations Training Video

£ 98.64 + VAT

*Indicative price

Original amount in AUD:

$ 189