SQL Database Development & Design

Master databases by discovering the art of database development and design.

Technologies: SQL Server 2014, SQL Server 2016, Visual Studio 2013
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.
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.
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.
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.
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.
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.
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.
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.
Isolation levels in SQL Server 2016 help control the way locking works between transactions. Discover the various isolation levels available and how each works.
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.
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.
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.
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.
Constraints can be used in SQL Server 2016 to ensure data integrity. Discover how to design and implement constraints for tables and columns.
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.
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.
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.
Columnstore indexes work differently from traditional indexes in SQL Server 2016. Discover how to implement columnstore indexes in SQL Server 2016.
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.
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.
LINQ provides a powerful set of tools for incorporating databases into .NET applications. Learn to create a simple query in LINQ, create relationships with a query, update database tables with a query, and some advanced query techniques.
For a SQL Server Reporting Services report to be useful, the data must be up-to-date. Explore different ways to process and view reports, and how to create and manage subscriptions and schedules.
For optimal performance and security, you must maintain and monitor SQL Server Reporting Services. Learn how to manage the Report Server, including troubleshooting, and performance tuning, and how to configure security.
SQL Server Data Tools Report Designer and Report Builder are two versatile tools for creating reports. Discovert how to use these tools to add interactivity, such as sorting, filtering, and hyperlinks, to a report.
You can create different types of reports using either SQL Server Data Tools Report Designer and Report Builder. Learn how to use these tools to create reports with different options, including images, charts, and column headers.
To create a SQL Server Reporting Services (SSRS) report, you retrieve the data from a data source into a dataset. Explore different methods of dataset creation, including using stored procedures, and MDX and DAX queries.
You can access SQL Server Reporting Services (SSRS) reports from a variety of sources. Learn how to install and configure the Reporting Services topologies, plan and create reports, and create the data sources for data retrieval.
Tabular modeling in SQL Server Analysis Services (SSAS) lets users access data using DAX queries. Learn how to create calculations and DAX queries, and how to create and manage partitions in a tabular model.
Tabular modeling in SQL Server Analysis Services (SSAS) provides fast performance for users. Discover how to implement tabular models in SSAS, including how to create and manage the tables, and how to manage security and backups.
Managing the Analysis Services server helps ensure it runs smoothly and is secure. Explore SSAS management tasks, including security issues, and preparing, backing up, and restoring multidimensional databases.
Once up and running, the SQL Server Analysis Services (SSAS) multidimensional models and the SSAS databases must be maintained. Learn how to analyze and tune performance, and troubleshoot data analysis issues.
After creation, multidimensional models need to be processed and the databases deployed for users to access them. Examine what is involved in processing data models and deploying SSAS databases.
Users can query data in dimensions, cubes, and measures using Multidimensional Expressions, MDX. Discover how to create queries using MDX on multidimensional models.
Attain better data aggregation and results for the user in SQL Server Analysis Services (SSAS). Learn how with custom logic implementation into a multidimensional model using calculated members, time intelligence, and named sets.
In SQL Server Analysis Services (SSAS), partitions are used to provide the physical storage for the fact data in a measure group. Discover how to design, create, and work with both local and remote partitions.
A SQL Server Analysis Services (SSAS) cube includes measures and measure groups. Explore measures, including how to create and configure them for use in a cube.
In SQL Server Analysis Services (SSAS), a dimension is a collection of related objects used to provide the fact data to one or more cubes. Learn how to create dimensions, and how to configure relationships, hierarchies, and attributes.
A SQL Server Analysis Services (SSAS) cube contains the information required to perform analysis on the data. Learn how to create cubes, measures, measure groups, and other elements including perspectives, hierarchies, and relationships.
SQL Server Analysis Services (SSAS) multidimensional models contain objects called cubes, dimensions, and measures. Discover how to design these objects, and create new projects.
SQL Server Analysis Services (SSAS) uses multidimensional models to analyze large amounts of data. Let's examine the logical and cube architectures of multidimensional models, and how to create data sources.
There are other tools that can be used in conjunction with SQL Server Analysis Services (SSAS). Learn how to install and work with SQL Server Data Tools – Business Intelligence, and how to deploy SQL Server Management Studio.
SQL Server Analysis Services (SSAS) lets you use different models to analyze large amounts of data. Explore the benefits each model provides, and how to install and configure SSAS.
Learn about the physical database design phase, including transforming entities to tables and attributes to views, as well as implementing views and various types of indexes.
The logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. Explore the entities, attributes, and relationships that exist in the logical model.
Database normalization allows you to organize data in a way that reduces redundancy and increases integrity. Learn about normalization and the normal forms in database design.
Good database design sets the foundation for database implementation and ensures business requirements can be met. Learn how to design a database, including database modeling, the design life cycle, and requirements.
Proper database design ensures the database will perform as expected for its users. Explore conceptual design, entities, relationships, as well as creating and integrating views into an ERD.
Microsoft SQL Server 2014 has new features added to help optimize performance. Discover In-Memory OLTP, how to write scripts to automate backups to the cloud, and how to design and create database and programming objects.
Microsoft SQL Server 2014 includes new features to provide optimal performance for applications. Discover some of these features and see how to optimize both queries and overall security in SQL Server 2014.