1st Step to Certification: Designing Database Solutions for Microsoft SQL Server 2012 (70-465)


  • 1st Step to Certification: Designing Database Solutions for Microsoft SQL Server 2012 (70-465), Singapore SKillsFuture elarning online course
  • 1st Step to Certification: Designing Database Solutions for Microsoft SQL Server 2012 (70-465), Singapore SKillsFuture elarning online course
  • 1st Step to Certification: Designing Database Solutions for Microsoft SQL Server 2012 (70-465), Singapore SKillsFuture elarning online course
  • 1st Step to Certification: Designing Database Solutions for Microsoft SQL Server 2012 (70-465), Singapore SKillsFuture elarning online course
  • 1st Step to Certification: Designing Database Solutions for Microsoft SQL Server 2012 (70-465), Singapore SKillsFuture elarning online course
  • 1st Step to Certification: Designing Database Solutions for Microsoft SQL Server 2012 (70-465), Singapore SKillsFuture elarning online course

Course Description

Microsoft's Designing Database Solutions for Microsoft SQL Server 2012 70-465 certification exam is intended for database professionals who design and build database solutions in the organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs. The exam is part of Microsoft's MCSE: Data Platform certification track. In this VTC course, author Mark Long walks you through the technologies, terms, and functionalities you need to know to prepare for the 70-465 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


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 design Database Structure
5. Understand the Database Object Design
6. Be able to Design Tables and apply Indexes  
7. Know how to apply Programming Objects
8. Understand Database Server Maintenance
9. Be able to monitor Performance 
10. Understand about Backup and Recovery 


Related Courses

  • Network+ Certification Prep

    Network+ Certification Prep

    SGD $299.00

    Course Description

    The Network+ Certification Prep Course readies students for CompTIA's Network+ Certification exam which is a vendor-neutral certification allowing IT professionals to gain expertise in configuring, managing, installing, troubleshooting and maintaining basic computer networks. With top experts and an interactive, lab-filled environment, students gather essential knowledge of network configuration, technologies and installations as well as topologies and media security and management. The Network+ certification by CompTIA is an internationally recognized and coveted credential providing proof of a student's knowledge, skills and ability to manage, maintain, troubleshoot, install, operate and configure a basic network infrastructure. This course prepares the student for the CompTIA Network+ Certification exam N10-006.

    Read more...

  • Certification at Your Fingertips - CompTIA SY0-401 or JK0-018: Security+

    Certification at Your Fingertips - CompTIA SY0-401 or JK0-018: Security+

    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: The Security+ course covers the most important foundational principles for securing a network and managing risk. Access control, identity management and cryptography are important topics on the exam, as well as selection of appropriate mitigation and deterrent techniques to address network attacks and vulnerabilities. Security concerns associated with cloud computing, BYOD and SCADA are addressed in the SY0-401 certification exam. 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...

  • Security+ Certification Prep

    Security+ Certification Prep

    SGD $299.00

    Course Description

    Security+ Certification Prep The Security+ Certification Prep Course readies students for CompTIA's S+ certification exam which is globally recognized for validating foundational, vendor-neutral IT security knowledge and skills. With top experts and an interactive, lab-filled enviornment, students gain essential knowledge of the principals for network security and risk management with competency in organizational security, system security, access control and network infrastructure. The S+ certification by CompTIA is an internationally recognized credential ensuring ground-level security proficiency as well as skills for organization and security professionals to provide information, infrastructure, application and operational security. This course prepares the student for the CompTIA S+ Certification Exam SYO-401.

    Read more...


Content

Welcome

Preview Available

+

Introduction

Course Overview

Understanding SQL

Understanding TSQL

SQL Server History

SQL Server Certifications

The 70-465 Exam

SQL Server 2012 Essentials

+

SQL Server 2012 Editions

Hardware Requirements

Software Requirements

Installing SQL Server 2012

+

Getting a Copy of SQL Server 2012

Understanding Instances

Installing SQL Server 2012 pt. 1

Installing SQL Server 2012 pt. 2

SQL Books Online Goes Online

Downloading Books Online

SSMS Tour

Designing Database Structure

+

Determining Business Requirements

Database Types

The Relational Model

Normalization Basics

Basic Architectural Decisions

Understanding File Groups

Understanding Partitioning

Authentication Modes

Windows Authentication

SQL Server Authentication

The SA Account

Database Object Design

+

Logical Database Design

Physical Design Implications

Understanding Collation

Linked Servers

Understanding NULLs

ANSI NULLs

Handling Database Growth

Linked Servers or Openrowset

CPU Affinity

Memory Allocation

Managing SQL Server Memory

Designing Tables

+

Table Basics

Temp Tables

Table Variables

Common Table Expressions

Transaction Basics

Explicit & Implicit Transactions

Transaction Impact on Performance

Planning with Concurrency in Mind

Locking Basics

Lock Types & Escalation

Schema Basics

Creating Schemas

Indexing

+

Understanding Indexes

Understanding Data Distribution

Clustered Indexes

Non-Clustered Indexes

Indexing Best Practices

Reorganizing & Rebuilding Indexes

Which Should I Use?

Understanding Index Fragmentation

Understanding Index Internals pt. 1

Understanding Index Internals pt. 2

Understanding Fillfactor

Programming Objects

+

Stored Procedure Basics

Advantages of Stored Procedures

Stored Procedure Best Practices

Understanding Views

Understanding Indexed Views

Database Server Maintenance

+

SQL Server Agent

Understanding Jobs

Understanding Alerts

Understanding Operators

Understanding Schedules

Creating a Job

Database Maintenance Plans

Creating a Maintenance Plan

Maintenance Plan Design Surface

Multiserver Administration

Ensuring Good Database Health

DMVs

SQL Server 2012 DMVs

Getting to Know Your DMVs

Monitoring Performance

+

Performance Monitoring Basics

Performance Monitor

Counters To Watch

Monitoring Locks

SQL Server Profiler pt. 1

SQL Server Profiler pt. 2

Designing Backup & Recovery

+

Backup & Recovery Planning

Transaction Log Basics

Understanding Recovery Models

Setting the Recovery Model

Understanding Database Snapshots

Using Database Snapshots

High Availability Options

Conclusion

+
Resource Files

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.