ExitCertified Training Training with Java Solaris Red Hat IBM Symantec Siebel PeopleSoft Certified
 
Start
Training Courses and Schedules
Training Savings
IT Certification
Training Solutions
Loading
Trust Your IT Training   |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.
Email Training Course

Oracle Database 10g: SQL Fundamentals Self-Study CD Course

Format: Self-Paced DVD/CD
Other Formats:
 
 

Oracle University Self-Study CD Courses are a great accompaniment and reliable alternative to our inClass courses, and provide an excellent ongoing resource for reviewing key concepts and practicing skills.

In this CD ROM course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Learners will be introduced to the powerful SQL programming language and its features. After learning the basics of SQL, participants will be introduced to advanced features of SQL, such as advanced querying, reporting, schema objects, manipulating large data sets, advanced sub-queries, and storing and retrieving dates according to different t
 
 

Skills Gained
 

  • Search data using advanced sub queries

  • Retrieve row and column data from tables with the SELECT statement

  • Control user access and manage schema objects

 

  • Run data manipulation statements (DML) to update data in the Oracle Database 10g

  • Employ SQL functions to generate and retrieve customized data

Who Can Benefit
 

  • PL/SQL Developer

  • System Analysts

 

  • Technical Consultant
 
Buy This Training
Enroll For This Class
Oracle DB PeopleSoft Hyperion This self-paced course is Certified By Oracle.

Oracle University has awarded ExitCertified the 2009 Partner of the Year and Outstanding Instructor Quality Awards

There is a difference....learn more.
Buy Training Now Ask A Question About This Training
Code: D47359
Format: Self-Paced DVD/CD
Length:
Certified By: Oracle
Tuition (CAD): $669
Browse Similar Training Classes
Related training classes
Instructor Training Classes
Instructor-Led Live Virtual Class
Oracle Database 10g: SQL Fundamentals I - LVC

Sort Schedule By: 
     
Virtual Live Class Sep.6 - Sep.8.2010 course register
Virtual Live Class Oct.4 - Oct.6.2010 course register
Virtual Live Class Nov.1 - Nov.3.2010 course register
Virtual Live Class Dec.6 - Dec.8.2010 course register
     
   
Request Other Course Date Request Course On-Site
 

Oracle Database 10g: SQL Fundamentals Self-Study CD Course Content Details
 
 
Identify features of an Entity Relationship (ER) model
 
Identify features of Relational Database Management System (RDBMS)
 
Identify the SQL statement to retrieve data from tables
 
Identify arithmetic expressions used to perform operations on data
 
Identify operators used to format results in SQL statements
 
Identify features of single-row functions
 
Match the character functions with their uses
 
Match the number functions with their purpose
 
Identify the use of natural joins to retrieve data from multiple tables
 
Identify the use of an equi-join to retrieve data from multiple tables
 
 
Identify the use of self-join to retrieve data from a table
 
Identify the code for using the INSERT statement
 
Identify the code for using the UPDATE statement
 
Identify the code for using the DELETE statement
 
Identify tasks to be performed for granting system privileges
 
Identify tasks to be performed for granting object privileges
 
Identify syntax for performing various tasks for maintaining columns
 
Identify the code for retrieving data hierarchically from a table
 
Identify the code for formatting hierarchical reports
 
Identify features of regular expression functions
 


  ExitCertified Training with Java Solaris Red Hat IBM Symantec Apple MySQL Siebel PeopleSoft  
  When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience.

There is a difference. Learn from the source.		  
Training Contacts  
   
Canada United States

Vancouver Training :: 604.633.3948
Victoria Training :: 1.866.328.3948
Calgary Training :: 403.291.2855
Edmonton Training :: 780.441.3948
Regina Training :: 1.866.328.3948
Toronto Training :: 416.487.3948
Ottawa Training :: 613.232.3948
Montreal Training :: 514.876.1666
Quebec City Training :: 514.876.1666

Sacramento Training :: 916.669.3970
San Francisco Training :: 415.975.3948
San Jose Training :: 408.288.3948
Las Vegas Training :: 1.800.803.3948
Phoenix Training :: 602.889.9350
Worldwide - 613.232.3948 Got Questions?
We are happy to help. Just email us with this form and we'll get back to you shortly.
   



(c) 2010 ExitCertified Corp. All rights reserved.


ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:
 
Sun Microsystems Training Oracle Training Symantec Training IBM Training Red Hat - Linux Training
Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses, Solaris Training, Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, Fusion Middleware Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, BEA Courses, e-Business Suite Altiris Training, NetBackup Training, Veritas Training, Symantec Certification, Virus Protection Courses, IT Security Training DB2 Training, Cognos Classes, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class, CISCO Training, VMWare Training SUSE Training, RedHat Training , JBoss Training
         
MySQL Training Apple Training Hitachi - HDS Training Project Management PMI Training  
  Apple Course, Leopard Training, Xsan Training