SQL for Data Science

New York, 115W 30th St.
SQL for Data Science
0 Reviews
  • Art
    Instructor
  • SQL
    Categories
  • Data Science
    Categories
  • Beginner
    Skill Level

ABOUT THE COURSE

This workshop will teach you advanced concepts of databases as well as how to write effective SQL queries you can use in your everyday work. Going over the major topics a data scientist should know when working with databases. As well as all parts of the CRUD functions of data. The session will be highly interactive and engaging - questions are encouraged!

WHAT TO EXPECT FROM THIS COURSE

This workshop is for intermediate SQL users. We will start with a refresher of basic topics and gradually move toward more complex SQL queries. By the end of this workshop, you’ll know how to write SQL that is more complicated than reading off a single table.

WHAT WILL YOU LEARN

  • Statistical functions in SQL
  • The four operations you can perform on data.
  • String and regular expressions
  • Working with dates and intervals
  • Window functions, and ranking
  • Listagg and JSON usage
  • Using Github or shared query library
  • Please login to submit a review

Things To Remember

  • Please bring your own laptop to class.
  • We will help you to install all the programs you need in class.
  • If you withdraw one day before the course start date, any deposit paid will be refunded in full.
  • If you cannot attend classes for which you were charged, you could join next cohort and make up the missed classes.