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

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

  • Essential Online Course - Computer Hacking Forensic Investigator (CHFI)

    Essential Online Course - 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...

  • Configuring Advanced Windows Server 2012 Services (70-412)

    Configuring Advanced Windows Server 2012 Services (70-412)

    SGD $40.00

    Course Description

    Microsoft's server operating systems have powered business for over 20 years. In the beginning, it was all about connectivity in the local area network, now it's all about connectivity in the cloud. Microsoft calls Server 2012 ’The Cloud OS’ and is branding it as being ’built from the cloud up.’ Their goal with this product is to deliver the power of many servers with the simplicity of one. Achieving a Microsoft Certification on this product is an excellent career move. In this VTC course, Mark Long brings 20+ years of experience with Microsoft technologies along to help you understand the features and functionalities of Windows Server 2012 from the standpoint of preparing for certification exam 70-412 Configuring Advanced Windows Server 2012 Services. 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...


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.