70-465: Designing Solutions for SQL Server

70-465: Designing Solutions for SQL Server

PS You can change currency to see the price in your country at the top of the screen, just below the search box

This 2KO Africa is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around designing database solutions for Microsoft SQL Server 2012. These courses are also available as instructor led courses in Cape Town.

This course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to designing:

The 2KO Africa course on designing database solutions for Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-465.

This course will provide all the skills and knowledge for the following areas:

  • Creating and altering tables (complex statements)
  • Designing, implementing, and troubleshooting security
  • Designing the locking granularity level
  • Maintaining indexes
  • Implementing data types
  • Creating and modifying constraints (complex statements)
  • Working with XML Data
  • Writing automation scripts
  • Designing and implementing stored procedures
  • Designing T-SQL table-valued and scalar functions
  • Creating, using, and altering user-defined functions (UDFs)
  • Creating and altering views (complex statements)
  • Designing tables
  • Designing for concurrency
  • Creating and altering indexes
  • Designing data integrity
  • Designing for implicit and explicit transactions
  • Optimizing and tuning queries
  • Troubleshooting and resolving performance problems
  • Optimizing indexing strategies
  • Capturing and analyzing execution plans
  • Collecting performance and system information

Microsoft 70-465: Developing Microsoft SQL Server 2012 Databases

1 - Introduction to Enterprise Data Architecture

  • Considerations for Enterprise Data
  • Assessing an Existing Infrastructure

2 - Multi-Server Configuration Management

  • Policy-Based Management
  • Microsoft System Center

3 - Consolidating Database Workloads with SQL Server 2014

  • Considerations for Database Server Consolidation
  • Managing Resources in a Consolidated Database Infrastructure

4 - Introduction to Cloud Data Solutions

  • Overview of Cloud Computing
  • SQL Server in a Private Cloud

5 - Introduction to Microsoft Azure

  • Microsoft Azure Overview
  • Microsoft Azure Storage

6 - Microsoft Azure SQL Database

  • Introduction to Microsoft Azure SQL Database
  • Microsoft Azure SQL Database Security
  • Implementing and Managing Databases

7 - SQL Server in Microsoft Azure Virtual Machines

  • Introduction to Microsoft Azure Virtual Machines
  • Microsoft Azure Virtual Machine Connectivity and Security
  • Creating Databases in a Microsoft Azure Virtual Machine

8 - Introduction to High Availability in SQL Server 2014

  • High Availability Concepts and Options in SQL Server 2014
  • Log Shipping

9 - Clustering with Windows Server and SQL Server 2014

  • Introduction to Windows Server Failover Clustering
  • SQL Server AlwaysOn Failover Cluster Instances

10 - AlwaysOn Availability Groups

  • Introduction to AlwaysOn Availability Groups
  • Working with AlwaysOn Availability Groups
  • Considerations for Using AlwaysOn Availability Groups

11 - Planning High Availability and Disaster Recovery

  • High Availability and Disaster Recovery with SQL Server 2014
  • High Availability and Disaster Recovery for Databases in Microsoft Azure

12 - Replicating Data

  • SQL Server Replication
  • Planning Replication

Write a review

Please login or register to review

  • Views: 4301
  • Brand: Microsoft
  • Product Code: MS70-465
  • Availability: 99
0 Product(s) Sold
  • R1,495.00

Tags: 70-465, designing solutions for microsoft sql server, sql server design, online sql course 70-465: databases