Introduction to SQL Queries

  • amshot Training: Introduction to SQL Queries
    January 25, 2019 - February 1, 2019
    2:00 pm - 3:30 pm

This two-part class will be held from 2:00 PM to 3:30 PM on Friday, 1/25 and Friday, 2/1.

In this class, attendees will walk through the process of creating queries against a SQL database and discuss the purpose of each element of a SQL statement.* The class will cover the following topics:

  • Installing SQL Server Management Studio
  • Connecting to a database
  • Creating a new Query
  • SELECT
  • FROM
  • WHERE
  • ORDER BY
  • TOP X
  • JOIN
  • LEFT/RIGHT JOIN
  • GROUP BY
  • SUM, MAX, MIN

*Attendees must bring a laptop to follow along with the class in a hands-on fashion. During the class, attendees will install SQL Server Management Studio (SSMS). To complete this task, attendees must have administrative privileges on their machine.

CLIENTS: amshot training classes are free for all employees of our clients. If you are a client and need your client-only discount code, please refer to this month’s training class email (typically sent out two weeks before the event) or reach out to us at info@amshot.com.