« Back

Course Catalog

Databases and SQL

Upcoming offerings in Microsoft Access, Microsoft Excel, and Structured Query Language (SQL).

Microsoft Access: Accessing the Possibilities

Create and manage your own Access database! Join us as we build and edit queries, tables, forms and reports for data manipulation. Explore various database objects, relationships, and primary keys while learning how to properly and efficiently utilize various Access functionalities. Course is best suited for current Access or intermediate Excel users with knowledge in database and/or table sorting/filtering functions. Homework is assigned between the classes.

After completing this course, students will be able to:

  • Create an Acces database with tables, forms, queries and reports
  • Understand Database Objects including tables, forms, queries and reports
  • Construct tables with text, date, numerical, and other fields
  • Use input masks to aid in entering and editing data for SSN, date, and other fields
  • Build queries for data manipulation and working with various types of criteria
  • Create forms for editing, deleting, viewing, and inputting data
  • Establish primary keys for our tables and appropriate relationships
  • Edit tables and fields, queries, forms, and reports to add functionality and customization
Section: MS-ACCESS (06JUN17) -- Learn More...
Start Date: Jun 06, 2017 End Date: Jun 20, 2017 Tuition: $675.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 1: Introduction

This class is taught specifically for Microsoft Excel 2010 using our lab PCs. Material learned in this course may not apply to different versions of Excel (2007/2013/2016) or those for Mac.

Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 2010 by learning to create, edit, and print basic Excel spreadsheets with the latest version of this application! In this course, you will learn to speed up data entry, move and copy information, and create formulas to perform calculations. You'll prepare a spreadsheet for printing by setting margins, page breaks, and more. Finally, you'll learn to manage large Excel workbooks, making your data more readable and more attractive with formatting techniques.
Section: MS-EXCEL-LVL1 (26APR17) -- Learn More...
Start Date: Apr 26, 2017 End Date: Apr 26, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register
Section: MS-EXCEL-LVL1 (21JUL17) -- Learn More...
Start Date: Jul 21, 2017 End Date: Jul 21, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register

Microsoft Excel Level 2: Excelling at Excel

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

Learn the five Fs of Excel—formatting, fills, functions, formulas, and filters—tools that help you create effective and clear spreadsheets. Understand formatting and basic formulas as you begin building budget and expense spreadsheets. We go on to explore filters, fills, complex formulas, macros, charts and conditional formatting. These tools help you to create fully functional monthly and annual budget tracking spreadsheets.
Section: MS-EXCEL-LVL2 (22MAR17) -- Learn More...
Start Date: Mar 22, 2017 End Date: Mar 29, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (09JUN17) -- Learn More...
Start Date: Jun 09, 2017 End Date: Jun 16, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (04AUG17) -- Learn More...
Start Date: Aug 04, 2017 End Date: Aug 11, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 3: More Excelling at Excel

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

Students will customize their workbooks through more functions, such as If . .. Then . . . Else and Data Validation, learn more functions, collaborate with other users, and enhance their spreadsheets using charts.
Section: MS-EXCEL-LVL3 (28FEB17) -- Learn More...
Start Date: Feb 28, 2017 End Date: Feb 28, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL3 (12APR17) -- Learn More...
Start Date: Apr 12, 2017 End Date: Apr 12, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel: Data Analysis Using Pivot Tables and Subtotals

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

This half day course covers creating and downloading databases and then how to analyze data through Pivot Tables and SubTotals. Students interested in this course should be comfortable using Excel formatting, sorting, and filter features.

Data analysis is a powerful Excel feature and we will look in depth at creating and editing Pivot Tables and Pivot Charts for analysis. We will look at other database features such as Subtotals and using the Name Manager. We will use sorting and filtering to help restrict our data and use Pivot Tables for Sum, Average, and Count functions. Using Office 2007/2010 we will use the new Format as a Table feature and learn the advantages and disadvantages of using Format as a Table.
Section: MS-EXCEL-DATA (05MAY17) -- Learn More...
Start Date: May 05, 2017 End Date: May 05, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-DATA (16AUG17) -- Learn More...
Start Date: Aug 16, 2017 End Date: Aug 16, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel: Data Management and Manipulation

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

Control data without data controlling you. Create and import databases and tables in Excel while handling multiple sorting and filtering tasks using a variety of criteria. Retrieve the information you need quickly and easily using multiple filters. Learn how to format tables and databases in a professional manner and master Excel’s terrific Name Box and Name Manager features. Separate data easily using the Text-to-Column feature and bring columns together using the CONCATENATE function.

After this class, you will be able to:

  • Sort and filter data using multiple criteria in order to get needed information with little effort
  • Download databases from other applications and servers
  • Create a data table or database avoiding common pitfalls
  • Format a professional and attractive table
  • Use the Name Box and Name Manager to efficiently navigate, print select, and add other functionality for your database and tables
  • Create the CONCATENATE function to bring columns together and VLOOKUP to bring data from one table into another
  • Employ Text to Columns to separate data from one column into multiple columns
Section: MS-EXCEL-MGMT (02MAR17) -- Learn More...
Start Date: Mar 02, 2017 End Date: Mar 02, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-MGMT (16MAY17) -- Learn More...
Start Date: May 16, 2017 End Date: May 16, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-MGMT (25AUG17) -- Learn More...
Start Date: Aug 25, 2017 End Date: Aug 25, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

SQL Level 1: Introduction

SQL is a ‘must know’ technology for anyone in the IT industry! Use SQL to create queries that extract and manipulate information from relational databases. Learn to create expressions that calculate and summarize information and search, filter and sort your data. SQL can be used with almost all relational databases such as Microsoft Access, Microsoft SQL Server and Oracle, as well as business applications such as Crystal Reports, Business Objects and many more.
In this fun and informative class you will learn how to use over 30 different SQL clauses and functions and leave with a good working knowledge and understanding of the SQL language.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course, students will be able to:
  1. Understand database and SQL fundamentals
  2. Work with SQL script files and coding standards
  3. Return and organize data from a single table
  4. Code Derived Columns and use built functions
  5. Use basic WHERE Clauses to filter data
  6. Use Advanced WHERE Clauses to filter data
  7. Understand relational database theory and data diagrams
  8. Plan and write simple multi table queries
  9. Understand different join types and what they do
  10. Summarize and filter data with aggregate functions
  11. Understand and use action queries and their best practices
  12. Use and debug sub-queries and know when to use them
Section: SQL-LVL1 (16MAR17) -- Learn More...
Start Date: Mar 16, 2017 End Date: Mar 17, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Paul Dunlop Register
Section: SQL-LVL1 (13APR17) -- Learn More...
Start Date: Apr 13, 2017 End Date: Apr 14, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (10MAY17) -- Learn More...
Start Date: May 10, 2017 End Date: May 11, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (05JUN17) -- Learn More...
Start Date: Jun 05, 2017 End Date: Jun 14, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (13JUL17) -- Learn More...
Start Date: Jul 13, 2017 End Date: Jul 14, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register

SQL Level 2: Intermediate

Take your SQL skills to the next level by learning how to do more work with SQL inside the database before pushing data across the network to your applications. This class takes a time efficient ‘problem / solution/ discussion’ approach and covers the topics that are important to today’s SQL developers.

This class teaches you how to use window functions, pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set. Also covered is the topic of ‘bucketization’, how to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course, students will know about:
  • Retrieving Records
  • Conditional SQL & Sample Data
  • Conditional Sorting & Stacking Rows
  • Views and Different Join Types
  • Working with Text Data
  • Working Numerical Data
  • Working with Dates
  • Grouping and Window Functions
  • Pivoting and Pivot Reports
  • Other Ways to Pivot
  • Bucketization and Histograms
  • Analyzing and Presenting Data
Section: SQL-LVL2 (17MAY17) -- Learn More...
Start Date: May 17, 2017 End Date: May 18, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL2 (12AUG17) -- Learn More...
Start Date: Aug 12, 2017 End Date: Aug 19, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register