- UMBC Training Centers offers a range of SQL Database training for students of all levels of expertise, from beginners to power users. As a members of the Oracle Workforce Development Program and Microsoft Imagine Academy, we provide the quality materials to prepare you to perform on the job.
Introduction to SQL
This course is designed to give users an understanding of SQL Language. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations.
Certificate in Oracle Database Administration
The Certificate in Oracle Database Administration provides students with the skills, knowledge, and credentials required to enter the field of database administration. As an Oracle Workforce Development partner and an authorized Pearson Vue testing center, UMBC Training Centers is able to bundle official Oracle training and the certification exam, providing a direct and convenient pathway for committed students to master concepts in the classroom and obtain Oracle Database 12c Certified Associate certification. We are committed to preparing students with the on-the-job skills needed as an Oracle DBA as well as the knowledge to confidently complete the certification exam.
Microsoft SQL Server
Microsoft® SQL Server® 2012: Database Administration
You have created databases and executed queries on them. You are now ready to perform database administration tasks such as installation of SQL Server instances, configuration of SQL Server databases and settings, monitoring database performance, controlling user access to databases, and database maintenance. In addition to these tasks, SQL Server 2012 provides many advanced features that enable you to manage databases efficiently. By familiarizing yourself with these tasks and features, you can plan, deploy, administer, and maintain SQL Server databases efficiently. In this course, you will perform database administration tasks.
Microsoft® SQL Server® 2012: Database Querying
In this course, you will create queries to retrieve, add, update, and maintain your database data. You will also work with data sorting, built-in functions, stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and error handling features of SQL Server 2012.
Oracle Database 12c: Introduction to SQL
This Oracle Database: Introduction to SQL training helps you to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
Oracle Database 12c: Administration Workshop I or II
This course is designed to give students a firm foundation in basic administration of Oracle Database 12c. In this class, students learn how to install and maintain Oracle Database 12c. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
PostgreSQL 9 Database Administration and Deployment
This PostgreSQL 9 Database Administration and Deployment course covers PostgreSQL database administration and planning for a production deployment with multiple servers. Hands-on workshop exercises are provided for performance and replication fundamentals. The class will also introduce techniques and tools for managing servers as they grow over time.