Office Productivity Classes in Online

Master the number one accounting system for small and medium size businesses. Create a truly portable QuickBooks company accessible over the internet anywhere. In this class we’ll compare the features of the available QuickBooks versions and their costs. You’ll learn the basic QuickBooks architecture and navigation system and practice using QuickBooks...

Create vector-based graphics that can be easily rescaled without loss of quality. Learn basic tools & fundamentals, features for creating distinct designs include painterly/fluid brushes, shape-building tools, and path controls.  There are also different transparency and gradients tools available for a variety of illustrations and mediums....

Course Overview Migrating to AWS focuses on planning and migrating existing workloads to the AWS Cloud. The course covers various cloud migration strategies with a detailed discussion on each phase of the migration process, including portfolio discovery, application migration planning and design, migration execution, and post-migration validation...

Shotgrid Production Tracking, Review, and Management Using Shotgrid During this 8-week course focusing on Autodesk Shotgrid (formerly known as Shotgun,) bring your lunch and feed your brain with new info, too! Starting with Shotgrid Basics, each online session will focus on different aspects of Producing, Tracking, Reviewing and Managing your...

Course Overview Developing on AWS helps developers understand how to use the AWS SDK to develop secure and scalable cloud applications. The course provides in-depth knowledge about how to interact with AWS using code and covers key concepts, best practices, and troubleshooting tips. Target Audience This course is intended for Intermediate-level...

Course Overview The Advanced Developing on AWS course uses the real-world scenario of taking a legacy, on-premises monolithic application and refactoring it into a serverless microservices architecture. This three-day advanced course covers advanced development topics such as architecting for a cloud-native environment; deconstructing on-premises,...

Course Overview 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 and medium-sized business, and enterprise development scenarios Target...

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Learn how to create documents, apply good formatting, and to save and share your work using Microsoft Word. You will receive an email 2 hours before the class starts with the link to join the virtual class.  *Please note that some people using older or less common email addresses have experienced issues with receiving emails from TechConnect....

Learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, and work further with queries and reports. Class Outline Unit 1: Designing a Relational databases Topic A: Relational database design...

Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques. Class Outline Unit 1: Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Enhance navigation...

The fundamental-level full day course is intended for individuals who seek an overall understanding of the AWS Cloud, independent of specific technical roles. It provides a detailed overview of cloud concepts, AWS services, security, architecture, pricing, and support. It includes lab exercises reinforcing some of the core concepts of the lecture....

Course Overview Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon...

Course Overview Big Data on AWS introduces you to cloud-based big data solutions such as Amazon 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,...

Course Overview This course covers fundamental AWS cloud security concepts, including AWS access control, data encryption methods, and how network access to your AWS infrastructure can be secured. Based on the AWS Shared Security Model, you learn where you are responsible for implementing security in the AWS Cloud and what security-oriented services...