Database Admin school training courses in Baltimore, MD (public, in-house or online)

The Database Systems Administration Certificate offers students skills necessary for designing, using, implementing and managing traditional and non-traditional multi-user database systems and applications. Practical experience is gained in utilizing various database management systems (DBMS) environments such as Oracle, Microsoft SQL Server, and Microsoft Access running on UNIX or Microsoft Windows platforms. Database Systems Administration is designed to prepare students for various vendor cer...

Full archival course description>>

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

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