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

Oracle 12c OCP 1Z0-061: SQL Fundamentals

$49
Instructor
Category
Reviews
Rating

About this 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

Course Outline

Module 1 Introduction To Oracle 12c SQL Fundamentals

  •  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 MultiTable Selection Demo

Module 3 SQL Functions

  •  3.1 Single Row Functions
  •  3.2 Aggregate Functions
  •  3.3 SingleRow Functions Demo
  • 3.4 MultiRow Functions Demo
  •  3.5 Group By
  •  3.6 Grouping Demo
  •  3.7 Conversion Functions
  •  3.8 Conversion Functions Demo
  •  3.9 Datetime Functions
  •  3.10 Datetime Functions Demo

Module 4 Subqueries

  •  4.1 SingleRow Subqueries
  •  4.2 SingleRow Subqueries Demo
  •  4.3 MultiRow Subqueries
  •  4.4 MultiRow 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 Review

  •  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

Reviews

0 Rated 0 out of 0 Ratings
5 stars
4 stars
3 stars
2 stars
1 stars