NIIT Training.com

Developing SQL Databases

Become and SQL Server 2016 Specialist. Design and Implement Tables and Data Integrity through Constraints. Be able to describe indexes and implement Views. Design and Implement Stored Procedures. Acquire knowledge to design and implement User Defined Functions. And respond to data manipulation using triggers. Get complete knowledge to design and implement In-Memory Tables. Learn to implement, store and query XML Data. Get to work with spatial data and query blobs and text documents.

  • On demand online self-paced Instructor-led classes by Industry Experts
  • Design, implement and store data in SQL Server 2016.
  • Guidance to Practice, Study and Gain confidence to clear the Microsoft SharePoint Server 2013 Certification Exam
  • Call Me

    Self-Paced

    batch loading...

    Course Features

    Related Courses

    About Developing SQL Databases

    This 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.

    Course Objectives
    • Design and Implement Tables.
    • Describe advanced table designs
    • Ensure Data Integrity through Constraints.
    • Describe 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.
    Curriculum
    Module 1:

    Introduction to Database Development

    Module 2:

    Designing and Implementing Tables

    Module 3:

    Advanced Table Designs

    Module 4:

    Ensuring Data Integrity through Constraints

    Module 5:

    Introduction to Indexes

    Module 6:

    Designing Optimized Index Strategies

    Module 7:

    Columnstore Indexes

    Module 8:

    Designing and Implementing Views

    Module 9:

    Designing and Implementing Stored Procedures

    Module 10:

    Designing and Implementing User-Defined Functions

    Module 11:

    Responding to Data Manipulation via Triggers

    Module 12:

    Using In-Memory Tables

    Module 13:

    Implementing Managed Code in SQL Server

    Module 14:

    Storing and Querying XML Data in SQL Server

    Module 15:

    Storing and Querying Spatial Data in SQL Server

    Module 16:

    Storing and Querying BLOBs and Text Documents in SQL Server

    Module 17:

    SQL Server Concurrency

    Module 18:

    Performance and Monitoring

    Instructor

    All Microsoft On-demand content is designed and created by Microsoft Certified Trainers and Microsoft Subject Matter Experts. The trainers teaching the content in videos are the officials who have been working on the same technology that is being taught in the course.

    Certification

    After completing the course sucessfully you will be able to download and save the certificate or print it.

    Pre-requisites

    Before attending this course, students must have:

    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Working knowledge of Transact-SQL.
    • Working knowledge of relational databases.
    FAQs

    Why should I choose MOC on-demand?

    To ensure that learners have the adequate skills to use Microsoft technologies MOC on-demand Courses have been introduced by Microsoft. These courses have been made available to serve the needs of learners who prefer to study at their own pace, at their convinient time and from their preferred location globally.

    What do MOC On-demand courses include?

    • MOC On-demand Courses are organised in Modules which include:
    • Demos: A video walk-through of a process or task discussed in that lesson.
    • Practices: A self-paced practice where they can apply what was covered in the lesson, with supporting prompts to guide them as needed.
    • Labs: These detailed exercises use practice files and offer a more hands-on experience with the lesson material. Note: Not all courses include labs.
    • Knowledge Checks: A brief quiz testing what was learned in the lesson.
    • Assessments: To test knowledge attained from the course.

    How do I get the product?

    After purchasing a MOC on-demand course on training.com, you will receive a mail with an access code, link to the Microsoft training site and detailed instructions to login, redeem the Access Code and start with your course.

    What is important for students to know before redeeming a voucher code?

    • You need to create a Microsoft account if you have not already, for example, Live.com, Hotmail.com and Outlook.com.
    • An access code can only be redeemed once.
    • A code must be redeemed by the expiration date provided by their Microsoft Learning Partner.
    • Once activated, course materials are available for a period of 90 days
    • All the details are included in the Microsoft Official Course On-Demand Terms and Conditions: http://go.microsoft.com.

    Who should join this course?

    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.

    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.

    How are the MOC courses structured?

    Microsoft official courses on-demand are arranged in modules that include few minutes videos. At the end of each module one or two questions will be posed to test your comprehension. There will be an assessment of at least 25 questions at the end of the course.

    How long does a MOC on-demand course generally take to complete?

    It requires approximately 30 to 45 hours to complete a course.

    What are the course packages available to purchase?

    There are 2 sets of courses - Basic Set and Package Set

    Basic Set:
    • 90-day access to the official Microsoft On-Demand Training Videos
    • 90-day access to Live Microsoft Labs Online (MLO) for hands-on practice
    • 90-day access to Course Exercises
    • Reading and Knowledge checks throughout the course
    • Package Set:
    • Basic Set features
    • Digital edition of the Microsoft Official Curriculum (dMOC) kit for reference.

    Course Features

    batch loading...

    Related Courses

    AI and Deep Learning with TensorFlow
    AWS Certification and Training Program
    Active Directory® Services with Windows Server®
    Administering Microsoft Exchange Server 2016
    Administering Microsoft® SQL Server® 2014 Databases
    Administering System Center Configuration Manager and Intune
    Administering Windows Server® 2012
    Administering the Web Server IIS Role of Windows Server
    Administration Essentials for New Admins- Salesforce
    Advanced Automated Administration with Windows PowerShell®
    Advanced Data Mining projects with R
    Advanced Pay Per Click
    Advanced Program in Data Sciences
    Advanced Social Media Marketing
    Advanced Solutions of Microsoft Exchange Server 2013
    Advanced Solutions of Microsoft® SharePoint® Server 2013
    Analyzing Data with Power BI
    Analyzing and Visualizing Data with Excel
    Analyzing and Visualizing Data with Power BI
    Android Game Development for Beginners
    Angular 5
    Application Development with Swift 2
    Automated UI Testing in Java
    Automating Administration with Windows PowerShell®
    Big Data Analytics with R
    Big Data Applications using Hadoop
    Building Android Games with OpenGL ES
    Building Applications with Ext JS
    Building Applications with Force.com
    Building a Data Mart with Pentaho Data Integration
    Building iOS 10 Applications with Swift
    Builiding web application with spring MVC
    Business Analytics using R from KPMG
    Business Analytics using R from KPMG – Advanced
    Business Analytics using R from KPMG – Expert
    Certified Digital Marketing Professional
    Cloud and Datacenter Monitoring with System Center Operations Manager
    Complete Web and Social Media Analytics
    Configuring Advanced Windows Server® 2012 Services
    Core Solutions of Microsoft® Exchange Server 2013
    Core Solutions of Microsoft® SharePoint® Server 2013
    Core Solutions of Skype for Business 2015
    Data Quality 9.x: Developer, Level 1
    Data Science Orientation
    Data Science with R
    Data Science with Spark
    Deploying Windows Desktops and Enterprise Applications
    Designing and Deploying Microsoft Exchange Server 2016
    Designing and Implementing a Server Infrastructure
    DevOps Certification Training
    Developing Microsoft Azure Solutions
    Developing Microsoft SharePoint® Server 2013
    Developing Microsoft SharePoint® Server 2013 Core Solutions
    Developing SQL Databases
    Enabling and Managing Microsoft Office 365
    Executive Program in Applied Finance
    Executive Program in Digital and Social Media Marketing Strategy
    Fundamentals of a Windows Server® Infrastructure
    GNIIT Foundation
    Getting Started with R for Data Science
    Getting started with Apache Solr Search Server
    IBM Cognos Connection and Workspace Advanced
    IT Service Management with System Center Service Manager
    Implementing Microsoft Azure Infrastructure Solutions
    Implementing Microsoft Azure Solutions-70-533
    Implementing a Data Warehouse with Microsoft® SQL Server® 2014
    Informatica PowerCenter 9.x Level 1
    Installing and Configuring Windows 10
    Installing and Configuring Windows Server® 2012
    Introducing Rails 5 Learning Web Development the Ruby Way
    Introduction to ITIL
    Introduction to SQL Databases
    Introduction to Web Development with Microsoft Visual Studio 2010
    Java Enterprise Apps with DevOps
    Joomla Certification Training Program
    Julia for Data Science
    Learning Android N Application Development
    Learning Data Mining with R
    Learning Joomla 3 Extension Development
    Learning MongoDB
    Learning R for Data Visualization
    Learning Spring Boot
    Learning Swift 2
    Linux shell scripting solution
    Machine Learning with Python
    Marketing Analytics Data Tools and Techniques
    Mastering Magento
    Open Source Web App Development using MEAN Stack
    PMI® Agile Certified Practitioner Training
    Pentaho Reporting
    Performance Tuning and Optimizing SQL Databases
    Planning and Deploying System Center 2012 Configuration Manager
    Post Graduate Certificate in General Management (PGCGM)
    Programming Using Python
    Programming in C Sharp
    Programming in HTML5 with JavaScript and CSS3
    Programming with Python for Data Sciences.
    Project Management Professional (PMP®) Training
    Querying Data with Transact SQL
    Querying Microsoft SQL Server® 2014
    R Data Mining Projects
    R for Data Science Solutions
    Reactive Java 9
    SAS Certification Training Program
    Secrets of Viral Video Marketing
    Selenium with Java
    Six Sigma Certification Training Program
    Spring Security
    Supply Chain Management(SCM) Training Program
    Supporting and Troubleshooting Windows 10
    Teradata Certification Training
    Test Driven Android
    UNIX Shell Scripting Training
    Upgrading Your Skills to MCSA Windows Server 2016
    Upgrading Your Skills to MCSA Windows Server® 2012
    Web Apps Development using Node.js along with Express.js and MongoDB
    Web Apps Development with HTML5, CSS3, jQuery & Bootstrap
    Web Development with Node.JS and MongoDB
    iOS App Development Certification Training
    jquery UI Development