COMPUTERS AND INFORMATION TECHNOLOGY DATABASES 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
Apr 2-Apr 4 Apr 9-Apr 17
MTW 9 am-4 pm MTWTh 6 pm-9 pm 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, students must successfully complete the following courses listed to the right within a two-year period.
Courses should be taken in the order listed below. REQUIREMENTS
Access, Introduction Access, Intermediate Database Design SQL, Introduction Access, Advanced
Crystal Reports, Introduction SQL Server Database Services Database Productivity Labs
HOURS 12
12 6
12 12 12 18 6
Total: 90 hrs
COST $299
$299 $199 $399 $299 $599 $699 $199
$2992
NEAST CESQL 609 30 HARBN CESQL 609 55
DATABASE PRODUCTIVITY LAB
At the end of the Database Analyst Certificate Program, students design a working database, queries, forms, and reports. This hands-on session provides the review and practical application needed to pull it all together and fine-tune your new database management skills. $199
Apr 24 T Apr 25-Apr 26 WTh
9 am-4 pm 6 pm-9 pm
HARBN CEDBS 626 37 HARBN CEDBS 626 59
MICROSOFT OFFICE 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 to design simple forms and reports. $299
Jan 8-Jan 9 MT Jan 22-Jan 30 MT
9 am-4 pm 6 pm-9 pm
ACCESS, INTERMEDIATE
Learn about database normalization, relationships, referential integrity, and how to analyze tables. Explore complex queries with joins, parameters, calculated fields, and summarizing and grouping values. Work with action queries and find unmatched or duplicate records. Learn to create more advanced reports with calculated fields and enhanced control formatting and data bars. $299
Jan 31-Feb 1 Feb 5-Feb 8
WTh ACCESS, ADVANCED
Learn more advanced form design with sub-forms, tab pages, and navigation forms. Students will import, export, and link external data and perform a Word mail merge with Access data. The database will be made more turn-key with macros, VBA
14 9 am-4 pm MTWTh 6 pm-9 pm
NEAST CEDBS 623 29 NEAST CEDBS 623 75
NEAST CEDBS 620 29 NEAST CEDBS 620 80
programming, and switchboards. Database management topics like dependencies, documenting, and compacting, repairing, splitting, security, and turning into ACCDE file will be addressed. $299
Mar 12-Mar 13 MT Mar 14-Mar 22 WTh
9 am-4 pm 6 pm-9 pm
OFFICE PRODUCTIVITY LAB
At the end of the Office Administrative Specialist Certificate Program, students will demonstrate their knowledge of office applications by creating documents and spreadsheets using the skills acquired in the program. Grades will be assigned in this course. To receive an Office Administrative Specialist Certificate, you must successfully complete this course. $159
Apr 25 W 9 am-4 pm POWERPOINT, INTRODUCTION
Your presentations can be show stopping. Create slide shows using PowerPoint's most commonly used features. $299 Mar 7-Mar 8
WTh 9 am-4 pm HARBN CEPDP 629 37 NEAST CEMSO 516 03
HARBN CEDBS 624 33 HARBN CEDBS 624 61
COURSE DESCRIPTIONS AND ADDITIONAL CLASS DATES @
MIDLANDSTECH.EDU/training
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
