1st step to certification: Microsoft SQL Server 2012 Development (70-464)


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

Course Description

Microsoft SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights and quickly build solutions to extend data across on-premises and public clouds, backed by mission critical confidence. The latest version not only includes many of the same capabilities and characteristics that administrators have come to trust for over 10 years but it also introduces some new features that change how databases make data available across the enterprise. It continues the evolution and maturity of a trusted platform that leads in industry-relevant and real-world application performance benchmarks. In this VTC course, author Mark Long will introduce you to SQL Server 2012 from a development viewpoint and will help you prepare for the Microsoft 70-464 Development Certification 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 the basics of SQL 
5. Understand how to work with Tables
6. Be able to apply Indexes 
7. Know how to work with Programming Objects 
8. Understand about Concurrency and Locking
9. Know about Optimization 
10 . Able to work with XML Data


Related Courses

  • 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...

  • Certification at Your Fingertips - Cisco 300-135: CCNP - TSHOOT - Troubleshooting and Maintaining Cisco IP Networks

    Certification at Your Fingertips - Cisco 300-135: CCNP - TSHOOT - Troubleshooting and Maintaining Cisco IP Networks

    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: Troubleshooting and Maintaining Cisco IP Networks (TSHOOT 300-135) is a qualifying exam for the Cisco CCNP Routing and Switching certification. The TSHOOT 300-135 exam certifies that the successful candidate has the knowledge and skills necessary to: Plan and perform regular maintenance on complex enterprise routed and switched networks, Use technology-based practices and a systematic ITIL-compliant approach to perform network troubleshooting.  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 This course is SkillsFuture Credit Eligible.

    Read more...

  • 1st Step to Wireless Hacking and Security

    1st Step to Wireless Hacking and Security

    SGD $49.00

    Course Description

    This VTC course delivers an in-depth look at wireless security, demonstrating how IEEE 802.11 wireless attacks are carried out and defended against. Veteran instructor Bobby Rogers first provides a foundation in wireless security technologies before he proceeds with practical demonstrations on securing both clients and network devices. He also demonstrates how to monitor wireless networks, capture wireless traffic, and even crack WEP and WPA keys.  Defend your desktop and other gadget from being compromised! - Know the different types of hacking  - Be able to identify the telltale signs of hacking  - Learn how to secure your network for safer surfing experience - Learn the different prevention measures of protecting yourself from being hacked  This course is eligible for SkillsFuture Credit and UTAP funding.

    Read more...


Content

Introduction

Preview Available

+

Welcome

Course Overview

Understanding SQL

Understanding TSQL

SQL Server History

Microsoft SQL Server Certifications

Programmability Enhancements for 2012

SQL Server 2012 Essentials

+

SQL Server 2012 Editions

Hardware Requirements

Software Requirements

Installing SQL Server

+

Getting Your Hands on SQL Server 2012

Installing SQL Server 2012

Validate a SQL Server Installation pt. 1

Validate a SQL Server Installation pt. 2

Uninstalling SQL Server 2012

SQL Books Online Goes Online

SQL Server Basics

+

SQL Server Instances

SQL Server Configuration Manager

SQL Server Management Studio

Understanding Databases

Table Basics

Understanding Primary Keys

Understanding Data Types

Understanding Normalization

Understanding Foreign Keys

Creating a Database

Database Types

Understanding Transaction Logs

Refreshing Intellisense

Understanding Schemas

Four Part Naming

Understanding Synonyms pt. 1

Understanding Synonyms pt. 2

Working with Tables

+

Attaching Adventureworks Sample DB

Database Diagrams

Working with Diagrams

Table Design Basics

Creating Tables Graphically

Creating Tables with TSQL

Altering Tables

Understanding Temporary Tables

Understanding Table Variables

Temp Table vs. Table Variable

GUIDs and SQL Server pt. 1

GUIDs and SQL Server pt. 2

NEWID() and NEWSEQUENTIALID()

Understanding Table Partitioning

Database Files

Understanding Filegroups

Working with BLOBs

FILESTREAM Basics

Using FILESTREAM

FileTable Basics

Understanding Constraints

Creating Constraints

Indexes

+

Index Basics

Clustered Indexes

Nonclustered Indexes

Pages and Extents

Understanding Fill Factor

Creating Indexes Graphically

Creating Indexes with TSQL

Optimizing Indexes

Reorganizing and Rebuilding Indexes

Checking Index Fragmentation

Programming Objects

+

Understanding Stored Procedures

Creating Stored Procedures

Using Parameters with SPs

Using Temp Tables with SPs

Types of Stored Procedures

Understanding Transactions

Explicit and Implicit Transactions

Using Explicit Transactions

Transactions and Locking

Creating Views

Partitioned Views

Common Partitioned View Usage

View Options

Understanding Functions

Scalar Function Example

Concurrency and Locking

+

Understanding Concurrency

Normalization and Concurrency

Transaction Isolation Levels

Monitoring and Managing Locking

Optimization

+

SQL Server Profiler

Creating a Trace pt. 1

Creating a Trace pt. 2

Querying a Trace Table

Database Engine Tuning Advisor

Query Execution Plans

Understanding Query Hints

Using System Views

Using Performance Monitor

Working with XML Data

+

XML Basics

Relational vs. XML Data

Retrieving XML from Relational Data

Conclusion

+

Course Wrap Up

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $45.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.