CBT Nuggets Microsoft MCSE SQL Server 2014 70-464

http://bit.ly/22a5WDI

CBT Nuggets Microsoft MCSE SQL Server 2014 70-464

Developing SQL Server 2014 Databases

This Microsoft SQL Server training course with Garth Schulte covers the latest version of developing against Microsoft’s SQL Server database server, including how to design, implement, optimize, and troubleshoot SQL Server 2014 database and programming objects.

Recommended skills:

2+ years of experience working with SQL Server

Familiarity with writing T-SQL statements

MCSA: SQL Server 2012

Recommended equipment:

Microsoft SQL Server 2014

Related certifications:

MCSE: SQL Server 2014 Data Platform

Related job functions:

Database designers

Database developers

Database administrators

Database wizardry

70-464 is the first exam for the SQL Server MCSE: Data Platform certification. This SQL server training will help you prepare for the 70-464 exam and beyond by covering Microsoft's exam objectives. You'll also get up to speed on the latest features in SQL Server 2014.

The 70-464 exam and this course covers the following general topic areas: Implementing database objects; implementing programming objects; designing database objects; and optimizing and troubleshooting queries. Let's BEGIN!

CBT Nuggets Microsoft MCSE SQL Server 2014 70-464 Free Download Links

Uploaded Download Links

Get Premium Uploaded Account: Max Speed & Resumable Support Download :

cnmcsesqls2014-70464.part1.rar
cnmcsesqls2014-70464.part2.rar
cnmcsesqls2014-70464.part3.rar

FileFactory Download Links

For Full Speed Download Buy FileFactory Premium Account:

FileFactory Links Not Yet Found

1. Introduction to 70-464: Developing SQL Server 2014 Databases (16 min)

Welcome to 70-464! This Nugget will introduce you to SQL Server 2014 and the 70-464 exam. We'll cover the most talked about SQL 2014 features, run through the editions and components, cover the exam audience and exam objectives, as well as the MCSE: Data Platform requirements. We'll also get familiar with the virtual NuggetLab configuration used for demonstration purposes throughout the course. Let's rock SQL 2014 and 70-464 together!

2. Tables (16 min)

In this Nugget, we'll cover basic database and table design concepts. We'll start with normalization and denormalization, as well as the three major normal forms. We'll also compare the differences between these design patterns by looking at a real-world example. We'll cover the basics of primary keys and foreign keys, and get an introduction to the many table types supported in SQL Server 2014, such as disk-based tables, memory-optimized tables, temporary tables, and system tables. It's all about tables!

3. Demo: Working with Tables (16 min)

This demonstration Nugget is all about designing, creating, and working with tables! We'll cover table design and creation, computed columns, temporary objects, and show you how to encrypt a columns worth of data using symmetric key encryption.

4. Data Types (14 min)

This Nugget will cover common objectives for working with tables and data types. We'll start by defining what data types are and take a brief tour of the many data types supported in SQL Server 2014. We'll also talk about using Globally Unique Identifiers (GUIDs), implicit and explicit conversions, column collation, and sparse columns.

5. Demo: Working with Data Types (16 min)

This demonstration Nugget will show you how to work with data types. We'll cover where to find system, alias, and CLR data types in object explorer, implicit and explicit conversions, column collation, and the effects random and sequential GUIDs have as a clustered index.

6. Data Integrity (10 min)

This Nugget will define what data integrity is all about. We'll start with the big picture, and cover data integrity implementation at the many levels of an application architecture. We'll also look at the levels data integrity can be applied within a database, such as domain, entity, and referential integrity, as well as cover the objects used to enforce data integrity at each level.

7. Demo: Domain Data Integrity (18 min)

This demonstration Nugget will cover how to implement and enforce data integrity at the domain level. We'll cover all of the constraint objects we can developer against, such as NULL, DEFAULT, and CHECK, as well as using UDFs and triggers for enforcing domain-level data integrity!

8. Demo: Entity and Referential Data Integrity (13 min)

This demonstration Nugget will cover entity and referential data integrity. We'll see how to use primary and unique key constraints to enforce entity-level data integrity, and foreign key constraints to enforce referential-level data integrity. By the end of this Nugget, our data will be completely free of inconsistencies!

9. Security (13 min)

This Nugget will cover the core security layers and concepts in SQL Server 2014. We'll talk about Server-, Database-, and Object-level security, drill into principals, securables, permissions and scope, as well as schemas and ownership chaining. We'll also see where to download some incredibly useful SQL Server 2014 security posters!

10. Demo: Implementing Security (28 min)

This demonstration Nugget covers a lot of security goodness! We'll see how to work with server logins, database logins, roles, permissions, securables, schemas, ownership chaining, and even how to identify and fix orphaned users.

11. Indexes (23 min)

This Nugget will cover the concepts of indexing. We'll talk about the need for indexes, their internal b-tree structure, and how they are organized as heaps, clustered, or nonclustered indexes. We'll also talk about index fragmentation and optimization, as well as the many index types available in SQL Server 2014.

12. Demo: Working with Indexes (29 min)

This demonstration Nugget will cover how to create and work with all of the standard and special index structures available in SQL Server 2014. We'll see how to work with clustered-, nonclustered-, columnstore-, spatial-, and Full-text indexes. We'll also cover statistics and why they are super important to ensure the query optimizer makes the right decisions on how to execute our queries.

13. Demo: Maintaining Indexes (28 min)

This demonstration Nugget will cover how to identify missing and unused indexes, optimize indexes and statistics through rebuilding and reorganizing, and the many ways we can define and automate a maintenance strategy. We'll also look at a great real-world strategy for handling index maintenance!

14. Views (10 min)

This Nugget will cover views, from the basics and benefits of views, to the specific types of views supported in SQL Server 2014. We'll cover indexed view design, as well as partitioned view design, and their purposes.

15. Demo: Working with Views (10 min)

We'll cover how to work with views in this demonstration Nugget! We'll see how to create and query a standard view, indexed view, and partitioned view, as well as the restrictions and requirements of each view.

16. Stored Procedures (13 min)

This Nugget will cover the ins and outs of stored procedures! We'll start with a primer to show where Sprocs fit in the big picture, as well as in the data access layer. We'll also talk about design strategies and discuss topics such as execution context, parameter sniffing, and best practices.

17. Demo: Working with Stored Procedures (26 min)

This demonstration Nugget will go over how to create and work with stored procedures. We'll cover basic and advanced design, see the effects parameter sniffing has on our stored procedure plans, and how to fix it using the many levels of recompilation. We'll also see how to build a data access layer out of stored procedures, and how to work with pagination using OFFSET and FETCH.

18. User-defined Functions (12 min)

This Nugget will cover designing and creating user-defined functions. We'll see where this programmable object fits in the big picture, how they differ from stored procedures, as well as the benefits and types available. We'll also cover design aspects such as determinism, the structure of both Scalar- and Table-valued UDFs, and best practices around designing and using them.

19. Demo: Working with User-defined Functions (19 min)

This demonstration Nugget will show you how to create and work with user-defined functions. We'll start with Scalar UDFs and finish with a look at both types of table-valued UDFs: Inline and Multistatement.

20. In-Memory Features (10 min)

This Nugget will go over the hot new in-memory features in SQL Server 2014! We'll cover and configure the Buffer Pool Extension (BPE), and talk about the new in-memory OLTP feature consisting of memory-optimized tables and natively compiled stored procedures.

21. Demo: In-Memory OLTP (21 min)

This Nugget will show you how to create and work with SQL Server's new in-memory structures. We'll cover how to create memory-optimized tables and natively compiled stored procedures from scratch, use the AMR tools to identify, report, and migrate existing disk-based structures to memory-based structures. Then we'll run through a fun comparison test to see the incredible performance of in-memory OLTP!

22. Data Files (13 min)

This Nugget will go over our options for BLOB storage. We'll cover the pros and cons to storing unstrucutred data in SQL Server, and cover the FILESTREAM and FileTable features. We'll also cover the basics and benefits of table partitioning.

23. Demo: BLOB Storage (12 min)

This demonstration Nugget will walk you through enabling, configuring, and working with both the FILESTREAM and FileTable features to enable BLOB storage within SQL Server.

24. Demo: Table Partitioning (15 min)

This demonstration Nugget will cover how to set up, configure and create partitioned tables! We'll cover file and filegroup configuration, partition functions, partition schemes, and see the management benefits of partition switching, as well as the performance benefits of partition elimination.

25. XML Data (16 min)

This Nugget will cover the many ways we'll be working with XML data in SQL Server. We'll talk about storing, querying, importing, and exporting XML, as well as topics that include the XML data type, XSD schemas, XQuery, and XPath.

26. Demo: Working with XML Data (24 min)

This demonstration Nugget will show you how to perform common tasks against XML data in SQL Server. We'll cover how to create and work with schemas, store typed and untyped XML, query XML, shred XML into relational data, and export relational data as XML.

27. Query Tuning (21 min)

This Nugget will cover the process, tools, and techniques for query optimization in SQL Server. We'll talk about how to identify poor performing queries, tools such as execution plans for identifying the cause of poor performing queries, and back doors such as plan guides and query hints for forcing optimizations. We'll also cover best practices for improving query performance.

28. Demo: Query Tuning (24 min)

This demonstration Nugget will show you how to identify and tune expensive queries. We'll look at all the tools of the query optimization trade, such as reports, execution plans, and plan guides. We'll see how to tune a query from the top down and even through the back door!

29. Concurrency (21 min)

This Nugget will take you through the many concepts of concurrency and concurrent database design. We'll cover the pessimistic and optimistic concurrency models, transactions, isolation levels and locking modes, and what it all means.

30. Demo: Concurrency (23 min)

This demonstration Nugget will walk through the many tools you'll use when designing and working with concurrency in a database. We'll cover the major concurrency topics such as transactions, isolation levels, and their effect against concurrency anomalies, as well as blocks and deadlocks, and the tools used for monitoring and troubleshooting them.

31. Automation (12 min)

This Nugget gets you excited and ready to automate those repetitive tasks. We'll cover why automation is important, common automation tasks at the server and database level, automation tools such as PowerShell and SSIS, and we'll even challenge you with an automation project. Don't forget, automate everything!

32. Demo: Automation (18 min)

This demonstration Nugget will walk through a possible solution for automating our SSIS database refresh challenge from the previous Nugget. We'll also look at using SSIS, PowerShell, and SQL Server Agent for automating processes, and even use the Windows Azure BLOB storage service as a staging area for backups with T-SQL, PowerShell, and SSIS!

33. Managed Code (10 min)

This Nugget will define what managed code and CLR integration in SQL Server is all about. We'll discuss the .NET framework, the CLR, assemblies, and the reasons why extending our database objects to managed code can provide great benefits to the database. We'll also cover the process for building, registering, and utilizing an assembly from SQL Server.

34. Demo: Working with Managed Code (18 min)

In this demonstration Nugget, we'll see how to work with managed code in SQL Server. We'll look at the process for coding up an assembly, enabling CLR integration, and registering it with SQL Server. We'll code up a CLR stored procedure, CLR user-defined function, CLR data type, and see how to work with them from a SQL Server database!

35. Monitoring and Troubleshooting (12 min)

This Nugget will cover the areas that most often cause bottlenecks in SQL Server and the methods for planning and troubleshooting those areas. We'll also get familiar with the process for creating a performance baseline, common metrics to create your baselines from, the tools we use monitoring and troubleshooting, and how to control resources using the resource governor.

36. Demo: Monitoring and Troubleshooting (16 min)

This demonstration Nugget will show you how to use many of the common tools for monitoring and troubleshooting SQL Server performance issues. We'll cover performance monitor, data collection, extended events, and how to control resources at the workload level using the resource governor!

If this post was usefull for you, let us know in comments…

The post CBT Nuggets Microsoft MCSE SQL Server 2014 70-464 appeared first on Download all for Free.

Downloads - Téléchargements