LIVE Webinar -Developing SQL Databases -
von PROTRANET GmbH
After completing this course, students will be able to:- Design and Implement Tables.- Describe advanced table designs- Ensure Data Integrity through Constraints.- Describe indexes, including Optimized and Columnstore indexes- Design and Implement Views.- Design and Implement Stored Procedures.- Design and Implement User Defined Functions.- Respond to data manipulation using triggers.- Design and Implement In-Memory Tables.- Implement Managed Code in SQL Server.- Store and Query XML Data.- Work with Spatial Data.- Store and Query Blobs and Text Documents.
- Introduction to Database Development- Designing and Implementing Tables- Advanced Table Designs- Ensuring Data Integrity through Constraints- Introduction to Indexes- Designing Optimized Index Strategies- Columnstore Indexes- Designing and Implementing Views- Designing and Implementing Stored Procedures- Designing and Implementing User-Defined Functions- Responding to Data Manipulation via Triggers- Using In-Memory Tables- Implementing Managed Code in SQL Server- Storing and Querying XML Data in SQL Server- Storing and Querying Spatial Data in SQL Server- Storing and Querying BLOBs and Text Documents in SQL Server- SQL Server Concurrency- Performance and Monitoring
The primary audience for this course is IT Professionalswho want to become skilled on SQL Server 2016 product features andtechnologies for implementing a database.
The secondary audiences for this course are individuals who aredevelopers from other product platforms looking to become skilled in theimplementation of a SQL Server 2016 database.
Termine und Orte