Database school training courses in Charlotte, NC (public, in-house or online)

Southwest Florida College’s Computer Programming and Database Management degree program provides the foundation for positions in Information Technology such as computer support specialist, junior database analyst and administrator, programmer analyst, or systems analyst. In preparation for these positions, students will obtain the skills needed in both computer and network technology. Courses will cover the most current programming languages and database management
tools available.
...

Full archival course description>>

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Audience
This course is intended for IT Professionals who administer and maintain SQL Server databases.

At Course Completion
After completing this course, students will be able to:
�Create databases and datab...

Full archival course description>>

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Audience
This course is intended for IT Professionals who administer and maintain SQL Server databases.

At Course Completion
After completing this course, students will be able to:
�Install and configure SQL Se...

Full archival course description>>

Major tasks to be considered within this course are:
�Software installation and the creation of new databases.
�An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
�Management of database files.
�Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other...

Full archival course description>>

CHOOSING A SQL & PL/SQL INTERFACE
�USING SQL DEVELOPER
�USING SQL*PLUS
�USING APPLICATION EXPRESS
�USING JDEVELOPER STUDIO

LANGUAGE FEATURES
�UNDERSTANDING PL/SQL
�STRUCTURE OF A PL/SQL PROGRAM BLOCK
�USING PL/SQL FROM SQL*PLUS

DECLARE CLAUSE
�ABOUT THE DECLARE CLAUSE
�DECLARE SIMPLE TYPES
�DECLARE COMPLEX TYPES
�TYPE ... TABLE
�TYPE ... RECORD

BEGIN CLAUSE
�ABOUT THE BEGIN CLAUSE
�PERFORMING DATA MANIPULATION
�LOGI...

Full archival course description>>