Developing SQL Databases
This five-day course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 features and tools related to database development .
COD: MOC 20762
Categorie: Microsoft
Teaching methodology
The course includes educational laboratories in which each student will be able to work in order to complete training exercises that will provide practical experience in using the instrument, for each of the topics covered during the course.
Who should participate
The primary target audience of this course is IT professionals who want to gain knowledge of SQL Server 2016 product features and technologies for implementing a database.
The secondary target audience for this course are developers of other product platforms seeking to become proficient in implementing a SQL Server 2016 database.
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its main features.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases
Outgoing knowledge/skills
This five-day course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 features and tools related to database development
Educational program
- 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 request XML data.
- Working with Spatial Data.
- Storing and querying blobs and text documents
Duration – 5 days
Delivery – in Classroom, On Site, Remote
PC and SW requirements:
- Internet connection
- Web browser, Google Chrome
- Zoom
Language
Instructor: English
Workshop: English
Slides: English
