Monday, 27 June 2016

Oracle - SQL& PL/SQL

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.

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;

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

4 comments:

  1. Replies
    1. IEEE Project Domain management in software engineering is distinct from traditional project deveopment in that software projects have a unique lifecycle process that requires multiple rounds of testing, updating, and faculty feedback. A IEEE Domain project Final Year Projects for CSE system development life cycle is essentially a phased project model that defines the organizational constraints of a large-scale systems project. The methods used in a IEEE DOmain Project systems development life cycle strategy Project Centers in India provide clearly defined phases of work to plan, design, test, deploy, and maintain information systems.


      This is enough for me. I want to write software that anyone can use, and virtually everyone who has an internet connected device with a screen can use apps written in JavaScript. JavaScript Training in Chennai JavaScript was used for little more than mouse hover animations and little calculations to make static websites feel more interactive. Let’s assume 90% of all websites using JavaScript use it in a trivial way. That still leaves 150 million substantial JavaScript Training in Chennai JavaScript applications.

      Delete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Great information about sql
    If you are interested in different programming language like python
    CHECK IT OUT.

    check it out

    ReplyDelete