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.