Oracle

Oracle Database 12c: SQL Fundamentals

(WGU-1Z0-061) / ISBN : 978-1-61691-816-3
Lessons
Lab (Add-on)
TestPrep
AI Tutor (Add-on)
336 Reviews
Get A Free Trial

Skills You’ll Get

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role. Oracle Database 12c: SQL Fundamentals exam is designed to certify the competency of Database professionals to manage, develop, or implement enterprise-wide databases, middleware, or applications.
Download Course Outline

1

Introducing Oracle Database 12c RDBMS Oracle Database 12c

  • Relational Database Management Systems
  • The Oracle Database 12c
  • Becoming Familiar with SQL*Plus
  • Summary
  • Exam Essentials
2

Introducing SQL

  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials
3

Using Single-Row Functions

  • Single-Row Function Fundamentals
  • Using Single-Row Character Functions
  • Using Single-Row Numeric Functions
  • Using Single-Row Date Functions
  • Using Single-Row Conversion Functions
  • Using Other Single-Row Functions
  • Summary
  • Exam Essentials
4

Using Group Functions

  • Group Function Fundamentals
  • Utilizing Aggregate Functions
  • Summary
  • Exam Essentials
5

Using Joins and Subqueries

  • Writing Multiple-Table Queries
  • Using Set Operators
  • Using Subqueries
  • Summary
  • Exam Essentials
6

Manipulating Data

  • Using DML Statements
  • Understanding Transaction Control
  • Summary
  • Exam Essentials
7

Creating Tables and Constraints

  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials
8

Video Tutorials

  • Introduction
  • Oracle 12c- SQL Fundamentals
  • Basic Select Statements
  • Using the Where Clause
  • The Order By Clause
  • Left And Right Outer Joins
  • Multi-Table Selection Demo
  • SQL Functions
  • Using Group By clause
  • Conversion Functions
  • Subqueries
  • Data Modification
  • Implementing Security
  • Creating Objects In The Database
  • Using Sequences
  • Indexes
  • Views
  • Combining Queries
  • Oracle 12c SQL Fundamentals Review

1

Introducing Oracle Database 12c RDBMS Oracle Database 12c

  • Connecting to a Database
  • Saving the SQL Buffer
  • Clearing the SQL Buffer
2

Introducing SQL

  • Creating a Table
  • Inserting Data Into a Table
  • Converting the String to the DATE Data Type
  • Retrieving Data Using the SQL SELECT Statement
  • Using the WHERE Clause
  • Using the IN Operator
  • Using the NULL Values in the SELECT Statement
  • Using the Column Aliases
  • Using the Concatenation Operator
  • Using the DESCRIBE Command
  • Using the DISTINCT Keyword
  • Using the INEQUALITY Operator
  • Using the Less Than Operator
  • Using the Greater Than Operator
  • Using the ANY Operator
  • Using the ALL Operator
  • Using the NOT Operator
  • Using the AND Operator
  • Using the BETWEEN Operator
  • Using the EXISTS Operator
  • Using the FETCH Clause
  • Using the WITH TIES Clause
  • Using the OFFSET-FETCH Clause
  • Using the CASE Statement
  • Using the Runtime Query
3

Using Single-Row Functions

  • Using the UPPER Function
  • Using the SUBSTR Function
  • Using the ROUND Function
  • Using the TRUNC Function
  • Using the Single-Row Date Function
  • Using the ASCII Function
  • Using the DECODE Function
4

Using Group Functions

  • Retrieving Unique Columns
  • Using the average Function
  • Using the MIN Function
  • Using the MEDIAN Function
  • Using the LISTAGG Function
5

Using Joins and Subqueries

  • Retrieving data using the INNER JOIN operator
  • Using the Self Join
  • Using the FULL OUTER JOIN
  • Using the MINUS Operator
  • Using the INTERSECT operator
  • Using a Subquery
  • Using the UNION Operator
  • Creating a View
  • Using the WITH Clause
  • Using the GROUP BY Clause
  • Using the HAVING Clause
6

Manipulating Data

  • Updating a Table
  • Deleting Rows from a Table
  • Deleting Data from a Table
  • Using the MERGE Statement
  • Locking a Table
7

Creating Tables and Constraints

  • Creating a Sequence
  • Inserting Data Into a Table Using Sequence
  • Retrieving the Next Value of Sequence
  • Creating an Index
  • Using the CREATE SYNONYM Statement
  • Creating a Table with the INTERVAL Datatype
  • Creating a Table from Another Table
  • Creating a Table with Default Values
  • Creating a Table with an Invisible Column
  • Dropping a Table
  • Renaming a Table
  • Adding a Column

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Oracle Database 12c: SQL Fundamentals

$47.00

Buy Now

Related Courses

All Course