SQL Querying: Fundamentals

1 Day | Price: $545

This workshop covers the basics of SQL to effectively transform information contained in databases into information that is usable by a variety of sources. The workshop assumes that users have a basic familiarity with databases and an understanding of relational database concepts.

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
StartsRegister
Aug 19, 2024 9:00AM

Register