SQL Querying: Fundamentals
Description
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 onscreen.
- Retrieve data from multiple tables.
- Export the results of a query.
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 String 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