2005 - 2008 Schedule

Course Descriptions

Classwork Example

Creating the Next Wave

Technology innovation over the past two decades has triggered important changes to the business world. Corporations were first to enjoy cost benefits through automated processes. These same tools moved quickly to small businesses and have spread globally. Anything that can be done by phone or Internet is subject to outsourcing, anywhere in the world.

Today raw technology skills are not enough. To be competitive, the technical worker must communicate, design and implement applications that meet the needs of business people served. This cannot be done without solid business knowledge. Those with the ability to wear two hats – technology and business – can be difficult to find and often command the best jobs.

We are pleased to announce a new technology program integrating business and technical knowledge. Our goal is to prepare the beginning technologist to competitively serve the business world.

Our Training Goals

Our goal is for every student to understand how a business operates, its opportunities and risks. Our next goal is for each student to achieve at least a Microsoft Certified Professional (MCP) certificate. Our vision however, is to not emphasize the certification, but to develop cognitive skills. We want students to develop fully, not just memorize material, but also learn to use their perception, intuition, and reasoning skills and apply them to real world situations.

Certifications

Our courses are designed to give the student the skills to pass not only the MCP but also the Microsoft Certified Systems Engineer (MCSE), and the Microsoft Certified Database Administrator (MCDBA). The latter two exams are much more involved and require a high commitment from the student to complete.

Our basic program is for two years, and by the second year the student should be able to pass a MCP certification. Advanced students should be able to pass MCDBA and/or MCSE certifications. Return to top

Technology Program

The Center for Empowerment and Media Logic are pleased to offer training for those communities that have not traditionally had access to information, training, and careers in the field of technology. Together, we offer free scholarships for to those who apply and qualify for the program.

For information on how to begin the screening process and qualify for a scholarship valued at $4000.00 per course, please contact the Center for Empowerment at 206.722.7310, or register online at http://www.centerforempowerment.org/contact.htm.

Class Size:

12-15 person maximum

Class Times:

Tuesday and Thursday evenings from 6:30 - 9:00 p.m.
Saturday mornings from 10:00 a.m. - 1:00 p.m.
Lab times to be arranged.

Business Technology Classes

FALL 2005
Part I: Managing Financial Position, MS Excel
Advanced Administrative Techniques, MS Word
Part I: Presentation Skills, MS Visio
Part II: Presentation Skills, MS Powerpoint
WINTER 2006
Part II: Managing Financial Position, Intuit QuickBooks
Web Strategies in Business
Beginning Web Design, MS Frontpage/HTML
Beginning Data Storage, MS Access

Technology Classes:

SPRING 2006
A+ (in preparation for A+ certification)
Risk Assessment
FALL 2006
TCP/IP Protocol Stack
Database Administration Part I
Security Part I (Optional)
WINTER 2007
Microsoft XP
Database Implementation Part II
Security Part II (Optional)
SPRING 2007
Introduction to Linux
FALL 2007
Microsoft 2003 Server
Database Implementation Part I
Technology Seminars
WINTER 2008
Cisco Routers
Database Implementation Part II
Technology Seminars

For more information about these programs and to find out how to enroll, please contact:

Center for Empowerment-Cassandra Williams
7930 Rainier Avenue South
Seattle, WA 98188 - 206.722.7310
http://www.centerforempowerment.org/
Return to top

Course Descriptions - Business Technology Classes

Introduction to Business Technology

Description

Seminar overview of primary functional areas in managing a small business and the corresponding technologies to reduce operational cost, improve efficiencies and enhance the bottom line.

Part I: Managing Financial Position, MS Excel

Description

This course starts from a beginner's understanding of spreadsheets and builds advanced skills that assist the business owner in financial management. It will teach how to build reports necessary for obtaining capital (banks, grants, venture capital), managing cash flow and anticipating problems before they happen.

Part II: Managing Financial Position, Intuit QuickBooks

Description

This course is a step-by-step instruction in how to setup a new business in the world's most popular small business accounting system, or how to migrate an existing system. It will focus on specific skills that save money, reduce bookkeeping time, reveal problem areas and ensure the business owner understands cash position at all times.

Advanced Marketing and Sales Skills, MS Word

Description

This course starts from a beginner's understanding of word processing and builds advanced skills essential to marketing and sales, such as mail merging, label making and specialized forms.

Part I: Presentation Skills, MS Visio

Description

This course shows how to create organizational charts, present a business concept, show business processes and other information for streamlining your operation or demonstrating how your products will do the same for your client.

Part II: Presentation Skills, MS Powerpoint

Description

This course shows how to create professional presentations crucial to successful sales.

Business Web Strategies

Description

This course explains the strategic importance of web presence for business sales, what needs to be done to get a web site and how to do it - on a budget.

Beginning Web Design, MS Frontpage/HTML

Description

This course is designed for the business owner or beginning technologist who wants to design, implement and maintain a business web site that attracts traffic and sales.

Beginning Data Storage, MS Access

Description

This course is designed for the beginning technologist who seeks to build simple business applications requiring stored information. Coursework will stress actual business application projects to be used by businesses when complete.

Course Descriptions - Technology Classes

A+ Course

Introduction

This course is designed to train the student in the organization of a typical Personal Computer (PC). The hardware level is examined in popular operating systems environment. Terminology and concepts related to major PC hardware components and their functions will be discussed. Entry level hands- on skills as well as theoretical knowledge in handling PC hardware will be covered.

Topics:

  • The Personal Computer and its Components
  • The Motherboard and its Components
  • Operating Systems
  • The Graphical User Interface (GUI) Desktop
  • Configuring and using the Operating System
  • Installing, uninstalling, upgrading and configuring PC components
  • Computer Security
  • Introduction to Networking.
  • Troubleshooting Printing Problems

Prerequisites:

Before beginning this course, students should have:

Proficiency using the Windows interface to locate, create, and manipulate folders and files and to configure the desktop environment.

General knowledge of computer hardware components, including memory, hard disks, and central processing units.

Database Administration (Parts I and II)

Learn how to deliver exceptional performance and scalability to your business information systems—and prepare for the Microsoft® Certified Professional (MCP) exam. Work with our highly experienced instructors as they bring a system of lessons and hands-on exercises to gain practical experience installing, configuring, and troubleshooting SQL Server™. As you build these real-world database administration skills, you’re also preparing for MCP Exam 70-228—an elective for MCSE/MCSA certification and a core exam on the MCDBA track.

Part I Topics:

  • What Is a database
  • Overview of SQL Server
  • Installing SQL Server
  • Preparing to Use SQL Server
  • Upgrading to SQL Server 2005
  • Understanding System and User Databases
  • Creating and Configuring User Databases
  • Populating a Database
  • Developing a Data Restoration Strategy

Part II Topics:

  • Backing Up and Restoring SQL Server
  • Managing Access to SQL Server
  • Managing SQL Server Permissions
  • Performing Administrative Tasks
  • Automating Administrative Tasks
  • Monitoring SQL Server Performance and Activity
  • Using SQL Server Replication
  • Maintaining High Availability
  • Working With Clustered Servers

Prerequisites:

Before beginning this series, students should have:

Business Technology series, Risk Assessment and A+ courses or demonstrated ability to use Microsoft Visio, Excel, Word, Intuit Quickbooks (or similar accounting package) and other office products. Students must demonstrate a basic understanding of computer components and systems. Database Administration Part I required for Part II.

Database Implementation (Parts I and II)

Learn how create, script and develop a professional database system—and prepare for the Microsoft® Certified Professional (MCP) exam. Work with our highly experienced instructors as they bring a system of lessons and hands-on exercises to gain practical experience designing, implementing and tuning SQL Server™. As you build these real-world database administration skills, you’re also preparing for MCP Exam 70-229—an elective for MCSE/MCSA certification and a core exam on the MCDBA track.

Part I Topics:

  • Introduction to Microsoft SQL Server 2000
  • Using Transact-SQL on a SQL Server Database
  • Designing a SQL Server Database
  • Implementing SQL Server Databases and Tables
  • Implementing Data Integrity
  • Accessing and Modifying Data
  • Managing and Manipulating Data

Part II Topics:

  • Implementing Stored Procedures
  • Implementing Triggers
  • Implementing Views
  • Implementing Indexes
  • Managing SQL Server Transactions and Locks
  • Designing and Administering SQL Server 2000 Security
  • SQL Server Monitoring and Tuning

Prerequisites:

Before beginning this series, students should have:

Risk Assessment, A+ course, Security I, TCP/IP Protocol Stack, Database Administration I and II, Database Implementation Part I required for Part II.
Return to top

Classwork Example

Project Development Plan

(Media Logic Community Database Project)

Instructions

The class will break up into groups of two or three. Each student will play several roles throughout the project.

Business Analyst - Interviews the client to build a business case for the database. The analyst should come up with a vision statement. The statement should include business, fiscal, and functional objectives.

The statement should:

  1. Specify functional objectives and the results that will be achieved.
  2. A cost/benefit analysis, including a return on investment if possible.
  3. Establish realistic outcomes based on resources and project parameters.
  4. Set a realistic time frame, based on resources and circumstances, to achieve specific goals. (For example, project will commence on "X" date and complete on "Y" date.)

The vision statement documents the database environment and provides the basis for the scope document and conceptual model.

Project Scope

Architect - Will work with the business analyst to justify, design and implement the database. The architect will be responsible for creating the project scope that expands the vision statement and functional objectives with specific details, including the business case for physical deployment, features, resources, and scheduling. It should be used as a guide for deploying the database and establishing the project's limits. Keep it to one to two pages, and make sure it identifies:

  1. Business goals, requirements, and constraints.
  2. Assumptions. Identify hardware and software resources.
  3. Critical dates. Identify start/end dates, time dependencies, etc.

The project scope must also include the following:

  • Importance to the organization
  • How widely used
  • How large
  • Ownership: administrators, users departments.
  • Backup and recovery plan
  • Database backup and maintenance schedule
  • General configurations (CPU, memory, disk space, and so forth)

The Architect will also be responsible for creating the high level conceptual design. Use the vision/scope findings to diagram the interrelationship of the database environment, applications, and users.

Now it's time for the actual design work that the architect will use to develop his/her database.

The Conceptual Data Model

This model, or diagram, deals with entities and relationships. This is where the architect describes the information to be stored in the database. Each entity corresponds to the real-world set of objects to be modeled. Entity attributes describe specific aspects about an entity, such as Customer - name, address and phone number. Don't forget to provide the relationships between the entities. The conceptual model will be used to develop the logical and physical data models in the second part of this class database project. Return to top