Objective 1

SQL

  • Connecting to SQL with Python (pyodbc), Selecting from table, Grouping, Ordering, Filtering and Aggregations
  • Joining tables, Appending tables
  • Inner Queries as tables, Inner Queries as Filters
  • Creating tables, Insert into tables

Objective 2

Spark

  • PySpark Basics, Data Manipulation, MLLib, Model Development, and Tuning
  • PySpark SQL, N-Gram Counts, Caching Logging in UI, NLP Classification
  • Big Data, Lambda with Map and Filter, RDD Operations, SQL to Data Frames
  • PySpark MLLib Extensions

Struggling to assess your current and incoming data professionals?

Let's Talk