Database Analyst

With a recent boom in database requirements across all industries, you will find your skills in high demand as a database analyst. Complete your training in as few as three months, and find yourself installing computer databases, adding users, testing systems, and ensuring they perform as they should. Use your strong communication skills and knowledge of computers earning an average $32 an hour working in almost any organization.

This program prepares you to obtain the Microsoft Specialist:  Access* certification. 

To earn this certificate, students must successfully complete the following courses within a two-year period.  Courses should be taken in the order listed below.

Click here to see all classes associated with this program and an estimated program cost.


Take all of the following in order listed:

Database Design

ID: CEDBS-614

Is your database efficient and easy to work with? Learn the theory behind relational databases, entity relationship diagrams, and normalization of data and plan the design of a database.

  • Total Hours: 6.00
  • CEUs: 0.60
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

Access, Introduction

ID: CEDBS-620

Take away the mystery of database design in Access by creating, designing, and editing tables. Learn to create simple queries and filters and develop the skills to design simple forms and reports.

  • Total Hours: 12.00
  • CEUs: 1.20
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

Access, Intermediate

ID: CEDBS-623

Learn about database normalization, relationships, referential integrity, and analyzing tables. Explore complex queries with joins, parameters, calculated fields, and summarizing and grouping values. Work with action queries and finding unmatched or duplicate records. Learn to create advanced reports with calculated fields and enhanced control formatting and data bars.

  • Total Hours: 12.00
  • CEUs: 1.20
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

SQL

ID: CEDBS-590

This course prepares the novice database user to use generic SQL (Structured Query Language) to retrieve, store, and manipulate data from any relational database. The course will progress quickly through fundamental concepts and move into advanced SQL concepts such as nested queries, tables, and data manipulation as well as indexing. This course prepares the novice database user to use generic SQL (Structured Query Language) to retrieve, store, and manipulate data from any relational database.

  • Total Hours: 12.00
  • CEUs: 1.20
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

Access, Advanced

ID: CEDBS-624

Learn more advanced form design with sub-forms, tab pages, and navigation forms. Import, export, and link external data and perform a Word mail merge with Access data. Learn how to have a more turnkey database with macros, VBA programming, and switchboards. Learn about database management topics like dependencies, documenting, compacting, repairing, splitting, security, and converting into ACCDE.

  • Total Hours: 12.00
  • CEUs: 1.20
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

Business Intelligence 1

ID: CEDBS-588

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2016 helps you build advanced reports with ease, presenting complex information in an understandable way. Crystal Reports® 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.

  • Total Hours: 12.00
  • CEUs: 1.20
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

Business Intelligence 2

ID: CEDBS-645

The creation of data-backed visualizations is a key way data scientist, or any professional, can explore, analyze, and report insights and trends from data. Tableau® software is designed for this purpose. Tableau® was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. In this course, you will visualize data with Tableau.

  • Total Hours: 12.00
  • CEUs: 1.20
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

SQL Server Database Services

ID: CEDBS-641

Learn everything you need to be productive with SQL Server. This course gives you hands-on exposure to database design and creation, security, diagramming, backup, recovery, indexes, views, stored procedures, triggers, and basics of reporting services.

  • Total Hours: 24.00
  • CEUs: 2.40
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

Database Productivity Lab

ID: CEDBS-626

Design a working database, queries, forms, and reports. This hands-on session provides the review and practical application needed to pull the courses in the Database Analyst Certificate Program together and fine-tune your new database management skills. You must successfully complete in order to receive the Database Analyst Certificate. Prerequisites: Access (Introduction, Intermediate and Advanced), Database Design, SQL (Introduction), Crystal Reports (Introduction), and SQL Server Database Services.

  • Total Hours: 6.00
  • CEUs: 0.60
View available classes
No sections currently available. For information on Training classes, contact our Corporate and Continuing Education Department (CCE) at 803.732.0432 or cce@midlandstech.edu.

Course Search