Menu

Querying Microsoft SQL Server

Training Program

Credential(s) Offered

Industry certification, Employment, Measurable skills gain

Method of Delivery

Hybrid or blended

When offered

Daytime Hours

Instructional Program (CIP)

Computer Systems Analysis/Analyst. 110501

Description

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.


The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
As such, the primary target audience for this course is: Database Administrators, Database Developers, report creators, BI professionals application developers who have an understanding of relational database concepts and have basic Windows navigation skills.


Prerequisites

  • Basic understanding of relational databases.
    Basic Windows knowledge.



  • At Course Completion

  • Create single table SELECT queries

  • Create multiple table SELECT queries

  • Filter and sort data, Insert, update, and delete data

  • Query data using built-in functions, Create queries that aggregate data

  • Create subqueries, Create queries that use table expressions

  • Use UNION, INTERSECT, and EXCEPT on multiple sets of data

  • Implement window functions in queries

  • Use PIVOT and GROUPING SETS in queries

  • Use stored procedures in queries

  • Add error handling to queries

  • Use transactions in queries


 

Details

Program Length (Weeks)

1

Hours

35

Entrance Requirements

Combination of Education and Course(s)

School

VTEC

WIOA Approved Program

Yes

Curriculum Competency Based

Microsoft SQL

Training Location(s)

343 Gorham Rd, South Portland, ME

Local WIB

4 - Coastal Counties Local Area 4

Type of Attainment:

Postsec. Awards/Cert./Diplomas; 1 yr.

Name of Credential

Querying Data with Transact-SQL

Type of financial aid offered or have access to

Refund Policy

Is the proposed curriculum currently certified by an accrediting agency or similar national standardization program?

Yes - Microsoft

Is this proposed curriculum considered a nontraditional program of training services for women?

No

Is this proposed curriculum considered a nontraditional program of training services for men?

No

Cost Items

Books (Estimated)

$250.00

Testing/Exam Fees

$165.00 (Optional)

In-State/District Tuition

$2,495.00 Days

Total In-State Program Cost

$2,910.00

Demand Occupation(s)

15-1211.00Computer Systems Analysts
$29.00 per hour

Provider Status

Approved

Address

343 Gorham Rd, 2nd Floor (around back), South Portland, Maine 04106

Phone Number

(207) 775-0244

Fax Number

(207) 756-6148

Last Updated

Apr 18, 2023

Created

May 06, 2016

Renewal

Jun 15, 2018

Please Wait ...