Sql plsql online training
Hello, We are from O2education, Online software Education and training team.
We are one of the best rated software training team, who are offering online software training from India.
We offer you efficient yet affordable online software training with quality as the main objective.
Our online education experts' team assists you in every phase of your online education.
We are the pioneers in offering practical industry-oriented online software training that makes you capable of handling real time situations by applying the concepts which you learn through our programming languages.
Initially, we make you understand about the software course contents and we will counsel you how the software course will be will be able to apply your practical skills in a real time environment.
for all major Software Technologies.
.
About our Faculty:
- We have Certified Instructors who have real time experience plus good orientation in Online Training.
We offer you:
- Interactive Learning at Learners convenience - Industry savvy Trainers - learn right from your place - 24/7 Technical Support - Highly affordable fee Satish@o2education.
com Introduction & Basics 1) Introduction 1) History of relational database management systems.
2) Oracle vs other RDBMS 3) Editions and Versions of Oracle 4) Different development environments.
2) Oracle Setup 1) Oracle Binaries installation 2) Creating Sample database.
3) Connection setup through sqlplus and Sql developer.
3) Oracle Architecture 2) Concept of Normalization.
3) Different normal forms.
4) Oracle Architecture in detail 5) Logical & Physical structure of oracle database.
SQL 1) Introduction to SQL 1) DDL commands 2) DML commands 3) DCL commands 4) TCL Commands 5) Data types in oracle 6) Detail understanding on Select statement 2) Restricting and Sorting Data 1) Where clause 2) Between, In and Like operators 3) And, OR and Not operators 4) Order by clause 5) Defining and Assigning values to variables 3) Single Row functions 1) Character Manipulation functions 2) Case conversion functions 3) Number functions 4) Date functions 5) Round and Trunc with date functions 4) Conversion Functions 1) Data type conversion 2) To_char,to_date and to_number functions 3) Replacing null values (NVL2), Decode function 4) Conditional expressions ( Case) 5) Group functions 1) Group by clause 2) Sum, Avg, Min and Max functions 3) Group by clause on multiple columns 4) Restricting group results ( Having) 6) Oracle Joins 1) Type of joins 2) Join using On and Using clauses 3) Natural, self and equi joins 4) Outer joins (left, right and full) 5) Cross join ( Cartesian product) 7) Sub queries 1) Types of sub-queries 2) Single and multiple row sub-queries 3) Group functions on sub-queries 4) Using All and Any operators 8) Set operators 1) Union and union-all operators 2) Intersect and minus operators 3) Order by clause in set operators 9) More on DML statements and Data integrity 1) Inserting data from other table 2) Conditional insert ( Merge ) 3) Select for update statement 4) Delete vs truncate 5) Data integrity ( Commit & Rollback) 10) More on DDL and Constraints 1) Creating tables and inserting default values 2) Primary and foreign key constraints 3) Unique and check constraints 4) Adding and dropping columns from a table 11) Creating other Schema objects 1) Simple and Complex views 3) Working with sequences 4) Creating synonyms 12) Controlling User Access 1) Creating users 2) Granting system & object privileges 3) Creating Roles 4) Granting and revoking privileges to and from a role 13) Managing other Schema Objects 1) Setting and Dropping UNUSED columns 2) Deleting data from Child Tables (on Delete) 3) Disable & Enable constraints 4) Drop Table Purge 5) Flashback Table 6) Temporary Table 7) External Table 14) Miscellaneous 1) Multi Table Insert 2) Merge statement in detail 3) Flashback Versions Query 4) Interval data types 5) Exists & not exists operators 6) With Clause 7) Rollup and Cube operators PLSQL Introduction to PLSQL 1) Need and Benefits of PLSQL 2) Anonymous PLSQL Block 3) Declaring & Initializing variables 4) %Type attribute 5) INTO clause Control Structures & loops 1) If and Case statements 2) For and While loops Cursors 1) Implicit and Explicit cursors 2) Usage of Cursors in Loops 3) Cursors with parameters Procedures 1) Anonymous PLSQL vs Procedure 2) Writing simple procedures 3) Exception Handling 4) Pre-defined exceptions 5) User defined Exceptions Functions 1) Procedure vs Function 2) Creating simple functions 3) Usage of functions Packages 1) Benefits of creating packages 2) Package spec and Body 3) Overloading of subprograms Working with Oracle supplied Packages 1) DBMS_OUTPUT 3) DBMS_FILE Triggers 1) Types of triggers 2) Creating and Managing triggers 3) Compound, DDL and Event based triggers Miscelleneous 1) Bulk Collect Partitioning 1) Different types of partitions 2) Partition examples.
Estimated Salary: $20 to $28 per hour based on qualifications.
We are one of the best rated software training team, who are offering online software training from India.
We offer you efficient yet affordable online software training with quality as the main objective.
Our online education experts' team assists you in every phase of your online education.
We are the pioneers in offering practical industry-oriented online software training that makes you capable of handling real time situations by applying the concepts which you learn through our programming languages.
Initially, we make you understand about the software course contents and we will counsel you how the software course will be will be able to apply your practical skills in a real time environment.
for all major Software Technologies.
.
About our Faculty:
- We have Certified Instructors who have real time experience plus good orientation in Online Training.
We offer you:
- Interactive Learning at Learners convenience - Industry savvy Trainers - learn right from your place - 24/7 Technical Support - Highly affordable fee Satish@o2education.
com Introduction & Basics 1) Introduction 1) History of relational database management systems.
2) Oracle vs other RDBMS 3) Editions and Versions of Oracle 4) Different development environments.
2) Oracle Setup 1) Oracle Binaries installation 2) Creating Sample database.
3) Connection setup through sqlplus and Sql developer.
3) Oracle Architecture 2) Concept of Normalization.
3) Different normal forms.
4) Oracle Architecture in detail 5) Logical & Physical structure of oracle database.
SQL 1) Introduction to SQL 1) DDL commands 2) DML commands 3) DCL commands 4) TCL Commands 5) Data types in oracle 6) Detail understanding on Select statement 2) Restricting and Sorting Data 1) Where clause 2) Between, In and Like operators 3) And, OR and Not operators 4) Order by clause 5) Defining and Assigning values to variables 3) Single Row functions 1) Character Manipulation functions 2) Case conversion functions 3) Number functions 4) Date functions 5) Round and Trunc with date functions 4) Conversion Functions 1) Data type conversion 2) To_char,to_date and to_number functions 3) Replacing null values (NVL2), Decode function 4) Conditional expressions ( Case) 5) Group functions 1) Group by clause 2) Sum, Avg, Min and Max functions 3) Group by clause on multiple columns 4) Restricting group results ( Having) 6) Oracle Joins 1) Type of joins 2) Join using On and Using clauses 3) Natural, self and equi joins 4) Outer joins (left, right and full) 5) Cross join ( Cartesian product) 7) Sub queries 1) Types of sub-queries 2) Single and multiple row sub-queries 3) Group functions on sub-queries 4) Using All and Any operators 8) Set operators 1) Union and union-all operators 2) Intersect and minus operators 3) Order by clause in set operators 9) More on DML statements and Data integrity 1) Inserting data from other table 2) Conditional insert ( Merge ) 3) Select for update statement 4) Delete vs truncate 5) Data integrity ( Commit & Rollback) 10) More on DDL and Constraints 1) Creating tables and inserting default values 2) Primary and foreign key constraints 3) Unique and check constraints 4) Adding and dropping columns from a table 11) Creating other Schema objects 1) Simple and Complex views 3) Working with sequences 4) Creating synonyms 12) Controlling User Access 1) Creating users 2) Granting system & object privileges 3) Creating Roles 4) Granting and revoking privileges to and from a role 13) Managing other Schema Objects 1) Setting and Dropping UNUSED columns 2) Deleting data from Child Tables (on Delete) 3) Disable & Enable constraints 4) Drop Table Purge 5) Flashback Table 6) Temporary Table 7) External Table 14) Miscellaneous 1) Multi Table Insert 2) Merge statement in detail 3) Flashback Versions Query 4) Interval data types 5) Exists & not exists operators 6) With Clause 7) Rollup and Cube operators PLSQL Introduction to PLSQL 1) Need and Benefits of PLSQL 2) Anonymous PLSQL Block 3) Declaring & Initializing variables 4) %Type attribute 5) INTO clause Control Structures & loops 1) If and Case statements 2) For and While loops Cursors 1) Implicit and Explicit cursors 2) Usage of Cursors in Loops 3) Cursors with parameters Procedures 1) Anonymous PLSQL vs Procedure 2) Writing simple procedures 3) Exception Handling 4) Pre-defined exceptions 5) User defined Exceptions Functions 1) Procedure vs Function 2) Creating simple functions 3) Usage of functions Packages 1) Benefits of creating packages 2) Package spec and Body 3) Overloading of subprograms Working with Oracle supplied Packages 1) DBMS_OUTPUT 3) DBMS_FILE Triggers 1) Types of triggers 2) Creating and Managing triggers 3) Compound, DDL and Event based triggers Miscelleneous 1) Bulk Collect Partitioning 1) Different types of partitions 2) Partition examples.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
