SQL Series (4 Sessions)
o Downloading and installing
o Connecting to a database
o Exploring tables
o Exploring views
o Configuration (date formats and line numbers)
Introduction to SQL
o Select statement
o Basic operators
o Advanced operators (IN, LIKE, BETWEEN)
o Null values
o Sorting results
o Data types
o Inner joins
o Outer joins
o Joining multiple tables
o Numeric functions (absolute value, rounding)
o String functions (lower, upper, replace, substring)
o Aggregate functions (average, count, max, min, sum)
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 firstname.lastname@example.org 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.
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.