750. oracle 10g - introduction to sql Workshop

software training academy
toronto, on, canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 1. introduction to relational databases

relational model of data

key concepts

data structure: two dimensional5?s

what is a join?

data integrity

primary keys

sql concepts, examples and terminology

relational database design

entities, attributes and relationships defined

many-to-many relationship

normal forms



2. introduction to oracle10g

what is the oracle database?

principal features

ddl & dml statements

enterprise, standard & personal editions

8i & 9i releases

10g release overview

oracle architecture

common schema objects



3. introduction to sql*plus

development environment

connect to sql*plus

sql*plus describe command

sql*plus connect command

customizing your environment (login.sql and predefined variables) (10g)

sql*plus host command

executing queries in sql*plus

spooling the output

editing in sql*plus

listing and editing the buffer contents

sql*plus edit command

related sql*plus commands

editing: a better way

running sql*plus scripts

exit from sql*plus

what’,s in my recyclebin? (10g)

workshop



4. introducing isql*plus

starting the isql*plus application server

launching isql*plus in your browser

using the workspace

accessing history

setting preferences



5. querying the database, simple select, part i

simplified select statement

select column list

select distinct

calculated columns

column aliases

concatenated columns

sorting: order by

sorting by calculated columns

sorting by column alias

sorting by multiple columns

case (and accent) insensitive sort (10g)

comparison operators

available comparison operators

quoting text strings (10g)

logical operator and

available logical operators

accessing remote5?s

workshop



6. datatypes and functions

datatypes

workshop

new xml data type

miscellaneous data types

datatype conversion

dual: the oracle work5?

pseudo columns: user, sysdate, uid, null

pseudo columns: rowid and rownum

functions overview

string manipulation functions

case conversion functions

concatenation function

trim function

substr function

instr function

decode function

translate function

numeric functions

round function

trunc function

nvl function

character conversion function

to_char example: number to character

new 9i built-in functions

date conversion functions

to_char examples: character to date

to_date examples

datetime conversions

time zone functions

date arithmetic & functions

adding & subtracting days

add_months function

last_day function

trunc function

workshop



7. querying the database, part ii - advanced filters

conditional operators

search lists: in

search range: between

search patterns: like

introduction to nulls

selecting rows with null values

is null operator

ansi compliant case

simple case example



8. querying the database, part iii - joins

simple joins

unqualified names in joins

table aliases in joins

outer joins

ansi compliant joins

ansi natural join

ansi inner join

ansi outer joins

full outer joins

partition outer join (10g)

ansi cross join



9. querying the database, part iv - set operators

union, intersect and minus operators

union example

intersect example

minus example



10. querying the database, part v - subqueries

subquery overview

subquery in operator

subquery exists operator

not exists example

subquery in from clause

extended subquery support

named subqueries

workshop



11. querying the database, part vi - grouping data

group functions

min, max, sum, count, avg

group functions with nulls

summary grouping

group by clause

grouping multiple columns

golden group by rule

where clause restrictions

having clause

rollup

cube

grouping function

decode and grouping

workshop



12. regular expressions (10g)

introduction

pattern matching with rege9?like

using rege9?instr, rege9?replace, rege9?substr



13. data manipulation and transaction control

inserting rows

rounding on insert

returning values from dml

returning aggregates (10g)

inserting multiple rows

9i multi-table insert.

deleting rows

truncate command

updating a single row

updating multiple rows

merge statement.

10g merge enhancements (10g)



14. concurrency control

introduction to locks

row lock architecture

basic locking rules

dml & ddl locks

locking issues: lost update.

locking issues: blocking

locking issues: deadlocks

deadlocks: cause and fix

workshop



15. transaction control

transaction review

supported statements.

statement level read consistency.

transaction level read consistency

oracle isolation levels

phantom and non-repeatable reads

read committed

serializable

read only

savepoints

implicit commits

workshop



16. 5?s and indexes

oracle objects

naming rules

listing oracle objects using the data dictionary

creating5?s

naming constraints example

creating5?s from other5?s (ctas)

managing constraints

altering5? structure

3?table adding columns

3?table adding constraints

drop column

dropping5?s

introduction to indexes.

b-tree indexes

index diagram

rowid structure

index creation

index use - who decides?

workshop



17. views and synonyms

what is a view?

views concept diagram

what are views used for?

creating views: hiding sensitive columns

creating views simplify5? access

creating views: using column aliases

updateable views

read only views

with check option

views & the data dictionary

what is a synonym?

private & public synonyms

create synonym examples

synonym search sequence

synonyms & the data dictionary

workshop



18. other database objects

privileges and roles

roles - concepts

determining privileges

sequences

caching of sequences

sequences - uses

using a sequence to generate a primary key

sequences & the data dictionary

workshop



19. introduction to sql tuning

sql tuning basics

tuning - the process

the plan5?

sql*plus autotrace

workshop



20. where do i go from here?

certification

getting help

other topics



21. ap ...''

Elements of this syllabus are subject to change.

Phone:1-888-896-7852

School Address:

1 yonge st, 18th floor

Jobs & Resumes: toronto
Houses & Roommates: toronto
Travel Agencies: toronto

Search other schools for 750. oracle 10g - introduction to sql training resources.

developing applications using visual basic 2008 (vb2008)

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: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.