Overview

Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database. The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools. 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 intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, who want to use SQL to query databases. In this course, 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, and export the results of a query. This course requires that you have Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.

Syllabus

Executing a Simple Query

In this course, you will query an SQL database using fundamental query techniques. Simple queries form the basis of building your querying skills. In this lesson, you will begin by composing and executing a simple SQL statement to retrieve information from a database. You will then modify and save a query so that you can use it later

Performing a Conditional Search

At this point, you have connected to a server, written a simple query and executed it, and saved that query to a file. With simple queries, you typically retrieve all the information in a table. In a production environment, however, you rarely need to view all the information in a table. Instead, you want to retrieve only the rows in a table that meet certain criteria. In this lesson, you will add criteria to your SELECT statements so that you can perform more sophisticated queries.

Working with Functions

You have retrieved specific data from a table by using a WHERE clause. But you can do more than just display data that is in a table. You can perform calculations and other operations on data and present it in a desired format. In this lesson, you will use various functions to perform calculations on data to obtain meaningful output from the database.

Organizing Data

Retrieving data is the main purpose of most SQL queries. Organizing the data that appears in the result set helps you identify the information that you need instead of searching for it among the retrieved data. In this lesson, you will sort and group data so that the required output is displayed.

Retrieving Data from Multiple Tables

Up to now, you have been retrieving and organizing data from a single table using various clauses and functions in SQL. In this lesson, you will retrieve data from multiple tables.

Exporting Query Results

So far in this course, you have queried tables and viewed the results in the Results pane in Microsoft® SQL Server® Management Studio (SSMS). SQL professionals would have no problem with viewing and understanding such results. End users, on the other hand, typically don't have SSMS installed on their computers. For this reason, you need to be able to provide users with data in formats they can use in the applications they do have available to them. In this lesson, you will obtain query results in formats that users can use in other applications and tools.