mcAfee-secured website

Course name Databases Courses Oracle SQL Certifications Complete Guide: Oracle SQL Certifications Complete Guide

Oracle SQL Certifications Complete Guide Video Course

Oracle SQL Certifications Complete Guide Video Course is developed by Databases Courses Professionals to help you pass the Oracle SQL Certifications Complete Guide exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass Oracle SQL Certifications Complete Guide exam.

Curriculum For This Course

  • 1. Database Basics 2 Videos 00:28:23
    • Oracle Database Introduction & Basics of Tables 18:39
    • Setting Up the SQL Development Environment (Mac & Windows) 08:28
  • 2. Single Table Queries (Exercises & Solutions in the Lectures) 7 Videos 02:14:13
    • Retrieving Data Using the SELECT Clause 15:17
    • Using the WHERE Clause in a Query 19:18
    • Using Operators in the WHERE Clause 19:19
    • Combining WHERE, AND & OR with Operators 18:03
    • Query Filtering Continued BETWEEN, IN and NULL 19:20
    • Query Filtering Conditions & Operator Precedence 19:19
    • Ordering, Concatenating & Aliasing Query Results 19:37
  • 3. Single Row Functions (Exercises and Solutions In the Lectures) 5 Videos 01:35:18
    • Single Row Functions (SRF) & Using The Dual Table 19:17
    • Using Functions in WHERE And Character Based SRFs 18:39
    • Numeric and Date Data type SRFs 19:00
    • Conversion SRFs & Date Formatting 19:09
    • Concluding SRFs & NULL / NULLIF Functions 16:01
  • 4. Grouping Functions (Exercises and Solutions In the Lectures) 3 Videos 00:51:49
    • Grouping Functions MIN, MAX, AVG, COUNT etc. 19:22
    • GROUP BY Clause & HAVING Clause 19:44
    • More Practice With The GROUP BY Clause 11:58
  • 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures) 4 Videos 01:25:56
    • SELECT within SELECT (Subqueries) 23:10
    • Relating Tables Together Using JOINs 18:59
    • Joins Continued INNER & OUTER Joins 21:09
    • More Joins With Correlated Subqueries 20:56
  • 6. Creating, Altering, and Updating Tables Using SQL (Exercises in Lectures) 9 Videos 02:59:22
    • Creating Your Own Tables & Design Considerations 20:21
    • Inserting Data Into Our Table 07:36
    • Create Table With a Primary Key Constraint 21:15
    • Using ALTER to modify the table structure 16:25
    • Create Table with SELECT + UPDATE Data 19:36
    • DELETE, TRUNCATE, and DROP Commands 18:01
    • Working With Database Indexes (Newly Added) 13:40
    • System Tables, Pseudo Columns & Deleting Duplicates (Newly Added) 23:30
    • Views and Other Objects and Commands (Newly Added) 22:56