Generic filters
Search in title

Developing Microsoft SQL Server Training

  • Training Duration:
  • 5 Days
  • Training Environment:
  • On-site at the Institution
  • In DVA Classrooms
  • Online
Download Training Document
Request Information!

About the Training

The Developing Microsoft SQL Server Introductory Training is a beginner-level course designed to teach software development skills on SQL Server. This training focuses on developing software with SQL Server and covers the fundamental topics related to SQL Server.

The training teaches the core features of SQL Server, including database development, performance optimization, security, and other key areas. Participants deepen their knowledge of SQL Server development through real-world examples and projects.

Additionally, the training covers the tools and technologies that can be used in the software development process with SQL Server. Participants learn how to manage essential features such as data processing, real-time analytics, database development, and security. They also gain an understanding of how to develop and manage software solutions using SQL Server.

The Developing Microsoft SQL Server Introductory Training covers all the fundamental aspects of SQL Server-based software development. Before starting to develop effective software solutions, participants acquire the essential skills they need.

The program begins with the basics of SQL Server development. Participants learn fundamental concepts such as database development, performance optimization, and security. They also gain insight into the role that SQL Server plays in developing and managing software solutions. These foundational concepts provide the building blocks participants will need in the software development process.

The training emphasizes the core features and components related to SQL Server. This equips participants with essential skills for real-time data processing, database development, and security. The course content covers key topics such as database development and data management.

Finally, the course provides knowledge on how to develop a software solution based on SQL Server. This process includes designing the solution, conducting tests, and ultimately developing the software solution on SQL Server. These skills help participants successfully develop software solutions using SQL Server.

What Will You Learn?

  • Basic knowledge and skills related to the Microsoft SQL Server database management system.
  • Writing SQL queries and optimizing database performance.
  • Designing database structures and storing, querying, and managing data.
  • Understanding and applying database security, backup, and recovery operations.
  • Familiarity with the features of the latest version of Microsoft SQL Server and recent technological developments.
  • Skills in developing database applications.
  • Opportunity to work on projects and reinforce theoretical knowledge with practical applications.
This training will enable participants to specialize in Microsoft SQL Server and use this software professionally.

Prerequisites

  • Basic Knowledge of Database Concepts and Terminology
  • Fundamental SQL Usage and Querying Skills
  • Basic Understanding of Operating Systems, Servers, and Database Structures
  • Basic Knowledge of a Programming Language (e.g., C++, Java, Python)
These prerequisites are not strictly mandatory and can be covered during the training. However, having these skills beforehand can shorten the training duration and provide a more efficient learning experience.

Who Should Attend?

 
  • Database Administrators and Analysts: Database administrators and analysts who want to gain knowledge about database management, performance optimization, security, and backup/recovery.
  • Database Developers: Database developers who want to gain knowledge about designing and developing database applications, writing SQL queries, and related topics.
  • IT Professionals: IT professionals who want to specialize in Microsoft SQL Server and gain knowledge about database management, performance optimization, security, and backup/recovery.
  • Application Developers Using Large Database Systems: Application developers who want to enhance their skills in using large database systems with Microsoft SQL Server.
This training can be beneficial for anyone working in or having a forward-looking interest in the database and IT fields.

Outline

Introduction to Database Development
  • This module introduces database development and the key tasks that a database developer would typically perform.
  • Lessons:
  • Introduction to the SQL Server Platform
  • SQL Server Database Development Tasks
  • Lab: Introduction to Database Development
Designing and Implementing Tables
  • This module explains how to design, create, and alter tables. It also focuses on working with schemas.
  • Lessons:
  • Designing Tables
  • Data Types
  • Working with Schemas
  • Creating and Altering Tables
  • Partitioning Data
  • Compressing Data
  • Lab: Designing and Implementing Tables
Ensuring Data Integrity through Constraints
  • This module explains how to enforce data integrity, and implement domain integrity to maintain high quality data. In addition, it focuses on implementing Entity and Referential Integrity.
  • Lessons:
  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity
  • Lab: Ensuring Data Integrity through Constraints
Introduction to Indexing
  • 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.
  • Lessons:
  • Core Indexing Concepts
  • Data Types and Indexes
  • Single Column and Composite Indexes
  • Lab: Implementing Indexes
Designing Optimised Index Strategies
  • This module explains covering indexes and the INCLUDE clause as well as the use of padding, hints, and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies.
  • Lessons:
  • Covering Indexes
  • Managing Indexes
  • Working with Execution Plans
  • Using the DTE
  • Lab: Designing Optimised Index Strategies
Columnstore Indexes
  • This module explains columnstore indexes and how to use them to maximise the performance and scalability of database applications.
  • Lessons:
  • Introduction to Columnstore indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes
  • Lab: Using Columnstore Indexes
Designing and Implementing Views
  • This module introduces Views, and explains how to create and manage Views. It also focuses on the performance consideration for Views.
  • Lessons:
  • Introduction to Views
  • Creating and Managing Views
  • Performance Considerations for Views
  • Lab: Designing and Implementing Views
Designing and Implementing Stored Procedures
  • This module describes the potential advantages of the use of stored procedures along with guidelines on creating them.
  • Lessons:
  • Introduction to Stored Procedures
  • Working with Stored Procedures
  • Implementing Parameterised Stored Procedures
  • Controlling Execution Context
  • Lab: Designing and Implementing Stored Procedures
Designing and Implementing User-Defined Functions
  • This module explains how to design and implement user-defined functions that enforce business rules or data consistency, and modify and maintain existing functions written by other developers.
  • Lessons:
  • Overview of Functions
  • Designing and Implementing Scalar Functions
  • Designing and Implementing Table-Valued Functions
  • Implementation Considerations for Functions
  • Alternatives to Functions
  • Lab: Designing and Implementing User-Defined Functions
Responding to Data Manipulation via Triggers
  • This module explains what DML triggers are and how they enforce data integrity. It also focuses on the different types of triggers available, and how to define triggers in a database.
  • Lessons:
  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts
  • Lab: Responding to Data Manipulation via Triggers
Using In-Memory Tables
  • This module covers the creation of in-memory tables and native stored procedures and discusses the advantages and disadvantages of using in-memory tables.
  • Lessons:
  • In-Memory Tables
  • Native Stored Procedures
  • Lab: In-Memory OLTP
Implementing Managed Code in SQL Server 2014
  • This module explains how to use CLR integrated code to create user-defined database objects that are managed by the .NET Framework.
  • Lessons:
  • Introduction to SQL CLR Integration
  • Importing and Configuring Assemblies
  • Implementing SQL CLR Integration
  • Lab: Implementing Managed Code in SQL Server 2014
Storing and Querying XML Data in SQL Server
  • This module introduces XML and shows how XML data can be stored within SQL Server and then queried, including queries written in a language called XQuery.
  • Lessons:
  • Introduction to XML and XML Schemas
  • Storing XML Data and Schemas in SQL Server
  • Implementing the XML Data Type
  • Using the T-SQL FOR XML Statement
  • Getting Started with XQuery
  • Lab: Storing and Querying XML Data in SQL Server 2014
Working with SQL Server 2014 Spatial Data
  • This module introduces Spatial Data, and explains how to work with SQL Server Spatial Data Types.
  • Lessons:
  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications
  • Lab: Working with SQL Server Spatial Data
Incorporating Data Files into Databases
  • Lessons:
  • Querying Data with Stored Procedures
  • Implementing FILESTREAM and File Tables
  • Searching Data Files
  • Lab: Implementing a Solution for Storing Data Files
 

Training Request Form

If you want to maximize the benefits of your training in terms of time and cost efficiency, all you need to do is contact us.

Our training consultants will get in touch with you, assist in identifying your organization’s needs, and provide the most suitable training programs for your employees.

Training Request Form

Digital Vision Academy © All Rights Reserved 2023