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 to certification: Designing and Developing ASP.NET 4 Web Apps (70-519)

    1st step to certification: Designing and Developing ASP.NET 4 Web Apps (70-519)

    SGD $49.00

    Course Description

    ASP.NET is a free web framework for building great Web sites and Web applications with HTML, CSS, and JavaScript using development tools like Visual Studio 2010 and Visual Web Developer. Since ASP first appeared in 1998 and then became ASP.NET in the early 2000s, it has become the web platform of choice for sites such as GoDaddy, NY Times, Reuters, Citibank, and thousands of others. Microsoft Certification Exam 70-519 tests a developer's knowledge of web application design and development using ASP.NET 4, the latest version in the evolution of ASP.NET. In this course, Mark Long introduces you to many of the new features of ASP.NET 4. He covers the basics of ASP.NET 4 and helps you prepare for this challenging 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 examinationsThis course is SkillsFuture Credit Eligible.

    Read more...

  • CompTIA Network+ N10-006 (2015 Objectives)

    CompTIA Network+ N10-006 (2015 Objectives)

    SGD $45.00

    Course Description

    The CompTIA Network+ N10-006 (2015 Objectives) certification is recognized internationally as validation of the technical knowledge required for foundation-level IT network technicians. Network+ certification exhibits third-party validation that the successful candidate has the knowledge and skills necessary to manage, maintain, troubleshoot, install, operate, and configure basic network infrastructure. In this course, Mark Long takes you step by step through the process and technologies you need to get ready to take this 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 examinationsThis course is SkillsFuture Credit Eligible.

    Read more...

  • Certification at Your Fingertips - Cisco 640-554: CCNA Security - Implementing Cisco IOS Network Security - IINS

    Certification at Your Fingertips - Cisco 640-554: CCNA Security - Implementing Cisco IOS Network Security - IINS

    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: Cisco Certified Network Associate Security (CCNA Security) validates associate-level knowledge and skills required to secure Cisco networks. With a CCNA Security certification, a network professional demonstrates the skills required to develop a security infrastructure, recognize threats and vulnerabilities to networks, and mitigate security threats. The CCNA Security curriculum emphasizes core security technologies; the installation, troubleshooting and monitoring of network devices to maintain integrity, confidentiality and availability of data and devices, and competency in the technologies that Cisco uses in its security structure.    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 both practical and theory aspects of the examination - Apply the practical skills through the Remote Practice Environment

    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.