SQL: Fundamentals of Querying

Learning Outcomes:

• Connect to the SQL Server database and execute a simple query utilizing data presented in the lesson lab with accuracy.
• Using various functions based on the data types correctly perform calculations on data as directed by the Instructor.
• Successfully organize the data obtained from a query before it is displayed on the screen using the information provided in the manual.
• Correctly retrieve data by combining information from multiple tables as shown in the Activity Lab.

During this first level course, students will learn what SQL is and how it can help them query a database to answer business questions.

• Executing a Simple Query
• Performing a Conditional Search
• Retrieve Data Based on Patterns
• Perform Date Calculations
• Manipulating String Values
• Organizing Data
• Multi-table queries
• Presenting Query Results

SQL: Fundamentals of Querying

During this course, students will connect to a database, query the database, modify the query and then save and execute the saved query. You will search using a simple condition; compare column values, search using multiple conditions, search for a range of values and null values and retrieve data based on patterns. Perform date calculations, calculate other data and manipulate string values. Sort and group data; filter the grouped data and summarize grouped data. Combine results of two queries; retrieve data by joining tables, check for unmatched records, and retrieve information from a table using joins. Customize and save the query result and generate an HTML report.

Class targeted to: Students needing to learn how to use SQL statements to query a database.

Prerequisites: Windows: Introduction or equivalent knowledge.