Database Admin school training courses in Boston, 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>>

You Will Learn How To

Leverage SQL Server technologies to achieve high-availability database solutions
Design a Service Level Agreement that matches business requirements
Plan, prepare and install a SQL Server failover cluster
Maintain a warm standby server with log shipping
Mirror a database to ensure instant failover
Employ peer-to-peer transactional replication as a high-availability solution

Course Benefits

SQL Server provides a full range of technol...

Full archival course description>>

You Will Learn How To

Administer SQL Server 2008 with SQL Server Management Studio and Transact-SQL
Build databases and upgrade from prior versions
Secure the server through logins and permissions management
Automate administrative activities with SQL Server Agent multistep jobs
Perform routine maintenance to correct fragmentation and database corruption
Identify problems and monitor server health

Course Benefits

SQL Server 2008 provides a robust platfor...

Full archival course description>>

The Microsoft Certified IT Professional (MCITP) certification is appropriate for IT professionals who administer a Microsoft SQL Server 2005 database. This certification tests knowledge related to installation and management of SQL Server 2005, backup and maintenance of databases, generation of reports, security management and implementation of automated tasks.

Classroom-based training combined with intensive hands-on labs build the knowledge and experience you needed to succeed!

Full archival course description>>

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>>