SQL Querying: Fundamentals

In this course, you will compose SQL queries to retrieve desired information from a database. You will: 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 the data obtained from a query before it is displayed on-screen. Retrieve data from multiple tables. Export the results of a query.
 

This course is intended for 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. Completion of one of the following Logical Operations courses or equivalent knowledge and skill are highly recommended: Using Microsoft® Windows® 8.1 Microsoft® Windows® 8 Transition from Windows® 7
 

Lesson 1: Executing a Simple Query Topic A: Connect to the SQL Database Topic B: Query a Database Topic C: Save a Query Topic D: Modify and Execute a Saved Query Lesson 2: Performing a Conditional Search Topic A: Search Using One or More Conditions Topic B: Search for a Range of Values and NULL Values Topic C: Search Data Based on Patterns Lesson 3: Working with Functions Topic A: Perform Date Calculations Topic B: Calculate Data Using Aggregate Functions Topic C: Manipulate String Values Lesson 4: Organizing Data Topic A: Sort Data Topic B: Rank Data Topic C: Group Data Topic D: Filter Grouped Data Topic E: Summarize Grouped Data Topic F: Use PIVOT and UNPIVOT Operators Lesson 5: Retrieving Data from Multiple Tables Topic A: Combine the Results of Two Queries Topic B: Compare the Results of Two Queries Topic C: Retrieve Data by Joining Tables Lesson 6: Exporting Query Results Topic A: Generate a Text File Topic B: Generate an XML File Appendix A: The FullerAckerman Database