This course has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages.

Topics Covered

1.Introduction to SQL 1.1 What is SQL? 1.2 What is RDBMS? 1.2.1 Table 1.2.2 Datatypes 1.3 Types of SQL statements 2.Basic Elements of Oracle SQL 2.1. Basic SQL construct 2.2. Importance of NULL 2.3. Operators 2.3.1 Comparison operator 2.3.2 Arithmetic operators 2.3.3 Logical Operators 2.4. Expressions 3.Tables and Table Joins 3.1. Need for joins 3.2. Cartesian products 3.3. Column aliases 3.4. Types of joins 3.5. ANSI Syntax and Oracle Syntax for writing Join statements. 4.Filtering and Sorting data 4.1. Limiting rows retrieved 4.2. Using LIKE for pattern matching 4.3. Using logical operators AND, OR & NOT 4.4. Using BETWEEN & IN operators 4.5. Sorting data using ORDER BY clause 5.Oracle SQL Functions part 1 5.1. SQL Functions overview 5.2. What are single row functions? 5.3. Using Character functions 5.4. Using Number functions 5.5. Using Date and timestamp functions. Avoid the YY and RR pitfall. 5.6. Using CASE and DECODE functions. 5.7. Nested functions 5.8. Data type conversion functions 6.Oracle SQL Functions part 2 6.1. What are multi row functions? 6.2. Various multi row functions 6.3. Grouping data with GROUP BY clause 6.4. Using the HAVING clause 6.5. Sorting GROUP BY data 7.Nested SQL queries 7.1. Need for nested queries 7.2. Types of nested queries 7.3. USING EXISTS, ALL & ANY operators 8.Database Manipulation Language – DML and Transactions 8.1. What is data manipulation in a database? 8.2. Need for data manipulation 8.3. INSERT statement 8.4. UPDATE statement 8.5. DELETE statement 8.6. Definition of Transaction 8.7. COMMIT & ROLLBACK statements 8.8. Using the SAVEPOINT statement 8.9. MERGE statement 9.Database Definition Language – DDL 9.1. Creating tables 9.2. Modifying tables, adding constraints to a table, renaming a table and its columns. 9.3. Dropping columns (set unused command) and dropping tables. 9.4. Creating and replacing views 10.1. Creating and dropping public synonyms 10.2. Creating modifying and dropping sequences 10.3 Grant and Revoke of object privileges between two Oracle database users 11.Indexes and Index types 11.1. What are Indexes and how they work ? 11.2. Need for Indexes 11.3. Types of Indexes 11.4. Composite Indexes 11.5. Function based Indexes 11.6. Analyzing and rebuilding Indexes 12.Others 12.1. Set operators in SQL Language (UNION, UNION ALL, INTERSECT, MINUS) 12.2. RANK() and DENSE_RANK() functions 12.3. ROWID & ROWNUM 12.4. Various other Analytical functions 12.5. Data dictionary views

Who should attend

-Students -IT Developers -IT Testers -IT DBA

Pre-requisites

Nothing

What you need to bring

Laptop

Key Takeaways

-Understanding of SQL concepts -Ability to write SQL statements with ease