1st step to certification: Querying Microsoft SQL Server 2012 (70-461)


  • 1st step to certification: Querying Microsoft SQL Server 2012 (70-461), Singapore SKillsFuture elarning online course
  • 1st step to certification: Querying Microsoft SQL Server 2012 (70-461), Singapore SKillsFuture elarning online course
  • 1st step to certification: Querying Microsoft SQL Server 2012 (70-461), Singapore SKillsFuture elarning online course
  • 1st step to certification: Querying Microsoft SQL Server 2012 (70-461), Singapore SKillsFuture elarning online course
  • 1st step to certification: Querying Microsoft SQL Server 2012 (70-461), Singapore SKillsFuture elarning online course
  • 1st step to certification: Querying Microsoft SQL Server 2012 (70-461), Singapore SKillsFuture elarning online course

Course Description

The 2012 Microsoft MCSA Certification track includes Exam 70-461 Querying Microsoft SQL Server 2012. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This VTC course is intended for SQL Server database administrators, implementers, system engineers, and developers who are preparing to take the 70-461 exam as well as those who are just beginning to learn Transact-SQL. Mark Long is the instructor and will take you through the various tools and concepts needed to help you get ready for the 70-461 exam.

Be fully prepared for your certifications exams!

- Learn of the examination outline before sitting for your certification
- Know and understand the topics that may be covered in your examinations
- Learn and understand the chapters for each tailored certification
- Go through past questions to have a feel of the examinations

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Know what to expect for your examination 
2. Understand the introduction to SQL Server 2012
3. Be able to install and configure SQL Server 2012
4. Know how to create a Database Objects
5. Understand the Basic Select Queries 
6. Know more Advanced Select Statements
7. Know the Data Types in SQL Server 2012
8. Understand about Joins, Inserts, Updates, Deletes, Subqueries 
9. Know about Stored Procedures 
10. Understand about Functions and Transactions


Related Courses

  • Database Fundamentals (98-364)

    Database Fundamentals (98-364)

    SGD $40.00

    Course Description

    Database administration, design and development continue to be some of the most sought-after skills in Information Technology, but where do you start to learn such a big topic? In this course, Mark Long teaches you the fundamentals about Microsoft's SQL Server database management system to help you take the first step on a path to becoming part of this exciting field. Mark has worked with SQL Server for almost 20 years and brings his experience along to present database fundamentals in an easy to understand manner to get you started. This course will also help you prepare to take Microsoft's 98-364 Database Fundamentals MTA exam so you can become Microsoft certified right away.Be fully prepared for your certifications exams!- Learn of the examination outline before sitting for your certification - Know and understand the topics that may be covered in your examinations- Learn and understand the chapters for each tailored certification - Go through past questions to have a feel of the examinations

    Read more...

  • Certification at Your Fingertips - Microsoft 70-331: Core Solutions of SharePoint Server 2013

    Certification at Your Fingertips - Microsoft 70-331: Core Solutions of SharePoint Server 2013

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: This course will provide you with the knowledge and skills to configure and manage a Microsoft SharePoint Server 2013 environment and will teach you how to configure SharePoint Server 2013, as well as provide guidelines, best practices, and considerations that will help you optimize your SharePoint server deployment. Be fully prepared for your certifications exams! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Learn and understand the chapters for each tailored certification  - Go through past questions to have a feel of the examinations

    Read more...

  • Certification at Your Fingertips - Microsoft 70-332: Advanced Solutions of SharePoint Server 2013

    Certification at Your Fingertips - Microsoft 70-332: Advanced Solutions of SharePoint Server 2013

    SGD $299.00

    Course Description

    This course examines how to plan, configure, and manage a Microsoft SharePoint Server 2013 environment. Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the Search experience, how to develop and implement a governance plan. and how to perform an upgrade or migration to SharePoint Server 2013. Be fully prepared for your certifications exams! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Learn and understand the chapters for each tailored certification  - Go through past questions to have a feel of the examinations

    Read more...


Content

Introduction

Preview Available

+

Welcome

Course Overview

Understanding SQL

Understanding TSQL

SQL Server History

Microsoft SQL Server Certifications

Getting Set Up

+

Getting SQL Server 2012

Installing SQL Server 2012

Attaching the Sample Database

Getting SQL Books Online Locally

Code Examples

SQL Server 2012 Management Studio

+

Query Results Options

Database Diagrams

SSMS Tour

Graphical Queries

SSMS Options

Creating Database Objects

+

Table Design Basics

Creating a Table

Altering Tables

Dropping Tables

Understanding Views

Creating Views pt. 1

Creating Views pt. 2

Dropping Views

Understanding Constraints

Creating Constraints

Understanding Triggers

Trigger Options

Inserted and Deleted Tables

Creating Triggers

Basic Select Queries

+

The Basic Select Statement

Select Statement Structure

The FROM Clause

The WHERE Clause

WHERE Clause Example

The ORDER BY Clause

ORDER BY Example

The GROUP BY Clause pt. 1

The GROUP BY Clause pt. 2

The HAVING Clause

The Power of LIKE

More Advanced Select Statements

+

Using Distinct

Column Aliasing

Using the Top Option

Top Option Example

Using the OFFSET-FETCH Option

Understanding NULLs

Working with NULLs

Using the Case Statement

SELECT INTO

The UNION Statement

Using INTERSECT

Using EXCEPT

Understanding Synonyms

Creating and Using Synonyms

Using Concatenation

Dynamic Queries pt. 1

Dynamic Queries pt. 2

INSERT Into

SQL Server 2012 Data Types

+

Understanding GUIDs

NEWID() vs. NEWSEQUENTTIALID()

Using GUIDs

Data Type Basics

Numerical Data Types

Character Data Types

Date and Time Data Types

Binary Data Types

Using Joins

+

Understanding Joins

Table Aliasing

Inner Joins

Outer Joins

Cross Joins

The Merge Statement pt. 1

The Merge Statement pt. 2

Querying Metadata

+

Catalog Views

Information Schema Views

System Stored Procedures

Inserts / Updates / Deletes

+

The Basic INSERT Statement

INSERT Examples

The Basic UPDATE Statement

UPDATE Examples

The Basic DELETE Statement

DELETE Examples

Using @@ROWCOUNT

Subqueries

+

Scalar Subqueries

Multi-Valued Subqueries

Correlated Subqueries

Table Expressions

+

Understanding Temporary Results Sets

Understanding Derived Tables

Understanding Common Table Expressions

Using CTEs

Understanding Temporary Tables

Table Variables

Temporary Table or Table Variable?

Stored Procedures

+

Understanding Stored Procedures

Creating a Stored Procedure

Using Input Parameters

Stored Procedure Return Codes

Stored Procedure Permissions

Functions

+

Understanding Functions

Built-in Functions

Scalar Functions Example

Table Valued Functions Example pt. 1

Table Valued Functions Example pt. 2

Transactions

+

Understanding Concurrency

Understanding Transactions

Coding Explicit Transactions

Transactions and Locking

Conclusion

+
Resource Files

Course Wrap Up

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $49.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.