Querying Microsoft SQL Server 2012 Exam No 70461

Master in SQL Server 2012 in a step-by-step manner
Querying Microsoft SQL Server 2012 Exam No 70461
File Size :
1.64 GB
Total length :
6h 25m



Compaq learning


Last update




Querying Microsoft SQL Server 2012 Exam No 70461

What you’ll learn

List different SQL data types
Make, amend and delete various database structures
Modify constraints
Make new data storing procedures
Maximize querying
Work with various functions
Know to handle errors
Manage transactions

Querying Microsoft SQL Server 2012 Exam No 70461


Knowledge of TSQL, javascript and C++ will be an added advantage for any particpant who is taking up this course. awareness about RDMS would be an added advantage.


Querying Microsoft SQL Server (Exam 70-461) training has been designed to help learners ace the Microsoft SQL Server 70-461 exam. The course is based on the curriculum prescribed by Microsoft.Taking leap into the data management system had Microsoft come up with a new, authentic and infallible version of SQL Server, Microsoft SQL Server 2012. It offers a trustworthy storage of data for not so important websites and other desktop applications. In this course you will be introduced to the construction and usage of databases in this platform.In this course, students who are preparing themselves for this exam will be showcased with all the necessary technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2012. Also, another point that adds value to this course is that it is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence—are few among them. This course is more or less a guide that will help you with exam 70-461 preparation, known as Querying Microsoft SQL Server 2012. It is the advent of cloud that has made this exam so popular amongst the professionals. Apart from cloud, other enterprises are considers SQL Server 2012 as a strong platform as there are many other trivial systems founded on it.By the end of the course you will be trained in creating as well as managing databases in SQL Server 2012. Apart from learning about various database objects including tables, columns, keys and others, there will be an overall understanding of how these objects help store data by providing a well-constructed structure. As add-ons you will also know to query for stored data, add new data, update and delete existing and unwanted data.All these and more are combined in 137 lecture with demos to help you out. There are end of the lesson quiz sections which will check your understanding of the lessons.15 hours of learning provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. Passing the Querying Microsoft SQL Server 2012 (70-461) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieve an MCSE certification.


Section 1: Introduction to SQL Server 2012

Lecture 1 Introduction to SQL Server 2012

Lecture 2 RDBMS – An Introduction

Lecture 3 SQL Server 2012

Lecture 4 SQL Server Components

Lecture 5 SQL Server Tools

Lecture 6 SQL Server Management Studio

Lecture 7 Managing Databases

Lecture 8 SSMS Windows

Lecture 9 Demo – Exploring SSME

Lecture 10 Understanding Database Objects

Lecture 11 Demo – Creating Database Objects using SSMS

Lecture 12 Conclusion

Section 2: Working with T-SQL

Lecture 13 Working with T – SQL

Lecture 14 Demo Viewing a Table Structure

Lecture 15 Querying

Lecture 16 T – SQL

Lecture 17 Demo Writing a Simple Query

Lecture 18 Managing Database Objects

Lecture 19 Demo – Add, Modify, and Delete Database Objects

Lecture 20 Constraints

Lecture 21 Demo – Adding Constraints

Lecture 22 SELECT

Lecture 23 Demo – Querying Data from Tables

Lecture 24 CASE

Lecture 25 Demo – Advanced Queries

Lecture 26 Conclusion

Section 3: Understanding SQL Data Types

Lecture 27 Understanding SQL Data Types

Lecture 28 String Types

Lecture 29 MAX Setting

Lecture 30 Demo – Using Character, UNICODE, and Binary Strings

Lecture 31 Numeric Types

Lecture 32 Demo – Working with Numeric Data

Lecture 33 Date and Time

Lecture 34 Demo – Working with Date and Time

Lecture 35 Advanced Data Types

Lecture 36 Demo – Exploring Some Advanced Data Types

Lecture 37 Conclusion

Section 4: Sorting and Filtering

Lecture 38 Sorting and Filtering

Lecture 39 Sorting with ORDER BY, and Performing Multiple Column and Ascending – Descending

Lecture 40 Extended Capabilities for Sorting

Lecture 41 Demo – Using TOP, OFFSET, and FETCH

Lecture 42 Filtering Results

Lecture 43 Demo – Filter using WHERE, and Different Predicates and Operators

Lecture 44 Advanced Filtering

Lecture 45 Demo – Unicode, ANY, and ALL filters

Lecture 46 Conclusion

Section 5: Query Multiple Tables using JOINs

Lecture 47 Query Multiple Tables using JOINs

Lecture 48 Multiple Tables

Lecture 49 Demo – Querying Multiple Tables without a JOIN

Lecture 50 Using JOIN

Lecture 51 Simple Join

Lecture 52 Demo – Using Implicit Join between Tables

Lecture 53 JOINs

Lecture 54 Demo – Using CROSS, INNER, and OUTER JOINs

Lecture 55 Advanced JOINs

Lecture 56 Demo – Using MERGE, HASH, and LOOP

Lecture 57 Conclusion

Section 6: Modifying Table Data

Lecture 58 Modifying Table Data

Lecture 59 Demo – Using Different Forms of INSERT to Add Data to a Table

Lecture 60 Other Methods to Add Data

Lecture 61 Demo – Using Bulk Adding Methods

Lecture 62 Modifying Data in a Table

Lecture 63 Demo – Modifying Data with UPDATE

Lecture 64 Removing Data from Tables

Lecture 65 Demo – DELETE and TRUNCATE Data from Tables

Lecture 66 Synchronizing Data between Tables

Lecture 67 Demo – Synchronizing Data using MERGE

Lecture 68 Conclusion

Section 7: Programming in SQL Server

Lecture 69 Programming in SQL Server

Lecture 70 Function Categories

Lecture 71 String Functions

Lecture 72 Conversion Functions

Lecture 73 Logical Numeric Functions

Lecture 74 Date and Time Functions

Lecture 75 Demo – Using Different Functions in SQL Server

Lecture 76 Working with Groups and Aggregates

Lecture 77 Aggregate Functions

Lecture 78 Demo – Grouping and Using Different Aggregates

Lecture 79 Variables and Batches

Lecture 80 Demo – Using Variables and Batches

Lecture 81 Control Flow Statements

Lecture 82 Demo – Using Control Flow Statements

Lecture 83 Working with Stored Procedures

Lecture 84 Demo – Working with Stored Procedures

Lecture 85 Conclusion

Section 8: Writing Advanced Queries in T-SQL

Lecture 86 Writing Advanced Queries in T – SQL

Lecture 87 Using Subqueries Demo

Lecture 88 Table Expressions

Lecture 89 Using Table Valued Expressions Demo

Lecture 90 Set and Conditional Operators

Lecture 91 Using Different Set Operators Demo

Lecture 92 Window Functions

Lecture 93 Using Window Functions Demo

Lecture 94 Creating User – Defined Functions

Lecture 95 Create and Use UDF Demo

Lecture 96 Conclusion

Section 9: Data Manipulation

Lecture 97 Data Manipulation

Lecture 98 Using PIVOT to Analyze Data Demo

Lecture 99 Grouping Sets

Lecture 100 Grouping Sets Demo

Lecture 101 Handling Transactions

Lecture 102 Using Transactions Demo

Lecture 103 Conclusion

Section 10: Advanced Querying

Lecture 104 Advanced Querying

Lecture 105 Master Database

Lecture 106 System Stored Procedures

Lecture 107 Work with System Stored Procedures Demo

Lecture 108 Query Plans

Lecture 109 Viewing Query Plans Demo

Lecture 110 Manage Indexes

Lecture 111 Manage Views

Lecture 112 Using Indexes and Views Demo

Lecture 113 Windows Azure SQL Database

Lecture 114 Overview of Windows Azure SQL Database Demo

Lecture 115 Conclusion

Section 11: Test Paper

This is intended for professionals who want to excel in querying. Therefore working professionals like database administrators, developers, system engineers and business professionals can take up this exam. This the first level so if you’re looking for an advanced version this course is not for you.

Course Information:

Udemy | English | 6h 25m | 1.64 GB
Created by: Compaq learning

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top