Querying Microsoft SQL Server 2012 - (Exam No. 70-461)

Master in SQL Server 2012 in a step-by-step manner
4.1 (51 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.
435 students enrolled
$85
Take This Course
  • Lectures 115
  • Contents Video: 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

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.

What are the requirements?

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

What am I going to get from this course?

  • 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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to SQL Server 2012
00:48

Get introduced to SQL Server 2012

03:14

Understand RDBM. RDBMS is an acronym for Relational Database Management System and is the most popular and widely used database system in the world.

04:51

SQL Server 2012 is available in 6 different editions. You can pick the one that matches what you need as well as your budget.

01:58

Main components of SQL Server

02:06
SQL Server Management Studio, or SSMS in short, is probably the most important tool in the product.
01:55

SQL Server Management Studio, or SSMS in short, is probably the most important tool in the product. SQL Server Management Studio, also referred to as SSMS, is the main management tool of the SQL Server product.

01:46

Learn how to use SSMS to manage the Database Engine and what all you can do with it.

03:22
The Object Explorer, as shown in the first screenshot, is a pane that appears on the left side of the SSMS window.
02:12

Explore different parts of SSMS and take a look at some of the SQL Server components that are available.

03:25

There are many different structures that are stored within a database file,

03:21

We will see how you can create and manage certain database objects using the SSMS tool.

01:34

Discuss the main points of this lesson.

Quiz
3 questions
Section 2: Working with T-SQL
07:03
A table is the basic form of data storage units. All data in a database is stored in tables that you create.
02:00

Explore some of the database objects and structures in a pre created database.

01:40

The Structured Query Language – popularly known as SQL – is the main language for talking to RDBMS. SQL, which is different from SQL Server, the product, is a unique computer language. It is

03:03

Microsoft's flavor of SQL is called T-SQL which is a short form for Transact SQL. T-SQL contains many extensions that are specific to SQL Server and obviously works with them.

00:55

Work with a simple query in T-SQL to see what it allows us to do.

03:09

Introduces you to some T-SQL statements that allow to manage objects like databases and tables in an SQL Server platform.

03:37

You will see how we can manage different database objects in SQL Server using the CREATE, ALTER and DROP commands.

08:22

Explain constraints, what they are, the different types that are available, and why they are used.

08:01

See how to use different constraints and the effect they have on data within the table.

03:44

SELECT is an important query command.

03:13

Look at some simple uses of the SELECT statement.

02:19

The CASE extension is one that lets you change the way a value in a column is displayed in the result.

03:33

See how you can use the different CASE extensions for more advanced scenarios involving the SELECT statement.

Conclusion
01:42
Quiz
3 questions
Section 3: Understanding SQL Data Types
04:25

When you store data in a table under different columns, each column is allowed to be for a single data type.

04:42
The default set of string based data types stores simple character strings.
MAX Setting
04:04
04:14

You will see how you can work with String data types in SQL Server and store different types of string data within them.

03:16

The first subcategory of numeric data types is the ones that store exact numeric values. These have further subcategories under them as well.

01:46

See how you can work with numeric data and store different numeric values in a table.

03:59
look at the Date types that are available.
03:18

See how we can use different date and time types as well as the effect that changing the date format has on the database in understanding dates.

05:56

Most of the advanced data types are meant for special purposes and scenarios.

05:20

Look at some of the advanced data types available in SQL Server.

Conclusion
00:48
Quiz
3 questions
Section 4: Sorting and Filtering
05:54

Learn how you can use the ORDER BY clause to sort results of a query and some of its different forms that you can use.

02:35

Learn to specify multiple columns to sort on in an ORDER BY clause by separating the column names with commas. The sort will be performed in the order of the columns given.

Extended Capabilities for Sorting
06:42
02:50

See how to use the TOP, OFFSET and FETCH clauses for paging records.

08:03
A single condition is the simplest form of input for the WHERE clause.
03:54

Use the WHERE clause, different predicates and operators to filter search results.

03:29

Understand some advanced ways of filtering data in SELECT queries for different types of results.

02:03

See how to use Unicode strings in queries as well as the ANY and ALL clauses.

Conclusion
01:26
Quiz
3 questions
Section 5: Query Multiple Tables using JOINs
03:13

See how you can query from multiple tables at the same time and the way that SQL Server handles this.

03:45

To understand how SQL Server handles queries from multiple tables, one must first understand why you use multiple tables in the first place. This is a core concept of RDBMSs called “normalization”.

02:31

See how querying works when using multiple tables simultaneously.

02:09

Look at the different types of JOIN and the differences between each and why each should be used with examples.

Simple Join
00:56
Demo - Using Implicit Join between Tables
01:42
07:42

The CROSS JOIN is the simplest form of a JOIN. When you use a CROSS JOIN in a SELECT statement, it is functionally identical to the case of simply providing the names of the tables in the FROM clause.

03:31

See how using different types of JOINs show different results.

03:24

Learn how you can create advanced JOINs using certain keywords.

00:54

See how the join hints are used in queries.

Conclusion
00:58
Quiz
3 questions
Section 6: Modifying Table Data
05:53

See how data can be added to a table using the INSERT command. You will also see its many variant syntaxes that allow you to add data in different ways to the table.

04:26

Learn how to add records to a table using the different forms of the INSERT statement.

04:58

The third method of bulk adding data is helpfully called an obvious BULK INSERT. This is most useful when the data is external to the database.

05:49

See how you can use the SELECT, SELECT INTO and BULK INSERT commands to add multiple records to a table in one go.

02:45

Know the UPDATE statement allows you to modify existing data in a table.

01:37

Learn how to update records in a table using the UPDATE command and specify records to update using its WHERE clause.

04:12

Know how to remove data – that is, records – from a table in SQL using the DELETE statement.

03:38

See how records can be deleted from a table using the DELETE and TRUNCATE statements.

04:34

Learn an advanced feature of SQL Server that lets you synchronize data between two tables. This is done using a new statement called MERGE that combines the power of the INSERT, UPDATE and DELETE statements.

05:56

See how we synchronize data between two tables using the MERGE statement along with the 2 rules.

Conclusion
01:04
Quiz
3 questions
Section 7: Programming in SQL Server
03:15

Learn about functions, what they are, how they work and how you can use them. Also, see the different categories of functions that exist and look at some of the most commonly used functions within those categories.

01:47
A function is a method that adds a specific functionality to a SQL Server statement.
01:57
The LEN function returns the length of a string.
02:18

Conversion functions are an important part of SQL Server. By default, you cannot mix data types within a statement.

01:43

The Logical functions are used to perform logical choices in SQL.

01:54

Date and time functions are a very important category of functions and are used quite extensively. While mostly used to manipulate dates, the functions here can also manipulate time values as well.

05:01

See how to use many different functions from different categories. You'll see how to use them singly with a value as well as with column in table with many rows of data.

02:34

Learn about grouping data, the need to do so and an introduction to special functions called Aggregate functions or simply Aggregates.

02:14

The Aggregate functions, or as they're commonly known – aggregates are special functions in SQL Server. These work over groups of data rather on individual rows unlike other functions.

02:20

See some examples of grouping and using different aggregates to see an overview of data.

05:58

Get introduced to using variables in SQL Server programming and the different ways and places you can use them in.

03:00

See how to declare variables and use them in different places and create and use batches.

06:01

Control flow statements let you modify this behavior a little bit by giving a different direction to the statement execution.

05:07

See how to use different control flow statements like the GOTO, IF and WHILE along with enclosing statement batches within a container.

07:10

Learn about Stored Procedures – an advanced programming construct in SQL that lets you define a batch of statements that can be reused whenever you want.

06:11

Show you how to create a stored procedure, execute it and then modify it to use parameters to make it even more useful.

Conclusion
00:46
Quiz
3 questions
Section 8: Writing Advanced Queries in T-SQL

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Compaq learning, One stop to learn and succeed

With a clear motto to upgrade the skills of students from high school goers to professionals, Compaq learning started its tutoring journey in 2013. But within two years, an effort by three IT professionals that started as a blog went on to become one of the largest course developing company in the e learning industry.

We kick started our stint in the e-learning world by mentoring high school students. The passion for teaching and mentoring students gave us the confidence and courage to plunge into the e learning industry and provide various guidance for high school students to IT professionals. Until now we have trained around 15,000 students in various subjects ranging from simple mathematics to android app development. We have a group of fine instructional designers, graphic designers and SMEs who ensure that our products are original and valuable.

Ready to start learning?
Take This Course