« Back

Course Catalog

Python, SQL, and Databases

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

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 (30NOV18) -- Learn More...
Start Date: Nov 30, 2018 End Date: Dec 14, 2018 Tuition: $675.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 1: Introduction


Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 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.

This class is taught specifically for Microsoft Excel 2016 using our lab PCs. Material learned in this course may not apply to different versions of Excel (2007/2010/2013) or those for Mac.
Section: MS-EXCEL-LVL1 (10OCT18) -- Learn More...
Start Date: Oct 10, 2018 End Date: Oct 10, 2018 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register
Section: MS-EXCEL-LVL1 (06FEB19) -- Learn More...
Start Date: Feb 6, 2019 End Date: Feb 6, 2019 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register

Microsoft Excel Level 2: Excelling at Excel

You may feel comfortable using Excel -- but to maximize the software’s full potential, you’ll need to discover the 5 Fs—Formatting, Fills, Formulas, Functions, and Filters/Sorts. To begin creating clearer and more effective spreadsheets (including fully operational budget tracking), we’ll utilize formatting as well as basic formulas and functions.

Join us to review the features in Excel that allow for data management in both flat file and relational databases as we incorporate Name Box/Name Manager for easier/cleaner data referencing. PivotTables and Pivot Charts help avoid information overload by summarizing the data selection – now you can change the view of your data, simplify huge worksheets, and easily apply functions like COUNT, SUM, AVERAGE, and more.

VLOOKUPS functionality will pull together information from large, database-like workbooks; then we’ll repackage data into more useful forms using the CONCATENATE function to combine data from two or more columns.

After completing this course, you will be able to:
  • Increase productivity through shortcuts and the Quick Access Toolbar
  • Create attractive worksheets with formatting
  • Understand syntax of Excel’s formulas and functions
  • Develop formulas and functions in Excel for tables and databases
  • Filter your information quickly for date ranges, numbers, and text lists
  • Construct powerful functions to find and display data with VLOOKUP
  • Utilize the CONCATENATE function to bring columns together
  • Use the Name Box and Name Manager to navigate, print select, and add functionality for your tables
  • Create PivotTables to analyze data more effectively
  • Select useful charts to help visualize information

This class is taught using Microsoft Excel 2016 on our lab PCs, but the content applies to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to Excel for Mac.
Section: MS-EXCEL-LVL2 (14AUG18) -- Learn More...
Start Date: Aug 14, 2018 End Date: Aug 21, 2018 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (14SEP18) -- Learn More...
Start Date: Sep 14, 2018 End Date: Sep 21, 2018 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (27NOV18) -- Learn More...
Start Date: Nov 27, 2018 End Date: Dec 4, 2018 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 3: More Excelling at Excel

Microsoft Excel has hundreds of features, functions, formulas, and other things that can make managing your data easier. In this course, we will discover how to formulate smarter worksheets by understanding Excel’s time format and using Date Calculations such as TODAY and YEAR.

We will also learn to use Data Validation criteria to keep data accurate and streamline input with dropdown lists. From there, we will construct logical comparisons between given and expected values using IF…THEN…ELSE statements to make data more readable, locate information in a workbook, and avoid duplicate entries.

We will use advanced functions to repackage data into more useful forms—such as correctly formatted addresses—using the CONCATENATE function to pull data together from two or more columns. Split data using delimiters and the Text to Columns feature to deconstruct names, dates, and other data into more useful formats.

We will also go more in-depth with PivotTables, saving time with macros, and how to create the most useful types of charts for presenting your data.

After completing this course, you will be able to:
  • Establish criteria using Data Validation to more easily search for data
  • Record macros for repetitious actions that save time and assign the macro to keyboard shortcuts
  • Create multiple IF-THEN-ELSE statements for more efficient functions
  • Develop functions—COUNTIFS, SUMIFS, AVERAGEIFS, DSUM, DCOUNT, and DAVERAGE—that give results based on criteria
  • Develop formulas and functions in Excel for tables and databases
  • Construct advanced functions to find and display data with VLOOKUP/HLOOKUP and IF-THEN-ELSE.
  • Create the CONCATENATE function to bring columns together
  • Employ Text to Columns to separate data from one column into multiple columns

This class is taught using Microsoft Excel 2016 on our lab PCs, but the content applies to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to Excel for Mac.
Section: MS-EXCEL-LVL3 (13DEC18) -- Learn More...
Start Date: Dec 13, 2018 End Date: Dec 13, 2018 Tuition: $375.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel: Data Analysis Using Pivot Tables


When you use Excel as a tracking system or database, you can have a tremendous amount of data in thousands of rows and hundreds of columns. Summarizing the data and reviewing key components of the worksheet can be difficult, but PivotTables can help with this information overload. If you work in an analytical role, being able to create and manipulate PivotTables is a necessary skill.

PivotTables allow you to change the view of your data quickly and easily. They also automatically sort your data and create totals, averages and other functions, too. PivotCharts add visualizations to the data summarized into a PivotTable and can help you spot trends and patterns within the data.

Students in this half-day course will build different PivotTables using existing databases to obtain insights into account management, human resources, marketing, and more. We will use sorting and filtering to help restrict our data and use PivotTables for SUM, AVERAGE, COUNT, and PERCENTAGE functions. We will also discuss the advantages and disadvantages of the new Format as a Table feature.

Audience: We designed this course for current, experienced users of Excel who are comfortable using formatting, sorting, and filtering features.

Software: We teach this course using Microsoft Excel 2016 on our lab PCs, but much of the content should also apply to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to any version of Excel for Mac.

After completing this course, participants will be able to:
  • Create custom PivotTables and edit existing PivotTables
  • Use the Format as a Table feature
  • Analyze data through PivotTables
  • Increase productivity using the Report Filter Pages
  • Produce attractive and professional reports with PivotTable styles
  • Filter data interactively through slicers
  • Apply PivotTables to a wide variety of datasets
  • Incorporate custom calculations for data items and fields
Section: MS-EXCEL-DATA (22AUG18) -- Learn More...
Start Date: Aug 22, 2018 End Date: Aug 22, 2018 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-DATA (02NOV18) -- Learn More...
Start Date: Nov 2, 2018 End Date: Nov 2, 2018 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-DATA (01FEB19) -- Learn More...
Start Date: Feb 1, 2019 End Date: Feb 1, 2019 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel: Data Management and Manipulation


Control data without data controlling you!

In this half-day course, we will discuss how Excel can be used to manage and manipulate data in Excel, both in flat file databases and relational databases. Create and import databases and tables in Excel while handling multiple sorting and filtering tasks using a variety of criteria. We will also discuss how to format tables and databases in a professional manner while using Excel’s Format as Table feature.

Discover how to retrieve the information you need quickly and easily using multiple filters and custom views. We will also employ Excel’s terrific Name Box and Name Manager features to make data clearer and easier to reference.

We will use advanced functions to repackage data into more useful forms— such as correctly formatted addresses—using the CONCATENATE function to pull data together from two or more columns. Split data using delimiters and the Text to Columns feature to deconstruct names, dates, and other data into more useful formats.

Audience: We designed this course for current, experienced users of Excel who want to know more about managing and manipulating data

Software: This class is taught using Microsoft Excel 2016 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.

After completing this course, participants 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
  • Employ Text to Columns to separate data from one column into multiple columns
Section: MS-EXCEL-MGMT (16NOV18) -- Learn More...
Start Date: Nov 16, 2018 End Date: Nov 16, 2018 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-MGMT (21MAR19) -- Learn More...
Start Date: Mar 21, 2019 End Date: Mar 21, 2019 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Python: General Programming for Practical Applications


Python is regarded as a very easy language to learn, yet powerful enough to provide the insights required to learn any language – and potentially move you up the career ladder. Forbes magazine recently cited “data scientist” as one of the top jobs in America -- and Python is a critical skill for this position and many others, including software developer/engineer, analyst, researcher, web developer and more.

In this introductory course, you will learn the fundamentals of Python: object-oriented programming, database programming, and User Interface (UI) programming. We’ll also explore how to utilize Python for data science, website and online game development, file creation/management, and other relevant, in-demand applications; these practical skills can provide the groundwork to help prepare you for a variety of lucrative career options.

CLICK HERE FOR REQUIRED BOOK

After completing this course, participants will be able to:
  • Design and develop your own Python programs based on parts of existing Python programs
  • Develop easy-to-play games and simple web sites
  • Create features for web sites that collect, organize, and report on user provided data
  • Automate complex numerical computations essential to artificial intelligence, data science and machine learning
  • Search the web and download online content using Python scripts
  • Manage files efficiently using Python to create, update, move, and rename files
  • Locate additional resources for learning more about learning to program using Python
Section: PYTHON (06AUG18) -- Learn More...
Start Date: Aug 6, 2018 End Date: Aug 22, 2018 Tuition: $1,350.00
Campus: Executive Park Instructor: Rashaad Jones Register
Section: PYTHON (08OCT18) -- Learn More...
Start Date: Oct 8, 2018 End Date: Oct 24, 2018 Tuition: $1,350.00
Campus: Executive Park Instructor: Rashaad Jones 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 (16AUG18) -- Learn More...
Start Date: Aug 16, 2018 End Date: Aug 17, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (12SEP18) -- Learn More...
Start Date: Sep 12, 2018 End Date: Sep 13, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (11OCT18) -- Learn More...
Start Date: Oct 11, 2018 End Date: Oct 12, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (06NOV18) -- Learn More...
Start Date: Nov 6, 2018 End Date: Nov 7, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (05DEC18) -- Learn More...
Start Date: Dec 5, 2018 End Date: Dec 6, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page 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 (23AUG18) -- Learn More...
Start Date: Aug 23, 2018 End Date: Aug 24, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL2 (28NOV18) -- Learn More...
Start Date: Nov 28, 2018 End Date: Nov 29, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL2 (21FEB19) -- Learn More...
Start Date: Feb 21, 2019 End Date: Feb 22, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register