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.

SQL: Advanced

Learning Outcomes:

• Accurately perform a query with sub queries utilizing information in the Lesson Lab.
• Using the information provided by the Instructor, perform multiple-level subqueries with 95% accuracy.
• Working with the information from the Activity Lab, successfully create, alter, and delete tables.
• Correctly create a view and manipulate data in views as directed by the Instructor using the data provided.

During this one-day second level course, students will learn how to perform advanced queries and add, update, and delete data, tables, views, and indexes.

• Advanced Querying Using Subqueries
• Filter Grouped Data Within Subqueries
• Manipulating Table Data
• Manipulating the Table Structure
• Working with Views
• Indexing Data
• Working with Transactions

SQL: Advanced

During this Advanced level the student will s earch based on an unknown value and on multiple unknown values. Compare a value with unknown values. Search based on the existence of records. Generate output using correlated subqueries. Filter grouped data within subqueries. Perform multiple-level subqueries. Insert, modify and delet data. Create a simple table and a table with constraints. Add or drop table columns. Add or drop constraints. Modify the column definition and delete tables. Create a view, manipulate data in views and modify and drop views. Create and drop indexes. Rollback transactions and commit transactions.

Class targeted to: Students enrolling in this course should understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins.

Prerequisites: SQL: Fundamentals of Querying or equivalent knowledge.