VGREDDY TECHNOLOGIES Ameerpet, Hyderabad, Telangana

INTRODUCTION Introduction to Oracle TwoThree tier architecture DBMS Concepts Definition of Database Database Management System Database models and Relations Relational Database management System Dr. E.F. Codd Rules Database Design Entity Relationship Diagram Normalization Features of Oracle SQL Introduction to SQL Features of SQL SQL Sub Languages Data Definition Language Data types Constraints Data Manipulation Language Data Retrieval Language Operators Data Control Language Transaction Control Language Functions Aggregate functions Character functions Date functions Arithmetic functions General functions Joins Equi joins Non equi joins Self joins Outer joins Set operators Cartesian joins Full outer joins Natural joins Inner joins Cross joins Sub queries Correlated Subqueries Large Database objects Views Sequences Synonyms Indexes Clusters Roles SQL * Plus commands PLSQL Introduction to PLSQL Architecture of PLSQL Advantages of PLSQL PLSQL Block structure Variables and constants Attributes Control statements If statement If else statement Multiple elsif statement Nested if statement Loops For statement While statement Cursors Explicit cursors Implicit cursors Cursor for loop Parameterized cursors Ref cursors Composite datatypes PLSQL Tables PLSQL Records Exception handling Sub Programs Procedures Functions Using mode parameters Packages Pragma restrict_references Database triggers Instead of triggers UTL Files New and improved datatypes Concept of object oriented Programming Object relational features Object tables Collections Nested tables Varrays Partitioning tables Maintaining partitions Oracle 9i features J2EE and XML Applications Oracle 10g11g features

Introduction access 2007 fundamentals introduction to databases starting access 2007 the getting started page and opening a database what’s new in access 2007 understanding the access program screen understanding the ribbon using the office button and quick access toolbar using keyboard commands using contextual menus using help database basics working with database objects tour of a table adding, editing and deleting records tour of a form tour of a query tour of a report previewing and printing a database object selecting data cutting, copying and pasting data using undo and redo checking your spelling using the zoom box exiting access 2007 creating and working with a database planning a database creating a new database creating a table modifying a table creating a query sorting a query using and and or operators in a query creating a form with the form wizard creating a report with the report wizard creating mailing labels with the label wizard converting an access database finding, filtering, and formatting data finding and replacing data sorting records using common filters filtering by selection filtering by form creating an advanced filter adjusting and rearranging rows and columns changing gridline and cell effects changing the datasheet font freezing a column hiding a column functions sql queries joins sub queries forms and reports reports.