Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Microsoft 70-761: Querying Data with Transact-SQL

EDUTAINMENT COURSE

Microsoft 70-761: Querying Data with Transact-SQL

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

This course introduces viewers to Microsoft Transact-SQL,  the language used to input and retrieve data from Microsoft SQL servers.  The series is designed for viewers of all experience levels as it  walks through running your very first query all the way through crafting advanced server-side stored procedures.

Objectives

At the end of this course,  you will have developed the knowledge and skills necessary to pass the Querying Data with Transact-SQL Exam.  So let's get started.

Prerequisites

Candidate should have a working knowledge of relational databases and a basic knowledge of the Microsoft Windows operating system and its core functionality.

Target Audience
  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-761
Instructor: ITProTV

ITProTV delivers the IT instruction that you need to advance or launch your IT career in a fun and creative way. With attractive studios and an interactive, talk-show style format, you'll watch more and learn more. From CompTIA, Cisco, and Microsoft to Security and Cloud Fundamentals, you can learn it all. Dive deep into one or master many with the friendly faces of IT training.

  1. QUERYING DATA WITH T-SQL
1
Start
Overview
2
Start
Introduction To Transact-SQL
3
Start
Introduction To Transact-SQL Part 2
4
Start
Retrieving Data With SELECT
5
Start
Retrieving Data With SELECT Part 2
6
Start
Combining Results With JOIN
7
Start
Combining Results With JOIN Part 2
8
Start
Combining Results With JOIN Part 3
  1. MODIFYING DATA WITH T-SQL
9
Start
Adding Data With INSERT
10
Start
Changing Data With UPDATE
11
Start
Removing Data With DELETE
12
Start
Recording Changes With OUTPUT
  1. WORKING WITH FUNCTIONS
13
Start
Querying Data With Functions
14
Start
Querying Data With Functions Part 2
15
Start
Aggregating Data
16
Start
Performing Arithmetic
17
Start
Working With Dates
18
Start
System Functions
  1. WORKING WITH DATA TYPES
19
Start
Data Types
20
Start
Data Types Part 2
21
Start
Custom Data Types
22
Start
Converting Data Types
23
Start
Converting Data Types Part 2
24
Start
Conditions And Nulls
  1. PROGRAMMING DATABASES WITH T-SQL
25
Start
User Defined Functions
26
Start
Stored Procedures
27
Start
Creating Views
28
Start
Transactions
29
Start
Transactions Part 2
30
Start
Error Handling
31
Start
Error Handling Part 2
  1. ADVANCED TRANSACT-SQL
32
Start
Subqueries
33
Start
Subqueries Part 2
34
Start
Grouping Sets And Cubes
35
Start
Grouping Sets And Cubes Part 2
36
Start
Ranking Data With Window Functions
37
Start
Ranking Data With Window Functions Part 2
38
Start
Pivot And Unpivot Data
39
Start
Table Expressions And Apply
  1. WORKING WITH JSON AND XML
40
Start
Working With XML
41
Start
Working With JSON
EDUTAINMENT COURSE
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 19
  • 18:16:00
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top