GK4400A Developing SQL Databases (20762_A)

0% of 42 hours and 2 minutes completed.

In this course, you will learn the major tools of the SQL Server 2016 platform, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters and functions. You will also learn procedure coding, such as indexes, triggers, SQL Common Language Runtime (CLR), SQL Server spatial data, and considerations for binary large object (BLOB) data. This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20762: Developing SQL Databases.

After completing this course, you will be able to:

  • Design and implement tables
  • Advanced table designs.
  • Ensure data integrity through constraints.
  • 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.
There are no resources available.
0 attachments
0%
An Introduction to Database Development
41 minutes 16 Activities: Article  (0)  |  Lab  (8)  |  Video  (8)
0%
Designing and Implementing Tables
3 hours 10 minutes 41 Activities: Article  (0)  |  Lab  (9)  |  Video  (32)
0%
Advanced Table Designs
2 hours 13 minutes 31 Activities: Article  (0)  |  Lab  (9)  |  Video  (22)
0%
Ensuring Data Integrity through Constraints
2 hours 15 minutes 28 Activities: Article  (0)  |  Lab  (9)  |  Video  (19)
0%
Introduction to Indexes
2 hours 32 minutes 34 Activities: Article  (0)  |  Lab  (9)  |  Video  (25)
0%
Designing Optimized Index Strategies
3 hours 6 minutes 31 Activities: Article  (0)  |  Lab  (9)  |  Video  (22)
0%
Columnstore Indexes
2 hours 12 minutes 22 Activities: Article  (0)  |  Lab  (9)  |  Video  (13)
0%
Designing and Implementing Views
2 hours 55 minutes 29 Activities: Article  (0)  |  Lab  (9)  |  Video  (20)
0%
Designing and Implementing Stored Procedures
3 hours 1 minute 31 Activities: Article  (0)  |  Lab  (9)  |  Video  (22)
0%
Designing and Implementing User-Defined Functions
2 hours 40 minutes 28 Activities: Article  (0)  |  Lab  (9)  |  Video  (19)
0%
Responding to Data Manipulation via Triggers
2 hours 50 minutes 30 Activities: Article  (0)  |  Lab  (9)  |  Video  (21)
0%
Using In-Memory Tables
2 hours 15 minutes 22 Activities: Article  (0)  |  Lab  (9)  |  Video  (13)
0%
Implementing Managed Code in SQL Server
2 hours 21 minutes 22 Activities: Article  (0)  |  Lab  (9)  |  Video  (13)
0%
Storing and Querying XML Data in SQL Server
3 hours 43 minutes 42 Activities: Article  (0)  |  Lab  (9)  |  Video  (33)
0%
Storing and Querying Spatial Data in SQL Server
2 hours 39 minutes 33 Activities: Article  (0)  |  Lab  (9)  |  Video  (24)
0%
Storing and Querying BLOBs and Text Documents in SQL Server
2 hours 48 minutes 28 Activities: Article  (0)  |  Lab  (8)  |  Video  (20)
0%
Course Conclusion: GK4400A Developing SQL Databases
2 minutes 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
Knowledge Assessment: End of Course Questions
25 minutes 25 Activities: Article  (0)  |  Lab  (25)  |  Video  (0)
0%
Survey
5 minutes 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)