SQL (pronounced sequel) is the set-based, high-level declarative computer language with which all programs and users access data in an Oracle database. Although some Oracle tools and applications mask SQL use, all database operations are performed using SQL. Any other data access method circumvents the security built into Oracle Database and potentially compromises data security and integrity.
SQL provides an interface to a relational database such as Oracle Database. SQL unifies tasks such as the following in one consistent language:
Creating, replacing, altering, and dropping objects.
Inserting, updating, and deleting table rows.
Querying data.
Controlling access to the database and its objects
Oracle program is positioned to cater to the IT requirements of large companies and software houses. It is ideally suited for the following category of candidates
Freshers developing careers in IT.
Professionals aspiring to launch their careers in software development with cutting edge technology.
Individuals with concrete plans to switch over to IT, who desire to acquire the latest skills in advanced software tools that would be the most sought after in the overseas market.
This course in designed to help people move to the popular software development environment – using Oracle. The Objective of the course is to introduce the student to RDBMS (Relational database Management system ) concepts.
Restricting and Sorting Data
Sort the rows that are retrieved by a query
Limit the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Including Constraints
Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
Using DDL Statements to Create and Manage Tables
Using Single-Row Functions to Customize Output
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries
Define subqueries
Describe the types of problems that the subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries
Using the Set Operators
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned
Describe how schema objects work -
Creating Other Schema Objects
Create simple and complex views -
Retrieve data from views
Create, maintain, and use sequences
Create private and public synonyms
Create and maintain indexes
Controlling User Access - Granting / Revoking Object Privileges
DateTime Functions - Understanding time zone Using time stamp Using time interval
