Course Description

With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace.

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Additional information

16 Hours 1 Minute

45 Course Videos

245 Test Questions

Course Videos

This course contains the following modules and videos. Click the down arror to view video details.

Module 1: Introduction To Oracle 12c SQL Fundamentals
  • Introduction
  • Intro To Oracle 12c-SQL Fundamentals
  • Structure Of SQL
  • Basic Select Statements
  • Basic Select Statements Demo
Module 2: Retrieving Data
  • Modifying Reported Output
  • The Where Clause
  • The Order By Clause
  • Left And Right Outer Joins
  • The Where Clause Demo
  • Multi-Table Selection Demo
Module 3: SQL Functions
  • Single Row Functions
  • Aggregate Functions
  • Single Row Functions Demo
  • Muiltrow Functions Demo
  • Group By
  • Grouping Demo
  • Conversion Functions
  • Conversion Functions Demo
  • Datetime Functions
  • Datetime Functions Demo
Module 4: Subqueries
  • Single-Row Subqueries
  • Single-Row Subqueries Demo
  • Multi-Row Subqueries
  • Multi-Row Subqueries Demo
  • Other Subquery Types
  • Other Subquery Types Demo
Module 5: Data Manipulation Language
  • Adding Data
  • Changing Data
  • Deleting Data
  • DML Demo
Module 6: Data Control Language
  • Security
  • Object Privileges
  • DCL Demo
Module 7: Data Definition Language
  • Creating Objects In The Database
  • Creating Objects In The Database Demo
  • Sequences
  • Sequenced Demo
  • Indexes
  • Views
Module 8: Combining Queries
  • Combining Queries
Module 9: Oracle 12C SQL Fundamentals Review
  • Oracle 12c SQL Fundamentals Review - Part 1
  • Oracle 12c SQL Fundamentals Review - Part 2
  • Oracle 12c SQL Fundamentals Review - Part 3
  • Conclusion

Oracle 12c OCP 1Z0-061: SQL Fundamentals

$99.00

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Instructor Led Courses

All ITU Courses replicate a live class experience with an instructor on screen delivering the course's theories and concepts.

These lectures are pre-recorded and available to the user 24/7. They can be repeated, rewound, fast-forwarded.

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Visual Demonstrations, Educational Games & Flashcards

ITU recognizes that all students do not learn alike and different delivery mediums are needed in order to achieve success for a large student base. With that in mind, we deliver our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Mobile Optimization & Progress Tracking

Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded.

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Practice Quizzes and Exams

ITU Online's custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure you are confident on the topic you are learning.

Oracle 12c OCP 1Z0-061: SQL Fundamentals

World Class Learning Management System

ITU provides the next generation learning management system (LMS). An experience that combines the feature set of traditional Learning Management Systems with advanced functionality designed to make learning management easy and online learning engaging from the user’s perspective.

Need help? Call our support team at (855) 488-5327

ITU Online IT Training

ITU Online IT Training

PGlmcmFtZSBzcmM9Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vbWFwcy9lbWJlZD9wYj0hMW0xOCExbTEyITFtMyExZDYwNDQuMjc1NjM3NDU2ODA1ITJkLTczLjk4MzQ2MzY4MzI1MjA0ITNkNDAuNzU4OTkzNDExNDc4NTMhMm0zITFmMCEyZjAhM2YwITNtMiExaTEwMjQhMmk3NjghNGYxMy4xITNtMyExbTIhMXMweDAlM0EweDU1MTk0ZWM1YTFhZTA3MmUhMnNUaW1lcytTcXVhcmUhNWUwITNtMiExc2VuITJzITR2MTM5MjkwMTMxODQ2MSIgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZnJhbWVib3JkZXI9IjAiIHN0eWxlPSJib3JkZXI6MCI+PC9pZnJhbWU+
Thank You. We will contact you as soon as possible.
COMPANY NAME
CONTACT US
Dolor aliquet augue augue sit magnis, magna aenean aenean et! Et tempor, facilisis cursus turpis tempor odio putonius mudako empero brutto populius giten facilisis cursus turpis balocus tredium todo.
Thank You. We will contact you as soon as possible.
PGlmcmFtZSB3aWR0aD0iMTAwJSIgaGVpZ2h0PSIxMDAlIiBzcmM9Ii8vd3d3LnlvdXR1YmUuY29tL2VtYmVkL3NCV1BDdmR2OEJrP2F1dG9wbGF5PTEiIGZyYW1lYm9yZGVyPSIwIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+
ENJOY AURORA BOREALIS

WIN A FULL YEAR
OF IT TRAINING

Subscribe now to get special offers and discounts. By subscribing you will also be entered into our monthly drawing to win 1 full year of free ITU training.
Your Name
Your Email
WIN 1 YEAR OF FREE TRAINING
Subscribe to our mailing list and automatically be entered into our monthly drawing to win 1 year of free training from ITU Online.
2019 (C) All rights reserved.
We respect your privacy and will not sell your email
to any third party.
Congratulations to Anthony B. of New Pasadena TX, our Aug. 2019 Winner!
Drop a line.
This is Layered Popups' version of Lorem Ipsum. Proin gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis.
2016 (C) All rights reserved.
WELCOME!
Subscribe to our free newsletter and win some prizes. Enter your email below and get updates and news weekly.
We never share your data with 3rd parties.
2018 (C) All rights reserved.
Subscribe Now
Get some fresh designer freebies by subscribing to our daily newsletter.
2016 (C) All rights reserved.