Querying Microsoft SQL Server 2014 (M20461)

SQL Server 2014, brings in the new era of Microsoft’s Cloud OS, which provides organizations and customers with one consistent platform spanning customer datacenters, hosting service provider datacenters, and the Microsoft public cloud. The benefits that customers get from such a platform are common development, management, data, identity, and virtualization, irrespective of where the application may be executing. SQL Server 2014 also protects, unlocks, and scales the organization’s data across all devices, the cloud and data centers. Furthermore, SQL Server 2014 makes a strong impact on organizations worldwide with its new capabilities for transforming the IT industry. SQL Server provides mission-critical performance for the most demanding database applications and also while delivers the highest forms of security, scalability, high availability, and support. SQL Server 2014 has also enabled new unique hybrid-cloud solutions based on the Cloud OS.

These solutions are able to affect an organization’s bottom line and create innovative solutions for its database applications. SQL Server 2014’s main mission is to deliver faster insights into data of all kinds be it small or big and, most importantly, deliver business intelligence in a consumable manner through familiar tools such as Microsoft Excel.

• Introducing Microsoft SQL Server 2014
  • SQL Server Architecture
  • SQL Server Editions and Versions
  • Introducing the SQL Server Management Studio
• Transact-SQL Querying
  • Learning to use the Transact-SQL
  • Using The SET Operators
  • Predicate Logic
  • Logical Order of Operations in SELECT Statements
• Learning to Write SELECT Queries
  • Writing Simple SELECT Statements
  • Using DISTINCT to Eliminate Duplicate Result Sets
  • Understand Column and Table Aliases
  • Writing and Understanding CASE Expressions
• Querying Multiple Tables
  • Joins and their types
  • Query with Inner Joins and Outer Joins
  • Differentiating between Cross Joins and Self Joins
• Sorting and Filtering Data
  • Sort Data
  • Filter Data with a WHERE Clause
  • Filter with the TOP and OFFSET-FETCH Options
  • Work with Unknown and Missing Values
• SQL Server 2014 Data Types
  • Data Types in SQL Server 2014 
  • Work with Character Data
  • Work with Date and Time Data
• Data Manipulation Language (DML) to Modify Data
  • Insert Data
  • Modify Data 
  • Delete Data
• Using Built-In Functions
  • Write Queries with Built-In Functions
  • Conversion Functions
  • Logical Functions
  • Handle NULL values using in-built functions.
• Grouping and Aggregating Data
  • Use Aggregate Functions
  • Use the GROUP BY Clause
  • Applying conditions on a Group with HAVING clause
• Sub-queries
  • Write Self-Contained Sub-queries
  • Write Correlated Subqueries
  • Use the EXISTS Predicate with Sub-queries
• Table Expressions
  • Use Derived Tables
  • Use Common Table Expressions
  • Use Views
  • Use Inline Table-Valued Functions
• Working with Set Operators
  • Write Queries with the UNION Operator
  • Use EXCEPT and INTERSECT
  • Use APPLY
• Window Ranking, Offset, and Aggregate Functions
  • Create Windows with OVER
  • Explore Window Functions including Ranking, Aggregate and Offset Functions
• Pivoting and Grouping Sets
  • Write Queries with PIVOT and UNPIVOT
  • Work with Grouping Sets
• Query Data with Stored Procedures
  • Understanding Stored Procedures
  • Query Data with Stored Procedures
  • Pass Parameters to Store Procedures
  • Create Simple Stored Procedures
  • Work with Dynamic SQL
• Implement Error Handling
  • Use TRY/CATCH Blocks
  • Work with Error Information
• Implement Transactions
  • Understanding Transactions
  • Transactions and the Database Engine
  • Control Transactions
  • Isolation Levels
• Improve Query Performance
  • Factors in Query Performance
  • Display Query Performance Data
• Query SQL Server Metadata
  • Query System Catalog Views and Functions
  • Execute System Stored Procedures
  • Query Dynamic Management Objects