Description

Using Structure Query Language to Deal With database by creating new tables, inserting new rows, update and delete data also how to write queries to display data from database tables as well as using Oracle functions and creating database objects such as Views. Finally, how to secure it by creating new users, grant and revoke privileges to/from them.

Program

IS -132 CRs

Objectives

• 1-Develop essential SQL skills that enable developers to write queries against single and multiple tables.
  2- Manipulate data in tables.
  3- Create database objects.
  4- Use single row functions to customize output.
  5- Work with group functions to report aggregated data.
  6- Use conversion functions and conditional expressions.
  7- Manipulate queries to return required data.
  8- Perform calculations on data.
  9- Administer database objects.