Become a member

Online Access to 1000+ Courses!

Exam 70-761: Querying Data with Transact-SQL Course

Author : Mark Long

9hrs (99 Lessons) 2017-01-31

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
This course is designed to help administrators, report writers, application developers and others who need to understand the basics of Transact-SQL. SQL Server is used to create and maintain databases, data warehouses, data reporting, business intelligence, data integration, and more.

Transcription not available

Course: Exam 70-761: Querying Data with Transact-SQL
Author: Mark Long
SKU: 34922
ISBN: 978-1-61866-133-3
Work Files: Yes
Captions: No
Subject: Certification
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

Welcome/Intro

Welcome/Intro

Course Overview

What is SQL Server?

What Is Transact SQL?

SQL Server Editions

Microsoft Certifications

SQL Terminology and Acronyms

Getting Setup

Getting SQL Server Express

Installing SQL Server Express pt. 1

Installing SQL Server Express pt. 2

Verifying the Installation

Getting SQL Server Management Studio

Management Studio Tour

Attaching the Sample dB

General Database Information

What is a Database?

Data Storage Challenges

Two Main Types of Databases

Understanding Tables

Columns and Datatypes pt. 1

Columns and Datatypes pt. 2

Transact SQL Language Basics

T-SQL Coding Basics pt. 1

T-SQL Coding Basics pt. 2

Lets Store Something

Creating a Database using T-SQL

Creating a Database Graphically

The Database File

The USE Command

Creating a Table

Creating a Table using T-SQL

Creating a Table Graphically

Modifying a Table

Using ALTER TABLE

Modifying a Table Graphically

Constraints and Defaults

Basic Select Statement

Basic SELECT Statement pt. 1

Basic SELECT Statement pt. 2

Adding Comments

Column Aliasing

Concatenation in TSQL pt. 1

Concatenation in TSQL pt. 2

Filtering with Predicates pt. 1

Filtering with Predicates pt. 2

Graphical Queries

Understanding NULL

Working with Data

Using Default Values

Advanced Select Statements

Using DISTINCT pt. 1

Using DISTINCT pt. 2

Using LIKE and IN pt. 1

Using LIKE and IN pt. 2

COUNT, SUM, & AVG

Using CASE Expressions pt. 1

Using CASE Expressions pt. 2

SELECT INTO Clause

Using INTERSECT and EXCEPT

OFFSET and FETCH

Grouping and Aggregating Data

GROUP BY Clause pt. 1

GROUP BY Clause pt. 2

Relational Basics

What is Normalization?

Understanding Primary Keys

Understanding Foreign Keys

Three Types of JOINs

JOIN Examples pt. 1

JOIN Examples pt. 2

Programming Objects

Stored Procedure Basics

Creating Stored Procedures

Using Parameters with Stored Procedures

Using Output Parameters

Understanding Temporary Tables

Understanding Table Variables

Temp Table vs. Table Variables

Common Table Expressions pt. 1

Common Table Expressions pt. 2

Subqueries

Understanding Subqueries

Scalar Subquery Example pt. 1

Scalar Subquery Example pt. 2

Correlated Subquery Example

Built-In Functions

Understanding Functions

Using Scalar Functions pt. 1

Using Scalar Functions pt. 2

Table-Valued Functions pt. 1

Table-Valued Functions pt. 2

Course Wrap-Up

Credits

About the Author