Professional SQL
Join us for an awesome workshop on:

(CANCELED) Professional SQL

Mike North
Mike North
Stripe
March 28, 2018 - 9:30am to 5:30pm Central Daylight Time

RSVP to Attend Online

Live and in Full HD
Attend Online
OR

Join in Person

From Downtown Minneapolis, MN
Apply to Join In-Person

Sorry, this workshop was canceled. :-(

This Workshop's Online Chatroom is Currently Open!

March 28, 2018 - 9:30am to 5:30pm Central Daylight Time
Join to Attend Online

Sorry, this workshop was canceled and not available for replay. :-(

Sorry, this workshop was canceled and not available for replay. :-(

Professional SQL

If you look at MySQL and PostgreSQL as “just a place to store structured spreadsheet-like data,” you’re missing out on some of the most exciting advancements that have landed in these projects over the last ten years. Relational databases have evolved into rich and robust services with their own customizable caching, dynamic runtime behavior, and a wide range of integration points for talking to other parts of your app. Through working through hands-on examples dealing with issues like full-text search, publish-subscribe (pubsub) systems, materialized views, triggers, and prepared statements, you can be sure that by the end of this course, you’ll be able to manage and monitor your database like a pro.

Some Key Takeaways!

By participating along with us in the workshop, you'll learn:

  • Programming our database to take action in response to new record insertions automatically.
  • Building a dashboard that requires some expensive queries, and then use a materialized view to cache the query result for a performance boost.
  • Creating prepared statements in our database to avoid the overhead of parsing and analyzing statements on a per-query basis.
  • Storing collections as values with array and JSON column types
  • Subscribing to notifications about updates through a pubsub system
  • Using full-text search to obtain a weighted set of relevant query results based on values in multiple columns
  • Using simple CLI tools to backup and restore your database remotely

Your (Awesome) Instructor

Mike North

Mike North

Mike is a Principal Staff Engineer and Tech Lead of Developer Platform at Stripe, where his role includes defining the company’s public API semantics and types, as well as driving many large TypeScript projects like the Node.js Stripe SDK Stripe Shell, and Stripe Workbench. Prior to working at Stripe, Mike was a Senior Staff Engineer at LinkedIn, the CTO of Levanto Financial and the UI Architect of Yahoo’s Ads & Data division. As part of his ongoing work to improve the JavaScript ecosystem, Mike is a regular contributor and maintainer of a wide range of open source libraries. His areas of focus are TypeScript, Ember.js, CLIs and Progressive Web Applications.

Manage and monitor your database like a pro

Workshop Details

If you look at MySQL and PostgreSQL as “just a place to store structured spreadsheet-like data,” you’re missing out on some of the most exciting advancements that have landed in these projects over the last ten years. Relational databases have evolved into rich and robust services with their own customizable caching, dynamic runtime behavior, and a wide range of integration points for talking to other parts of your app.

Through working through hands-on examples dealing with issues like full-text search, publish-subscribe (pubsub) systems, materialized views, triggers, and prepared statements, you can be sure that by the end of this course, you’ll be able to manage and monitor your database like a pro.

Daily Schedule

We've already held over 100 workshops holding thousands attendees in-person and online. In this time we've discovered ways to schedule the day so it goes smoothly and efficiently. Regardless if you're in-person or participating with us online you'll have the full ability to replay things you missed, get your questions answered LIVE and interact with the teacher throughout the day.

  • 9:30AM
    Introduction
  • 9:45AM
    Views
  • 10:00AM
    Exercise: Views for Complex Queries
  • 10:20AM
    Prepared Statements
  • 10:40AM
    Exercise: Prepared Statements
  • 11:00AM
    Triggers & Procedural SQL
  • 11:20AM
    Exercise: Trigger for Order Totals
  • 11:40AM
    Materialized Views
  • 12:00PM
    Exercise: Cached Dashboard Stats
  • 12:20PM
    Lunch
  • 1:20PM
    Structured Data Types: Array and JSON Columns
  • 1:50PM
    Exercise: Product Tags & Metadata
  • 2:20PM
    Publish & Subscribe
  • 2:50PM
    Exercise: Auto-Refreshing Dashboard
  • 3:10PM
    Full Text Search
  • 3:40PM
    Exercise: Global Multi-Entity Search
  • 4:00PM
    Command Line Tools
  • 4:40PM
    Performance & Optimization
  • 5:00PM
    Wrap Up
Expand...

Interact with the Instructor - Online & In-Person

Get Your Questions Answered • Code Along with the Class • Classroom Format

Is This Workshop for Me?

Summary

If you’re interested in building soft-real-time apps, optimizing for database performance, taking extra steps to ensure data integrity, or if you’re responsible for managing and monitoring your company’s databases — this course is for you!

Any Prerequisites?

  • Completion of SQL Fundamentals course
  • Students with basic level of comfort and familiarity building a system involving components hosted on different machines will benefit even more than others
  • Students should have a free Heroku account, or should be prepared to setup their own PostgreSQL database on their local machine

Event Details

What

One Full Day Workshop Session

Replay Videos (available immediately)

When

CANCELED, sorry. :-(