Data Manipulation Language (DML) triggers are powerful tools that you can use to enforce domain, entity, referential data integrity and business logic. The enforcement of integrity helps you to build reliable applications. In this module, you’ll learn what DML triggers are, how they enforce data integrity, the different types of trigger that are available to you, and how to define them in your database.
You’ll explore the granting of permissions at the schema level in the final lesson of this module. As a SQL Server professional, you are likely to be asked to create databases that meet business needs. However, occasionally you may need additional capabilities that can only be met by using common language runtime (CLR) code.
Microsoft SQL Server 2016: Installation and Administration
This module describes the elements of T-SQL and their role in writing queries. Dynamic Data Masking is a feature in SQL Server 2016 that is designed to return a custom mask of information for sensitve data in columns. Polybase allows a SQL Server use to access data stored in Hadoop using T-SQL. The Managed Backup feature is designed to automate your backups to Azure Blob Storage.
It is easy to become overwhelmed by the volume of output that monitoring tools can provide, so you also need to learn techniques for analysing their output. Monitoring performance metrics provides a great way to assess the overall performance SQL Server 2016 Lessons of a database solution. However, there are occasions when you need to perform more detailed analysis of the activity occurring within a Microsoft SQL Server instance—to troubleshoot problems and identify ways to optimise workload performance.
Advanced Relational Database and SQL
In the previous module, you learned how to plan a backup strategy for a SQL Server system. You can now learn how to perform SQL Server backups, including full and differential database backups, transaction log backups, and partial backups. Protection of data within your Microsoft SQL Server databases is essential and requires a working knowledge of the issues and SQL Server security features. This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorisation. SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications.
In this module, you’ll consider how to create a strategy that is aligned with organisational needs, based on the available backup models, and the role of the transaction logs in maintaining database consistency. The physical design of a database can have a significant impact on the ability of the database to meet the storage and performance requirements set out by the stakeholders. Designing a physical database implementation includes planning the filegroups, how to use partitioning to manage large tables, and using compression to improve storage and performance. Temporal tables are a new feature in SQL Server and offer a straightforward solution to collecting changes to your data. As well as learning skills specific to SQL databases, you’ll learn how to install, configure and manage SQL Server 2016 itself. This will teach you to setup SQL Server 2016 and prove you know how it functions within your business.
SQL Server User-defined Functions
This module explains how to name, declare, assign values to, and use variables. Concurrency control is a critical feature of multiuser database systems; it allows data to remain consistent when many users are modifying data at the same time. This module covers the implementation of concurrency in Microsoft SQL Server. You’ll learn about how SQL Server implements concurrency controls, and the different ways you can configure and work with concurrency settings.
SQL Server Extended Events is a flexible, lightweight event-handling system built into the Microsoft SQL Server Database Engine. This module focuses on the architectural concepts, troubleshooting strategies and usage scenarios of Extended Events. Join our community of 30 million+ learners, upskill with CPD UK accredited courses, explore career development tools and psychometrics – all for free. This SQL course is a great place to start if you’re interested in SQL programming, how to use SQL Server Core 2016 or have career aspirations to be in Database Administration, coding or software development. These skills can be used in the broader IT operations and development operations arena and can open an even bigger set of professions in your career path.