SQL Series (4 Sessions)

2/18/20201:00pm CST2 hours
2/20/20201:00pm CST2 hours
2/25/20201:00pm CST2 hours
2/27/20201:00pm CST2 hours
There are four sessions in this webinar:

SQL Developer
o Downloading and installing
o Connecting to a database
o Exploring tables
o Exploring views
o Configuration (date formats and line numbers)
o Exporting

Introduction to SQL
o Select statement
o Filtering
o Basic operators
o Advanced operators (IN, LIKE, BETWEEN)
o Null values
o Sorting results
o Data types
o Sorting

Intermediate SQL
o Inner joins
o Outer joins
o Joining multiple tables

Advanced SQL
o Numeric functions (absolute value, rounding)
o String functions (lower, upper, replace, substring)
o Aggregate functions (average, count, max, min, sum)
o Subqueries
o Conditional logic (case statement)
o Pivoting results

COST: $280 for all four sessions
PAYMENT: A PO for the amount of the training session must be made out to Marcia Brenner Associates and emailed to ap@mba-link.com to confirm seating. Once we receive the PO, we will confirm your spot in the webinar. If you wish to pay by credit card you will be able to do so once you receive an invoice. Please be sure to include the email address to send invoices to when completing the registration form.

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.

info@mba-link.com

Marcia Brenner Associates
8017 Excelsior Drive, Suite 120
Madison, WI 53717

How Can We Help?

Questions about our plugins, training or customizations? Let's talk about it. We'll connect with you within a business day.

If this is a support issue for PowerSchool SIS or MBA Plugins, please click here.

  • This field is for validation purposes and should be left unchanged.

MBA Powerschool Plugins  Enhancing the Power of Powerschool