Database Development Oracle 12c OCP 1Z0-061 SQL Fundamentals

Oracle 12c OCP 1Z0-061 SQL Fundamentals

599.00 599.00
$599.00
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
  • Course Delivery: On Demand
  • Duration: 16.01 
  • Language: English
  • Audience: Everyone

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

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.
 

Course Objectives

  • Retrieving Data
  • SQL Functions
  • Data Manipulation Language
  • Combining Queries
 

Topics Covered

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

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.