100%

Pill

Author Image

Education

Notable awards

Profile

Courses

1
Data Analysis Fundamentals Using Excel
Expires After: 6 months

Discover if a career in data analytics or data science is right for you with our targeted course. Begin with the basics of data analysis in Excel, learning to clean and prepare data, automate analysis, grasp Excel’s various data types, and utilize logical and lookup functions for effective data management.

This basic data course will help you understand data analysis using the industry-standard program, Excel. You will get a taste of Excel, working with data, and be able to not only gain practical skills in Excel which is helpful to nearly any modern job, but also help them determine if Data is a good career fit for you.

Throughout this course you will learn the Foundations of Data Analysis using Excel including:

  • Data types
  • Data processing
  • Data clean-up
  • Formulas
  • Functions
  • VLookups
  • Conditional Formatting
  • Number Formats
  • Filters
  • Sorting
  • Pivot Tables
  • Bar Charts
  • Linear Regression
  • Line Charts
  • Area Charts
  • Pie Charts
  • Bubble Charts
  • Radar Charts
  • Waterfall Charts

The course will consist of

  • 4 online instructor led classes over two weekends for a total of 25 hours
  • 10+ hours of self study material provided throughout the week
  • Reading material, example codes, quizzes, and assignments
  • Real life exercises and lots of practice!

This course is intended for the desktop version of Excel (any version later than Excel 2008). The browser version of Excel (Excel 365 Online), or older versions of Excel would also work for most of the course material except for a few less-crucial advanced features. If you don’t have access to the desktop version of Excel, you could search for “Excel 365 Online Free Trial” and follow the course through the browser version.

2
Cybersecurity Foundations
Expires After: Does not Expire

Assess your aptitude for a career in cybersecurity & information security and explore the fundamentals through our course. Become familiar with what cybersecurity professionals do, including risk management, operating systems, and the core principles of cybersecurity policies, frameworks, and auditing, to lay the groundwork for your future in protecting digital assets.

Throughout this course you will learn the Foundations of Cybersecurity including:

  • The history of cybersecurity
  • Malware types and what they do
  • Attack types and how to avoid them
  • Solutions to cybersecurity problems
  • Learn how to do things Everyone Should Know How To Do on a computer
  • Basic hardware components
  • Computer networking
  • Operating Systems
  • Application security
  • Web security
  • Security teting
  • Incident response and forensic analysis
  • Cloud security

The course will consist of:

  • 4 online instructor led classes over two weekends for a total of 25 hours
  • 10+ hours of self study material provided throughout the week
  • Reading material, videos, example code, quizzes, and assignments
  • Real life exercises and lots of practice!

3
SQL
Expires After: 6 months

Data increases exponentially with over 1.134 trillion MB of data created daily! To learn from this data, you need to be skilled in the TOP data programming language, SQL. “SQL” is a fast-paced, straightforward introduction to SQL, the most common language used in querying databases and the TOP programming language in terms of number of job listings! 

Throughout this course, you will learn the foundations of SQL including:

  • Database basics, SQL/NoSQL, and database design
  • Installation and setting up a development environment
  • Creating tables and inserting data
  • Retrieving data and updating data
  • Sorting and filtering data
  • Working with different data types
  • Combining tables

The course will consist of :

  • 3 online instructor led classes over 1 week
  • 15+ hours of self study material provided throughout the week
  • Reading material, videos, example codes, quizzes, and assignments
  • Real life exercises

4
SQL – Advanced
Expires After: 6 months

Data increases exponentially with over 1.134 trillion MB of data created daily! To learn from this data, you need to be skilled in the TOP data programming language, SQL. SQL Advanced is a fast-paced, straightforward introduction to SQL, the most common language used in querying databases and the TOP programming language in terms of number of job listings! 

Throughout this course, you will build upon your previous understandings of SQL including:

  • Combining tables, aggregate functions and transactions
  • Triggers, automation and views
  • Building a SQL application in Javascript

The course will consist of :

  • 3 online instructor-led classes over 1 week
  • 15+ hours of self-study material provided throughout the week
  • Reading material, videos, example codes, quizzes, and assignments
  • Real-life exercises

5
Fortune Teller
Expires After: Does not Expire

6
Introduction to Computational Thinking
Expires After: Does not Expire