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

  • Certification at Your Fingertips - Cisco 200-355: CCNA Wireless Network Fundamental WIFUND

    Certification at Your Fingertips - Cisco 200-355: CCNA Wireless Network Fundamental WIFUND

    SGD $299.00

    Course Description

    This Cisco 200-355 training course will provide students with knowledge of Radio Frequency (RF) and 802.11 technology essentials along with installing, configuring, monitoring and basic troubleshooting tasks needed to support Small Medium Business and Enterprise wireless networks. The Cisco 200-355 is the base level certification for those who would like to prove their wireless networking knowledge using Cisco Systems® or related equipment.  Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand theory aspects of the examination

    Read more...

  • Cisco ICND2 (640-816)

    Cisco ICND2 (640-816)

    SGD $49.00

    Course Description

    The Cisco 640-816 exam is the follow-up exam to ICND1 (640-822). Passing this exam in conjunction with the ICND1 exam will earn you the CCNA (Cisco Certified Network Associate) certification, which is Cisco's enterprise network technician certification. In this VTC course, author Greg Dickinson will guide you through the requirements for the ICND2 exam. After following along with him, you should be prepared to pass the 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.

    Read more...

  • Certification at Your Fingertips - Microsoft 70-646 Pro: Windows Server 2008, Server Administrator

    Certification at Your Fingertips - Microsoft 70-646 Pro: Windows Server 2008, Server Administrator

    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 prepares students for the Microsoft 70-646 MCITP: Server Administrator certification exam. It is intended for IT Professionals who are interested in the knowledge and skills necessary to plan and implement a Windows Server 2008 and Windows Server 2008 R2 environment. This course incorporates both the planning of the server infrastructure and key aspects of the implementation, management and maintenance of Active Directory and Network Infrastructure. It covers the most important job tasks for Server Administrators who are responsible for the planning, operations, and day-to-day maintenance of Windows Server 2008 and Windows Server 2008 R2 servers in the enterprise.

    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.