SQL Server Database & Survey Design

- Creating relational data structures: tables, data types, clustered and non-clustered indexes - Transact SQL/T-SQL - CONSTRAINTS and TRIGGERS; Instead of triggers - Stored procedures, scalar and table valued functions - Normalization of data sets: foreign key relationships, avoiding redundant data - Data manipulation: INSERT, UPDATE, SELECT INTO, MERGE - Data query: SELECT, Joining Tables, JOIN, APPLY, Grouping Sets, Aggregation, Windowing Functions, Common Table Expressions (CTE) - Authorize users: GRANT, REVOKE - Using temporary tables - Use of FILESTREAM data, FileTables - Optimization with columnstore indexes and InMemory OLAP - Use of XML in SQL Server, OPENXML, FOR XML, data type XML and XML indexing - SQL extensions