MCSA: SQL 2016 Database Development (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
34 hours 10 minutesof self-paced video lessons -
32 Programscrafting your path to success -
Completion Certificateawarded on course completion
Analyzing Query Plans
Price on Request
50 minutes
Optimizing queries can improve the amount of time they take to execute. Discover how to analyze and troubleshoot query plans in SQL Server 2016, and examine Query Store usage scenarios and best practices.
Perks of Course
Certificate: Yes
CPD Points: 50
Compliance Standards: AICC
Azure SQL Database
Price on Request
35 minutes
Microsoft Azure Cloud SQL Database is the cloud database service for developers. Explore Azure SQL Database 2016, including service tiers, elastic database pools and scaling, and how to create and connect to an Azure SQL database.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Columnstore Indexes
Price on Request
45 minutes
Columnstore indexes work differently from traditional indexes in SQL Server 2016. Discover how to implement columnstore indexes in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 43
Compliance Standards: AICC
Data Integrity & Constraints
Price on Request
1 hour 15 minutes
Constraints can be used in SQL Server 2016 to ensure data integrity. Discover how to design and implement constraints for tables and columns.
Perks of Course
Certificate: Yes
CPD Points: 73
Compliance Standards: AICC
Data Types & Normalization
Price on Request
55 minutes
To optimize performance, you must understand how to properly design your SQL Server 2016 database. Examine database normalization and the various data types available in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 54
Compliance Standards: AICC
Database Instance Performance
Price on Request
1 hour 25 minutes
SQL Server Resource Governor is a feature used to manage SQL Server workloads and resource consumption. Discover Resource Governor, and monitoring and troubleshooting tools to improve database performance.
Perks of Course
Certificate: Yes
CPD Points: 85
Compliance Standards: AICC
Database Programmability Objects & Non-relational Data
Price on Request
1 hour 50 minutes
SQL Server 2016 offers various database programmable objects, such as stored procedures and functions. Discover how to implement database programmability objects and how to work with temporal and non-relational data in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 111
Compliance Standards: AICC
Designing & Implementing Views
Price on Request
55 minutes
In addition to indexes, SQL Server 2016 uses views to improve the performance of queries and the overall database. Discover how to enhance usability in SQL Server 2016 by using views.
Perks of Course
Certificate: Yes
CPD Points: 55
Compliance Standards: AICC
Extended Events & SQL Trace
Price on Request
45 minutes
Improve the performance of your SQL Server 2016 database. Discover how to use SQL Server Extended Events and SQL Trace to monitor your SQL Server instances.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Filtering Data
Price on Request
50 minutes
SQL Server 2016 offers various clauses that work in conjunction with SELECT statements. Discover how to sort and filter data, use predicates and operators, and use NULL in queries.
Perks of Course
Certificate: Yes
CPD Points: 48
Compliance Standards: AICC
Functions
Price on Request
40 minutes
Functions in SQL Server 2016 are sets of reusable code that enact operations on a database. Examine functions, including scalar-valued, table-valued, deterministic, and non-deterministic.
Perks of Course
Certificate: Yes
CPD Points: 38
Compliance Standards: AICC
Index Design Guidelines
Price on Request
1 hour 5 minutes
SQL Server 2016 uses indexes to speed up the performance of queries and improve overall database performance. Discover how to design and implement the various index types available in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 63
Compliance Standards: AICC
Isolation Levels
Price on Request
1 hour 30 minutes
Isolation levels in SQL Server 2016 help control the way locking works between transactions. Discover the various isolation levels available and how each works.
Perks of Course
Certificate: Yes
CPD Points: 35
Compliance Standards: AICC
Memory-optimized Tables & Native Stored Procedures
Price on Request
45 minutes
Improve the overall performance of your SQL Server 2016 databases. Explore memory-optimized tables as well as native stored procedures, a feature used to enable efficient execution of the queries.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Modifying Data
Price on Request
1 hour 25 minutes
SQL Server 2016 offers various clauses determine how the results of a particular query are presented. Explore data modification using conversions, character data, SELECT INTO, INSERT, and more.
Perks of Course
Certificate: Yes
CPD Points: 84
Compliance Standards: AICC
Nonclustered, In-Memory, & XML Indexes
Price on Request
40 minutes
Columnstore indexes work differently from traditional indexes in SQL Server 2016. Explore columnstore performance considerations that can impact operations, nonclustered indexes, in-memory indexes, and XML indexes.
Perks of Course
Certificate: Yes
CPD Points: 42
Compliance Standards: AICC
Operators & Expressions
Price on Request
1 hour 30 minutes
Set operators in SQL Server 2016 are used to compare rows between input sets. Explore the UNION, INTERSECT, and EXCEPT set operators, the APPLY operator, and the basic components of common table expressions.
Perks of Course
Certificate: Yes
CPD Points: 89
Compliance Standards: AICC
Optimize Locking Behavior
Price on Request
50 minutes
Locking is a feature in SQL Server 2016 that helps ensure the physical integrity of each transaction. Discover how to implement and troubleshoot locking, and minimize, handle, and remediate deadlocks.
Perks of Course
Certificate: Yes
CPD Points: 50
Compliance Standards: AICC
Optimizing Statisitics & Indexes
Price on Request
1 hour
Optimizing statistics helps ensure the most efficient means of executing statements in SQL Server 2016. Discover how to create, modify, and troubleshoot statistics and indexes in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
Performance Metrics
Price on Request
1 hour 10 minutes
SQL Server 2016 provides a comprehensive set of tools for monitoring and tuning to ensure optimal performance. Examine performance metrics and monitoring, and the various logging tools available with SQL Server.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
Querying & Manipulating Data
Price on Request
1 hour
SELECT statements in SQL Server 2016 are used to query tables and views and to manipulate data for customized results. Explore the fundamentals of using SELECT statements, including how to use aliases and case expressions.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Querying with Joins
Price on Request
1 hour 5 minutes
SELECT statements in SQL Server 2016 are used to query tables and views and to manipulate data for customized results. Explore the fundamentals of querying multiple tables using joins.
Perks of Course
Certificate: Yes
CPD Points: 64
Compliance Standards: AICC
Sets & Predicate Logic
Price on Request
45 minutes
SQL Server 2016 delivers many new features and enhancements. Explore an overview of the SQL Server 2016 architecture, from topics such as sets and predicate logic.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
SQL 2016 Tables
Price on Request
45 minutes
In order to properly design and implement a relational database schema, it's important to have an understanding of the fundamentals of SQL Server 2016. Explore the creation and altering of tables, including constraints.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Stored Procedures
Price on Request
1 hour 5 minutes
A stored procedure in SQL Server 2016 is prepared SQL code that can be reused, improving performance, productivity, and ease of use. Discover how to work with stored procedures, including creating, editing, and handling errors.
Perks of Course
Certificate: Yes
CPD Points: 67
Compliance Standards: AICC
Subqueries & the EXISTS Predicate
Price on Request
1 hour 30 minutes
Subqueries in SQL Server 2016 are nested SELECT statements used to create more effective queries in T-SQL. Explore subqueries and correlated subqueries and the EXISTS predicate.
Perks of Course
Certificate: Yes
CPD Points: 88
Compliance Standards: AICC
Transactions
Price on Request
1 hour
SQL Server transactions allow you to group together a number of statements to form a single logical unit of work. Explore the various types of transactions, and discover how to implement them in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 58
Compliance Standards: AICC
Triggers
Price on Request
1 hour 10 minutes
Triggers in SQL Server 2016 are sets of statements that execute automatically when a specific event occurs in a database. Explore the design and implementation of the various types of triggers found in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
T-SQL Queries
Price on Request
1 hour 30 minutes
SQL Server 2016 delivers many new features and enhancements. Explore an overview of the SQL Server 2016 architecture through the fundamentals of T-SQL querying.
Perks of Course
Certificate: Yes
CPD Points: 73
Compliance Standards: AICC
Using Aggregate Functions
Price on Request
45 minutes
Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore various types of aggregate functions such as SUM, MIN, MAX, AVG, and COUNT.
Perks of Course
Certificate: Yes
CPD Points: 43
Compliance Standards: AICC
Using Functions
Price on Request
1 hour 30 minutes
SQL Server 2016 offers built-in functions that provide data type conversion, comparison, and NULL handling. Explore the various types of built-in functions and how to write queries using built-in functions.
Perks of Course
Certificate: Yes
CPD Points: 88
Compliance Standards: AICC
Using GROUP BY, PIVOT, & UNPIVOT
Price on Request
1 hour 25 minutes
Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore the GROUP BY clause and how to change a table-valued expression into another table using the PIVOT and UNPIVOT operators.
Perks of Course
Certificate: Yes
CPD Points: 86
Compliance Standards: AICC