{"id":3421,"date":"2017-01-09T09:58:43","date_gmt":"2017-01-09T09:58:43","guid":{"rendered":"http:\/\/fusionsol.wp.knows.live\/?page_id=3421"},"modified":"2025-04-11T08:50:00","modified_gmt":"2025-04-11T01:50:00","slug":"od20762-developing-sql-databases","status":"publish","type":"page","link":"https:\/\/www.fusionsol.com\/en\/od20762-developing-sql-databases\/","title":{"rendered":"OD20762: Developing SQL Databases"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><div class=\"vc_row wpb_row vc_row-fluid dt-default\" style=\"margin-top: 0px;margin-bottom: 0px\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h2 lang=\"en\"><span class=\"course-detail-id\">Course OD20762A:<\/span>Developing SQL Databases<\/h2>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid dt-default\" style=\"margin-top: 0px;margin-bottom: 0px\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_tour wpb_content_element  tab-style-one\" data-interval=\"0\">\n\t\t<div class=\"wpb_wrapper wpb_tour_tabs_wrapper ui-tabs vc_clearfix\">\n\t\t\t<ul class=\"wpb_tabs_nav ui-tabs-nav vc_clearfix text-big\"><li><a href=\"#tab-8dd578e1-a42e-1\">Choose how you want to learn: online or in a classroom<\/a><\/li><li><a href=\"#tab-3a58faf0-f326-8\">About this course<\/a><\/li><li><a href=\"#tab-1483952452641-2-10\">Overview<\/a><\/li><li><a href=\"#tab-1483952471897-3-3\">Course details<\/a><\/li><li><a href=\"#tab-1483952507646-4-7\">Prerequisites<\/a><\/li><li><a href=\"#tab-1483952524804-5-6\">Community Share this page Facebook Twitter LinkedIn Email<\/a><\/li><\/ul>\n\t<div id=\"tab-8dd578e1-a42e-1\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<table class=\"course-moc-on-demand\">\n<thead>\n<tr>\n<th style=\"text-align: left;\" scope=\"col\">Compare learning environments<\/th>\n<th scope=\"col\">\n<p style=\"text-align: center;\"><strong>On-demand training<\/strong><\/p>\n<p style=\"text-align: center;\">Learn more<\/p>\n<\/th>\n<td style=\"text-align: center;\"><\/td>\n<th scope=\"col\">\n<p style=\"text-align: center;\"><strong>Classroom training<\/strong><\/p>\n<p style=\"text-align: center;\"><a class=\"mscom-link\" href=\"https:\/\/www.microsoft.com\/en-us\/learning\/partners.aspx\">Learn more<\/a><\/p>\n<\/th>\n<\/tr>\n<\/thead>\n<tfoot>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Find a Microsoft Learning Partner<\/th>\n<td style=\"text-align: center;\">Find an on-demand training partner<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td style=\"text-align: center;\"><a class=\"mscom-link msl-button msl-button-blue\" href=\"https:\/\/www.microsoft.com\/en-us\/learning\/find-partner.aspx\">Find a classroom training partner<\/a><\/td>\n<\/tr>\n<\/tfoot>\n<tbody>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Anytime access<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Anywhere access to recorded instructor<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Microsoft official training content<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">In-depth training<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Hands-on labs<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">SATV redemption<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Ask instructor questions in person<\/th>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Attend live class in person<\/th>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Attend live class remotely<\/th>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Time commitment<\/th>\n<td style=\"text-align: center;\">Self-paced<br \/>\n(3 month access)<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td style=\"text-align: center;\">5 days<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-3a58faf0-f326-8\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<table>\n<tbody>\n<tr>\n<td>Audience(s):<\/td>\n<td>IT Professionals<\/td>\n<\/tr>\n<tr>\n<td>Technology:<\/td>\n<td>Microsoft SQL Server<\/td>\n<\/tr>\n<tr>\n<td>Level:<\/td>\n<td>300<\/td>\n<\/tr>\n<tr>\n<td>This Revision:<\/td>\n<td>A<\/td>\n<\/tr>\n<tr>\n<td>\n<div>Delivery method:<\/div>\n<\/td>\n<td lang=\"en\">Classroom<\/td>\n<\/tr>\n<tr>\n<td>Length:<\/td>\n<td>2 days<\/td>\n<\/tr>\n<tr>\n<td>Language(s):<\/td>\n<td>English<\/td>\n<\/tr>\n<tr>\n<td>First published:<\/td>\n<td>18 August 2016<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952452641-2-10\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p><b>About this course<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.<\/span><\/p>\n<p><b>Audience profile<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.<\/span><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.<\/span><\/p>\n<p><b>At course completion<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this course, students will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design and Implement Tables.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe advanced table designs<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Ensure Data Integrity through Constraints<\/span><span style=\"font-style: inherit; font-weight: inherit;\">.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe indexes, including Optimized and Columnstore indexes<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design and Implement Views.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design and Implement Stored Procedures.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design and Implement User Defined Functions.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Respond to data manipulation using triggers.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design and Implement In-Memory Tables.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement Managed Code in SQL Server.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Store and Query XML Data.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Work with Spatial Data.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Store and Query Blobs and Text Documents.<\/span><\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952471897-3-3\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<table>\n<tbody style=\"font-style: inherit; font-weight: inherit;\">\n<tr style=\"font-style: inherit; font-weight: inherit;\">\n<td style=\"font-style: inherit;\"><b><span style=\"font-style: inherit;\">Course Outline<\/span><\/b><b><span style=\"font-style: inherit;\">Module 1: Introduction to Database Development<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module is used to introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Introduction to the SQL Server Platform<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">SQL Server Database Development Tasks<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : SQL Server Database Development Tasks<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the SQL Server platform.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Use SQL Server administration tools.<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 2: Designing and Implementing Tables<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This modules describes the design and implementation of tables. (Note: partitioned tables are not covered).<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Designing Tables<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Data Types<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Working with Schemas<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Creating and Altering Tables<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Designing and Implementing Tables<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design Tables<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the various types of data<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Be able to work with schemas<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Be able to create and amend tables<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 3: Advanced Table Designs<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes more advanced table designs.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Partitioning data<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Compressing Data<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Temporal Tables<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Using Advanced Table Designs<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe how data can be partitioned<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe how data can be compressed.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe Temporal tables<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 4: Ensuring Data Integrity through Constraints<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes the design and implementation of constraints.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Enforcing data Integrity<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementing Domain Integrity<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementing Entity and Referential Integrity<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Ensuring Data Integrity through Constraints<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe how to enforce data integrity<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe how to implement domain integrity<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe how to implement entity and referential integrity<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 5: Introduction to Indexes<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes the concept of an index and discusses selectivity, density and statistics. It covers appropriate data type choices and choices around composite index structures.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Core Indexing Concepts<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Data Types and Indexes<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Single Column and Composite Indexes<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Implementing Indexes<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Explain the need for indexes and describe the core concepts of index design<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Choose appropriate data types for indexes<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design single column and composite indexes<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 6: Designing Optimized Index Strategies<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module includes covering indexes and the INCLUDE clause, hints, padding \/ fillfactor, statistics. It also execution plans and the DTE Lessons.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Covering Indexes<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Managing Indexes<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Execution Plans<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Using the DTE<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Designing Optimized Index Strategies<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Choose an appropriate table structure<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement clustered indexes and heaps<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 7: Columnstore Indexes<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module introduces Columnstore indexes.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Introduction to Columnstore indexes<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Creating Columnstore indexes<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Working Columnstore indexes<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Using Columnstore indexes<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe suitable scenarios for Columnstore indexes<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Create clustered and non-clustered Columnstore indexes<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe considerations for updating non-clustered Columnstore indexed tables<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 8: Designing and Implementing Views<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes the design and implementation of views.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Introduction to views<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Creating and managing views<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Performance considerations for views<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Designing and Implementing Views<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Explain the concept of views<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design, Create and Alter Views<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Create Partitioned Views<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 9: Designing and Implementing Stored Procedures<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes the design and implementation of stored procedures.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Introduction to Stored Procedures<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Working with Stored Procedures<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementing Parameterized Stored Procedures<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Controlling Execution Context<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Designing and Implementing Stored Procedures<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design, Create and Alter Stored Procedures<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Control the Execution Context of Stored Procedures<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement Stored Procedures that use Parameters<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 10: Designing and Implementing User-Defined Functions<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes the design and implementation of functions, both scalar and table-valued. (Also discusses where they can lead to performance issues).<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Overview of Functions<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Designing and Implementing Scalar Functions<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Designing and Implementing Table-Valued Functions<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementation Considerations for Functions<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Alternatives to Functions<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Designing and Implementing User-defined Functions<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design, create and alter scalar functions<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design, create and alter table-valued functions<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the performance impacts of functions<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 11: Responding to Data Manipulation via Triggers<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes the design and implementation of triggers.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Designing DML Triggers<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementing DML Triggers<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Advanced Trigger Concepts<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Responding to Data Manipulation via Triggers<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Design DML triggers<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement DML triggers<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Work with Nested and Recursive Triggers<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 12: Using In-Memory Tables<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module covers the creation of in-memory tables and native stored procedures. Furthermore, advantages of in-memory tables are discussed, for example the removal of transaction blocking.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">In-Memory tables<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Native Stored Procedures<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : In Memory OLTP<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">\u00a0Implement in-memory tables<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement native stored procedures<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 13: Implementing Managed Code in SQL Server<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes the implementation of and target use-cases for SQL CLR integration.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Introduction to SQL CLR Integration<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Importing and Configuring Assemblies<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementing SQL CLR Integration<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Implementing Managed Code in SQL Server<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe SQL CLR Integration<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Detail appropriate use cases for SQL CLR Integration<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement SQL CLR code<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 14: Storing and Querying XML Data in SQL Server<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module covers the XML data type, schema collections, typed and un-typed columns and appropriate use cases for XML in SQL Server.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Introduction to XML and XML Schemas<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Storing XML Data and Schemas in SQL Server<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementing the XML Data Type<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Using the T-SQL FOR XML Statement<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Getting Started with xQuery<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Storing and Querying XML Data in SQL Server<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Explain the purpose and structure of XML and XML schemas<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe how XML data and schemas can be stored in SQL Server<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement the XML data type<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 15: Working with SQL Server Spatial Data<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module describes spatial data and how this data can be implemented within SQL Server.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Introduction to Spatial Data<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Working with SQL Server Spatial Data Types<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Using Spatial Data in Applications<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Working with SQL Server Spatial Data<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe how spatial data can be stored in SQL Server<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Use basic methods of the GEOMETRY and GEOGRAPHY data types<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Query databases containing spatial data<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Module 16: Storing and Querying Blobs and Text Documents in SQL Server<\/span><\/b><span style=\"font-style: inherit; font-weight: inherit;\">This module covers full text indexes and queries.<\/span><b><span style=\"font-style: inherit;\">Lessons<\/span><\/b><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Considerations for BLOB Data<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Working with FileStream<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Using Full-Text Search<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-style: inherit;\">Lab : Storing and Querying Blobs and Text Documents in SQL Server<\/span><\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the need for full-text indexing in SQL Server<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement a full-text index<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Perform basic full-text queries<\/span><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952507646-4-7\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li>Basic knowledge of the Microsoft Windows operating system and its core functionality.<\/li>\n<li>Working knowledge of Transact-SQL.<\/li>\n<li>Working knowledge of relational databases.<\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952524804-5-6\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li>Looking for training resources, events and advice from peers? Join the <a href=\"http:\/\/borntolearn.mslearn.net\/\">Microsoft Training and Certification Community<\/a>.Preparing for an exam now? Find your <a href=\"http:\/\/borntolearn.mslearn.net\/certification\/\">Microsoft Certification Study Group<\/a>.\n<p>Talk to us on these social networks:<\/p>\n<ul>\n<li>Facebook<\/li>\n<li>Twitter<\/li>\n<li><a href=\"http:\/\/www.linkedin.com\/groups\/Microsoft-Learning-3183354\">LinkedIn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n<div class=\"wpb_tour_next_prev_nav vc_clearfix\"> <span class=\"wpb_prev_slide\"><a href=\"#prev\" title=\"Previous tab\">Previous tab<\/a><\/span> <span class=\"wpb_next_slide\"><a href=\"#next\" title=\"Next tab\">Next tab<\/a><\/span><\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Course OD20762A:Developing SQL Databases Choose how you want to learn: online or in a classroomAbout this courseOverviewCourse detailsPrerequisitesCommunity Share this page Facebook Twitter LinkedIn Email Compare learning environments On-demand training Learn more Classroom training Learn more Find a Microsoft Learning Partner Find an on-demand training partner Find a classroom training partner Anytime access Yes No&hellip;<\/p>","protected":false},"author":5,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3421","page","type-page","status-publish","hentry","description-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fusion Solution Co.,Ltd. \u2013 ARTICLE<\/title>\n<meta name=\"description\" content=\"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fusionsol.com\/en\/od20762-developing-sql-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fusion Solution Co.,Ltd. \u2013 ARTICLE\" \/>\n<meta property=\"og:description\" content=\"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fusionsol.com\/en\/od20762-developing-sql-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Fusion Solution\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/fusion.solution\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-11T01:50:00+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/\",\"url\":\"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/\",\"name\":\"Fusion Solution Co.,Ltd. \u2013 ARTICLE\",\"isPartOf\":{\"@id\":\"https:\/\/www.fusionsol.com\/#website\"},\"datePublished\":\"2017-01-09T09:58:43+00:00\",\"dateModified\":\"2025-04-11T01:50:00+00:00\",\"description\":\"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fusionsol.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OD20762: Developing SQL Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fusionsol.com\/#website\",\"url\":\"https:\/\/www.fusionsol.com\/\",\"name\":\"Fusion Solution\",\"description\":\"Business Innovation Provider\",\"publisher\":{\"@id\":\"https:\/\/www.fusionsol.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fusionsol.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.fusionsol.com\/#organization\",\"name\":\"Fusion Solution\",\"url\":\"https:\/\/www.fusionsol.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fusionsol.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.fusionsol.com\/wp-content\/uploads\/sites\/2\/2020\/04\/FusionLogo.png\",\"contentUrl\":\"https:\/\/www.fusionsol.com\/wp-content\/uploads\/sites\/2\/2020\/04\/FusionLogo.png\",\"width\":249,\"height\":249,\"caption\":\"Fusion Solution\"},\"image\":{\"@id\":\"https:\/\/www.fusionsol.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/fusion.solution\/\",\"https:\/\/www.youtube.com\/channel\/UCYhatfvclBLCGPdNCyX7EZg\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fusion Solution Co.,Ltd. \u2013 ARTICLE","description":"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fusionsol.com\/en\/od20762-developing-sql-databases\/","og_locale":"en_US","og_type":"article","og_title":"Fusion Solution Co.,Ltd. \u2013 ARTICLE","og_description":"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.","og_url":"https:\/\/www.fusionsol.com\/en\/od20762-developing-sql-databases\/","og_site_name":"Fusion Solution","article_publisher":"https:\/\/www.facebook.com\/fusion.solution\/","article_modified_time":"2025-04-11T01:50:00+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/","url":"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/","name":"Fusion Solution Co.,Ltd. \u2013 ARTICLE","isPartOf":{"@id":"https:\/\/www.fusionsol.com\/#website"},"datePublished":"2017-01-09T09:58:43+00:00","dateModified":"2025-04-11T01:50:00+00:00","description":"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.","breadcrumb":{"@id":"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fusionsol.com\/od20762-developing-sql-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fusionsol.com\/"},{"@type":"ListItem","position":2,"name":"OD20762: Developing SQL Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.fusionsol.com\/#website","url":"https:\/\/www.fusionsol.com\/","name":"Fusion Solution","description":"Business Innovation Provider","publisher":{"@id":"https:\/\/www.fusionsol.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fusionsol.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fusionsol.com\/#organization","name":"Fusion Solution","url":"https:\/\/www.fusionsol.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fusionsol.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.fusionsol.com\/wp-content\/uploads\/sites\/2\/2020\/04\/FusionLogo.png","contentUrl":"https:\/\/www.fusionsol.com\/wp-content\/uploads\/sites\/2\/2020\/04\/FusionLogo.png","width":249,"height":249,"caption":"Fusion Solution"},"image":{"@id":"https:\/\/www.fusionsol.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/fusion.solution\/","https:\/\/www.youtube.com\/channel\/UCYhatfvclBLCGPdNCyX7EZg"]}]}},"_links":{"self":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages\/3421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/comments?post=3421"}],"version-history":[{"count":5,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages\/3421\/revisions"}],"predecessor-version":[{"id":32383,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages\/3421\/revisions\/32383"}],"wp:attachment":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/media?parent=3421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}