LIVE TRAINING

SAVE THE DATE: July 26th, 2022 @ 1 pm EST

REGISTER HERE NOW

LIVE TRAINING: Introduction to PYTHON for Programming 

October 12th @12 PM EST

Save 30% : Register Now

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
View Plans

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
View Plans

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 on emojidex 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.

learn more
Open Data Science

Ai+ | ODSC
One Broadway, 14th Floor
Cambridge, MA 02142
admin_aiplus@odsc.com

Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from - Youtube
Vimeo
Consent to display content from - Vimeo
Google Maps
Consent to display content from - Google