Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

(8 customer reviews)
Sale!

Leading the way

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

(8 customer reviews)

| Total Course Video Hours: 9 Hrs 46 Min
|  Videos: 59
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute
|  International Certification (optional): Microsoft 70-464 Developing Microsoft SQL Server 2012 Databases exam

Course Fee:

R1600,00

Current Special Ends in:

  • 00Days
  • 00Hours
  • 00Min
  • 00Sec

Overview

This course is in preparation for the Microsoft 70-464 Developing Microsoft SQL Server 2012 Databases exam. This course covers logical table design, indexing and query plans, and focuses on the creation of database objects including views and stored procedures, along with parameters and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. It will guide you through real world application of design concepts and tolls needed for successful SQL Server database development.
Candidates for the Microsoft 70-464 Developing SQL Server Databases (MCSE) exam are primarily database professionals who build and implement databases across organizations and who ensure high levels of data availability. They have experience performing tasks in creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks. This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Implement database objects (30-35%) Implement programming objects (15-20%) Design database objects (25-30%) Optimize and troubleshoot queries (25-30%)

Claim your FREE R500 Gift Voucher

FREE R500 gift voucher, especially for you 🎁

Join our mailing list and get your free exclusive R500 discount voucher.

This Voucher can be used for any of our Bundle Courses.

Curriculum

SQL 2012 And The 464 Test
1.1 Introduction
1.2 Intro To SQL Server 2012 Part 1
1.3 Intro To SQL Server 2012 Part 2
1.4 Management Studio Demo Part 1
1.5 Management Studio Demo Part 2
1.6 Management Studio Demo Part 3
1.7 Other SQL Server Tools

 

Working With Data Types
2.1 Working With Data Types Part 1
2.2 Working With Data Types Part 2
2.3 Working With Data Types Part 3
2.4 Other Data Types

 

Tables
3.1 Tables
3.2 Creating Tables

 

Data Constraints
4.1 Data Constraints Part 1
4.2 Data Constraints Part 2

 

Planning In Indexing
5.1 Planning In Indexing Part 1
5.2 Planning In Indexing Part 2
5.3 Planning In Indexing Part 3
5.4 Planning In Indexing Part 4

 

Table Structures
6.1 Table Structures
6.2 Working With Clustered Indexes
6.3 Clustered Indexes
6.4 Designing Effective Clustered Indexes

Improving Performance with NonClustered Indexes
7.1 Improving Performance With NonClustered Indexes Part 1
7.2 Improving Performance With NonClustered Indexes Part 2
7.3 Improving Performance With NonClustered Indexes Part 3

 

Using Indexes And Execution Plans
8.1 Using Indexes
8.2 Execution Plans Part 1
8.3 Execution Plans Demo
8.4 Execution Plans Part 2

 

Working with Views
9.1 Working With Views Part 1
9.2 Working With Views Part 2

 

Designing and Implementing Stored Procedures
10.1 Designing And Implementing Stored Procedures Part 1
10.2 Designing And Implementing Stored Procedures Part 2
10.3 Designing And Implementing Stored Procedures Part 3

 

Merging Data and Passing Tables
11.1 Merging Data And Passing Tables Part 1
11.2 Merging Data And Passing Tables Part 2
11.3 Merging Data And Passing Tables Part 3

 

Designing and Implementing User Functions
12.1 Designing And Implementing User Functions

 

Creating Highly Concurrent SQL Server Applications
13.1 Creating Highly Concurrent SQL Server Applications
Part 1
13.2 Creating Highly Concurrent SQL Server Applications
Part 2
13.3 Creating Highly Concurrent SQL Server Applications
Part 3

 

Handling Errors in TSQL
14.1 Handling Error In TSQL Part 1
14.2 Handling Error In TSQL Part 2

 

Triggers
15.1 Triggers

 

Implementing Managed Code
16.1 Implementing Managed Code Part 1
16.2 Implementing Managed Code Part 2
16.3 Implementing Managed Code Part 3

 

Storing XML in SQL
17.1 Storing XML In SQL Part 1
17.2 Storing XML In SQL Part 2
17.3 Storing XML In SQL Part 3

 

Querying XML
18.1 Querying XML Part 1
18.2 Querying XML Part 2
18.3 Querying XML Part 3

 

Working with the Spatial Data
19.1 Working With Spatial Data Part 1
19.2 Working With Spatial Data Part 2
19.3 Working With Spatial Data Part 3

 

Working With FullText Indexes and Queries
20.1 Working With Full Text Indexes And Queries Part 1
20.2 Working With Full Text Indexes And Queries Part 2
20.3 Working With Full Text Indexes And Queries Part 3
20.4 Outro

8 reviews for Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

  1. Michael

    Best college in SA

  2. Nala

    Thank you for an awesome learning experience

  3. Jelani

    The course’s step-by-step approach made complex topics manageable and easy to follow.

  4. Dalia

    I’m so grateful for this course. Thank you, for helping me achieve my goals!

  5. Zimkhitha

    The course was flexible, allowing me to access the materials anytime and from any device.

  6. Ife

    I got my dream job thanks to you

  7. Aziza

    The instructor’s clear and concise explanations made complex topics easy to understand.

  8. Dalia

    The course was worth every penny. It delivered on its promises and provided immense value.

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.