MCSA Querying Microsoft SQL Server 2012/2014 Video Course

70-461: MCSA Querying Microsoft SQL Server 2012/2014

Your Microsoft 70-461 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-461 certification test. Ace your Microsoft 70-461 at the first attempt and obtain the MCSA Querying Microsoft SQL Server 2012/2014 credential with ease.

# of Students
546
# of Lectures
147
Course Length
12 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 70-461 Video Course

Introduction

  Video Name Time
  1. What To expect From This Course 02:07
  2. Course Overview 03:44
  3. Understanding Databases 06:44
  4. Transact-SQL Basics 04:22
  5. Microsoft SQL Certification 05:03
  6. How To Access Your Working Files 02:44
  Video Name Time
  1. SQL Server 2012 Evaluation 04:38
  2. SQL Server 2012 Installation 06:05
  3. Windows 8 Server 2012 Interface 02:51
  4. Windows 7 Interface 03:19
  5. SQL Server Sample Database 04:47
  6. Attaching The Sample Database 05:21
  7. Getting Help 05:26
  8. Installing SQL Books Online 06:45
  Video Name Time
  1. Management Studio Basics 06:13
  2. Connecting To SQL Server 04:09
  3. Customizing SSMS 06:04
  4. Utilizing Diagrams 05:34
  5. Saving Diagrams 03:07
  6. Text And Graphical Tools 04:26
  7. Using Sample Code Files 02:30
  8. About the Semicolon 03:07
  Video Name Time
  1. 0401 What Are Objects? 03:44
  2. 0402 Understanding Tables 05:16
  3. 0403 Understanding Data Integrity 04:01
  4. 0404 Understanding Data Types 06:06
  5. 0405 Understanding Primary Keys 03:52
  6. 0406 Understanding Constraints 05:05
  7. 0407 Understanding NULL 05:10
  8. 0408 Understanding Views 05:43
  9. 0409 Understanding Stored Procedures 05:30
  10. 0410 Understanding Triggers 03:16
  11. 0411 Understanding Synonyms 06:10
  Video Name Time
  1. 0501 Creating A Table 06:22
  2. 0502 Graphical Table Creation 04:07
  3. 0503 Changing A Table 05:48
  4. 0504 Graphical Table Alterations 05:53
  5. 0505 Deleting A Table 05:43
  6. 0506 Graphical Table Deletion 03:22
  7. 0507 Creating A Primary Key 05:40
  Video Name Time
  1. 0601 Four Basic Queries 04:56
  2. 0602 Thinking In SQL 06:08
  3. 0603 Options And More Options 06:03
  4. 0604 Good Query Structure 06:03
  5. 0605 Comments 05:09
  6. 0606 The USE Command 02:34
  7. 0607 The GO Command 04:11
  Video Name Time
  1. 0701 SELECT Basics 03:56
  2. 0702 SELECT Structure 05:01
  3. 0703 Using WHERE 04:48
  4. 0704 Using TOP To Limit Rows 05:02
  5. 0705 Ordering Results 06:41
  6. 0706 Working With NULLs 04:39
  7. 0707 T-SQL Concatenation 04:14
  Video Name Time
  1. 0801 Column Aliasing 03:39
  2. 0802 Using DISTINCT 04:57
  3. 0803 Using SUM 04:17
  4. 0804 Using AVG 03:14
  5. 0805 Using COUNT 04:37
  6. 0806 Using Group By 04:51
  7. 0807 Using HAVING 03:56
  8. 0808 SELECT INTO 04:07
  9. 0809 Using LIKE And IN 06:20
  10. 0810 Understanding UNION 04:45
  11. 0811 INTERSECT And EXCEPT 05:44
  12. 0812 Using Synonyms - Part 1 03:52
  13. 0813 Using Synonyms - Part 2 03:47
  14. 0814 Offset-Fetch 04:10
  15. 0815 What Is Ranking? 05:42
  16. 0816 Using Ranking 05:32
  17. 0817 More Ranking Examples 06:33
  Video Name Time
  1. 0901 Understanding Joins 06:12
  2. 0902 Join Query Structure 06:21
  3. 0903 Creating Inner Joins - Part 1 05:37
  4. 0904 Creating Inner Joins - Part 2 04:15
  5. 0905 Join Creation Through GUI 04:38
  6. 0906 Creating Outer Joins 05:37
  7. 0907 Creating Cross Joins 04:08
  Video Name Time
  1. 1001 The INSERT Statement 05:39
  2. 1002 Using INSERT - Part 1 05:27
  3. 1003 Using INSERT - Part 2 04:33
  4. 1004 The UPDATE Statement 05:37
  5. 1005 Using UPDATE 04:49
  6. 1006 The DELETE Statement 03:31
  7. 1007 Using DELETE - Part 1 05:10
  8. 1008 Using DELETE - Part 2 03:32
  Video Name Time
  1. 1101 Understanding Subqueries 05:40
  2. 1102 Subquery Versus Join 04:26
  3. 1103 Creating A Scalar Subquery 03:30
  4. 1104 Creating A Multi-Valued Subquery 04:12
  5. 1105 Creating A Correlated Subquery 05:45
  Video Name Time
  1. 1201 Utilizing Memory 02:47
  2. 1202 What Is A Derived Table? 06:38
  3. 1203 Creating A Derived Table 05:58
  4. 1204 Table Variables - Part 1 05:52
  5. 1205 Table Variables - Part 2 05:56
  6. 1206 Common Table Expressions 05:05
  7. 1207 Temporary Tables 05:59
  Video Name Time
  1. 1301 Programmability In T-SQL 04:12
  2. 1302 What Is A Stored Procedure? 05:03
  3. 1303 Why Use Stored Procedures? 04:46
  4. 1304 A Simple Stored Procedure 04:50
  5. 1305 Input Parameters 05:06
  6. 1306 Multiple Input Parameters 03:42
  7. 1307 Output Parameters - Part 1 05:59
  8. 1308 Output Parameters - Part 2 05:16
  9. 1309 Using Case Logic - Part 1 05:07
  10. 1310 Using Case Logic - Part 2 04:54
  11. 1311 Handling Errors 06:02
  12. 1312 Stored Procedure Security 04:46
  13. 1313 Working With Functions 03:42
  14. 1314 Using Built-In Functions 04:10
  15. 1315 Creating A Scalar Function 05:00
  16. 1316 Creating A Table Valued Function 04:29
  17. 1317 What Is Dynamic SQL? 03:17
  18. 1318 Dynamic SQL Example 04:53
  19. 1319 Understanding GUIDs 05:41
  20. 1320 GUID Examples - Part 1 03:35
  21. 1321 GUID Examples - Part 2 04:51
  Video Name Time
  1. 1401 Using Triggers 04:58
  2. 1402 Inserted And Deleted Tables 03:29
  3. 1403 Trigger Examples - Part 1 05:32
  4. 1404 Trigger Examples - Part 2 05:18
  Video Name Time
  1. 1501 What Are Transactions? 05:11
  2. 1502 Understanding Concurrency 06:36
  3. 1503 Explicit And Implicit Transactions 04:08
  4. 1504 Cross Platform Concerns 03:22
  5. 1505 Transaction And Locking Example 06:16
  Video Name Time
  1. 1601 Using Metadata 04:37
  2. 1602 Using Catalog Views 06:06
  3. 1603 Using Information Schema Views 05:05
  4. 1604 Using System Stored Procedures 04:48
  Video Name Time
  1. 1701 XML Basics 05:59
  2. 1702 Outputting XML From Queries 04:51
  3. 1703 Using FOR XML RAW 06:34
  4. 1704 Using FOR XML AUTO 06:18
  5. 1705 Using FOR XML PATH 06:38
  Video Name Time
  1. 1801 Optimization Basics 06:11
  2. 1802 Query Execution Plans - Part 1 04:36
  3. 1803 Query Execution Plans - Part 2 06:18
  4. 1804 SQL Server Extended Events - Part 1 03:01
  5. 1805 SQL Server Extended Events - Part 2 06:22
  6. 1806 SQL Server Profiler 05:16
  Video Name Time
  1. 1901 Exam Basics 05:38
  2. 1902 Taking Your Exam 06:32
  3. 1903 When It Is Over 04:55
  Video Name Time
  1. 2001 Wrap-Up 03:35

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
  • 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