Data Classes Canberra

Students in this program learn Python programming, database management with SQL and MongoDB, machine learning, data visualization, how to work with Big Data using Hadoop and Hive, deployment with Docker and Kubernetes, and more.

Fifty hours of training in the essentials of data science and data analytics prepare graduates for a career change or advancement in this training. Topics include data visualization, SQL, statistics and Python, A/B testing and web analytics, and machine learning.

Instruction in the essential elements needed when working with big data is the focus of this course. Students learn about data visualization, SQL, Python with statistics, A/B testing, and machine learning in this program.

This online data science program is meant to get students ready for a career in data science. The program covers the key components for data science, including SQL, Python, statistics, and machine learning. Students will start coding in Python using Jupyter notebooks, learn the statistics behind machine learning, apply machine learning techniques, and work on data science projects in this data science course. Students will also receive career coaching and job support during the program for help finding a job in data science. The online program offers flexible scheduling options, including full-time over 5 months, part-time over 10 months, and self-paced for up to 15 months.

This 1-day introductory Microsoft Excel course will teach those new to Excel how to successfully get up and running with Microsoft’s powerful spreadsheet program. The course explores a range of core Excel concepts, including an overview of the Excel interface, how to create a new workbook, editing data, working with formulas and functions, selecting ranges, copying and pasting data, applying borders to cells, row and column formatting, adjusting pages, printing, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day intermediate Microsoft Excel course will teach those with a basic understanding of Excel some intermediate tools and shortcuts to enhance their spreadsheet knowledge and workflow. The course explores a range of Excel concepts, including data filling, formula referencing, defining names, essential functions, conditional formatting, working with worksheets, find and replace, sorting and filtering data, creating charts, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day advanced Microsoft Excel course will teach those with a good grasp of Excel some of the advanced tools to elevate their spreadsheet knowledge and workflow capabilities. The course explores a range of advanced Excel concepts, including lookup and text functions, finance functions, complex formulas, goal seek, data linking, data protection, summarizing and subtotaling, grouping, pivot tables, pivot charts, macros, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

In this introductory, 2-day SQL course, participants will learn the basics of databases and start querying databases with SQL. Participants will get comfortable with databases and start performing basic querying techniques like SELECT, ORDER, SUM, and GROUP BY. This course is intended to give students a fundamental understanding of the use of SQL for database management.

This 2-day advanced SQL course is designed for individuals who want to better understand database structure and querying data. Specifically, the course will cover connecting to a SQL server, executing a query, adding a condition to a query, using functions to make calculations, organizing data, and retrieving data from multiple tables. Students will be able to apply what they learn to PostgreSQL, MySQL & MariaDB and Oracle among others.