Fast Track: MCSA SQL 2016 Database Development - Seminar / Kurs von PROTRANET GmbH

Dieser 5-tägige Power Workshop kombiniert die Inhalte aus den beiden Microsoft SQL 2016 Kursen Querying Data with Transact-SQL (MOC 20761) sowie Developing SQL Databases (MOC 20762) und bereitet die Teilnehmer optimal auf die Prüfung zum MCSA: SQL 2016 Database Development vor.

Querying Data with Transact-SQL (MOC 20761) - Module 1: Introduction to Microsoft SQL Server 2016 - Module 2: Introduction to T-SQL Querying - Module 3: Writing SELECT Queries - Module 4: Querying Multiple Tables - Module 5: Sorting and Filtering Data - Module 6: Working with SQL Server 2016 Data Types - Module 7: Using DML to Modify Data - Module 8: Using Built-In Functions - Module 9: Grouping and Aggregating Data - Module 10: Using Subqueries - Module 11: Using Set Operators Developing SQL Databases (MOC 20762) - Module 1: Introduction to Database Development - Module 2: Designing and Implementing Tables - Module 3: Advanced Table Designs - Module 4: Ensuring Data Integrity through Constraints - Module 5: Introduction to Indexes - Module 6: Designing Optimized Index Strategies - Module 7: Columnstore Indexes - Module 8: Designing and Implementing Views - Module 9: Designing and Implementing Stored Procedures - Module 10: Designing and Implementing User-Defined Functions - Module 11: Responding to Data Manipulation via Triggers - Module 12: Using In-Memory Tables - Module 13: Implementing Managed Code in SQL Server - Module 14: Storing and Querying XML Data in SQL Server - Module 15: Working with SQL Server Spatial Data - Module 16: Storing and Querying Blobs and Text Documents in SQL Server