Sumraaz Technologies
Home | About Sumraaz | Professionals Speak | Alliances and Partners | Careers | Contact Us 
  Sumraaz Kids
Facebook   Twitter   Linkedin   Blog
Individual Programs
+91- 9892005564
IT for 10th & 12th   Visual Basic 6.0   Oracle 9i Oracle 10g-DBA
C Programming   VB.NET 3.0   Java Oracle 10g-Developer
C++   ASP.NET 3.5   Adv. Java/J2EE  
Data Structures   C # 3.0   Struts  

Oracle 9i

You will be able to...
- Build robust and scalable Oracle9i database applications
- Establish a data model and a storage framework
- Develop powerful and efficient SQL statements
- Write reusable structured PL/SQL code with cursors, procedures and triggers
- Improve application performance by utilizing indexes and optimizing PL/SQL
Who should attend...
  This course is valuable for those who are, or will be, working with Oracle9i. Experience with relational databases and familiarity with basic programming concepts are helpful. Computer Fundamentals and Windows Operating System knowledge is an advantage. Any Programing Langauge, DBMS like Dbase or FoxPro are preferred.
Course Contents
  Duration : 84 Hrs.
  Prerequisite: Computer Fundamentals, Windows Operating Systems
Preferred: Any Programming Language, DBMS like Dbase or FoxPro
  Introduction to DBMS
  Database Design, ER Diagrams & Normalization
  Introduction to SQL and SQL*Plus
  SQL-DDL (Data Definition Language)
  SQL-DML (Data Retrieval)
  SQL-DML (Data Manipulation Language)
  Transaction Processing
  Views, Synonyms & Sequences
  Indexing & Clustering
  PL/SQL Language, PL/SQL Modules
  Cursors, Procedures, Functions
  Packages, Database Triggers
  Oracle Architecture