Description

The SQL with Oracle Certification course enables you to take your data skills into a variety of companies, helping them analyse data and make more informed business decisions. The course covers data exploration, data manipulation, and various critical and important aspects of SQL using Oracle. You will learn about various functions and options which we have in Oracle SQL also you will learn how to optimise the performance of the queries to get the output as quick as possible. In this curriculum you will learn about how to write the complex queries.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in-demand tech skills! In this course, you'll learn quickly and receive challenges and tests along the way to improve your understanding!

Course Objectives

Understanding the concept of constraints

Get the grasp of various SQL commands and functions

Get hold of different types of Joins and its benefits

Understand the concept of Subqueries and how will it help in the improvement of the queries performance 

Understand the concept of data manipulation

Get hold of advanced concepts like Hierarchical Queries, Regular Expressions and Analytical Functions

Get the understanding of Materialized views and Indexes. 

Target Audience

This course is meant for all those students and professionals who are interested in using the SQL in their day-to-day work

Basic Understanding

There are no prerequisites

Course Content

No sessions available.

Simpliv Logo
Simpliv LLC
39658 Mission Boulevard,
Fremont, CA 94539, USA

Oracle SQL Certification Bootcamp

Session 1: Introduction to constraints

  1. Naming Rules
  2. Data Types
  3. Default Constraint
  4. Primary Key Constraints
  5. Foreign Key Constraints
  6. Not Null constraint
  7. Unique Constraint

Session 2: Types of SQL Commands

  1. Data Definition Language
  2. Data Query Language
  3. Data Manipulation Language
  4. Data Control Language
  5. Transaction Control Language

Session 3: Operators and Clauses

  1. Concatenation
  2. Where Clause
  3. Like Clause
  4. Between and
  5. Is null
  6. Order by

Session 4: Single Row Function

  1. Character
  2. Number
  3. Date
  4. Conversion
  5. General Functions
  6. NVL
  7. NVL2
  8. COALESCE
  9. Case When
  10. Decode

Session 5: Multi Row Function

  1. Avg
  2. Count
  3. Min
  4. Max
  5. Stddev
  6. Sum
  7. Variance

Session 6: Joins in SQL

  1. Different types of joins
  2. Inner Join
  3. Left Outer Join
  4. Right Outer Join
  5. Full Outer Join
  6. Self-Join

Session 7: Single Row Subquery

  1. Detailed understanding of single row subquery

Session 8: Multiple Rows Subquery

  1. Detailed understanding of multiple row subquery
  2. In clause
  3. Any Clause
  4. All Clause

Session 9: Multiple Column Sub Queries

  1. Non-Pairwise
  2. Pairwise
  3. Correlated Sub Queries

Session 10: Exists and With Clauses

  1. Detail understanding of Exists and With Clauses

Session 11: Set Operators in SQL

  1. Union
  2. Union All
  3. Intersection
  4. Minus

Session 12: Data Manipulation

  1. Insert statements
  2. Update Statements
  3. Delete Statements
  4. Truncate

Session 13: Views in SQL

  1. Simple and Complex views
  2. Update through views

Session 14: Alter Statements in SQL

  1. How to add the constraints
  2. Alter statements
  3. System tables

Session 15: Multi table inserts

  1. Unconditional Inserts
  2. Conditional Inserts
  3. Condition First Insert
  4. Pivoting Insert

Session 16: Merge in SQL

  1. Update using Merge
  2. Insert using Merge

Session 17: Hierarchical Data fetching

  1. Connect by Prior

Session 18: Regular Expressions

  1. REGEXP_LIKE
  2. REGEXP_INSTR
  3. REGEXP_SUBSTR
  4. REGEXP_REPLACE
  5. REGEXP_COUNT

Session 19: Analytics Functions

  1. Row Number
  2. Rank
  3. Dense Rank

Session 20: Materialized Views

  1. Importance of Materialized Views
  2. Complete on Demand
  3. Complete on Commit
  4. Fast on Demand
  5. Explain Plan
  6. Understanding the concept of indexes in Oracle SQL

Coupons

No offers available at this time.

Live Support

Call

+510-849-6155

Mail to

support@simplivlearning.com

Similar Courses

Our Trusted Clients