$595.00

Overview

Course Duration: 4 hours 1 minute

Oracle 12c OCP 1Z0-061: SQL Fundamentals On-Demand Course includes:

  • EXPERT INSTRUCTOR-LED TRAINING: Finest instructors in the IT industry with a minimum of 15 years, real-world experience and are subject matter experts in their fields
  • VISUAL DEMONSTRATIONS & MULTIMEDIA PRESENTATIONS: Instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor.
  • QUIZZES & EXAM SIMULATORS: Custom practice exams prepare you more effectively than the traditional exam preps on the market. Practice quizzes after each module ensures confidence on the topic before proceeding.
  • SOCIAL LEARNING & NETWORKING: World class Learning Management System (LMS) which allows you to interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.
  • FLASH CARDS & EDUCATIONAL GAMES: Every Student learns differently. That is why we provide Flash Cards and Education Games throughout our courses. Allowing students to train in ways that keep them engaged and focused

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.

Module 1: Introduction To Oracle 12c SQL

1.1 Introduction To Course

1.2 Intro To Oracle 12c SQL Fundamentals

1.3 Structure Of SQL

1.4 Basic Select Statements

1.5 Basic Select Statements Demo

Module 2: Retrieving Data

2.1 Modifying Reported Output

2.2 The Where Clause

2.3 The Order By Clause

2.4 Left And Right Outer Joins

2.5 The Where Clause Demo

2.6 Multi­Table Selection Demo

Module 3: SQL Functions

3.1 Single Row Functions

3.2 Aggregate Functions

3.3 Single­Row Functions Demo

3.4 Multi­Row Functions Demo

3.5 Group By

3.6 Grouping Demo

3.7 Conversion Functions

3.8 Conversion Functions Demo

3.9 Date­time Functions

3.10 Date­time Functions Demo

Module 4: Subqueries

4.1 Single­Row Subqueries

4.2 Single­Row Subqueries Demo

4.3 Multi­Row Subqueries

4.4 Multi­Row Subqueries Demo

4.5 Other Subquery Types

4.6 Other Subquery Types Demo

Module 5: Data Manipulation Language

5.1 Adding Data

5.2 Changing Data

5.3 Deleting Data

5.4 DML Demo

Module 6: Data Control Language

6.1 Security

6.2 Object Privileges

6.3 DCL Demo

Module 7: Data Definition Language

7.1 Creating Objects In The Database

7.2 Creating Objects In The Database Demo

7.3 Sequences

7.4 Sequenced Demo

7.5 Indexes

7.6 Views

Module 8: Combining Queries

8.1 Combining Queries

Module 9: Oracle 12C SQL Fundamentals

9.1 Oracle 12c SQL Fundamentals Review – Part 1

9.2 Oracle 12c SQL Fundamentals Review – Part 2

9.3 Oracle 12c SQL Fundamentals Review – Part 3

9.4 Conclusion