For whom SQL is?

IT or NON IT people can easily enter into leading Database Technology which is commonly used for all domain application software as back-end. There are so many reason to go ahead:

  • Oracle SQL is basic learning platform to get in IT, which is easy to learn.
  • On completion Oracle SQL training you can attempt certification exam.
  • Certified candidate can take benefit as IT document and can get good opportunity in IT world.
  • Oracle SQL is easy for any support project for initial stage which get into IT carrier. In case you want to grow for development environment than it’s entry for programming.
  • Now a days SQL is basic skill set for any IT/NON IT folks, It’s always helpful for any functional, support and technical consultant.

WEEK-01

Oracle 12c SQL

SQL Basic:

[1] Introduction to Oracle DB 12c

Oracle Database 12c: Focus Areas, Fusion Middle-ware, Oracle Cloud, Services, Deployment Methods, RDBMS, Data Model, ER Diagram, Relation DB Terminology, SQL Statements and Development Environment, HR Schema Tables, DB Documentation.

[2] Retrieving Data using SQL SELECT statement

Basic Select Statement, Arithmetic Expression, Defining Null values, Concatenation Operator & Literal, Duplicate Rows, Displaying table structure. Practice Overview.

[3] Restricting & Sorting Data

Use of Where clause, Character Strings & Date Data, Comparison, Logical, Range, Pattern, & Other operators, Rules Precedence, Order By Clause, Substitution variables. Practice Overview

WEEK-02

[4] Single Row Function & Customized Output

SQL function, Single Row Function, Character/Case Functions, Number Functions, Nesting Function, Date Functions etc. Practice Overview.

[5] Conversion & Conditional Expressions

Conversion Function, Implicit/Explicit Data Conversion, General Function with covering NVL, NVL2, NULLIF, COALESCE, Conditional Expression with Decode function and Case Expression. Practice Overview.

[6] Reporting Aggregated Data using Group Function

Usages of Group function, Nesting Group Function, Creating Group Data, Restricting group data using Having Clause. Practice Overview.

[7] Displaying Data from Multiple Tables using Join

Type of Joins, Explaining with Natural Join, Using Clause, On Clause, SQL 99 Syntax, Three-Way Join, Self Join, NonEqui Join, Inner Versus Outer Join, Cross Join etc. Practice overview.

WEEK-03

[8] Using Sub-queries to solve queries

Scenario to use Sub-query, Rules for Sub-queries, Type of Sub-queries, Single Row Sub-queries and Multi Row Sub-queries. Null value in Sub-query etc. Practice Overview.

SQL Advanced:

[9] Using Set Operator

Set Operator Rules, Covering Set Operator as UNION, UNION ALL, INTERSECT, MINUS etc. Practice Overview.

[10] Managing Tables using DML Statements

Data Manipulation Language, Covering INSERT, UPDATE, DELETE & DB Transaction control using COMMIT, ROLLBACK, SAVEPOINT. Use of For update clause in SELECT Statement.

[11] Introduction to Data Definition Language

Database Object, Naming Rules, Various Data Types, CREATE TABLE statement, Constraint guidelines, Defining constraints as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY & CHECK etc. ALTER TABLE, DROP TABLE Statement. Create Table using Sub-query. Practice Overview.

WEEK-04

[12] Introduction to Data Dictionary Views

Data Dictionary Structure, How to use Data Dictionary, USER_OBJECTS, ALL_OBJECT, USER_CONSTRAININTS. TABLE Information, Column Information etc. Practice overview.

[13] Creating Sequence, Synonyms & Indexes

Importance of Sequence, Synonyms & Indexes. Defining Sequence, Synonyms & Indexes & DROP statement etc. Practice overview.

[14] Creating Views

What’s View? Advantage of Views, CRETAE Simple & Complex views, Rules for performing DML operation on views. Modifying & Removing a view etc. Practice Overview.

[15] Retrieving Data by using Sub-Query

Multiple Column Sub-query, Column Comparison, Pair & Non Pair Sub-queries, Scalar Sub queries, Co-related Sub-queries, Use of WITH clause. Practice Overview.