Microsoft 70-461: Querying SQL Server 2012
3.8 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
149 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft 70-461: Querying SQL Server 2012 to your Wishlist.

Add to Wishlist

Microsoft 70-461: Querying SQL Server 2012

Learn all about Microsoft 70-461 Querying SQL Server 2012
3.8 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
149 students enrolled
Last updated 1/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course will prepare you to pass the exam Microsoft 70-461 Querying SQL Server 2012
  • Earning an MCSA: SQL Server certification will qualify you for a position as a database developer or database analyst.
View Curriculum
Requirements
  • Desire to learn and pass the exam
  • Interest in SQL Server
Description

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries. 

This course provides the knowledge and understanding for some of these important job functions:

  • Apply built-in scalar functions
  • Apply ranking functions
  • Combine datasets
  • Creates and alters
  • Design T-SQL stored procedures, views
  • Implementing aggregate queries, error handling, sequence generation and data types
  • Manage transactions
  • Modify data by using INSERT, UPDATE, DELETE and MERGE statements
  • Optimizing queries
  • Query data using SELECT statements and Managing XML data
  • OUTPUT clause to return data


This learning course provides the knowledge for the 70-461 Exam on Queries on Microsoft SQL Server 2012:

  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and alter views (simple statements).
  • Design views.
  • Create and modify constraints (simple statements).
  • Create and alter DML triggers.
  • Work with Data
  • Query data by using SELECT statements.
  • Implement sub-queries.
  • Implement data types.
  • Implement aggregate queries.
  • Query and manage XML data.
  • Modify Data
  • Create and alter stored procedures (simple statements).
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Combine datasets.
  • Work with functions.
  • Troubleshoot & Optimize
  • Optimize queries.
  • Manage transactions.
  • Evaluate the use of row-based operations vs. set-based operations.
  • Implement error handling.

 We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Who is the target audience?
  • SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
196 Lectures
06:54:41
+
Querying Microsoft SQL Server 2012
3 Lectures 04:00
+
Module 1
29 Lectures 01:04:40




SQL Instances Part2
03:08

SQL Instances Part3
01:53

Editions and Licensing Part1
05:08

Editions and Licensing Part2
01:02

SQL Server Objects
01:20

System Databases
04:11

SQL Server Data Tools
02:23

Object Explorer Part1
00:49

Object Explorer Part2
01:53

Object Scripting Part1
00:48

Object Scripting Part2
02:57

Template Explorer Part1
00:55

Template Explorer Part2
01:50

Query Tabs Part1
00:36

Query Tabs Part2
03:28

Projects and Solutions Part1
00:48

Projects and Solutions Part2
03:09

Customizing SSDT Part1
00:39

Customizing SSDT Part2
05:17

Debugging T-SQL Part1
00:57

Debugging T-SQL Part2
02:20

SQLCMD Part1
02:17

SQLCMD Part2
05:36

Exam Scenarios
03:01

Module Review
01:13
+
Module 2
29 Lectures 40:04
T-SQL Overview Part1
00:07

T-SQL Overview Part2
01:15

T-SQL Overview Part3
01:02

T-SQL Elements Part1
00:17

T-SQL Elements Part2
01:29

Batch Separators Part1
01:11

Batch Separators Part2
02:56

Line Terminator Part1
00:31

Line Terminator Part2
01:35

Variables Part1
01:16

Variables Part2
01:50

Control Flow Part1
01:16

Control Flow Part2
01:28

Expressions Part1
00:56

Expressions Part2
01:48

Functions Part1
01:34

Functions Part2
02:51

Predicates and Operators Part1
01:37

Predicates and Operators Part2
02:11

Predicates and Operators Part3
00:56

SELECT Part1
01:12

SELECT Part2
01:41

SELECT Part3
00:38

Column Aliasing Part1
01:13

Column Aliasing Part2
01:15

SELECT Execution Part1
01:00

SELECT Execution Part2
01:21

Exam Scenarios
02:54

Module Review
00:44
+
Module 3
20 Lectures 25:47
SELECT Statements Part1
00:09

SELECT Statements Part2
00:09

Basic SELECT Statement Part1
01:04

Basic SELECT Statement Part2
01:22

Specifying Columns Part1
00:45

Specifying Columns Part2
01:51

Derived Columns Part1
00:47

Derived Columns Part2
01:20

Aliasing Columns Part1
01:41

Aliasing Columns Part2
01:09

Calculated Columns Part1
01:11

Calculated Columns Part2
01:46

Ordering Results Part1
00:07

Ordering Results Part2
00:51

Ordering Results Part3
01:18

Ordering Results Part4
01:03

Returning Distinct Results Part1
01:53

Returning Distinct Results Part2
01:53

Exam Scenarios
02:44

Module Review
02:44
+
Module 4
18 Lectures 39:55
Filtering Part1
00:13

Filtering Part2
00:17

WHERE Syntax Part1
01:26

WHERE Syntax Part2
01:35

BETWEEN
01:20

WHERE Syntax IN
01:36

Filtering NULL Values
02:49

LIKE
02:49

Data Type Comparison
03:35

Filtering Data with WHERE Part1
03:13

Filtering Data with WHERE Part2
04:35

Filtering Data with WHERE Part3
04:46

TOP Part1
00:13

TOP Part2
02:37

OFFSET-FETCH Part1
02:07

OFFSET-FETCH Part2
03:26

Exam Scenarios
02:26

Module Review
00:52
+
Module 5
14 Lectures 29:55
Join and Set Operators
00:10

Using Joins Part1
00:11

Using Joins Part2
01:21

Categories of Joins
01:45

INNER JOIN
04:23

OUTER JOIN
03:39

JOIN Demo
06:43

Set Operators Part1
00:08

Set Operators Part2
01:26

Set Operators Part3
01:14

Set Operators Part4
00:45

Set Operators Demo
04:32

Exam Scenarios
02:40

Module Review
00:58
+
Module 5
16 Lectures 31:16
Subqueries and Table Expressions
00:10

Subqueries Part1
00:08

Subqueries Part2
00:52

Self Contained Subquery
01:15

Correlated Subquery
00:43

Subquery Demo
03:39

EXISTS Part1
00:07

EXISTS Part2
01:21

EXISTS Part3
02:06

Common Table Expressions Part1
00:15

Common Table Expressions Part2
02:42

Temporary Tables
02:27

Table Variables
02:47

Table Demo
05:41

Exam Scenarios
05:41

Module Review
01:22
+
Module 7
19 Lectures 53:40
System Functions Part1
00:12

System Functions Part2
02:00

Scalar Functions
02:12

ROWSET
01:12

System Function Demo
03:22

Aggregate Functions Part1
00:33

Aggregate Functions Part2
02:27

DISTINCT
03:23

Aggregation Demo
04:56

GROUP BY Part1
05:23

GROUP BY Part2
07:33

HAVING Part1
01:23

HAVING Part2
02:27

Conversion Functions Part1
00:12

Conversion Functions Part2
02:51

Conversion Functions Part3
02:44

Conversion Functions Part4
06:10

Exam Scenarios
02:35

Module Review
02:05
+
Module 8
18 Lectures 48:21
T-SQL Programming
00:16

Logical Functions Part1
00:11

Logical Functions Part2
01:00

IIF, CHOOSE and CASE
03:18

Logical Function Demo Part1
02:34

Logical Function Demo Part2
02:48

Using Views Part1
00:28

Using Views Part2
04:02

Stored Procedures
04:02

Functions
03:44

Triggers
02:26

Views Demo Part1
04:35

Views Demo Part2
06:55

Views Demo Part3
04:46

TRY CATCH Part1
00:08

TRY CATCH Part2
02:23

Exam Scenarios
03:17

Module Review
01:28
+
Module 9
15 Lectures 39:21
Transactions
00:10

Introduction to Transactions Part1
00:08

Introduction to Transactions Part2
03:35

INSERT and UPDATE
02:29

DELETE and TRUNCATE
02:46

Transactions Demo Part1
04:51

Transactions Demo Part2
03:53

Transactions Demo Part3
03:35

Managing Transactions Part1
00:13

Managing Transactions Part2
03:41

XACT_ABORT
02:18

Managing Transactions Demo Part1
04:46

Managing Transactions Demo Part2
04:22

Exam Scenarios
02:01

Module Review
00:33
1 More Section
About the Instructor
iCollege Certifications
4.1 Average rating
1,676 Reviews
11,287 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
16,628 Reviews
274,986 Students
201 Courses
270,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.