GK4400A Developing SQL Databases (20762_C)

0% of 42 hours and 13 minutes completed.

This course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

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 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 14 minutes 29 Activities: Article  (0)  |  Lab  (6)  |  Video  (23)
0%
Ensuring Data Integrity Through Constraints
2 hours 10 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Introduction to Indexes
2 hours 31 minutes 31 Activities: Article  (0)  |  Lab  (6)  |  Video  (25)
0%
Designing Optimized Index Strategies
2 hours 39 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 34 minutes 30 Activities: Article  (0)  |  Lab  (6)  |  Video  (24)
0%
Designing and Implementing User-Defined Functions
2 hours 5 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
2 hours 13 minutes 21 Activities: Article  (0)  |  Lab  (6)  |  Video  (15)
0%
Implementing Managed Code in SQL Server
2 hours 17 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 36 minutes 29 Activities: Article  (0)  |  Lab  (6)  |  Video  (23)
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 25 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)