Most organizations store their business information in large SQL databases containing client records, product data, and sales transactions. However, accessing and analyzing this data requires specialized knowledge and the proper tools. Business intelligence platforms such as Power BI, Tableau, and Crystal Reports help analysts extract and visualize this data, but SQL knowledge is essential for retrieving exactly the datasets you need. SQL Querying: Fundamentals teaches you the core SQL commands to access, filter, organize, and combine data from databases.
Learning Outcomes:
- Connect to SQL Server databases and execute queries to retrieve data
- Use WHERE clauses and search conditions to filter results based on specific criteria
- Apply built-in functions, including date formatting, aggregate functions, and string manipulation
- Sort and group query results using ORDER BY and GROUP BY statements
- Join multiple tables together to retrieve related data from different sources
Target Audience: This course is intended for individuals with basic computer skills who understand database structure and terminology and want to use SQL to access and analyze data in databases.
Prerequisites: Some familiarity with database terminology and basic database structure is helpful.
Detailed Course Outline:
Executing a Simple Query
- Connect to the SQL Database using SQL Server Management Studio
- Query a Database using the SELECT Statement
- Save a Query Script to a File
- Modify and Execute a Saved Query
Performing a Conditional Search
- Use the WHERE Clause to Search and Filter Data using One or More Conditions
- Use the WHERE Clause to Search for a Range of Values with BETWEEN and IN Clauses
How to Handle NULL Values in Data
- Search Text Data Based on Patterns using the LIKE Operator
Working with Functions
- Format and Manipulate Dates using Date Functions
- Summarize Data using Aggregate Functions Like COUNT, SUM, AVG, MIN, MAX
- Use Functions to Manipulate String Values
Organizing Data
- Sort Data using the ORDER BY Clause
- Group Data with the GROUP BY Clause
- Filter Grouped Data using the HAVING Clause
Retrieving Data from Multiple Tables
- Query Data from Multiple Tables using the JOIN Clause
Additional Topics for Self-Study
- Organizing Data: Rank Data with the RANK and DENSE_RANK Clauses; Summarize Grouped Data using ROLLUP and CUBE Clauses; Use PIVOT and UNPIVOT Operators
- Retrieving Data from Multiple Tables: Combine the Results of Two Queries with the UNION Statement; Compare the Results of Two Queries with the INTERSECT and EXCEPT Statements
- Exporting Query Results: Save the Query Results; Export an XML File
