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.
Prerequisites:
The knowledge and skills that the learner should have before attending this course are as follows:
- 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
Course Objectives:
Upon completing this course, the learner will be able to meet these overall objectives:
- 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
Lesson 1: Executing a Simple Query
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify a Query
- Execute a Saved Query
Lesson 2: Performing a Conditional Search
- Search Using a Simple Condition
- Compare Column Values
- Search Using Multiple Conditions
- Search for a Range of Values and Null Values
- Retrieve Data Based on Patterns
Lesson 3: Working with Functions
- Perform Date Calculations
- Calculate Data Using Aggregate Functions
- Manipulate String Values
Lesson 4: Organizing Data
- Sort Data
- Rank Data
- Group Data
- Filter Grouped Data
- Summarize Grouped Data
- Use PIVOT and UNPIVOT Operators
Lesson 5: Retrieving Data from Tables
- Combine Results of Two Queries
- Compare the Results of Two Queries
- Retrieve Data by Joining Tables
- Check for Unmatched Records
- Retrieve Information from a Single Table Using Joins
Lesson 6: Presenting Query Results
- Save the Query Result
- Generate an XML Report
The primary audience for this course is as follows:
- Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.