
If you’re currently in, or looking to join, the Information Technology (IT) field, database management and Microsoft Office knowledge are critical skills to have! To make it easy and convenient to learn these skills, Hofstra University Continuing Education (CE) is offering online courses for beginner and intermediate database management and for the entire Microsoft Office suite (including the information you need for the Microsoft Office Specialist [MOS] Master credential). What better way could there be to get the knowledge you need?
Note: click on the course names to go to the course page and to register.
DATABASE MANAGEMENT
May 20-July 1 (Self-paced with materials available until August 31, 2013)
This is an advanced course on database management systems (DBMS) concentrating on the relational data model and SQL. It covers relational model theory; conceptual, logical, and physical database design; data normalization; integrity constraints; databases in the global business environment; data accuracy; and security and privacy protection. This course requires designing and implementing databases using a mainframe and/or micro DBMS.
July 8-August 20 (Self-paced with materials available until August 31, 2013)
This is a practical course covering the concepts of Relational DBMS (RDBMS), SQL, and Procedural Language (PL)/SQL. Topics include conceptual design, relational systems design, normalization and denormalization processes, SQL and its components; and advanced queries, joins, outer joins, subqueries, group functions, formatting query results, triggers, and stored procedures. Emphasis is placed on data security, data integrity, query optimizations, and database administration.
MICROSOFT OFFICE
Hofstra’s Microsoft Office 2010 courses are offered in a bundle (first listing below) or as individual courses (all items below the first).
Includes all five core Microsoft Office applications (Access, Excel, Outlook, PowerPoint, and Word). More than 225 hours of training covers beginning and advanced topics for each application and equips you to earn the Microsoft Office Specialist (MOS) Master credential.
35+ hours of comprehensive Outlook curriculum, Microsoft Office Specialist (MOS) certification preparation, including working with email; contacts; tasks; calendar; journal; and notes; plus organizing and finding information; collaborating with other users; and managing Outlook data.
45+ hours of comprehensive Word curriculum, Microsoft Office Specialist (MOS) Expert certification preparation, including editing text; formatting characters, paragraphs, and pages; working with themes, styles, tables, shapes, pictures, WordArt, SmartArt, charts, templates, forms, Web pages, mailings, long documents, and references; plus using document collaboration tools.
60+ hours of comprehensive Excel curriculum, Microsoft Office Specialist (MOS) Expert certification preparation, including worksheets; charts; workbooks; page layout and printing; functions and formulas; tables, PivotTables; and objects; plus analyzing and organizing data.
50+ hours of comprehensive Access curriculum, Microsoft Office Specialist (MOS) certification preparation, including creating and working with databases, tables, fields, queries, forms, reports, and macros; plus finding, filtering, and formatting data.
35+ hours of comprehensive PowerPoint curriculum, Microsoft Office Specialist (MOS) certification preparation, including inserting, editing, and formatting text, objects, tables, charts, SmartArt, effects, and multimedia; formatting and viewing presentations; finalizing and delivering presentations; and collaboration tools.
The sooner you have the database and Microsoft Office knowledge you need, the better for you and your organization. Click on any of the course links above to register for these convenient online courses today!