Government Contract | Oregon
SQL Training for Developers

Bid Information

Bid Alert No: 00000403635

Bid Title: SQL Training for Developers

Agency Bid No. Title: ODFW-1029-15

Received Date: 10/27/2015

Close Date: 11/02/2015

Purchase Type: Not Stated

Delivery Point:

Delivery Date: Not Stated

Special Notices: Bidder Preregistration, Training Required


Specifications include, but are not limited to:ontractor to provide the following instruction in a classroom setting located at the Oregon Department of Fish and Wildlifes Headquarters 4034 Fairview Industrial Drive SE, Salem Oregon 97302. All student instructional materials to be provided. A. Course Outline 1. Module 1: Introduction to Microsoft SQL Server 2008 This module introduces the SQL Server platform and major tools. It discusses editions, versions, tools used to query, documentation sources, and the logical structure of databases. Lessons to include: a. The basic architecture of SQL Server b. SQL Server editions and versions c. Getting started with SQL Server Management Studio d. Practice session Working with SQL Server 2008 tools 1) Working with SQL Server Management Studio 2) Creating and organizing T-SQL scripts 3) Using online resources what is available? 2. Module 2: Introduction to T-SQL Querying This module introduces Transact SQL as the primary querying language of SQL Server. It discusses the basic structure of T- SQL queries, the logical flow of a SELECT statement, and introduces concepts such as predicates and set-based operations. Lessons to include: a. Introducing T-SQL b. Understanding sets c. Understanding predicate logic d. Understanding the logical order of operations in SELECT statements e. Practice session Introduction to Transact-SQL Querying 1) Executing basic SELECT statements 2) Executing queries which filter data using predicates 3) Executing queries which sort data using ORDER BY.

Bid Related Documents

Download Document

Product Codes: 92435, 92440

Agency Information

Issuing Agency: State of Oregon Department of Administrative Services

State: Oregon

Agency Type: State and Local

Contact: Debbi Farrell, Procurement Services Oregon Department of Fish and Wildlife, 4034 Fairview Industrial Drive SE, Salem, Oregon, 97302

Phone: 503-947-6130

Fax: 503-947-6156




FREE Market Analysis

Get a FREE 90-Day Market Analysis and see the bids you’ve been missing