MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Oracle SQL - A Comprehensive Training on Oracle SQL

Course Summary

Complete package of Concepts, Basic Need & Practicle Execution of SQL Language


  • +

    Course Syllabus

    • Introduction
      • Introduction and Lesson Objectives
    • DBMS, ER Model, Normalization
      • File System, DBMS
      • DBMS
      • DBMS, Object Oriented Model
      • ER Model
      • Relationships, Normalization
      • Normalization
      • Summary
    • SQL Structured Query Language
      • Introduction and Components of SQL
      • SQL SELECT Statement, Arithmetic Operations, Null Value
      • Null Value, Components of SQL Statements
      • Components of SQL Statements - DDL
      • Components of SQL Statements - DML
      • Components of SQL Statements - Transaction Control StatementS
      • Components of SQL Statements - DCL
      • Structured Query Language
    • Restricting & Sorting Data
      • Where Clause, Logical Operators
      • Case Insensitive, Character Functions
      • Relational Operators
      • Column Alias
      • Between / in, Sorting
    • SingleRow Functions
      • Single Row Functions - SQL Functions
      • Character Functions - Character Manipulation Function
      • Character Functions - LPAD / RPAD
      • Character Functions - SUBSTR, REPLACE, TRANSLATE
      • Character Functions - INSTR, LENGTH, ASCII
      • Number Functions - ROUND, TRUNCATE, CEIL, POWER, ABS, DATE Functions
      • Conversion Functions - IMPLICIT, EXPLICIT
      • Conversion Functions - CHAR to DATE, Number; Nesting of Functions
      • General Functions - CASE, NVL, NVL2
    • Multiple Row Functions
      • Multiple Row / Group Functions
      • Group Functions - MIN, MAx
      • Group by Clause
    • SQL JOINS
      • SQL JOINS
      • SQL JOINS - Equi Join
      • SQL JOINS - Self Join
      • SQL JOINS - Avoiding Ambiguity of Columns
    • Subqueries
      • Subquery - Syntax
      • Guidelines for using Subqueries
      • Single Row subquery
      • Multiple Row Subqueries
      • Multiple Row Subqueries - ALL
    • Manipulating Data
      • Manipulating Data
      • Insert with Subquery
      • UPDATE
      • UPDATE, DELETE with Subquery
      • MERGE, Database Transations
      • Database Transation, AUTOCOMMIT
      • Commit and Rollback
    • Creating & Managing Data
      • Create and Manage Tables
      • The DEFAULT Option, Another User's Table, SYSTEM Tables
      • Advance Datatype in Oracle, Creating a Table using a subquery
      • Modify an existing Column, SET UNUSED Option
      • Dropping a Table, Changing Name, TRUNCATING
    • Oracle Date Time Functions
      • Oracle Date Time Functions
      • Oracle Date Time Functions Part 2
    • Pseudocolumn
      • Pseudocolumn
    • Constraints
      • Constraints
      • SQL Constraints Syntax
      • SQL Constraints - NOT NULL
      • SQL Constraints - UNIQUE
      • SQL Constraints - UNIQUE Continues
      • SQL Constraints - Primary Key
      • SQL Constraints - Composite Primary Key, Foreign Key,
      • SQL Constraints - Composite Foreign Key
      • SQL Constraints - CHECK
    • Sequences
      • Sequences
      • NEXTVAL Pseudocolumn
    • Views
      • What, Why, How is View
      • Advantages of Views, Creating Views
      • To get View Code, Creating a Complex View
      • To get View Code, Creating a Complex View continue
      • With Check Option
      • Removing View
    • Indexes
      • Indexes
      • Conditions, Scenario, Verifying Indexes
    • Controlling User Access
      • Controlling User AccessPart 1
      • Controlling User Access Part 2
      • Controlling User Access Part 3
      • Controlling User Access Part 4
      • Controlling User Access Part 5
    • Synonym
      • Synonym
    • Summery of SQL Course
      • Summery of SQL Course


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top