15% OFF
undefined months access
Start learning today! Switch to the monthly price afterwards if more time is needed.
At 10 hours / week
Get access to the classroom immediately on enrollment
Basic understanding of data types (e.g., string, integer, etc.)
Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate and join data and data tables. Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems.
Databases need to be structured properly to enable efficient and effective querying and analysis of data. Build normalized, consistent, and performant relational data models. Use SQL Database Definition Language (DDL) to create the data schemas designed in Postgres and apply SQL Database Manipulation Language (DML) to migrate data from a denormalized schema to a normalized one. Understand the tradeoffs between relational databases and their non-relational counterparts, and justify which one is best for different scenarios. With a radical shift of paradigms, learn about MongoDB and Redis to get an understanding of the differences in behaviors and requirements for non-relational databases.
Product Manager at Waymo
Mal Sridhar is currently a Product Manager at Waymo. Prior to her current role, she was a Senior Product Manager at CircleUp. Mal started her career as a management consultant at McKinsey & Company and is passionate about leveraging data to transform industries.
Software Developer and Co-Founder DecodeMTL
Ziad is a seasoned software developer who loves mentoring and teaching. Currently working as an independent contractor, he previously co-founded and taught full-stack web development at DecodeMTL, Montreal's first web development bootcamp.
Co-founder and CEO at Mode
Derek will introduce you to the SQL language and how to use SQL queries to analyze data in relational databases. Derek is the Co-Founder and CEO of Mode Analytics. He has worked as a data analyst in various companies, including Microsoft, Yammer, and Facebook.
15% OFF
Start learning today! Switch to the monthly price afterwards if more time is needed.
Start learning today! Get maximum flexibility to learn at your own pace.