Course Description 

Intro to SQL: T-SQL is the second of two SQL classes being offered to help prepare database and network administrators as well as report writers to use applications such as SQL Server Reporting Services and Crystal Reports. SQL is the programming language used to create queries against common BI projects and tools as well as manipulate data and manage the server.

SQL SELECT Queries define the logic used to extract data from any SQL database. Report writers, DBAs, and network administrators will be able to use well formed queries to build necessary reports.

The SQL SELECT Queries course is the foundation for an understanding of relational databases and extracting the data needed for reports. SQL is a very simple language which can be combined into highly complex queries to handle any type of database query. The companion T-SQL course covers topics essential to database management and the student has taken this Queries class. This course is designed for report writers, beginning DBA, and network administrators.

Course Outline

1. Database and DBMS basics
2. SELECT Statements
3. Sorting, Filtering, and Grouping
4. Calculated Fields and Functions
5. Sub Queries
6. Joins
7. Working with Views

Prerequisites

Participants do not need any previous programming experience. Previous experience using databases such as Access is helpful but not required.

Outcomes

1. Participants will identify and parse basic SQL queries.

2. Participants will effectively write simple SQL queries which follows proper syntax and format

3. Participants will troubleshoot problem code efficiently.

4. Participants will easily find and consistently use common learning and reference resources.

HONOR 

Please note that the price is per person.

A 10% discount will gladly be granted to organizations with 2 or more participants in a class.

STI reserves the right to bill the organization for unpaid attendees.

Logistics

Virtual Environment

It is the responsibility of the student to assure that they have an adequate Internet connection, are able to use the VoIP or dial-in audio connections, and can connect to the virtual meeting service. Please see the system requirements: https://www.meetingburner.com/support/sysreq 

Practice Environment

Students are encouraged to install and configure Microsoft SQL Server Express 2008 R2 and the provided database to use during the exercises in class. STI is unable to provide support for this installation so please have your IT department assist in the setup prior to class time. Setup information will be provided upon registration.

NOTE: It is recommended students use a second computer or monitor for the exercises. One computer or monitor should display the instructor’s screen and one should be used for the student’s exercises.

Text Book 

Upon registration students must provide a mailing address where they can receive the text book. Students who enroll later than 5 business days prior to the class may participate but cannot be guaranteed a copy of the book in time for class.

George Sawyer  (48 Posts)

Technology Coach & CEO of Sawyer Training, Inc. and active instructor and speaker. George has three children and enjoys the challenge of living a very low-tech, sustainable life in an urban environment.

Technology Coach & CEO of Sawyer Training, Inc. and active instructor and speaker. George has three children and enjoys the challenge of living a very low-tech, sustainable life in an urban environment.