LIVE TRAINING
SAVE THE DATE: July 26th, 2022 @ 1 pm EST
LIVE TRAINING: Introduction to PYTHON for Programming
October 12th @12 PM EST
Price: $147
Regular price $210, discounted 10%
4 hour immersive session
Hands-on training with Q&A
Recording available on-demand
Certification of Completion
30% Discount Ends in:
Subscribe and get an additional 10% to 35% off ALL live training session
Pricing: $189
Regular price $210, discounted 10%
3 hours immersive session
Hands-on training with Q&A
Recording available on-demand
Certification of Completion
10% Discount Ends in:
Subscribe and get an additional 10% to 35% off ALL live training session
Meet Your Instructor
Sheamus McGovern
Sheamus McGovern is the founder of ODSC (The Open Data Science Conference). He is also a software architect, data engineer, and AI expert. He started his career in finance by building stock and bond trading systems and risk assessment platforms and has worked for numerous financial institutions and quant hedge funds. Over the last decade, Sheamus has consulted with dozens of companies and startups to build leading-edge data-driven applications in finance, healthcare, eCommerce, and venture capital. He holds degrees from Northeastern University, Boston University, Harvard University, and a CQF in Quantitative Finance.
Course Overview
What’s the plan?
Data wrangling is an essential foundational topic for anyone considering projects or a role in data engineering, data science, or machine learning. This session will help one understand core data-wrangling concepts including what is data, data generation and collecting, data profiling, data transformation, data manipulation, and other essential workflow topics.
As this is an interactive training session, in addition to covering these data topics, we will layer on SQL and an introduction to relational databases. As we journey through the data workflow we will use SQL to wrangle and transform the data as needed. SQL consistently makes the top 5 job requirements list for data scientists, data analysts, machine learning engineers, and other related data roles. The SQL standard is the universal go-to tool for manipulating structured data stores including relational databases. Additional derivations of SQL are now widely employed in unstructured data stores also. With this foundational understanding, you will not only have job-ready data skills but you will be better positioned to proceed to other introductory-level courses in data analysis, programming, data science, and machine learning.
Who is this training for?
Anyone thinking about a career in data, data engineering, machine learning, data science, or other data/AI realated roles
Practicing developers, data scientists , machine learning engineers and related roles seeking to add essential skills such as SQL and Data Wrangling to their list of expertise
Anyone seeking better ways to work with and analyze data
Anyone seeking to grasp the various steps in the typical data workflow
Anyone seeking to take introductory-level courses in data science, machine learning, or deep learning
Course Outline
What’s the plan?
Matt Harrison has been working with Python and data since 2000. He has a computer science degree from Stanford. He has worked at many amazing companies, created cool products, wrote a couple books, and taught thousands Python and Data Science. Currently, he is working as a corporate trainer, author, and consultant through his company Metasnake, which provides consulting and teaches corporations how to be effective with Python and data science.
Course Overview
Python is a powerful tools that XXX
Join the live session with Sheamus McGovern
SAVE 30%Course Outline
Module 1:
Data Wrangling
Module 2:
The Data Life Cycle
Module 3:
Relational Databases
Module 4:
SQL Syntax
- Introduction to Data Wrangling
- Why SQL for Data Wrangling?
- The Data Life Cycle
- Understanding Data Types
- SQL Data Types
- Sourcing & Collecting Data
- Data Collection Tools
- Understanding Tables
- Introduction to Relational Database
- Popular SQL Databases
- Data Normalization
- Introduction to SQL Syntax
- SQL Query Syntax
- Understanding SQL CRUD (Create, Read, Update, Delete)
- Filtering Data
Module 5:
Data Generation & Capture
Module 6:
Data Profiling & Preparation
Module 7:
Data Wrangling
Module 8:
Data Visualization
- Data Generation
- Data Capture & Persisting Data
- Web Scraping
- Structured and Unstructured Data
- Describing Data & Outliers and Correlations
- Data Profiling with SQL
- Data Transformation and Enrichment
- Data Preparation with SQL
- Big Data & Wide Data
- Data Shaping with SQL
- Shaping with SQL Groups
- Shaping with SQL Joins
- Essential Charts
- Visualization Preparation with SQL
- Visualizing Data
- Resources Wrapup
Key Details
DATE
TIME:
DURATION:
LEVEL:
JULY 26th, 2022
TIME: 1 PM EST, 10 AM PST
3 HOURS
BEGINNER
Prerequisites
- No prior programming or data experience required
- A working knowledge of spreadsheets is helpful
Upcoming Live Training
XXth
XXX
XXX.