ORACLE SQL
Demo Links :
Demo Session 1:
Demo Session 2 :
Demo Session 3 :
Course Content :
Module-1: USERS AND SCHEMAS
- Introduction to Users and Schemas
- Definitions and Client Tools
- SQL Developer Login
- Creating An Application Schema
Module-2: PSEUDO COLUMNS & FUNCTIONS
- Using The Dual Table
- Functions
- Pseudo-Columns
- Using Rowid
- Using Rownum
Module-3: USING SUBQUERIES
- Simple Subqueries
- Inline Views
- Correlated Subqueries
- Scalar Subquery
Module-4: JOINING TABLES
- Review of Joins
- Equijoins
- Inner Joins
- Outer Joins
- Cross Joins
- Natural Joins
- Using Named Subqueries
Module-5: GROUP OPERATIONS
- About Group Processing
- Simple GROUP BY
- ROLLUP Function
Module-6: USING SET OPERATORS
- Set Operators Defined
- Relationship to Mathematical Set Theory
- Restrictions on Set Operators
Module-7: CONDITIONAL PROCESSING
- The DECODE Function
- The Case Expression
- Exercise: Conditional Processing
Module-8: SQL FUNCTIONS (CHARACTER)
- What Are SQL Functions?
- Character Functions
- CONCAT
- LENGTH
- INSTR
- REPLACE
- UPPER
- LOWER
- INITICAP
- LPAD
- RPAD
- TRIM
- TO_CHAR
- SOUNDEX
Module-9: SQL FUNCTIONS (NON-CHARACTER)
- Numeric Functions
- The TO_CHAR Function with numbers
- Date/Time Functions
- Date Format Functions
- Date Arithmetic Functions
- Null Value Functions
Module-10: SQL DATA MANIPULATION LANGUAGE
- The INSERT Statement
- INSERT Statement Categories
- The UPDATE Statement
- The DELETE Statement
- Transactions
- Complex Table References
- The MERGE statement
Module-11: Analytical Functions
Module-12: Queries for Queries
Module-13: Techniques to compare data
Module-14: Efficiently writing SQL queries
No comments:
Post a Comment