Querying Data with Transact-SQL Video Course

70-761: Querying Data with Transact-SQL

Your Microsoft 70-761 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-761 certification test. Ace your Microsoft 70-761 at the first attempt and obtain the Querying Data with Transact-SQL credential with ease.

# of Students
141
# of Lectures
66
Course Length
6 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 70-761 Video Course

Welcome

  Video Name Time
  1. Introduction 03:15
  Video Name Time
  1. Introduction 04:09
  2. Transact-SQL 04:49
  3. SQL Server 2016 Certifications 05:04
  4. Examples 03:09
  Video Name Time
  1. Introduction 08:10
  2. Database Structure and Purpose 06:21
  3. Database Terminology 05:55
  4. Understanding Data Types 05:07
  5. Statement Types 01:39
  Video Name Time
  1. Introduction 04:38
  2. Getting SQL Server 2016 05:02
  3. Installing SQL Server 2016 10:32
  4. Installing SQL Server Management Studio 07:01
  5. Attaching The Sample Database 04:20
  Video Name Time
  1. Introduction 08:32
  2. Using The Where Clause 06:10
  3. Column Aliasing 04:49
  4. Using Distinct 05:42
  5. Ordering Results 07:18
  6. T-SQL Concatenation 07:32
  7. Multipart Naming 07:10
  Video Name Time
  1. Introduction 08:36
  2. Union 07:27
  3. Intersect and Except 07:48
  4. Paging Results 06:25
  5. Understanding Case Expressions - 1 07:42
  6. Understanding Case Expressions - 2 04:37
  7. Using Pivot - 1 07:13
  8. Using Pivot - 2 05:09
  Video Name Time
  1. Introduction 07:38
  2. Table Relationships 08:57
  3. Using The Join Statement 07:04
  4. Table Aliasing 06:25
  5. Join Types 04:00
  6. Join Types Examples 06:09
  Video Name Time
  1. Introduction 05:44
  2. Understanding Group By 08:15
  3. Understanding Having 05:39
  4. Understanding Grouping Sets 08:02
  5. Using The Graphical Query Tool 07:47
  Video Name Time
  1. Introduction 06:42
  2. Insert Demo 08:05
  3. Insert Select 06:55
  4. Select Into 05:46
  5. Updating Data 04:10
  6. Update Demo 06:45
  7. Deleting Data 03:31
  8. Delete Demo 05:54
  Video Name Time
  1. Introduction 08:37
  2. Stored Procedure Demo 06:24
  3. Using Input Parameters 07:33
  4. Using Output Parameters 07:09
  5. Understanding Table Variables 07:23
  6. Understanding CTEs - 1 05:56
  7. Understanding CTEs - 2 04:47
  8. Understanding Masking 05:48
  9. Masking Demo 03:22
  Video Name Time
  1. Introduction 04:50
  2. Understanding Scalar Functions 06:54
  3. Table-Valued Functions 06:11
  Video Name Time
  1. Introduction 02:45
  2. Scalar Subqueries 04:55
  3. Multi-Valued Subqueries 06:20
  4. Correlated Subqueries 06:25
  Video Name Time
  1. Summary 05:28

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address