Udemy.com is a platform or marketplace for online learning. Udemy provides a platform for experts of any kind to create courses which can be offered to the public, either at no charge or for a tuition fee.

Microsoft SQL Server 2012 Certification Training Exam 70-461

This Microsoft SQL Server 70-461 Exam training course by Infinite Skills teaches you everything you need to know to pass the Querying Microsoft SQL Server 2012 exam.

It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server certification from Microsoft.

Lectures 148
Video 12.5 Hours
Skill Level All Levels
Languages English, captions
Includes Lifetime access
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion

What am I going to get from this course-

Over 148 lectures and 12.5 hours of content!
To Study and Pass The Microsoft 70-461 Exam and Gain Certification for MCSA or MCSE

Curriculum

Section 1: Introduction
Lecture 1Important - Download These First - Working FilesText
Lecture 2What to expect From This Course2:07
Lecture 3Course Overview3:44
Lecture 4Understanding Databases6:44
Lecture 5Transact-SQL Basics4:22
Lecture 6Microsoft SQL Certification5:03
Lecture 7How to Access Your Working Files2:45

Section 2: Course Setup
Lecture 8SQL Server 2012 Evaluation4:38
Lecture 9SQL Server 2012 Installation6:05
Lecture 10Windows 8 Server 2012 Interface2:57
Lecture 11Windows 7 Interface3:19
Lecture 12SQL Server Sample Database4:47
Lecture 13Attaching The Sample Database5:21
Lecture 14Getting Help5:26
Lecture 15Installing SQL Books Online6:45

Section 3: SQL Server 2012 Interface
Lecture 16Management Studio Basics6:13
Lecture 17Connecting to SQL Server4:09
Lecture 18Customizing SSMS6:04
Lecture 19Utilizing Diagrams5:34
Lecture 20Saving Diagrams3:07
Lecture 21Text and Graphical Tools4:26
Lecture 22Using Sample Code Files3:22
Lecture 23About the Semicolon3:07

Section 4: Database Objects and Data
Lecture 240401 What Are Objects?3:44
Lecture 250402 Understanding Tables5:16
Lecture 260403 Understanding Data Integrity4:01
Lecture 270404 Understanding Data Types6:06
Lecture 280405 Understanding Primary Keys3:52
Lecture 290406 Understanding Constraints5:05
Lecture 300407 Understanding NULL5:10
Lecture 310408 Understanding Views5:43
Lecture 320409 Understanding Stored Procedures5:30
Lecture 330410 Understanding Triggers3:16
Lecture 340411 Understanding Synonyms6:10

Section 5: Working With Tables
Lecture 350501 Creating A Table6:22
Lecture 360502 Graphical Table Creation4:07
Lecture 370503 Changing A Table5:48
Lecture 380504 Graphical Table Alterations5:53
Lecture 390505 Deleting A Table5:43
Lecture 400506 Graphical Table Deletion3:22
Lecture 410507 Creating A Primary Key5:40

Section 6: SQL Query Basics
Lecture 420601 Four Basic Queries4:55
Lecture 430602 Thinking in SQL6:08
Lecture 440603 Options and More Options6:03
Lecture 450604 Good Query Structure6:03
Lecture 460605 Comments5:09
Lecture 470606 The USE Command2:34
Lecture 480607 The GO Command4:11
Section 7: The Basic SELECT Statement
Lecture 490701 SELECT Basics3:56
Lecture 500702 SELECT Structure5:01
Lecture 510703 Using WHERE4:35
Lecture 520704 Using TOP to Limit Rows5:02
Lecture 530705 Ordering Results6:41
Lecture 540706 Working With NULLs4:39
Lecture 550707 T-SQL Concatenation4:28

Section 8: Advanced SELECT Statements
Lecture 560801 Column Aliasing4:35
Lecture 570802 Using DISTINCT5:38
Lecture 580803 Using SUM5:36
Lecture 590804 Using AVG4:32
Lecture 600805 Using COUNT5:16
Lecture 610806 Using Group By5:58
Lecture 620807 Using HAVING4:30
Lecture 630808 SELECT INTO5:11
Lecture 640809 Using LIKE and IN6:20
Lecture 650810 Understanding UNION6:16
Lecture 660811 INTERSECT and EXCEPT5:44
Lecture 670812 Using Synonyms - Part 14:41
Lecture 680813 Using Synonyms - Part 23:47
Lecture 690814 Offset-Fetch5:26
Lecture 700815 What Is Ranking?5:42
Lecture 710816 Using Ranking5:32
Lecture 720817 More Ranking Examples6:33

Section 9: Using Joins
Lecture 730901 Understanding Joins6:12
Lecture 740902 Join Query Structure6:20
Lecture 750903 Creating Inner Joins - Part 15:37
Lecture 760904 Creating Inner Joins - Part 24:15
Lecture 770905 Join Creation Through GUI5:40
Lecture 780906 Creating Outer Joins5:37
Lecture 790907 Creating Cross Joins4:48

Section 10: Modifying Data
Lecture 801001 The INSERT Statement6:07
Lecture 811002 Using INSERT - Part 15:54
Lecture 821003 Using INSERT - Part 24:33
Lecture 831004 The UPDATE Statement5:37
Lecture 841005 Using UPDATE5:13
Lecture 851006 The DELETE Statement3:31
Lecture 861007 Using DELETE - Part 15:42
Lecture 871008 Using DELETE - Part 23:32

Section 11: Using Subqueries
Lecture 881101 Understanding Subqueries5:40
Lecture 891102 Subquery Versus Join4:26
Lecture 901103 Creating A Scalar Subquery3:30
Lecture 911104 Creating A Multi-Valued Subquery4:12
Lecture 921105 Creating A Correlated Subquery5:45

Section 12: Advanced Table Utilization
Lecture 931201 Utilizing Memory2:47
Lecture 941202 What Is A Derived Table?6:38
Lecture 951203 Creating A Derived Table5:58
Lecture 961204 Table Variables - Part 15:52
Lecture 971205 Table Variables - Part 25:56
Lecture 981206 Common Table Expressions5:05
Lecture 991207 Temporary Tables5:59

Section 13: Programmability
Lecture 1001301 Programmability in T-SQL4:12