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 - Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

    Certification at Your Fingertips - Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

    SGD $299.00

    Course Description

    This course prepares students for the Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012 exam. The course teaches students how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. The course describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. 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...

  • Oracle database 11G OCA 1Z0-051 and 1Z0-052: Installation and Administration

    Oracle database 11G OCA 1Z0-051 and 1Z0-052: Installation and Administration

    SGD $299.00

    Course Description

    The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise in the industry's most advanced database management system, Oracle 11g. Oracle 11g training course will teach students how to install and maintain an Oracle database, how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. After completing Oracle OCA 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Oracle databases are the one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification! 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 the theory aspects of the examination

    Read more...

  • Cisco 640-864: CCDA Cisco Certified Design Associate

    Cisco 640-864: CCDA Cisco Certified Design Associate

    SGD $299.00

    Course Description

    This exam requires a foundation or apprentice knowledge of network design for the Cisco converged networks based on borderless network architecture. CCDA certified professionals can design routed and switched network infrastructures and services involving LAN, WAN, wireless, and broadband access for businesses and organizations.   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...


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.