Oracle Certification Preparation

Welcome to the new Oracle DBA career track which is a career builder for aspiring database administrators.
The course is designed to prepare students to handle the job of an Oracle DBA effectively in a real-world environment. It emphasizes on hands-on DBA experience on Solaris servers which would be setup in the classroom. Students will study major functionality of Sun Solaris 10 as a platform of choice by many leading companies. Oracle holds about 70% of market share for all Unix-based databases. Students will learn Oracle architecture, advanced SQL and introduction to PL/SQL programming. Students will create and maintain all major database objects: tables, views, indexes, and sequences. Students will be familiar with procedures, functions, packages and triggers. All in-class exercises are based on real database. The Oracle DBA part of the class will cover all major aspects of database administration. Students will learn how to create and manage instances, databases and all database objects. This part of a course will cover preparation for the first exam for OCP. The course allocates 60 hours for all labs with Oracle 10g and Sun Solaris 10.This class lays out solid background for future Oracle classes to follow and database development.
Software Testing & Quality Assurance
Teacher
Register
Please visit the SCAE website to check availability and register.
Prerequisites: Basic computer knowledge, some Unix and/or relational databases experience desired.
Textbook: Discussed in class.
Pre-registration required.

Learning SQL using Microsoft SQL Server

Microsoft SQL Server is a very popular and widely deployed relational database-management system, designed for high-performance online transaction processing, data warehousing and e-commerce applications, on Windows Server operating systems. The students enrolled in this course, Learning SQL using Microsoft SQL Server, will be introduced to SQL Server architecture and components, use tools such as SQL Server Management Studio to manage databases and other objects within a SQL Server database and learn how to use Structured Query Language (SQL) to query and update data in Microsoft SQL Server database.
Software Testing & Quality Assurance
Teacher
Register
Please visit the SCAE website to check availability and register.
Prerequisites: Basic computer knowledge.
Textbook: Discussed in class.
Pre-registration required.
Close
Register!
All registration is done via the the SCAE website. When you're ready to register, head over!