Tech Classes in Chicago, IL

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Big Data on AWS introduces you to cloud-based big data solutions such as Amazon Elastic MapReduce (EMR), Amazon Redshift, Amazon Kinesis and the rest of the AWS big data platform. In this course, we show you how to use Amazon EMR to process data using the broad ecosystem of Hadoop tools like Hive and Hue. We also teach you how to create big data environments,...

This hands on Python programming course shows how to rapidly develop and maintain effective Python programs. The course includes thorough coverage of Python syntax, built in data types and control constructs. The course takes a practical approach to creating and organizing Python programs using functions, packages, modules and classes as part of Python's...

You will walk away knowing how to set up a QuickBooks company, use registers, set up inventory, invoice customers, process payments, enter and pay bills, and much more. Course Outline: Lesson 1 – Getting Started Lesson 2 – Setting Up QuickBooks Lesson 3 – Working With Lists Lesson 4 – Setting Up Inventory Lesson 5 – Selling Your Product...

Want to start your own podcast, but you're not sure where to start? This course will take you through the podcasting process from start to finish! You’ll learn how to choose the topic of your podcast, user friendly recording and editing techniques, how to publish your podcast on platforms like iTunes, Google Play, and Stitcher, and more. The session...

MySQL Introduction will allow you to work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various SQL commands, indexes, and views, you can work with and modify data efficiently...

DevOps Engineering on AWS demonstrates how to use the most common DevOps patterns to develop, deploy and maintain applications on AWS. The course covers the core principles of the DevOps methodology and examines a number of use cases applicable to startup, small-medium business, and enterprise development scenarios. Skills Gained This course is designed...

This is a part time course.   In this 11week course, students learn to build robust predictive models, test their validity, and clearly communicate resulting insights. Unit 1: Research Design and Exploratory Data Analysis What is Data Science  Describe course syllabus and establish the classroom environment  Answer the questions:...

Learn to design and shape the world around you using the powerful, flexible features found in AutoCAD® design and documentation software, one of the world's leading 2D and 3D CAD tools. In this course, you will learn to navigate the AutoCAD user interfaces and use the fundamental features of AutoCAD. You will learn to use the precision drafting tools...

This introduction to typography is recommended for those pursuing a career in art and design fields, and those interested in the history and development of analog and digital type. The course functions as a working lab with multiple projects guaranteed to build confidence and knowledge in typographic usage.  Students learn about typographic history,...

On this class you will learn how to use Microsoft Visio to draw a wide variety of drawings such as flowcharts, organization charts, maps, floor plans and more. No prior experience of Visio is needed. Course Outline: Opening and Closing Visio Working with Files Setting Up Your Screen Your First Drawing Basic Editing Tasks Formatting Shapes...

Agile Scrum or Agile Project Management is an iterative and incremental method of managing the design and build activities for engineering, information technology, and new product or service development projects in a highly flexible and interactive manner. Learn the fundamentals of tools and techniques utilized in a number methodologies, including...

CISSP stands for Certified Information Systems Security Professional is an information security certification governed by (ISC) ² that is International Information System Security Certification Consortium. This certification is ideal for those who want to get trained for managing overall information security program to protect organizations from...

This multi-level typography course is recommended for students who have completed the Introduction to Typography course, and for working designers interested in further developing their knowledge and skills in typeface use and design.  The course functions as a working lab with multiple projects designed to advance typography usage in print and...

Data analytics is in the midst of an evolution. In today’s digital world, the practice of decision makers relying on information to be delivered to them is no longer sufficient to keep pace. Tableau is software that puts access to data, and the insights it can unlock, directly in the hands of those who need it. The software is designed to help people...