Introduction to Oracle9i: Advanced SQL Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 3 Days
Call: +971 4 5490356

Course details

Essential advanced features within the Oracle SQL language are considered within this course. Building indexes, specifying declarative constraints, managing security privileges for tables and using SQL to satisfy some of the most complex query requests are all among the topics considered within this course. This course largely focuses on SQL features that are unique to the Oracle database and as such is applicable even for SQL professionals experienced in other databases.

Prerequisites:

Introduction To Oracle9i: SQL

DEFINING DATABASE OBJECTS:

creating an application schema

truncate
difference from delete and drop table
create index / drop index
user_ind_columns
alter view
user_updatable_columns
defining sequences
create sequen
nextval, currval
alter, drop sequence
create synonym / drop synonym

DATABASE SECURITY:

user schema pass_a
about object security
grant, revoke

SQL FUNCTIONS (CHARACTER):

character functions
upper(), lower(), initcap()
chr(), ascii()
rpad(), rtrim()
decode(), substr()
instr(), translate()
replace()
greatest(), least()
soundex()

SQL FUNCTIONS (NON-CHARACTER):

greatest(), abs()
round(), trunc(), sign()
to_char()
format elements: yyyy, ddth, fm, rr
to_date() exam
months_between()
add_months(), last_day()
last_day(), next_day()
trunc(), round() dates
null value functi_

ADVANCED SQL LANGUAGE CONSTRUCTS:

case expression
coalesce() func_sce

PROTECTING TABLES WITH DECLARATIVE CONSTRAINTS:

not null constraint
check constraint
unique constraint
primary key constraint
references constraint
on delete cascade
on delete set null

MAINTAINING CONSTRAINT DEFINITIONS

drop table cascade
enabling & disabling constraints
validate new transactions only
deferred enforc_d
set constraints deferred
managing constraint exceptions
constraints
data dictionary storage
user_constraints
constraint_type code explanation

ENHANCING GROUPS WITH ROLLUP & CUBE:

using rollup
grouping()
cube

ADVANCED SQL*PLUS REPORTS:

break, compute
column, ttitle / btitle

BUILDING SQL*PLUS SCRIPTS:

xsql file
define / und
accept
start or @
prompt, pause

PROCESSING HIERARCHIES:

:n hierarchy (supervision)
m:n hierarchy (bill-of-materials)

advanced sql & sql*plus features

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current SQL Server and Oracle jobs in UAE