You are here

Oracle 12c OCP 1Z0-061: SQL Fundamentals

E-COURSE:

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview

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.

This course will provide the learner with everything that is needed to pass the Oracle 12c OCP 1Z0-061: SQL Fundamentals. The course has been designed to give you real-world knowledge that you can put to use from day one. It's highly flexible, so you can set your own timetable and study at your own pace.

Objectives
  • Understand data control language
  • Understand SQL functions and subqueries
  • Understand combining queries
  • Understand data definition language
Target Audience
  • The course is for students who want to prepare for the Oracle 12c certification exam.
  • The course is for the student are interested in Oracle 12c SQL Fundamentals
  • This is Science & Technology Professionals

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

E-COURSE E-Learning Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
  • 15:47:02
    + Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access (Unless indicated otherwise)
  • 10-Day money-back guarantee