SQL Server 2014 – Database Design
Course content:
- Create databases and database files.
- Create data types and tables.
- Use XML-related features in Microsoft SQL Server 2014.
- Plan, create, and optimize indexes.
- Implement data integrity in Microsoft SQL Server 2014 databases by using constraints.
- Implement data integrity in Microsoft SQL Server 2014 databases by using triggers.
- Implement views.
- Implement stored procedures.
- Implement functions.
- Implement managed code in the database.
- Manage transactions and locks.
- Use Service Broker to build a messaging-based solution.
Want to take this class? Let us know by clicking here.