GK4400A Developing SQL Databases (20762_B)

0% of 40 hours and 41 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
42 minutes 14 Activities: Article  (0)  |  Lab  (5)  |  Video  (9)
0%
Designing and Implementing Tables
3 hours 3 minutes 38 Activities: Article  (0)  |  Lab  (6)  |  Video  (32)
0%
Advanced Table Designs
2 hours 10 minutes 28 Activities: Article  (0)  |  Lab  (6)  |  Video  (22)
0%
Ensuring Data Integrity Through Constraints
2 hours 10 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Introduction to Indexes
2 hours 30 minutes 31 Activities: Article  (0)  |  Lab  (6)  |  Video  (25)
0%
Designing Optimized Index Strategies
2 hours 40 minutes 31 Activities: Article  (0)  |  Lab  (6)  |  Video  (25)
0%
Columnstore Indexes
1 hour 37 minutes 19 Activities: Article  (0)  |  Lab  (6)  |  Video  (13)
0%
Designing and Implementing Views
2 hours 22 minutes 26 Activities: Article  (0)  |  Lab  (6)  |  Video  (20)
0%
Designing and Implementing Stored Procedures
2 hours 35 minutes 30 Activities: Article  (0)  |  Lab  (6)  |  Video  (24)
0%
Designing and Implementing User-Defined Functions
2 hours 4 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Responding to Data Manipulation Via Triggers
2 hours 16 minutes 27 Activities: Article  (0)  |  Lab  (6)  |  Video  (21)
0%
Using In-Memory Tables
1 hour 43 minutes 21 Activities: Article  (0)  |  Lab  (6)  |  Video  (15)
0%
Implementing Managed Code in SQL Server
1 hour 48 minutes 19 Activities: Article  (0)  |  Lab  (6)  |  Video  (13)
0%
Storing and Querying XML Data in SQL Server
3 hours 5 minutes 38 Activities: Article  (0)  |  Lab  (6)  |  Video  (32)
0%
Storing and Querying Spatial Data in SQL Server
2 hours 7 minutes 30 Activities: Article  (0)  |  Lab  (6)  |  Video  (24)
0%
Storing and Querying BLOBs and Text Documents in SQL Server
2 hours 20 minutes 26 Activities: Article  (0)  |  Lab  (6)  |  Video  (20)
0%
SQL Server Concurrency
2 hours 24 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Performance and Monitoring
2 hours 26 minutes 32 Activities: Article  (0)  |  Lab  (6)  |  Video  (26)
0%
Course Conclusion: GK4400A Developing SQL Databases
2 minutes 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
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)