Oracle SQL 11g online classes. Duration-20 hours. Schedule-as per convenience of the student. Fee-Rs. 2500

Topics Covered

1. Intro to Structure Query Language (SQL) for Analyst SQL the language Data Manipulation Language (DML) Data Definition Language (DDL) SQL*Plus the Environment Scripting using Oracle's Procedural Language option (PL/SQL) Overview of complete SQL SELECT syntax 2. Intro to Oracle's RDBMS Objects Objects, Tables, Columns, Pseudo columns, Rows Data domains, Duplicate values, Null values Indexes, Views, Sequences, Synonyms Declarative Constraints Primary, Foreign, Unique keys Check, Not Null, Default 3. Using SQL in Different Scenarios SQL using SQL*Plus Starting SQL*Plus Entering and executing SQL commands The SQL command buffer within SQL*Plus Editors, Editing commands in the buffer SQL*Plus commands Set, Show, Column, Others Using SQL*Plus Worksheet SQL Developer Starting iSQLPlus Entering and executing SQL commands 4. More SQL SELECT Arithmetic calculations Character, Comparison, and Logical operators WHERE clause, Pattern matching, Using SQL*Plus substitution variables &, &&, &1 ORDER BY clause How NULLS are processed Multiple Columns ASC vs. DESC DISTINCT vs. UNIQUE 5. Single Row FUNCTIONS What are Functions? Analytic Character Numeric Date Conversion Miscellaneous 6. GROUP BY Clause & Group FUNCTIONS What are GROUP Functions? Aggregate (Group) Analytic functions COUNT(*) vs. COUNT(column_name) SUM(), AVG(), MIN(), MAX() VARIANCE(), STDDEV() GROUP BY and HAVING clause ROLLUP(), CUBE(), GROUPING() 7. Advanced Topics Joining Tables Subqueries Correlated Subqueries IF EXIST

Who should attend

Students or working professionals who want to learn RDBMS concepts and Oracle SQL as basics for pursuing DBA/Data warehouse/Business Intelligence career.

Pre-requisites

Computer/Laptop, Internet facility and headphone and mic.

What you need to bring

NA

Key Takeaways

Eligibility to write Oracle SQL 11g fundamentals-I certification.