SQL Databases

Course Overviews

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

View all sql Courses

• 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. Click for more information

• 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. Click for more information

Microsoft SQL Server (Certificate Map)

• 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. Click for more information

• Introduction to SQL Databases

  This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. Click for more information

• Administering a SQL Database Infrastructure

  This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. Click for more information

• Provisioning SQL Databases

  This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure. Click for more information

• Performance Tuning and Optimizing SQL Databases

  This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases. Click for more information

• Querying Data with Transact-SQL

  This course is designed to introduce students to Transact-SQL. It is designed in such a way that students aquire the knowledge for other courses in the SQL Server curriculum. Click for more information

• Managing SQL Business Intelligence Operations

  This course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources. Click for more information

• Analyzing Data with SQL Server Reporting Services

  This course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. Click for more information

• Analyzing Data with Power BI

  This course course provides students with the knowledge and skills to analyze data with Power BI. Click for more information

• 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. Click for more information

• 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. Click for more information

Oracle (Certificate Map)

• 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. Click for more information

• Oracle Database 12c: Administration Workshop

  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. Click for more information

• 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. Click for more information

• Oracle Database 12c: Install and Upgrade Workshop

  This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service. Click for more information

• Oracle Database 12c: Backup and Recovery Workshop

  This Oracle Database 12c: Backup and Recovery Workshop will teach each you how to evaluate your own recovery requirements. You will develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service. Click for more information

• Oracle Database 12c R2: Managing Multitenant Architecture

  During the Oracle Database 12c Administration Workshop, students cover a brief overview of the multitenant container database and its pluggable databases. This Oracle Database 12c R2: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. Click for more information

• Red Hat System Administration I (RH124)

  Red Hat System Administration I provides a foundation for students wishing to become full-time Linux system administrators by introducing key command line concepts and other enterprise-level tools. These concepts are further developed in the follow-on course, Red Hat System Administration II (RH134). Click for more information

• Linux for Cyber Fundamentals

  In this course, you will learn basic to intermediate end-user commands to help you navigate and use the Linux Operating System. Click for more information

• Red Hat System Administration II (RH134)

  This course goes deeper into enterprise Linux administration including file systems and partitioning, logical volumes, SELinux, firewalling, and troubleshooting. Attending both Red Hat System Administration I and Red Hat System Administration II can help you in your preparation for the Red Hat Certified System Administrator exam (EX200). Click for more information

• Linux for Cyber Administration

  In this course, you will build on Linux Fundamentals with more intermediate end-user and administrator command line operations focused on local system administration tasks. Click for more information

Postgre SQL

• 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. Click for more information