Ams Presentation

Welcome to AMS

System

Applications

Networking

Database

System System plays one of the key role in the stream of IT A System is the combination of Hardware and Operating system. Hardware is the set of physical devices Operating System is the interface between the hardware and the User. So, In order to maintain the System we need a System Administrator

Applications Applications are set of programs developed in different programming languages like JAVA,.net,c e.t.c to fulfill the business necessities While developing these Applications we follow two phases Programming Testing

We call them as

Programmers or Developers

Networking Networking is technology which helps to establish inter communication between a group of systems. In order to make group of systems to communicate well we need to establish different network topologies. A Network Administrator or Engineer is responsible for these kind planning and maintenance

Database A database is a structured collection of records or data that is stored in a computer system

Database

computer system

DBMS (Database Management System) A DBMS is a set of software programs that controls the organization, storage, management, and retrieval of data in a database DBMSes may use any of a variety of database models, such as the network model or relational model. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way.

DBMS MODELS According to the DBMS database model. The four most common types of organizations are Hierarchical model Network model Relational model Object model

At present we use Relational model in our DBMS

Available Database in the market Oracle database IBM DB2 Microsoft SQL Server MySQL

In this course we are going to deal with Oracle database

Oracle Database  Oracle is used for almost all large application and one of the main applications in which oracle takes its major presence is banking.  The world’s top 10 banks run Oracle because oracle offers a powerful combination of technology and comprehensive, pre-integrated business applications  Oracle is a database that responds very well with excellent performance in demanding environments  Oracle is a major database which along with its added features passes the ACID (Atomicity Consistency Isolation Durability) test, which is important in insuring the integrity of data. This is very important because data is the heart of any system in organization.  Efficient recovery from human errors  Faster database recovery  Helps in simplifying the management and administration processes

Working with Oracle The are two working streams in oracle Development Administration Development

Administration

Development There are two development tools available for Oracle SQL

( Structured Query Language )

PL/SQL ( Procedural Language/Structured Query Language )

SQL Structured Query Language SQL can be divided into two parts: The Data Manipulation Language (DML) Data Definition Language (DDL).

PL/SQL PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary procedural extension to the SQL database language, used in the Oracle database The key strength of PL/SQL is its tight integration with the Oracle database. PL/SQL consists

Functions Procedures Packages Triggers Exceptions Array handling Looping Cursor FOR loops