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

  • 1st step towards certification: CISSP-ISSEP

    1st step towards certification: CISSP-ISSEP

    SGD $58.00

    Course Description

    In this VTC course, veteran instructor Bobby Rogers prepares you for the ISC2 Information System Security Engineering Professional (ISSEP) certification exam. Designed for persons already holding a current CISSP certification, the course will cover all 4 domains of the ISSEP Common Body of Knowledge (CBK): Information System Security Engineering, Certification and Accreditation, Technical Management, and US Government IA Publications. This course covers the new March 2012 objectives. 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 examinationsThis course is SkillsFuture Credit Eligible.

    Read more...

  • 1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)

    1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)

    SGD $45.00

    Course Description

    Business data analysis becomes more important as the amount of data involved in the analysis grows. This data is in various database management products, spreadsheets, and documents. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present. In this VTC course, author Mark Long walks you through the information you need to get prepared to take Microsoft's 70-463 certification exam: Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is part of Microsoft's MCSA: SQL Server Certification. 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...

  • Computer Hacking Forensic Investigator (CHFI)

    Computer Hacking Forensic Investigator (CHFI)

    SGD $299.00

    Course Description

    CHFI certifies individuals in the specific security discipline of computer forensics from a vendor-neutral perspective. The CHFI certification will fortify the application knowledge of law enforcement personnel, system administrators, security officers, defense and military personal, legal professionals, bankers, security professionals, and anyone who is concerned about the integrity of the network infrastructure. Be updated with the latest IT security! - Know the changes and updates in IT Security - Equip yourself with the right knowledge  - Defend your system and data from latest threats - Have the advantage of protecting your data

    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.