oracle course sql programming in Hyderabad
oracle course sql programming in Hyderabad
ORACLE COURSE part 1 | ORACLE – SQL PROGRAMMING | |
FEES | INR 3K / 3000 | |
DURATION | 20 days/sessions | |
SYLLABUS / DAYWISE CONTENTS | ||
DAY | TOPIC | |
1. | Overview | RDBMS Concepts | |
2. | Data Types | |
3. | Operators | |
4. | Create Table | Drop Table | |
5. | Alter Table | |
6. | Insert Query | Select Query | |
7. | Update Query | Delete Query | |
8. | Where Clause | AND & OR Clauses | |
9. | Order By | Group By | | |
10 | Like Clause | Distinct Keyword | |
11 | Constraints (introduction and theory) | |
12 | Constraints (Practical) | |
13 | Joins (introduction and theory) | |
14 | Joins (Practical) | |
15 | Transactions (introduction and theory) | |
16 | Transactions (Practical) | |
17 | Sub Queries (introduction and theory) | |
18 | Sub Queries (Practical) | |
19 | Views | |
20 | Revision | |
ORACLE COURSE – PL / SQL PROGRAMMING |
ORACLE COURSE part 2 | ORACLE – PL / SQL PROGRAMMING | |
FEES | INR 3K / 3000 | |
DURATION | 20 days/sessions | |
SYLLABUS / DAYWISE CONTENTS | ||
DAY | TOPIC | |
1. | Overview | |
2. | Basic Syntax – PL / SQL Blocks | |
3. | Data Types | |
4. | Variables | |
5. | Constants | |
6. | Operators | |
7. | Conditions (introduction and theory) | |
8. | Conditions (Practical) | |
9. | Loops (introduction and theory) | |
10 | Loops (Practical) | |
11 | Strings | |
12 | Procedures (introduction and theory) | |
13 | Procedures (Practical) | |
14 | Functions (introduction and theory) | |
15 | Functions (Practical) | |
16 | Cursors (introduction and theory) | |
17 | Cursors (Practical) | |
18 | Triggers (introduction and theory) | |
19 | Triggers (Practical) | |
20 | Revision |