Oracle 12c OCP 1Z0-061: SQL Fundamentals

Take an extra 30% off this course! No coupon needed; auto applies in cart.

$49.00

Sale Ends Soon

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

Oracle Database 12c: SQL Fundamentals provides a multitude of advantages from the re-engineered Oracle Database for Cloud computing. The architecture ensures hardware and software efficiency, superior performance, manageability benefits that lead to quick and effortless cloud provisioning.

16  Training Hours
45 Videos
9  Topics
245 Practice Questions

Course Description

Note: Although this course is based on an older version, it remains to be a beneficial resource for educating and training.

About our online course:

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.

Who is this Oracle 12c OCP 1Z0-061: SQL Fundamentals training course for?

Perfect for IT professionals and Oracle administrators seeking to advance their skill level, this Oracle Database 12c Administration program is especially tailored for those aiming to enhance their database language proficiency. After completing the course, attendees will have acquired an unparalleled understanding of the latest version of Oracle that can be applied in both rising IT careers as well as established ones looking to validate their expertise.

Course Outline

Oracle 12c OCP 1Z0-061: SQL Fundamentals Course Outline

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
Oracle 12c OCP 1Z0-061: SQL Fundamentals

$49.00

Oracle Database 12c: SQL Fundamentals provides a multitude of advantages from the re-engineered Oracle Database for Cloud computing. The architecture ensures hardware and software efficiency, superior performance, manageability benefits that lead to quick and effortless cloud provisioning.

Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
$39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$20.00

In this course you will learn how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. This course will teach you how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. You will learn how to create plans and designs for database structure, storage, objects, and servers.

$29.00

Showcase your indispensable abilities and ingenious insights in creating and managing the upcoming generation of mission-critical environments with our Microsoft MCSA: SQL Server Solutions Associate online course.

$49.00

In this course you will learn how to start building enterprise web applications. This course will provide you with training in web development, C Sharp, HTML and CSS, SQL Server, JavaScript, Object Based JavaScript, Model View and Controller, and jQuery.

$49.00

Elevate your web development programming skills in this HTML5 and CSS3 training course. HTML5 and CSS3 are key web technologies that allow you to build up content for the internet. This training program showcases how to use innovative HTML5 multimedia features such as video, audio, and animation. With this course, you can unlock more creative possibilities with your digital media!

UNLOCK

25% OFF

Sign up for updates, discounts, and more.