Oracle Database 10g: Introduction To SQL - Part II Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 479
Course Abstract:	The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. Major subject areas to be explored are: > Learn to use the SQL99 join syntax. Also, performing advanced SQL queries using techniques such as grouping and cube operations. > Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others. > Understanding basic database security and object privileges. > Using the powerful set of built-in SQL functions. > Protecting the database and extending the basic data model using declarative constraints. > Developing complex SQLPlus reports and using SQLPlus scripts.
Audience:	The target audience for this course is all Oracle professionals. Further, this course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. Among the specific groups for whom this course will be helpful are application developers and database administrators.
Duration:	3 days
Learning Outcomes:	Refer to Course Topics
Course Topics:	SQL99 Join Techniques Cross Joins Natural Joins Inner Joins Outer Joins Anti Joins Using Named Subqueries Enhancing Groups With Rollup & Cube Using The Case Expression SQL Functions: Character What Are The SQL Functions? Character Functions About Greatest(), Least() SQL Functions: Numeric SQL Functions: Date Date Format Functions Date Arithmetic Functions Database Objects: Relational Views About Relational Views Updating View Data Maintaining View Definitions Alter View Drop View Database Objects: Data Dictionary Storage User_Updatable_Columns Understanding The Data Dictionary Structure Database Objects: Indexes About Indexes Use B-Tree Indexes Database Objects: Other Objects Creating An Application Schema More About Creating Tables Defining Sequences Alter Sequence & Drop Sequence Alter Sequence Drop Sequence About Synonyms Drop Synonym Create Schema Authorization Database Objects: Security User Id Passwords Object Security Data Integrity Using Constraints Not Null Constraint Check Constraint Unique Constraint Primary Key Constraint References Constraint Managing Constraint Definitions Managing Constraints Renaming & Dropping Constraints Enabling & Disabling Constraints Deferred Enforcement Set Constraints Handling Constraint Exceptions Data Dictionary Storage Optional – Advanced SQLPlus Reports Break Compute Column Ttitle & Btitle Optional – Building SQLPlus Scripts Using SQL*Plus Variables Define & Undefine Accept Prompt Pause
Prerequisites:	The course Oracle Database 10g: Introduction to SQL - Part 1 is a mandatory prerequisite for this course.

Oracle Database 10g: Introduction To SQL - Part II Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology