Oracle 10g Introduction to SQL

Software Training Academy
Toronto, Ontario, Canada

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

Course Description:

'' This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases.



Students receive a comprehensive introduction to Oracle’s implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts.



LEARNING OBJECTIVES



· Describe the principal features of a relational database

· Describe the principal features, versions and editions of the Oracle database

· Query and manipulate an Oracle database using Structured Query Language (SQL), including the use of functions, regular expressions and much more

· Code sophisticated query operations such as join, grouping, case and more

· Update data with insert, multi-table insert, update, delete and merge operations

· Utilize SQL*Plus and iSQL*Plus to query, update and create database objects

· Create simple database tables with all the major datatypes such as NUMBER, VARCHAR2, DATE, TIMESTAMP and LOBs

· Query Oracle data dictionary tables such as USER_TABLES and USER_OBJECTS

· Utilize transaction control statements such as Commit, Rollback and Savepoint

· Create database objects such as tables, temporary tables, nested tables, views, indexes, synonyms and sequences

· Grant and Revoke object privileges



Course Duration: 4 days

...''

Phone:1-888-896-7852

School Address:

Toronto Star Building
1 Yonge Street, Suite 1801
Downtown Toronto
Ontario, Canada - M5E 1W7

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

Search other schools for Oracle 10g Introduction to SQL training resources.

XML
Jakarta Struts
Java Development for Secure Systems
Java Persistence with Hibernate
Java Foundation Classes (Swing) Java 5.0
Java Servlets
JSP
JDBC
Oracle 10g Advanced SQL
Oracle 10g PL/SQL Programming
Oracle Applications Using ADO.NET and C#
J2EE
Visual Basic for Applications (VBA)
Securing Java Web Applications
SQL Server 2005 Additional Topics
SQL Server 2005 Analysis Services (SSAS)
SQL Server 2005
SQL Server 2005 Integration Services (SSIS)

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: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.