Basics of SQL

SQL is the language used to speak to databases, providing access to the mountains of valuable data stored within PowerSchool. It is simple enough to speak in SQL by copying and pasting other people’s examples and code snippets, but to get answers to data questions that are uniquely yours, you need to be able to think in SQL.

This session covers everything you need to know in order to build your own meaningful SQL queries and — more importantly — understand what’s happening behind the scenes. We will cover the anatomy of an SQL statement and simple SELECTs all the way through complex JOINs. You’ll understand why there are inner joins and outer joins, when to use them, and how they actually work. You’ll be able to explain why, no matter how complex the query, you’re only ever really dealing with a single table at a time. And we’ll cover some of the most common pitfalls, why they are evil, and how to avoid them.

This introductory session assumes no prior knowledge of SQL, so is targeted at beginners, but is also a good fundamentals review for intermediate and advanced users.

Cost: $90 per attendee.

PAYMENT: A PO for the amount of the training session should be made out to Marcia Brenner Associates and emailed to accounting@mba-link.com to confirm seating. Please be sure to include the email address to send invoices to when completing the registration form. International schools are subject to a $30 fee.

TERMS OF REGISTRATION: Cancellation Policy – Registrant shall pay a cancellation fee equal to fifty percent (50%) of the Webinar Cost and any processing fees if registrant cancels less than five (5) business days before the occurrence of any webinar. “No Shows” for webinars will be charged the full class fee plus any service fees.