SQL / PL SQL Online Training Course SQL ? The Oracle database environment Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g ? Basic SELECT Statement Writing the statement in sqlplus, Running the SELECT statement ? Ordering the output Single Column, Descending order, Multiple column sort ? Conditional retrieval of data Working with complex conditions, AND OR NOT ,,,, LIKE BETWEEN ? Pseudo columns and functions Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table ? Working with character functions UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(), ? Working with date functions TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY() ? Using non-character function ROUND(), TRUNC(), SIGN(), Working with multiple tables, Different type of Joins, Writing Outer Joins ? Using the SET operators Union, Intersect, Minus ? Aggregating data using group functions GROUP BY, HAVING ? Creating Subqueries Single Row subqueries, Multiple row Subqueries ? Enhancing groups function ROLLUP, CUBE ? Transaction Control Language Rollback, Commit, Savepoint ? Processing hierarchies Creating the Tree structure, LEVEL, CONNECT BY ? Data Manipulation Language INSERT, UPDATE, DELETE ? Data Definition Language CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE ? Using Declarative Constraints Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null ? Other Database Objects Views, Sequences, Synonyms, Indexes USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS ? Database Security Object Privileges, Granting access to objects PL -SQL ? Blocks Structure, Writing Anoyomous Blocks ? Variables Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments ? Control structures IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition ? Cursors Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN ? Error Handling Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions ? Procedures Creating and Calling Procedures ? Functions Creating and Calling Functions ? Packages Package Header, Package Body ? Design Tips and Techniques Format of standard packages in an application, Spec and Body, NOCOPY hint thoery ? Triggers Database triggers, CALLing procedures from triggers ? Dynamic SQL EXECUTE IMMEDIATE, DBMS_SQL package ? Oracle Supplied packages DBMS_OUTPUT, UTL_FILE Collection datatypes Associative Arrays, Nested tables, VARRAYs

Topics Covered

SQL / PL SQL Online Training Course Attend TWO FREE DEMO Classes! Experience the Quality of our Training. KEEN IT TECHNOLOGIES PVT. LTD. is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. KEEN IT TECHNOLOGIES PVT. LTD has a pool of Expert Trainers worldwide on all the technologies to train the students. KEEN IT TECHNOLOGIES PVT. LTD is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL / PL SQL Online Training Course instructors who have real time experience plus expert orientation in Online Training. We offer you:- • Interactive Learning at Learner’s convenience • Industry Savvy Trainers • Learn Right From Your Place • Customized Curriculum • Highly Affordable Courses • 24/7 system access Support after Training:- • Resume Preparation • Certification Guidance • Interview assistance We have a forth coming online batch on SQL / PL SQL Online Training Course We also provide online training on SAP (All Modules), DATA WAREHOUSING (All Modules), oracle (All Modules), Data Stage,SAS and..NET,Share point,TIBCO,Testing tools and QTP. Contact : Mr.Srinivasa Rao INDIA: +91-9989754807, +91-8125809802 US : +1 347-952-4634, +1 203-567-0149 Land line: 040-2113292 Website: http://www.keentechnologies.com/ » E- mail : trainings@keentechnologies.com »

Who should attend

For Online Training classes it can be any one who has a passion towards learning online training courses

Pre-requisites

Any ONE CAN should attend the class

What you need to bring

these are online classes

Key Takeaways

SQL / PL SQL Online Training COURSE,SQL / PL SQL Online Training,SQL / PL SQL Online IN INDIA,SQL / PL SQL