COMPUTER AND INFORMATION TECHNOLOGY CAREER SPOTLIGHT DATABASE ANALYST
In today’s workplace, managers, programmers, and professionals need database skills. Without question, effective understanding, management, and analysis of data is a key to success for business professionals at all levels. To earn this certificate, you must successfully complete the following courses within a two-year period.
REQUIREMENTS Access, Introduction
Access, Intermediate Database Design SQL, Introduction Access, Advanced
Business Intelligence 1 Business Intelligence 2
SQL Server Database Services Database Productivity Lab
HOURS 12
12 6
12 12 12 12 18 6
Total: 102 hrs
COST $299
$299 $199 $399 $299 $599 $599 $699 $199
$3591
DATABASES 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. $199
Sep 3 Sep 4-Sep 5 T WTh SQL, INTRODUCTION
Prepare yourself to use generic SQL (Structured Query Language) to retrieve, store, and manipulate data from any relational database. Querying and SQL statement fundamentals will be covered. $399
Oct 21-Oct 22 MT 9 am-4 pm
Oct 28-Oct 31 MTWTh 6 pm-9 pm BUSINESS INTELLIGENCE 1
HARBN CEDBS 590 45 HARBN CEDBS 590 70
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. $599
Oct 7-Oct 8 MT 9 am-4 pm Oct 14-Oct 17 MTWTh 6 pm-9 pm
NEAST CEDBS 588 34 HARBN CEDBS 588 69
9 am-4 pm 6 pm-9 pm
HARBN CEDBS 614 12 NEAST CEDBS 614 65
BUSINESS INTELLIGENCE 2
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. $599
Oct 28-Oct 29 MT Nov 4-Nov 7
9 am-4 pm MTWTh 6 pm-9 pm SQL SERVER DATABASE SERVICES
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. $699
Nov 18-Nov 21 MTW 9 am-4pmHARB CEDBS 641 04 Nov 25-Dec 10 MTWTh 6 pm-9pmHARB CEDBS 641 50
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. $199
Dec 9 M Dec 11-Dec 12 WTh
9 am-4 pm 6 pm-9 pm
HARBN CEDBS 626 42 HARBN CEDBS 626 64
HARBN CEDBS 645 01 NEAST CEDBS 645 50
ENROLL @
MIDLANDSTECH.EDU/training | 803.732.0432 | see page 46
15
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42 |
Page 43 |
Page 44 |
Page 45 |
Page 46 |
Page 47 |
Page 48