Michael McDonnell

COMP 1630 provides an introduction to relational database design concepts and industry standards. Topics include functional dependencies, normalization, database design methodologies, entity relationship modeling and the use of UML as a diagramming notation. Advanced topics include: an introduction to SQL, DDL- data definition language and DML- data manipulation language, views, security, transaction management, triggers and stored procedures. Current trends in database such as replication, object-relational DBMS, data warehousing, OLAP- online analytical processing and database uses web technology are discussed. Upon successful completion, participants will be able to design and implement a database application.

This course provides an understanding of computer terminology, operating systems, and the most popular office software used in business. Students will become proficient on MS Word, MS Excel, and MS Power Point with the latest version of Microsoft Office.

This instructor lead, hands-on course focuses on best practices used to create meaningful workbooks and how to master the techniques and time saving shortcuts for the daily use of MS Excel. Students learn to use MS Excel Ribbon interface with contextual tabs, Quick Access Toolbar and how to make use of templates, styles, pivot tables, what if analysis tools and macros via lectures, lab exercises and assignments outside of class. Topics include: creating, editing, formatting and saving a worksheet, sorting, filtering, slicers, applying formulae, functions, importing and exporting data, and consolidating data in multiple worksheets. This course provides preparation to write a Microsoft Office Specialist certification exam, available through third parties at additional cost. By the end of this course, successful participants will be expert end users of MS Excel.