Microsoft 70-464: Developing Microsoft SQL Server 2012
Original price was: £295.00.£99.00Current price is: £99.00.
Course Description
Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world.
Developing Microsoft SQL Server 2012 Databases training prepares Database developers to build their skills in developing and implementing databases, while ensuring high level of data availability. This course is in preparation for the 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.
Who is this course aimed at?
IT professionals with prior knowledge of writing T-SQL queries and basic database concepts.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.
What is included in this course?
When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:
Course Assessment Process
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!
Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.
Career Path
We’ve put together a list of relevant job titles you can apply for after achieving the Microsoft 70-464: Developing Microsoft SQL Server 2012 certification (note that some careers may require further study, training and/or work experience):
- Database Administrator
- Database Developer
- Database Analyst
Course Outline
Module 1: 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
Module 2: 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
Module 3: Tables
- 3.1 Tables
- 3.2 Creating Tables
Module 4: Data Constraints
- 4.1 Data Constraints Part 1
- 4.2 Data Constraints Part 2
Module 5: 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
Module 6: Table Structures
- 6.1 Table Structures
- 6.2 Working with Clustered Indexes
- 6.3 Clustered Indexes
- 6.4 Designing Effective Clustered Indexes
Module 7: Improving Performance with Non-Clustered Indexes
- 7.1 Improving Performance with Non-Clustered Indexes Part 1
- 7.2 Improving Performance with Non-Clustered Indexes Part 2
- 7.3 Improving Performance with Non-Clustered Indexes Part 3
Module 8: 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
Module 9: Working with Views
- 9.1 Working with Views Part 1
- 9.2 Working with Views Part 2
Module 10: 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
Module 11: 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
Module 12: Designing and Implementing User Functions
- 12.1 Designing and Implementing User Functions
Module 13: 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
Module 14: Handling Errors in TSQL
- 14.1 Handling Error in TSQL Part 1
- 14.2 Handling Error in TSQL Part 2
Module 15: Triggers
- 15.1 Triggers
Module 16: Implementing Managed Code
- 16.1 Implementing Managed Code Part 1
- 16.2 Implementing Managed Code Part 2
- 16.3 Implementing Managed Code Part 3
Module 17: 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
Module 18: Querying XML
- 18.1 Querying XML Part 1
- 18.2 Querying XML Part 2
- 18.3 Querying XML Part 3
Module 19: 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
Module 20: Working with Full Text 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
Payment Options
Pay securely online by debit or credit card or PayPal. Buying for your team? Talk to us about team training.
Student Reviews
There are no reviews for this course yet.
