*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3498-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, KSA 0502283468

Oracle Training – Oracle DBA 12c SQL Fundamentals Course


Be the first to rate 1Z0-061-Oracle Database 12c SQL Fundamentals (Exam-1)
Or log in to access your purchased courses
by admin
Price:  25,000  20,000
2 Months
0 Lessons

COURSE DESCRIPTION

 

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

Oracle DBA 12c SQL Fundamentals

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.

Introduction

  • Describe the features of Oracle Database 12c
  • Describe the salient features of Oracle Cloud 12c
  • Explain the theoretical and physical aspects of a relational database
  • Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)

Retrieving Data using the SQL SELECT Statement

  • Explain the capabilities of SQL SELECT statements
  • Execute a basic SELECT statement

Restricting and Sorting Data

  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions

  • Identify the available group functions
  • Describe the use of group functions
  • Group data by using the GROUP BY clause
  • Include or exclude grouped rows by using the HAVING clause

Displaying Data From Multiple Tables Using Joins

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins
  • Join a table to itself by using a self-join
  • View data that generally does not meet a join condition by using OUTER joins
  • Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

  • Define subqueries
  • Describe the types of problems that the subqueries can solve
  • Describe the types of subqueries
  • Write single-row and multiple-row subqueries
  • Using the SET Operators
  • Describe set operators
  • Use a set operator to combine multiple queries into a single query
  • Control the order of rows returned

Managing Tables using DML statements

  • Truncate data
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions

Introduction to Data Definition Language

  • Categorize the main database objects
  • Explain the table structure
  • Describe the data types that are available for columns
  • Create a simple table
  • Explain how constraints are created at the time of table creation
  • Describe how schema objects work

Flexible Class Options

  • Fast-Track Classes
  • Week End Classes For Professionals  SAT | SUN
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses

Oracle Techno Functional Consultant – Oracle Apps R12

Diploma SAP ERP Complete All-in-One Course
Oracle ERP R12 Supplychain Management
R12i Oracle E Business Suite Fundamentals
Oracle E-Business Suite R12 Applications DBA
Oracle Fusion Financials Cloud 

 

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

FREE Practice Exam Questions

Weekend Classes for Professionals

Internship Opportunity and Job Referrals

High Exam Success Rate

Please Fill the Inquiry Form

Inquire Now

Select Country:
Enter Phone e.g 923451234567
Branch
Online

Inquire Now

Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Gulshan Campus : A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, (Near Rab Medial) Karachi. 021 3498 6664, WhatsApp 0312 216 9325
  • Dha Campus: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 021 35344 600, 0333 3808376
  • 021 34986664, 021 35344 600, 0333 3808376, KSA 050 2283468
  • info@omni-academy.com
WORKING HOURS

  • Monday10.00am - 8.00pm
  • Tuesday10.00am - 8.00pm
  • Wednesday10.00am - 8.00pm
  • Thursday10.00am - 8.00pm
  • FridayClosed
  • Saturday10.00am - 8.00pm
  • Sunday10.00am - 8.00pm
WhatsApp chat