SQL 2014 Developer: VS 2012 and Data Types

The SQL 2014 Developer : VS 2012 and Data Types course is the second course in a three-course series on SQL 2014 Developer. This series of courses is a comprehensive series covering all the intermediate to advanced level topics of SQL Server 2014. The topics covered in part 2 of this series are related to Visual Studio 2012 and focuses on the data types available in SQL Server 2014. The course covers the related sub-topics in great detail and enables the students to implement the gained knowledge in their everyday tasks. This course explores the integration of Visual Studio Code and SQL Server to help developers writing queries efficiently. Developers can use a single query editor tool for writing codes in multiple languages. It eliminates the headache of using a separate editor for each language. It supports IntelliSense, SQL CMD mode, linting, Peek definition features to give you a better development experience.

The course begins by introducing you to Aggregates and User-defined Types. You will learn about the built-in aggregate functions provided in Transact-SQL that perform a calculation on a set of values and return a single value. The course also explores the different data tools in SQL as well as a show to connect and update a database. Using SSDT, you can create an offline database project and implement schema changes. You will learn how to add, modify, or delete the definitions of objects in your project without a connection to a server instance. You will also learn about the APPLY and MERGE statement in SQL. Without queries, retrieving specific data from a table will be in a timely manner will take a lot of time and headache. You will learn about how to create your own queries and use recursive queries. You will also learn about the two ways of executing SQL strings in TSQL.

One of the things that SQL Server excels at is given a database schema and established data usage patterns, finding the best way to execute your query. This course explores how SQL server executes these queries. An execution plan often requires multiple branches or subtrees to accomplish the work defined in a query. You will learn about the three basic join operators available for use in SQL. Hierarchyid datatype was introduced in SQL Server 2008. It is a variable-length system datatype. The datatype can be used to represent a given element’s position in a hierarchy – e.g. an employee’s position within an organization. You will learn about the syntax of the hierarchyid and its implementation in SQL. You will learn about the advantages of using filtered indexes and the scenarios you can use the filtered indexes. This course also gives you an understanding of Spatial Data and the rich set of features it provides