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

Saturday, 25 June 2016

Software Engineering
Dear All,   

         I am glad to inform you that I participated in short term training programme on “Software Engineering” at NITTTR Chennai from 13.06.2016 to 17.06.2016. Major topics covered in the course are

     1.      Introduction to Software Engineering
     2.      Software Project planning and Management
     3.      Requirement Analysis and Specification
     4.      Software Design, Coding & Testing
     5.      Software Metrics
     6.      Documentation

Formal Definition of Software Engineering: Application of systematic, disciplined, quantifiable approach to the development, operation, and maintenance of software.

Software engineering teaches how software should be constructed. The software engineering industry evolves faster than any other industry and of increasing importance to our economy and standard of living. It is a vast field. Its scope is extremely broad. It covers a wide range of professions such as scientific and numeric computing, ERP/HR and accounts, telecom industry, business applications, graphic designs, video game developmentdefense industry etc. So, software job became one of the most important jobs of today.

It is relatively young discipline by comparison with most other engineering disciplines. The main focus is on how to build and maintain high quality software systems in a controlled, predictable way. Software Engineer must have a sound knowledge of mathematics, science, economic and social issues to build software within given budget and time constraints.

I am very much pleased to be part of this course as it helped all the participants in understanding software engineering practices in the Industry perspective.

With Regards
Dr.K.Ratna Babu, L/CME GPT Addanki.