SQL 2014 Developer P2: VS 2012 and Data Types

Category
Databases
Level
Beginner
Lessons
108
Duration
8h 26m 47s
Last Updated: 2018-08-16
Prior to taking this course it is recommended you take part 1 of this series: SQL 2014 Developer P1: T-SQL and .NET Code.

We will begin this course by discussing aggregates, user defined types (UDT), tables and functions (TVF), and managing code modules. We will then go into data tools, including connected database development and updates.

Next, we will cover schemas and offline development with how to create new objects with TSQL, comparing database schemas, offline database development, and database project settings.

We will then move onto APPLY, MERGE, and grouping settings with additional instruction on how to create recursive queries. This will lead into ROLLUP, CUBE, pivot queries, and executing dynamic SQL.

Query execution will be next with an overview on how to use execution plans, execution plan operators, and common join operators. Hierarchy and columns will be further developed with hierarchyID data type, sparse columns, and column sets.

Additionally, you will learn about filtered indexes, FILESTREAM storage, and adding sequences to queries. We will conclude with spatial data types, spatial data in SQL server, manipulating spatial shapes, and interactions between objects.

Once you complete this course it is recommended to take part 3: SQL 2014 Developer P3: Partitions, Queries and XML.
Category
Databases
Level
Beginner
Lessons
108
Duration
8h 26m 47s
SQL 2014 Developer P2: VS 2012 and Data Types - Module 01 - Aggregate, UDT, TVF and Modules
Topic A: Aggregates - Part 1
3 lessons26m 52sCompleted 0 / 3
Topic B: User Defined Types - Part 1
3 lessons16m 40sCompleted 0 / 3
Topic C: Table and Functions - Part 1
3 lessons10m 15sCompleted 0 / 3
SQL 2014 Developer P2: VS 2012 and Data Types - Module 02 - Data Tools
SQL 2014 Developer P2: VS 2012 and Data Types - Module 03 - Schemas and Offline Development
SQL 2014 Developer P2: VS 2012 and Data Types - Module 04 - APPLY, MERGE and Grouping Sets
SQL 2014 Developer P2: VS 2012 and Data Types - Module 05 - ROLLUP, CUBE and Pivot Queries
SQL 2014 Developer P2: VS 2012 and Data Types - Module 06 - Query Execution
SQL 2014 Developer P2: VS 2012 and Data Types - Module 07 - Hierarchy and Columns
SQL 2014 Developer P2: VS 2012 and Data Types - Module 08 - Filtered, Streams, Sequences
SQL 2014 Developer P2: VS 2012 and Data Types - Module 09 - Spatial Data Types
Don Kiely
I’m an instructor on many SQL Server and Visual Studio courses. I’m a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. With many years of teaching experience, I’m the author or co-author of several programming books, and have spoken at many industry conferences and user groups. In addition, I’m a consultant for a variety of companies that develop distributed applications for public and private organizations.
Don KielyInstructor and Curriculum Developer
Other Courses by Don Kiely