Who should take this course?
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Prerequisites
None
The Training Covers These Topics:
- 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 data obtained from a query before it is displayed on-screen
- Retrieve data from tables
- Format an output, save a result, and generate a report
- Use subqueries to generate query output
- Manipulate table data by inserting, updating, and deleting records in a table
- Manipulate the table structure
- Create views, manipulate data through views, modify the view structure, and drop views
- Create indices on table columns and drop inefficient indices
- Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction
What is Structured Query Language (SQL)?
- Relational Databases
- Basic SQL Keywords
- Tips for Planning Queries
- What People Do with Queries
- Understanding Data Types
- SQL Platforms
Selecting Data
- Using SELECT Statements to Examine Database Tables
- Using Results to Figure Out Other Tables to Examine
- Using Comments in SQL Code
- Narrowing you SQL Statements Down to Fields
- Sorting Records
- Using Field Aliasing
- Saving a SQL Statement
Retrieving Data from Multiple Tables
- Inner and Outer Joins
- Table Aliasing
- Self Joins
Using Criteria in SQL Statements
- Avoiding Ambiguous Situations
- Using a Single Criterion to Limit Records
- AND/OR Situation in Criteria
- Criteria Keywords
- Using Comparison Criteria
- Using Wildcards
Generating Totals Using SQL
- Aggregate Keywords
- The GROUP BY Clause
- Finding Top N Values
- Using Offset and Fetch to Limit Rows Returned
- Using Criteria in Aggregate-Based Queries
Generating Calculated Fields Using SQL
- Math Calculations
- Using SQL Keywords to Enhance the Display of Data
- Date Calculations
- Text Calculations
Unions, Subqueries, and More Joins
- Using a Where Clause as an Inner Join
- Using Unions
- Using Intersect and Except without Using Joins
- Using Subqueries
- Matching Conditions with Subqueries
Action Queries
- Using the Insert Keyword
- Using Update Statements
- Using the Delete Keyword
Advanced SQL Functions
- Replacing NULL Values
- Comparing Expressions
- Returning Multiple Rows without Self-Joins
- Updating Contents in a String
Conditional Queries
- Using an IF Statement
- Using a Case Statement
- Using the While Statement
Data Types for SQL Server
- String Data Types
- Numeric Data Types
- Date and Time Data Types
- Other Data Types