MICROSOFT EXAM 70-464 DEVELOPING MICROSOFT SQL SERVER 2012 DATABASES ONLINE TRAINING BY LEARN365

Provided by Learning 247

  • Sector IT
  • Course Type Online
  • Duration Part-time
  • Ref LE-MS70464
  • Price £150.00 use code Jobstoday10 to get 10% discount

Enquire about this course

About the course

This course is preparation for the 70-464 exam and introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, 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. 

COURSE OUTLINE„


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

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

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

CV Mistakes That Are Sabotaging Your Job Search

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.