Dear all,
I am to glad to inform you that we participated in "Oracle-SQL & PL/SQL" at NITTTR Chennai from 20-06-2016 to 24-06-2016.
A database is basically a collection of information organized in such a way that a computer program can quickly access desired pieces of data. Example for a data base is address book in your phone.
I am to glad to inform you that we participated in "Oracle-SQL & PL/SQL" at NITTTR Chennai from 20-06-2016 to 24-06-2016.
A database is basically a collection of information organized in such a way that a computer program can quickly access desired pieces of data. Example for a data base is address book in your phone.
To access information from a database, you need a database management system (DBMS). This is a collection of programs that enables you to enter, modify, and select data in a database.
A Relational database management system (RDBMS) is a DBMS that is based on the relational model. Data is stored in the form of rows and columns .i.e Tables. Data is created and retrieved using SQL.Some of famous RDBMS softwares are Oracle, MS SQL Server, IBM DB2, Oracle, MySQL, Sybase, Informix, postgres and Microsoft Access.
Oracle is RDBMS software developed by Oracle Corporation from 70s. The latest version of the database is Oracle 12c. (c means Cloud). Oracle Database 11g XE is free to use for Educational institutions and students & developers.
SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database. All RDBMS software uses SQL. SQL includes commands for database creation, deletion, fetching rows and modifying rows etc.
Following statements would create a record in customer table
INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 );
Following is an example which would fetch ID, Name and Salary fields from the CUSTOMERS table where salary is greater than 2000
SQL> SELECT ID, NAME, SALARY FROM CUSTOMERS WHERE SALARY > 2000;
Some examples of SQL commands are
SELECT * FROM CUSTOMERS ORDER BY NAME, SALARY;
SELECT COUNT(*)FROM employees;
SELECT SUM(Salary) FROM employees;
SELECT COUNT(*)FROM employees;
SELECT SUM(Salary) FROM employees;
PL/SQL is a combination of SQL along with the procedural features of programming languages.
PL/SQL supports conditional statements, loops, arrays, functions, procedures, functions, Cursors, Exceptions, Triggers, Packages.
With Regards
BVS.Naga Raju & L.Mohana Tirumala,
Lecturers in CME,
GPT, Addanki