Menu

DP-080T00 Querying Data with Microsoft Transact-SQL

Training Program

Credential(s) Offered

Industry certification, Secondary school diploma

Method of Delivery

Hybrid or blended

When offered

Daytime Hours

Instructional Program (CIP)

Data Modeling/Warehousing and Database Administration. 110802

Description

Overview


  • Course Overview

  • This course will teach you how to use Transact-SQL to query and modify data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

    After completing this course, students will be able to:

    Use SQL Server query tools
    Write SELECT statements to retrieve columns from one or more tables
    Sort and filter selected data
    Use built-in functions to returned data values
    Create groups of data and aggregate the results
    Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

  • Audience

  • This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.


  • Course Details

    • Module 1: Getting Started with Transact-SQL

    • Introduction to Transact-SQL

    • Using the SELECT statement

    • Lab : Get started with SQL Server query tools and writing queries in T-SQL

    • Module 2: Sorting and Filtering Query Results

    • Sorting query results

    • Filtering the data

    • Lab : Sort and filter data returned by SELECT queries

    • Module 3: Using Joins and Subqueries

    • Using JOIN operations

    • Using subqueries

    • Lab : Write queries with JOIN operations

    • Lab : Write SELECT statements using subqueries

    • Module 4: Using Built-in Functions

    • Getting started with scalar functions

    • Grouping aggregated results

    • Lab : Built-in functions

    • Write queries using scalar functions

    • Write queries using aggregate function

    • Use GROUP BY to combine data into groups based on a common column value

    • Understand how HAVING is used to filter groups of rows

    • Module 5: Modifying Data

    • Inserting data into tables

    • Modifying and deleting data

    • Lab : Modify data

    • Insert data into an existing table

    • Specify that a column should be automatically populating with an IDENTITY or a SEQUENCE value

    • Modify data using the UPDATE statement

    • Delete data using the DELETE statement

    • Modify data using MERGE to synchronize two tables




 


 


 


DP-080T00 Querying Data with Microsoft Transact-SQL

Details

Program Length (Weeks)

1

Hours

14

Entrance Requirements

None

School

VTEC

WIOA Approved Program

Yes

Curriculum Competency Based

DP-080T00 Querying Data with Microsoft Transact-SQL

Training Location(s)

343 Gorham Rd South Portland, ME 04106

Local WIB

4 - Coastal Counties Local Area 4

Type of Attainment:

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

Name of Credential

DP-080T00 Querying Data with Microsoft Transact-SQL

Type of financial aid offered or have access to

N/A

Refund Policy

15 working days in advance of the scheduled start

 

 

https://vtec.org/About/Cancellation/

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)

$120.00

Testing/Exam Fees

$165.00

In-State/District Tuition

$995.00 2 Day Course

Total In-State Program Cost

$1,280.00

Demand Occupation(s)

15-1251.00Computer Programmers
$0.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

Dec 21, 2021

Created

Aug 26, 2016

Renewal

Aug 29, 2017