Loading Events
Find Events

Event Views Navigation

Events for May 24, 2019

Day Navigation

Ongoing
$2,295

SQL Server 2012: Database Querying

May 20 @ 8:30 am - May 24 @ 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
Managing required information by storing and retrieving data is part of Database Administrators day-to-day activities. One of the most effective ways to manage required information is by using databases. You may need to manipulate and modify your table data based on changing business requirements. The course, Microsoft SQL Server 2012: Database Querying will help you […] Find out more »
$2,295.00

SQL Server 2012: Database Admin

May 20 @ 8:30 am - May 24 @ 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
You have created databases and executed queries on them. You are now ready to perform database administration tasks such as installation of SQL Server instances, configuration of SQL Server databases and settings, monitoring database performance, controlling user access to databases, and database maintenance. In addition to these tasks, SQL Server 2012 provides many advanced features […] Find out more »
$2,995.00

Lean Enterprise: Plant or Office Design and Workflow study

May 21 @ 8:30 am - May 24 @ 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
After successful completion of this workshop each participant will understand cellular concepts, designing around monuments, improving the workflow at a macro level.  After your Value Stream Mapping has been performed, then a work analysis is developed, workflow is determined at the macro level, maintenance activities are noted, and process flow is considered.  After these studies […] Find out more »
$1,295

CompTIA Strata

May 22 @ 8:30 am - May 24 @ 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
Upon completing this course, students will have the skills to set up basic computer systems, install peripherals and software; learn about computer networks; identify internet protocols and email protocols; identify tisks associated with upgrading software and hardware; perform maintenance of computer components using preventative maintenance techniques; maintain and troubleshoot a basic PC workstation; identify and […] Find out more »
$795.00

SQL Query: Fundamentals/Advanced

May 23 @ 8:30 am - May 24 @ 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
SQL: Fundamentals of Querying During this course, students will connect to a database, query the database, modify the query and then save and execute the saved query. You will search using a simple condition; compare column values, search using multiple conditions, search for a range of values and null values and retrieve data based on […] Find out more »
$795

Writing Relevant Requirements

May 23 @ 8:30 am - May 24 @ 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
During this hands-on workshop, each individual will learn the skills needed to gather information to write complete, consistent requirements structures. Create IT requirement guidelines that meet the needs, goals and objectives of stakeholders. Ensure everyone involved in the process is working from the same set of specifications. Run scenarios to include each requirement needed. Determine […] Find out more »
8:30 am
$275.00

Access 2010: Level 3

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
During this course, the student will analyze tables, create a junction table, and improve table structure. Create subqueries, create unmatched and duplicate queries, group and summarize records using criteria, summarize data using a crosstab query, and create a PivotTable and a PivotChart. Create and attach a Macro, restrict records using a condition, validate data using […] Find out more »
$ 275.00

Word 2013: Advanced

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Learn to use Word efficiently with other programs. Modify user information, send a document for review, compare and merge document changes and review track changes and comments. Create, compare and merge document versions.  Insert bookmarks, footnotes and endnotes, add captions, hyperlinks cross-references, and add citations and a bibliography.  Create a Master Document, insert an index, […] Find out more »
$ 325.00

Excel 2013: Formulae/Functions

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
This workshop is designed for the more sophisticated user of Excel. You will learn to create formulae and perform calculations involving the following functions: Activities covered include: Tracking elapsed time. The Analysis ToolPak and other add-ins. Common Math and Statistical functions. Generating random numbers: RAND. The IF function. Using multiple lookup tables. Creating drop-down lists […] Find out more »
$ 325.00

Excel 2013: PowerUser-VBA Code/Macros

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Understand the basics of a Visual Basic Module.  Create a macro with the Macro Recorder.  Edit and debug a macro.  Customize the Quick Access Toolbar and Hotkeys.  Work extensively with macro security.  Insert and format text.  Sort and duplicate data.  Generate a report.  Determine the dialog box type.  Capture user input.  Insert, copy, and delete […] Find out more »
$195.00

Give A Presentation: Who Me?

May 24 @ 8:30 am - 12:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Determine ways to seize the audiences’ attention and keep them riveted, wanting to come back for more. Use humor to warm up the audience and hold peoples’ interest. Learn techniques for handling the problem child. Discover how to build your own confidence and displace the anxiety that troubles us all. Learn superb opening techniques. Find out more »
$295.00

Conflict Management

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
If you feel your relationships are suffering, there is a lack of cooperation and team spirit, or too much tension in the office, this class is for you. Learn how to defuse anger; release anxiety; and control emotions. Discuss when and how to offer criticism in differing circumstances. Learn life-changing answers to the conflict, strife, […] Find out more »
$195.00

Mother Told Me I’d Need This Some Day (Statistics Basics)

May 24 @ 8:30 am - 12:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
This review is designed to encourage the use and elementary understanding of statistical data. This half-day session is designed to assist the participant in the elementary understanding and use of numerical data.  Topics covered will include common terminology, estimation, probability, probability distributions, random variables, statistical inference, and tests of hypotheses. ***A calculator is needed. Find out more »
$295.00

Public Speaking

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Take a look at your own personality to see what presentation style suits you best. Capitalize on the pluses, minimize the negatives. Learn habits or irritating behaviors that should be avoided. Discover phrases or speech patterns to be used or shunned. Take a look at how to use body language effectively. Determine ways to seize […] Find out more »
$395.00

Doing More with Less

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Participants will examine the impact change has made on themselves, their workplace and organization. They will then look at how they normally respond to change and other exciting, innovative ways to reach solutions. Short sessions will be used to share experiences and the results. Then discussion can be held on possible solutions incorporating the mantra […] Find out more »
$395.00

Leadership Skills for Managers and Supervisors

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Discover the style extremes of passive and aggressive and when each may be effective. Learn the skills that will gain the respect from co-workers and will enhance your role as manager and leader. Work with attitudes that are common to winning managers. Discover ways to “get results” from your staff. Communicate more clearly and effectively: […] Find out more »
$395.00

Learning & Setting SMART Goals

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Making sure each employee has a good grasp on all company policies, procedures, and goals.  Discover how this knowledge can translate into a more interactive and productive work environment.  Managers will learn the implementation of specific steps to link organizational training, development and learning to business goals.  Each participant will go through the process of […] Find out more »
$ 275

Act!: Level 1

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Level 1: During this class the student will open an existing database and become familiar with the ACT! environment. Enter new contacts into the database by creating and editing a database. Locate contact records by using the Lookup feature and the Contact List window. Organize and manage contact records by creating groups. Schedule and manage […] Find out more »
$295.00

Emotional Intelligence

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
Emotional intelligence, also called EQ, is the ability to be aware of and to manage emotions and relationships. It’s a pivotal factor in personal and professional success. IQ will get you in the door, but it is your EQ, your ability to connect with others and manage the emotions of yourself and others, that will […] Find out more »
$325

Access 2010: Level 4

May 24 @ 8:30 am - 4:00 pm
DCG,
1551 Bond Street
Naperville, IL 60563 United States
Upon successful completion of this course, students will be able to: Create and modify a database switchboard, and set and modify startup options.  Import and export XML data.  Distribute a database and add security features to it. Integrate Access more fully into your business operations Create and modify a Database Switchboard and Set Startup Options. […] Find out more »
+ Export Day's Events