SQL202S: Accelerated Introduction to SQL Queries using SQL Server
Book List
Course Links
Tuition:
$195.00 per student
Length: 1 day
Introduction to SQL queries using Microsoft SQL Server. This course is ideal for business analysts looking to acquire SQL skills. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL202 which also covers modifying data and data structures.
Corporate groups (min. 2 students) at your facility or online via Remote Learning. Single individuals may arrange a private online session.
Flexible. Both onsite and online classes are custom scheduled to suit your requirements.
2-4 students 20%, 5-8 30%, >8 quote
Session 1
Introduction & Basic SQL Data Retrieval
3.0 Hours
- Relational database foundations
- Using the Query Analyzer or Management Studio
- Basic SQL data retrieval operations, DML
- SQL Select statement
- SQL Predicates, SQL Where clause
- Operators
- Sorting
- Calculated fields, Concatenation
Session 2
SQL Functions, Multi-table Retrieval
3.0 Hours
- String Manipulation
- Date Functions, Etc.
- SQL Aggregate functions (SUM, AVG, etc.)
- Group by
- Having
- Inner join, outer joins, self join
- Single and multi-valued subqueries
- Correlated subqueries
- Unions
