Page 13

COMPUTERS

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

Aug 7-Aug 9   MTW       9 am-4 pm          HARBN          CESQL 609 28

Aug 21-Aug 30               MTW                     6 pm-9 pm    HARBN  CESQL 609 53

Database Productivity Lab

At the end of the Database Design and Management 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

Aug 14            M             9 am-4 pm          HARBN          CEDBS 626 35

Career Spotlight

Database Analysis (QuickJobs, CoursePower, and Approved for Veteran Education Benefits)

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 within a two-year period.

Courses should be taken in the order listed.

requirements                                Hours              Cost

Access, Introduction                           12                       $289

Access, Intermediate                          12                       $289

Database Design                                6                          $199

SQL, Introduction                                12                       $399

Access, Advanced                              12                       $289

Crystal Reports, Introduction            12                       $599

SQL Server Database Services       18                       $699

Database Productivity Labs              6                          $199

                                                     Total: 90 hrs            $2962

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. $289

May 10-May 11              WTh                      9 am-4 pm    NEAST   CEDBS 620 27

May 22-May 30              MT                        6 pm-9 pm    NEAST   CEDBS 620 78

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 finding unmatched or duplicate records. Learn to create more advanced reports with calculated fields and enhanced control formatting and data bars. $289

May 31-Jun 1 WTh        9 am-4 pm          HARBN          CEDBS 623 27

Jun 5-Jun 13  MT           6 pm-9 pm          NEAST           CEDBS 623 73

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 programming and switchboards. Database management topics like dependencies, documenting, compacting, repairing, splitting, security, and turning into
ACCDE file will be addressed. $289

Jul 17-Jul 18  MT           9 am-4 pm          HARBN          CEDBS 624 31

Jul 5-Jul 13    WTh        6 pm-9 pm          NEAST           CEDBS 624 58

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. $149

Aug 23            W             9 am-4 pm          NEAST           CEMSO 516 01

REGISTER @ MIDLANDSTECH.EDU/training | 803.732.0432 | see page 2