Summary
SQL Querying: Fundamentals
Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.
This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of SQL.
– SQL Querying: Fundamentals (this course)
– SQL Querying: Advanced
Completion of this course will earn 0.575 CEUs.
- • Dates: May 20, 2021
- • Times: 9:00 am - 4:30 pm
- • Location: Louisville
- • Seats: 12
- • Price: $395
Introduction
Course Objectives:
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
Target Student:
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.
Prerequisites:
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
Outline
-
Lesson 1: Executing a Simple Query
- Topic 1A: Connect to the SQL Database
- Topic 1B: Query a Database
- Topic 1C: Save a Query
- Topic 1D: Modify and Execute a Saved Query
-
Lesson 2: Performing a Conditional Search
- Topic 2A: Search Using One or More Conditions
- Topic 2B: Search for a Range of Values and NULL Values
- Topic 2C: : Search Data Based on Patterns
-
Lesson 3: Working with Functions
- Topic 3A: Perform Date Calculations
- Topic 3B: Calculate Data Using Aggregate Functions
- Topic 3C: Manipulate String Values
-
Lesson 4: Organizing Data
- Topic 4A: Sort Data
- Topic 4B: Rank Data
- Topic 4C: Group Data
- Topic 4D: Filter Grouped Data
- Topic 4E: Summarize Grouped Data
- Topic 4F: Use PIVOT and UNPIVOT Operators
-
Lesson 5: Retrieving Data from Multiple Tables
- Topic 5A: Combine the Results of Two Queries
- Topic 5B: Compare the Results of Two Queries
- Topic 5C: Retrieve Data by Joining Tables
-
Lesson 6: Exporting Query Results
- Topic 6A: Generate a Text File
- Topic 6B: Generate an XML File