Database Analyst
Overview
Every business has data needs. In a business climate where everything is tracked digitally and as businesses become increasingly agile, the database analyst will find their skill set in high demand. Database analysts are employed across a wide variety of industries as businesses seek out skilled professionals to help them unlock and leverage the full potential of their data assets to allow them to excel.
A database analyst has competencies in the creation, management, and usage of databases. This includes data normalization, the creation of relational databases, creating secure identity management solutions for single- and multi-user database environments, proficiency in database software solutions including, but not limited to MS Access, T-SQL, and Oracle. Additional areas of proficiency include data-storage solutions, database troubleshooting, implementing cloud solutions, needs-based data-design goals, the creation of secure input forms, change management in data environments, installing and configuring database server software, organizing and maintaining data sources, leveraging business intelligence to produce real-time reports, data visualizations, trending/forecasting, and dashboards to help businesses use their data to make the most accurate decisions available.
Agile Fundamentals is the most widely used Agile Methodology, Scrum, for managing software development projects. Upon completing the Agile Fundamentals course, you will be able to participate on any project team and understand the Agile roles and responsibilities. Many organizations are changing the way software development projects are implemented. Completing the Agile Fundamentals course will increase your opportunities for IT careers in the software development IT arena.
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.
*Additional testing required for certifications.
How to Enroll
To pursue this certificate, please click on the courses below to see availability. You can register for courses online, and you do not have to apply to the college!
Talk to us
Tuition Assistance
Training Resources
Questions?
Call 803.732.0432 to talk to us about this program, or email cce@midlandstech.edu
Sample Program Plan and Costs
Students must successfully complete these courses within a two-year period. This program can be completed in three to four months.
Take all of the below courses in the order listed.
Class Delivery Methods
View current courses offered via our online course directory.
| On-Campus | Traditional. Classes meet on campus. |
|---|---|
| Virtual | 100% online. Meets with a live instructor and classmates on specific days, at specific times. Uses web conferencing software, like Zoom. |
| Hybrid | Some classes on campus. Some classes online or virtual. |
| Online | 100% online. Due dates for projects and assignments. Self-paced work on your time. |
| CEUs | Class Hours | Course Title | Cost |
|---|---|---|---|
| 1.20 | 12 |
Excel, Introduction Learn how to create effective and efficient worksheets using formulas, common functions, formatting, and printing. Microsoft Excel is required for online classes. Classroom, Online ID: CESDS-602 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.
|
$299.00 |
| 1.20 | 12 |
Excel, Intermediate Learn specialized functions, like IF, COUNTIF, and DSUM, and how to effectively analyze, sort, filter data, create outlines, subtotals, range names, and work with tables. Display data more visually in charts, Pivot tables, and charts and work with slicers and templates. Microsoft Excel is required for online classes. Classroom, Online ID: CESDS-610 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.
|
$299.00 |
| 1.20 | 12 |
Excel, Advanced In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends. Microsoft Excel is required for online classes. Classroom, Online ID: CESDS-611 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.
|
$299.00 |
| 0.60 | 6 |
Database Design 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. Classroom ID: CEDBS-614 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.
|
$199.00 |
| 1.20 | 12 |
Access, Introduction 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. Classroom ID: CEDBS-620 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.
|
$299.00 |
| 1.20 | 12 |
Access, Intermediate 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. Classroom ID: CEDBS-623 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.
|
$299.00 |
| 1.20 | 12 |
SQL 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. Classroom ID: CEDBS-590 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.
|
$499.00 |
| 1.20 | 12 |
Access, Advanced 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. Classroom ID: CEDBS-624 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.
|
$299.00 |
| 1.20 | 12 |
Business Intelligence 1 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. Classroom ID: CEDBS-588 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.
|
$599.00 |
| 1.20 | 12 |
Business Intelligence 2 The creation of data-backed visualizations is a key way a 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. Classroom ID: CEDBS-645 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.
|
$599.00 |
| 2.40 | 24 |
SQL Server Database Services Create queries to retrieve, add, update, and maintain database data. 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. Classroom ID: CEDBS-641 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.
|
$899.00 |
| 0.60 | 6 |
Database Productivity Lab 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. Classroom ID: CEDBS-626 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.
|
$199.00 |
| 1.80 | 18 |
Agile Fundamentals This course provides you with the Agile values and principles to incorporate Agile methodologies into your organization. To be successful in delivering software using Agile methods, you must have a strong and stable agile mindset. This course focuses on being Agile before doing Agile and provides a common foundation for making decisions about the best way to develop software using agile values and principles and introduces you to PMI's Agile Certified Practitioner (PMI-ACP)®. This course prepares you for the Professional Scrum Master 1 (PSM1) certification. Prerequisites: Familiarity with the software development life cycle (SDLC). Virtual ID: CEPMG-573 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.
|
$699.00 |
|
Estimated Cost
Tuition Assistance
$5,487.00
Not including fees and equipment |
|||
What’s next after I complete this program?
Enter the Workforce as a Database Analyst
Upon completing this certificate, you will have the necessary skills to gain employment in any industry requiring hands-on experience and training to be a Database Analyst.
Continue Your Education with MTC’s Project Manager Program
Expand your capabilities using the data analysis skills learned by earning your Project Manager 1 certification. You can take it one step further by completing the Project Manager 2 certification.