Course Overview
“Developing SQL 2016 Databases,” equips professionals with the necessary skills to create Microsoft SQL Server 2016 databases. It targets individuals responsible for designing and implementing databases, including database administrators, application developers, and IT professionals. This comprehensive course covers a wide range of topics, including database design, normalization, data modeling, database objects, and query optimization. Key features of SQL Server 2016, such as temporal tables, row-level security, and JSON support, are also explored.
Participants can learn to use SQL Server Management Studio and Transact-SQL (T-SQL) for effective database management and solution implementation. By the end of the course, learners will possess the ability to design and implement SQL Server 2016 databases, including managing database objects, optimizing queries, and implementing security and data integrity measures. They will also gain valuable insights into industry best practices, which can contribute to their professional growth in database administration and development.
Learning Options
Schedule Dates
Curriculum
-
Module 1: An 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
- Lesson 1: Introduction to XML and XML Schemas
- Lesson 2: Storing XML Data and Schemas in SQL Server
- Lesson 3: Implementing the XML Data Type
- Lesson 4: Using the Transact-SQL FOR XML Statement
- Lesson 5: Getting Started with XQuery
- Lesson 6: Shredding XML
- Lab: Storing and Querying XML Data in SQL Server
-
Module 15: Storing and Querying Spatial Data in SQL Server
-
Module 16: Storing and Querying BLOBs and Text Documents in SQL Server
-
Module 17: SQL Server Concurrency
-
Module 18: Performance and Monitoring
Database Administrator
Database Developer
Data Analyst
Business Intelligence Developer
Organizations that hire professionals with SQL Server certifications include technology companies, consulting firms, healthcare organizations, financial institutions, and government agencies.