Database school training courses in Cambridge, MA (public, in-house or online)

Earn your database administration certification at American Career Institute.

Students here learn how to perform the major tasks needed to administer and support Oracle database systems on both Microsoft Windows and Linux. And once you learn, there’s an opportunity to earn. Oracle is the most widely used database management system in the business field today. That creates a demand for skilled Oracle database administrators.

Where you’ll take your Oracle training matters too, especi...

Full archival course description>>

6232: Implementing a Microsoft SQL Server 2008 Database

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

After completing this SQL Server 2008 R2 training course, students will be able to:
Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
Plan, install and configure SQL Server 2008 R2
Backup and restore databases
Import and export wizards and explain how they relate to SSIS
Use BCP and BULK INSERT to import data
Manage security
Assign, configure fixed database roles and create and assign user defined database roles
Full archival course description>>

After completing this SQL Server 2008 R2 training course, students will be able to:
Understand the product, its components, and basic configuration.
Work with the data types supported by SQL Server.
Design and implement tables and work with schemas.
Design and implement views and partitioned views.
Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
Identify the appropriate table structures and implement clus...

Full archival course description>>

This 5-day SQL Server 2012 training from Solartehc introduces Microsoft SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.