London College Of Online Learning

HOME >> IT CERTIFICATIONS >> DATABASES >> Oracle 12c OCP 1Z0-061: SQL Fundamentals

£59.00

Duration: 16 Hours 21 Minutes

45 Course Videos

Oracle 12c OCP 1Z0-061: SQL Fundamentals

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 emphasise the full set of skills that DBAs need in today’s competitive marketplace.

Course Videos

This course contains the following modules and videos. Click the down arrow 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
Multirow 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

Our Learning System Includes

Instructor Led Lectures

All of our IT Courses recreate a real time class experience with a highly qualified and experienced instructor delivering the course’s theories and concepts on screen. All of our lectures are pre-recorded and available to the user 24/7. They can easily be paused, repeated, rewound and fast-forwarded.

Visual Presentations

We understand that all students are different when it comes to learning, therefore different types of delivery mediums are needed in order to achieve success for students. Taking that into account, we deliver our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimisation & Progress Tracking

Our courses are optimised for all mobile devices allowing users to learn on the go whenever they have spare time and wish to do so. Users can access their courses from anywhere and their progress is completely tracked and recorded delivering peace of mind to each and every user.

Practice Quizzes and Exams

Our custom practice exams prepare students for their exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure that they are confident on the topic they are learning.

World Class Learning Management System

We provide the next generation Learning Management System (LMS) to all of our students. This is an experience that combines the feature set of traditional LMS with advanced functionality designed to make learning management easy and online learning engaging from the student’s perspective.