Training Course:Oracle 9i: SQLSchool/Trainer:Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Students will learn how to effectively maintain and administer a Oracle Database. This course prepares you to appear for the Oracle DBA exam. 32 Hrs
Suggested Prerequisites: Sound Knowledge of Windows, and Microsoft applications (MS Word, MS Excel and Microsoft Access) required. Knowledge of using Application packages for data entry.
Attend and You Will Learn
Lesson 1: INTRODUCTION TO ORACLE 9i: SQL
List the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Differentiate between SQL statements and iSQL*Plus commands
Restricting and Sorting Data
Limit the rows retrieved by a query
Sort the rows retrieved by a query
Single-Row Functions
Describe various types of functions available in SQL
Use character, number, and date functions
in SELECT statements
Use conversion functions
Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table using equality and non-equality joins
View data that generally does not meet a join condition by using outer joins
Join a table to itself using a self-join
Aggregating Data using Group Functions
Identify the available group functions
Use group functions
Group data using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause ...''
Please go to the school's official website for training price and schedule:
http://www.ncsu.edu/
http://www.ncsu.edu/ctu/
Phone:919.515.8163
School Address:
Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA
Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh
Other training courses offered by Computer Training Unit, North Carolina State University:
Windows 2003 Active Directory
MCSA 2003
Cisco Certified Network Associate (CCNA)
Programming with Microsoft Visual Basic .NET
Microsoft Office Specialist Excel 2003
Microsoft Office Specialist Access 2003
Microsoft Office Specialist Word 2003
Microsoft Office User Specialist Test Prep
Certificate in Network Security
CompTIA Network+
Oracle Database Administrator 10g (DBA)
Oracle Database 10g Administrator Certified Professional
Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: Security
Oracle Database 10g Administrator Certified Associate
Oracle DBA
Oracle Performance Tuning and Monitoring
CompTIA Security+
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.
Facts:
We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa. |
|
|
