Training Course:Oracle (OCP)School/Trainer:COMPUFIELD
Mumbai, India
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Overview of Relational
Databases,SQL Displaying Data from
Multiple Tables Multiple-Column Subqueries
Discuss the theoretical and physical aspects of a
relational database
Describe the Oracle
implementation of the
RDBMS and ORDBMS
Describe the use and benefits of SQL
Writing Basic SQL Statements
List the capabilities of SQL SELECT statements
Execute a basic SELECT
statement
Differentiate between SQL statements and SQL*Plus commands
Restricting and Sorting Data
Limit the rows retrieved by a query
Sort the rows retrieved by a query
Single Row Functions
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Describe the use of
conversion functions
Write SELECT statements to access data from more than one table using equality and nonequality joins
View data that generally
does not meet a join
condition by using
outer joins
Join a table to itself
Aggregating Data Using
Group Functions
Identify the available group functions
Describe the use of group functions
Group data using the
GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
Subqueries
Describe the types of
problems that subqueries
can solve
Define subqueries
List the types of subqueries
Write single-row and
multiple-row subqueries
Write multiple-column
subqueries
Describe and explain the
behavior of subqueries
when null values are retrieved
Write subqueries in a
FROM clause
Managing Rollback Segments
Produce queries that require an input variable
Customize the SQL*Plus
environment
Produce more readable
output
Create and execute script files
Save customizations
Manipulating Data
Describe each DML
statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
...''
Please go to the school's official website for training price and schedule:
http://www.compufield.net/
Phone:091-22-23676218, 091-22-23679302, 091-22-23671772
School Address:
Chinoy Mansion, First Floor, Block # 2, Opposite St. Stephens Church, Warden Road,
Mumbai(Bombay) - 400 036. India
Jobs & Resumes: Mumbai
Houses & Roommates: Mumbai
Other training courses offered by COMPUFIELD:
PowerPoint
Financial Accounting (Tally)
Microsoft Excel, Level 2 (2003, XP, 2003/2007)
Advance TALLY
C
Data Structure
India Certificate Of Education Examination (ICSE)
Active Server Pages (ASP)
Oracle 9i DBA OCP
ORACLE 10g (OCP+OCA)
SQL Server
SAP (Sales & Distribution)
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed. |
|
|
