Topics

• Operators
• C# 6.0 Features
• Keywords
• Exceptions
• LINQ
• Using Statement
• LINQ Queries
• String.Format
• JSON Serialization
• List comprehensions
• Getting started with Microsoft SQL Server
• JOIN
• UPDATE
• Doctypes
• Join
• Dates
• Expression Trees
• Overflow
• ADO.NET
• Timers
• Index
• In-Memory OLTP (Hekaton)
• Temporal Tables
• Aggregate Functions

Examples

• Overloadable Operators
• Relational Operators
• Exception filters
• String interpolation
• stackalloc
• SelectMany (flat map)
• Cast
• Using Statement Basics
• Overloading equality operators
• Catching and rethrowing caught exceptions
• Multiple using statements with one block
• Self Join
• Modifying existing values
• Avoid repetitive and expensive operations using conditional clause
• INSERT / SELECT / UPDATE / DELETE: the basics of Data Manipulation Language
• PRINT
• HTML 4.01 Doctypes
• Inner Join
• Align left/ right, pad with spaces
• Currency Formatting
• Since C# 6.0
• DefaultIfEmpty
• Date & Time Formatting using FORMAT
• Simple Expression Tree Generated by the C# Compiler
• Serialization-Deserialization using Newtonsoft.Json
• Multithreaded Timers
• Integer overflow
• Best Practices - Executing Sql Statements
• Create Clustered index
• Create Non-Clustered index
• Declare Memory-Optimized Table Variables
• Index investigations
• Create function to calculate a person's age on a specific date
• FOR SYSTEM_TIME CONTAINED IN (<start_date_time> , <end_date_time>)
• FOR SYSTEM_TIME ALL
• Creating a Memory-Optimized System-Versioned Temporal Table and cleaning up the SQL Server history table
• Dynamic binding
• COUNT(Column_Name) with GROUP BY Column_Name