1013 Fundamentals of SQL Querying

In this 2-day instructor led course students will learn what SQL is and how it can help them query a database to answer business questions. This course will combine instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Students will learn how to use SQL statements to query a database. Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning.

• connect to the SQL Server database and execute a simple query
• include a search condition in a simple query
• use various functions to perform calculations on data
• organize data obtained from a query before it is displayed on-screen
• retrieve data from tables
• format an output, save a result, and generate a report

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases

• Basic end-user computer skills and some familiarity with database terminology and structure are required
• The following courses or equivalent knowledge and skills are highly recommended:
  • Windows
  • Relational Databases Design (Second Edition)
  • Access: Designing a Database