SQL Database Administration: SQL server intermediate

https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=7116318&expertiselevel=95681 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=95685&expertiselevel=95681 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=95682&expertiselevel=95683 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=7116318&expertiselevel=95683 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=95685&expertiselevel=95683 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=95685&expertiselevel=95684
  • 11 Courses | 10h 47m 59s
  • 4 Books | 38h 31m
  • 13 Courses | 10h 5m
  • 9 Books | 79h 23m
  • Includes Lab
  • Includes Test Prep
  • 19 Courses | 19h 27m 46s
  • 5 Books | 50h 57m
  • Includes Lab
  • 11 Courses | 12h 16m 29s
  • 4 Books | 44h 20m
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
 
Explore all aspects of managing SQL database software.

GETTING STARTED

SQL Concepts & Queries

  • 10m 10s
  • 8m 30s

GETTING STARTED

Encryption

  • 9m 52s
  • 7m 26s

GETTING STARTED

Designing & Implementing Dimensions

  • 10m 18s
  • 5m 47s

GETTING STARTED

Planning Infrastructure

  • 7m 28s
  • 5m 46s

COURSES INCLUDED

SQL Concepts & Queries
Master SQL concepts. Learning the core fundamentals creates a foundation. Discover relational databases and Structured Query Language (SQL) database concepts.
7 videos | 1h has Assessment available Badge
SQL Tables
Master SQL tables. Take your first steps in learning about relational databases and Structured Query Language (SQL) tables. Discover how to manage tables, and queries, including complex tables, changing tables, and deleting tables.
9 videos | 1h has Assessment available Badge
SQL Selecting, Ordering, & Filtering
Manipulating databases is a necessary skill. Explore Structured Query Language (SQL) and dive into the architecture. Discover efficient and easily manageable databases using features like SELECT, data types, UPDATE, and ORDER BY.
9 videos | 55m has Assessment available Badge
Table Design: Tables, Columns, & Numbers
Fundamentals create foundation. Get a clear picture of what SQL is all about. Discover table functions including ALTER and CREATE, as well as column functions and math operators.
13 videos | 1h 16m available Badge
Table Design: Functions & Strings
Master the core functions of SQL strings. Strings are a key component to any database, and you can work magic using fundamental SQL commands. Explore string functions like LENGTH, REVERSE, and TRIM, as well as how to put them together.
8 videos | 40m available Badge
Multiple SQL Tables
Work with multiple tables. Mastering the fundamentals of SQL creates a foundation. Explore multi-table database architecture and design, connecting several tables, using inner/outer joins, and equijoins and non-equijoins.
12 videos | 1h 20m available Badge
Advanced SQL Queries
Master advanced queries. Queries in SQL allow you to manipulate databases like a pro. Discover advanced techniques including subqueries, correlated queries, difficult queries, and learn query tips for better efficiency.
13 videos | 1h 24m available Badge
SQL Views
Discover SQL views. Explore SQL views in detail, defining various views and their management, from creating views to view types, updating, and dropping views.
5 videos | 38m has Assessment available Badge
SQL Transactions
Master SQL transactions. Explore transactions and how to group statements, Transact-SQL, and transaction logs.
8 videos | 1h has Assessment available Badge
SQL Transaction Locks
Master SQL transaction locks. Explore transaction locks and explore the different levels of locking.
5 videos | 40m has Assessment available Badge
SQL Security Architecture
Mastering security is crucial. Explore one of the most important aspects of SQL security. Discover the lock system, levels of security access and management, privileges and rights, and the setup and installation of security architecture.
7 videos | 51m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Encryption
Ensuring data security is an important part of administering any database infrastructure, and encryption is one method to help you protect sensitive data. Explore encryption-related tools and processes used in SQL Server 2016.
14 videos | 1h 31m has Assessment available Badge
Data Access & Permissions
To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. Explore data access and permissions, including database object permissions, users, and custom roles.
11 videos | 1h 8m has Assessment available Badge
Data Security & Azure SQL Database Options
To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. Explore user options for Azure SQL Database, row-level security, and dynamic data masking.
9 videos | 58m has Assessment available Badge
Auditing
Auditing is an essential administration task used to track and log database events to ensure the database is performing properly. Explore auditing, Azure SQL Database audit, and analyzing audit logs and reports from Azure SQL Database.
17 videos | 2h 6m has Assessment available Badge
Backup Management
A tested backup strategy is the most effective means of protecting your data from potential disaster. Explore SQL Server 2016 backup management practices, including backup strategies, media options, and retention and recovery models.
16 videos | 1h 42m has Assessment available Badge
Database Restoration
An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. Explore restoring SQL Server 2016 databases, including point-in-time recovery and automation for testing.
9 videos | 1h 1m has Assessment available Badge
File & Piecemeal Restores
In the event of an unforeseen disaster, critical data should be protected and easily recoverable. Discover how to perform piecemeal and page restores, and restoring file groups.
11 videos | 57m has Assessment available Badge
Managing Database Integrity
Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. Explore database consistency checks and how to identify and recover from database corruption.
10 videos | 53m has Assessment available Badge
Monitoring Database Activity
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. Explore managing and monitoring SQL Server database activity, including data collector and creating a utility control point.
10 videos | 1h 1m has Assessment available Badge
Monitoring Queries
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. Explore SQL Server database queries, including the Query Store, Extended Events, SQL Trace, and troubleshooting server health.
9 videos | 59m has Assessment available Badge
Database Mail & Alerts
Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore the creation and management of operators and SQL Server Agent alerts.
11 videos | 1h 2m has Assessment available Badge
Policy-based Management & Performance Monitoring
Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore Policy-Based Management and performance monitoring of SQL Server 2016 instances.
8 videos | 55m has Assessment available Badge
Index & Statistical Management
By carefully managing aspects of your database, you can better tune performance and identify potential issues. Explore index management tasks, such as identifying and repairing fragmentation, and identifying and creating missing indexes.
14 videos | 1h 26m has Assessment available Badge
Log Shipping & High Availability
Data is an important enterprise asset and must be protected, retrievable, and highly available. Examine high availability and disaster recovery in SQL Server 2016, including log shipping, shared disks, and cluster shared volumes.
16 videos | 1h 40m has Assessment available Badge
T-SQL Queries
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.
11 videos | 1h 13m has Assessment available Badge
Sets & Predicate Logic
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.
8 videos | 47m has Assessment available Badge
Querying & Manipulating Data
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.
10 videos | 1h 1m has Assessment available Badge
Querying with Joins
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.
8 videos | 1h 4m has Assessment available Badge
Filtering Data
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.
8 videos | 48m has Assessment available Badge
Modifying Data
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.
12 videos | 1h 24m has Assessment available Badge
Using Functions
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.
19 videos | 1h 28m has Assessment available Badge
Using Aggregate Functions
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.
9 videos | 43m has Assessment available Badge
Using GROUP BY, PIVOT, & UNPIVOT
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.
11 videos | 1h 26m has Assessment available Badge
Subqueries & the EXISTS Predicate
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.
15 videos | 1h 28m has Assessment available Badge
Operators & Expressions
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.
16 videos | 1h 29m has Assessment available Badge
Database Programmability Objects & Non-relational Data
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.
15 videos | 1h 51m has Assessment available Badge
SQL Platform & Installation Best Practices
It's important to understand the various components, editions, and versions that exist when discussing SQL Server 2016. Explore the SQL Server platform and best practices and guidelines to follow when preparing for an installation.
12 videos | 1h 4m has Assessment available Badge
Architecture
Understanding the architecture of SQL Server 2016 is important to being able to effectively work with it. Explore the SQL Server architecture, including parallelism, I/O operations, account types, and network protocols.
8 videos | 47m has Assessment available Badge
Installation & Configuration
It's important to understand the numerous recommended pre- and post-installation best practices set forth by Microsoft to ensure a successful deployment. Explore deployment options, including post-installation best practices.
9 videos | 54m has Assessment available Badge
Upgrading to SQL Server 2016
When performing a SQL Server 2016 upgrade, it's important to understand numerous recommended pre- and post-installation best practices. Examine upgrade options, such as in-place and side-by-side upgrades.
10 videos | 46m has Assessment available Badge
Virtual Machines on Azure
Azure virtual machines provide a way to move on-premise SQL Server workloads and applications to the cloud. Discover the recommended usage scenarios for Azure VMs as well as how to provision, create, and connect to Azure SQL Databases.
11 videos | 57m has Assessment available Badge
Service Tiers, Pools, & SQL Databases
Azure virtual machines (VMs) provide a way to move on-premise SQL Server workloads and applications to the cloud. Explore service tiers, pools and SQL databases for Azure VMs.
9 videos | 48m has Assessment available Badge
Instances & Storage Considerations
SQL Server uses instances to allow more than one copy of a SQL Server component to be installed on a single server. Explore SQL Server instances in IaaS and on-premises, and the various storage solutions in SQL Server 2016.
17 videos | 1h 36m has Assessment available Badge
Securing Azure SQL Databases
Determining how to secure databases in SQL Server 2016 is one of the most important parts of a deployment strategy. Discover how to implement firewalls, authentication, and auditing to ensure Azure SQL database security.
10 videos | 47m has Assessment available Badge
Dynamic Data Masking
Part of your deployment strategy should be to secure not only the databases but also the data itself. Examine dynamic data masking, a feature in SQL Server 2016 that can be used to limit exposure to sensitive data.
9 videos | 40m has Assessment available Badge
Transparent Data Encryption
Transparent Data Encryption (TDE) performs real-time I/O encryption of data and can be used to secure SQL servers and Azure SQL databases. Discover TDE commands, functions, and considerations.
10 videos | 43m has Assessment available Badge
Always Encrypted & Cell-level Encryption
Besides Transparent Data Encryption (TDE), there are other methods available for Azure SQL database encryption. Examine alternate encryption solutions, including Always Encrypted and cell-level encryption.
9 videos | 44m has Assessment available Badge
Database Performance Settings
SQL Server 2016 offers various tools to tune a SQL Server environment for peak performance. Discover how to maximize database performance as well as the maximum amount of server memory.
8 videos | 32m has Assessment available Badge
Configuring Operators & Alerts
Keeping a SQL Server environment running its best involves constant monitoring of activity. Discover how to configure operators and alerts in SQL Server 2016 to help you maintain peak performance.
11 videos | 36m has Assessment available Badge
Multiple Tenant Deployments
There are many variables to consider when deciding on a single-tenant or multi-tenant design for Windows Azure. Examine the considerations for each design option.
6 videos | 28m has Assessment available Badge
Migrating to Azure SQL Databases
Migrating a database to Azure SQL Database primarily involves three steps: preparing, exporting, and importing. Explore the requirements and processes involved in migrating data to Azure SQL Databases.
13 videos | 1h 1m has Assessment available Badge
Virtual Machines & Benchmark Data
Microsoft SQL Server applications can be moved to Azure virtual machines to help reduce costs and to optimize overall performance. Explore the various methods used to migrate applications as well as gathering benchmark data.
11 videos | 51m has Assessment available Badge
Performance Tuning & Availability Sets
Moving Microsoft SQL Server applications to Azure virtual machines can help optimize overall performance. Discover various methods used for performance tuning and configuring availability sets for redundancy.
8 videos | 31m has Assessment available Badge
Connection Strings & Traffic Manager
Connection strings are used to allow client applications to interact with Azure SQL databases. Explore application connections strings and the Azure Traffic Manager, which is used to control the distribution of incoming user traffic.
13 videos | 47m has Assessment available Badge
Application Patterns
There are various types of application patterns available when migrating SQL Server-based applications to an Azure environment. Examine some of these patterns, including 1-Tier, 3-Tier, Presentation Tier, and Business Tier.
7 videos | 28m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Designing & Implementing Dimensions
A data warehouse combines data from multiple sources that can be used to create analytical reports. Explore schemas and tables that are created within it, and how to create dimension and fact tables.
10 videos | 1h 3m has Assessment available Badge
Designing a Fact Table
Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. Explore the implementation of fact tables using partitions, data compression, and columnstore indexes.
9 videos | 1h 2m has Assessment available Badge
Connection Managers & Data Sources
Connection managers in a data warehouse are used to define the data source connections. Discover how to use connection managers to specify source and destinations, as well as how to create custom data sources.
11 videos | 1h 9m has Assessment available Badge
Data Transformation & Flow
When working with data in a data warehouse, some level of transformation is usually required between the source and destination. Learn how to work with transformations and design data flow.
10 videos | 59m has Assessment available Badge
Data Flow Implementation & ETL
Extract, transform, load (ETL), is the main process in data warehousing solutions and helps transfer data from one source to another. During this course you will examine the ETL process and how it can be implemented. You will start by examining data flows and how to debug them. Next, you will learn how to use SQL Server Integration Services (SSIS), and perform a broad range of data migration tasks. These include how to create SSIS packages, transform data, and perform lookup tasks. Next you will employ ETL, the SSIS data warehousing tool, to facilitate the transfer of data from a source to a destination. Discover how to implement the ETL process, to extract, transform, and load data. Specify a data source and a destination. Finally, you will performance tune SSIS data flow and optimize data Integration Services.
8 videos | 1h 2m has Assessment available Badge
SSIS Package Execution & Script Tasks
Microsoft SQL Server Integration Services (SSIS) is a platform that can be used to build packages for data warehousing. Discover how to create simple SSIS packages and use script tasks.
12 videos | 1h 14m has Assessment available Badge
Designing Control Flow
Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations. Examine how to design control flow elements in SSIS.
9 videos | 59m has Assessment available Badge
Implementing Control Flow
By using the control flow data flow task, data flow can be implemented into the SSIS package specifying the data source, data transformation, and data destination. Discover how to implement control flow elements.
11 videos | 1h 8m has Assessment available Badge
SSIS Variables
SQL Server 2014 allows for the use of parameters, variables, and expressions to create dynamic packages. Examine SSIS variable concepts, such as system variables, scope, parameterization of properties, and data types.
6 videos | 36m has Assessment available Badge
SSIS Packages
SSIS in SQL Server 2014 allows for dynamic packages, enabling values within the package to be manually set, depending on your requirements at execution time. Discover what's involved in designing SSIS packages.
13 videos | 1h 36m has Assessment available Badge
Data Loading
SQL Server Integration Services (SSIS) is an extensible platform for creating data integration and workflow solutions. Explore various options available for loading data, including incremental, full, and bulk load.
10 videos | 56m has Assessment available Badge
Script Components
SQL Server Integration Services (SSIS) provides the ability to create custom components if the integrated components do not suit your specific needs. Learn how to develop and install custom components and implement script tasks.
8 videos | 41m has Assessment available Badge
SSIS Components
SQL Server Integration Services (SSIS) can be installed during the SQL Server installation or as a separate component. Examine the various components of SSIS, as well as installation considerations, such as upgrade options and architecture.
14 videos | 1h 33m has Assessment available Badge
Auditing, Logging, & Event Handling
SQL Server Integration Services (SSIS) and SQL Server Data Tools (SSDT) both offer tools and techniques to monitor and optimize SSIS solutions. Discover how to implement auditing, logging, and event handling in SSIS.
7 videos | 46m has Assessment available Badge
Troubleshooting Data Integration
SSIS includes tools and features that can be used to troubleshoot data integration. Learn how to debug and troubleshoot packages at the design and production level using techniques such as data viewers and break points.
10 videos | 54m available Badge
SSIS Solutions
SSIS consists of several layers, including package properties and centralized management, to provide a rich and flexible environment. Explore SSIS catalog creation, package deployment, and package validation.
10 videos | 45m has Assessment available Badge
SSIS Security
SSIS consists of several layers, including digital signatures and database roles, to provide a rich and flexible security environment. Examine techniques and recommendations on how to secure an SSIS deployment.
10 videos | 58m has Assessment available Badge
Data Quality Services (DQS) & Master Data Services (MDS)
DQS can help identify duplicate or invalid data entries while automatically correcting them. MDS enables data validation and rules to ensure consistency in your data. Discover how to install and use both of these technologies.
11 videos | 1h 10m has Assessment available Badge
Data Quality Projects
When creating a data warehouse, data quality should be one of your top priorities. In order to trust the results of data analysis, high-quality data is essential. Explore various strategies for creating data quality projects.
8 videos | 46m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Planning Infrastructure
A SQL Server infrastructure must be planned from the hardware up. Discover how to plan both the physical and logical database structures using the Microsoft Planning and Assessment Toolkit.
14 videos | 1h 42m has Assessment available Badge
Implementing & Testing Policy
When planning a SQL Server infrastructure, you must include the management of all instances of SQL Server. Discover how to implement policy-based management and how to manage SQL Server using System Center.
7 videos | 44m has Assessment available Badge
Private Cloud Overview
SQL Server 2014 has a number of enhancements and features aimed at private cloud deployment and management of SQL databases. Explore SQL Server consolidation and management of consolidated resources.
6 videos | 34m has Assessment available Badge
Private Cloud Planning & Implementation
SQL Server 2014 includes features for private cloud deployment and management of SQL databases. Explore cloud computing, configuring SQL in a private cloud configuration, and working with prepared instances of SQL Server.
12 videos | 1h 8m has Assessment available Badge
Windows Azure SQL Database
Meet Microsoft Windows Azure and Windows Azure SQL Database. Explore Windows Azure architecture, services, and storage, and examine Windows Azure SQL Database, including security and migration.
19 videos | 1h 59m available Badge
High Availability
Windows Azure lets you configure and manage a dedicated VM to run an instance of SQL Server. Discover VMs on Windows Azure; how to install, configure and manage SQL Sever on a VM; and high availability options in SQL Server 2014.
16 videos | 1h 32m has Assessment available Badge
WSFC Clustering
Windows Server Failover Clustering (WSFC) helps increase the availability of applications and services. Explore WSFC, including processes and cluster storage, and how to create a failover cluster.
5 videos | 35m has Assessment available Badge
Clustering & AlwaysOn
SQL Server AlwaysOn Availability Groups are built on WSFC clusters and AlwaysOn Failover Cluster Instances (FCI). Discover how to create, configure, and manage SQL Server AlwaysOn FCIs and AlwaysOn Availability Groups.
15 videos | 1h 29m has Assessment available Badge
Backup & Recovery Strategies
From an individual to the largest organization, it is crucial that you always back up your data. Discover SQL Server 2014 backup strategies, how to perform a backup, and how to create and maintain a disaster recovery plan.
8 videos | 48m has Assessment available Badge
Recovery Implementation
Should something go wrong, you can always use your SQL Server backup to recover your data. Explore the SQL Server 2014 recovery process, including restoring from Azure and Azure SQL Database.
6 videos | 48m has Assessment available Badge
Replication Overview
One method for maintaining data integrity and minimizing potential disaster is replication. Discover how to configure, implement, and manage SQL Server replication as part of your backup and recovery plan.
7 videos | 53m has Assessment available Badge
SHOW MORE
FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Professional SQL Server 2014 Administration
Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. This book is your comprehensive guide to working with the new environment.
book Duration 14h 30m book Authors By Adam Jorgensen, Bradley Ball, Brian Knight, Ross LoForte, Steven Wort

Book

Professional Microsoft SQL Server 2014 Integration Services
Your ultimate guide to navigating the changes to Microsoft SQL Server Integration Services (SSIS) 2014 and using them to your utmost advantage, this unique resource offers an understanding of SSIS on a fundamental level, and sets you up for success.
book Duration 15h 4m book Authors By Brian Knight, Chris Rock, Devin Knight, Jessica M. Moss, Mike Davis

Book

Microsoft SQL Server 2014 Query Tuning & Optimization
Filled with ready-to-use techniques for creating high-performance queries and applications, this book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans.
book Duration 5h 4m book Authors By Benjamin Nevarez

Book

Learn SQL Server Administration in a Month of Lunches
The perfect way to get started with SQL Server, this concise, easy-to-read book skips academic introductions and teaches you day-to-day techniques for maintenance, backup and recovery, performance monitoring, and more.
book Duration 3h 53m book Authors By Don Jones
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

SQL in easy steps, 4th Edition
This book easy-to-follow style that will appeal to anyone who wants to begin using databases.
book Duration 1h 51m book Authors By Mike McGrath

Book

High Performance SQL Server: The Go Faster Book
Covering SQL Server instance-configuration for optimal performance, this book helps in implementing SQL Server in-memory technologies and provides guidance toward monitoring and ongoing diagnostics.
book Duration 4h 28m book Authors By Benjamin Nevarez

Book

Pro SQL Server Internals, Second Edition
Providing a solid road map for understanding the depth and power of the SQL Server database server, this detailed resource teaches you how to get the most from the platform and how to keep your databases running at the level needed to support your business.
book Duration 14h 41m book Authors By Dmitri Korotkevitch

Book

Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes
No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry.
book Duration 7h 54m book Authors By Bob Ward

Book

Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server, Second Edition
With a focus on new applications and modern database architecture, this book illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics.
book Duration 6h 11m book Authors By Edward Pollack

Book

Pro SQL Server Administration
Bringing SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core, this comprehensive guide for today's DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.
book Duration 12h 26m book Authors By Peter A Carter

Book

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports
Offering step-by step instruction on Microsoft SQL Server 2016, this thorough guide provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach.
book Duration 10h 39m book Authors By Paul Turley

Book

Microsoft SQL Server 2016 Reporting Services, Fifth Edition
Including a detailed case study and sample reports, this hands-on reference covers the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features.
book Duration 9h 55m book Authors By Brian Larson

Book

Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition
Get up and running on Microsoft SQL Server 2016 in no time with help from this thoroughly revised, practical resource. This book offers thorough coverage of SQL management and development and features full details on the newest business intelligence, reporting, and security features.
book Duration 11h 18m book Authors By Dušan Petković
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Professional SQL Server 2014 Administration
Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. This book is your comprehensive guide to working with the new environment.
book Duration 14h 30m book Authors By Adam Jorgensen, Bradley Ball, Brian Knight, Ross LoForte, Steven Wort

Book

Professional Microsoft SQL Server 2014 Integration Services
Your ultimate guide to navigating the changes to Microsoft SQL Server Integration Services (SSIS) 2014 and using them to your utmost advantage, this unique resource offers an understanding of SSIS on a fundamental level, and sets you up for success.
book Duration 15h 4m book Authors By Brian Knight, Chris Rock, Devin Knight, Jessica M. Moss, Mike Davis

Book

Pro SQL Server Administration
Bringing SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core, this comprehensive guide for today's DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.
book Duration 12h 26m book Authors By Peter A Carter

Book

Microsoft SQL Server 2014 Query Tuning & Optimization
Filled with ready-to-use techniques for creating high-performance queries and applications, this book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans.
book Duration 5h 4m book Authors By Benjamin Nevarez

Book

Learn SQL Server Administration in a Month of Lunches
The perfect way to get started with SQL Server, this concise, easy-to-read book skips academic introductions and teaches you day-to-day techniques for maintenance, backup and recovery, performance monitoring, and more.
book Duration 3h 53m book Authors By Don Jones
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Professional SQL Server 2014 Administration
Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. This book is your comprehensive guide to working with the new environment.
book Duration 14h 30m book Authors By Adam Jorgensen, Bradley Ball, Brian Knight, Ross LoForte, Steven Wort

Book

Beginning SQL Server R Services: Analytics for Data Scientists
Providing practical examples with detailed explanations of the WHY and not just the HOW, this book walks even the newest of users through the creation process of a powerful R-language tool set for use in analyzing and reporting on your data.
book Duration 2h 20m book Authors By Bradley Beard

Book

Pro SQL Server Administration
Bringing SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core, this comprehensive guide for today's DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.
book Duration 12h 26m book Authors By Peter A Carter

Book

Professional Microsoft SQL Server 2014 Integration Services
Your ultimate guide to navigating the changes to Microsoft SQL Server Integration Services (SSIS) 2014 and using them to your utmost advantage, this unique resource offers an understanding of SSIS on a fundamental level, and sets you up for success.
book Duration 15h 4m book Authors By Brian Knight, Chris Rock, Devin Knight, Jessica M. Moss, Mike Davis
SHOW MORE
FREE ACCESS

SKILL BENCHMARKS INCLUDED

Microsoft SQL Server 2016 Installation Literacy (Beginner Level)
The Microsoft SQL Server 2016 Installation Literacy benchmark measures a learner's exposure to Microsoft SQL database management concepts such as the SQL Server platform, versions, architecture, installations, configurations, and upgrading from older versions to SQL Server 2016. A learner who scores high on this benchmark demonstrates that they have the foundational knowledge and installation skills regarding Microsoft SQL Server.
13m    |   13 questions
Microsoft SQL Server 2016 Installation Competency (Intermediate Level)
The Microsoft SQL Server 2016 Installation Competency benchmark measures a learner's skills and exposure of Microsoft SQL database management concepts such as the SQL server platform, versions, architecture, installation best practices, and Azure Virtual Machines. A learner who scores high on this benchmark demonstrates that they have the required skills to install Microsoft SQL Server, upgrade from older versions, and move on-premises SQL Server workloads to the cloud.
26m    |   26 questions
Microsoft SQL Server 2016 Deployment Proficiency (Advanced Level)
The Microsoft SQL Server 2016 Deployment Proficiency benchmark measures a learner's skills and knowledge of Microsoft SQL Server instances and storage, securing Azure SQL databases, deployment strategies, migrations, data masking, encryption, and performance settings. A learner who scores high on this benchmark demonstrates that they have the required skills to plan deployment strategies and migrate to Azure SQL databases, as well as knowledge of security, encryption, and performance settings.
25m    |   25 questions
Microsoft SQL Server 2016 Data Querying and Manipulation Competency (Intermediate Level)
The Microsoft SQL Server 2016 Data Querying and Manipulation Competency benchmark measures a learner's skills and knowledge of querying, retrieving, and manipulating data. A learner who scores high on this benchmark demonstrates that they have the required skills to load, query, and manipulate data using Microsoft SQL Server 2016.
25m    |   25 questions
Microsoft SQL Server 2016 Data Querying and Manipulation Proficiency (Advanced Level)
The Microsoft SQL Server 2016 Data Querying and Manipulation Proficiency benchmark measures a learner's skills and knowledge of querying, retrieving, and manipulating data using advanced functions in Microsoft SQL Server. A learner who scores high on this benchmark demonstrates that they have the required skills to independently load, query, and manipulate data using Microsoft SQL Server 2016.
25m    |   25 questions
Microsoft SQL Server 2016 Migrating to Azure SQL Databases Proficiency (Advanced Level)
The Microsoft SQL Server 2016 Migrating to Azure SQL Databases Proficiency benchmark measures a learner's skills in migrating existing databases to Microsoft SQL databases, applying migration methods for applications, securing benchmark data, tuning performance, managing traffic, and applying various application patterns. A learner who scores high on this benchmark demonstrates that they have the required skills to plan and migrate existing databases and applications to Azure SQL databases and apply various application patterns, as well as knowledge of security and performance tuning.
25m    |   25 questions
Microsoft SQL Database Administration Competency (Intermediate Level)
Microsoft SQL Database Administration Competency (Intermediate Level) benchmark calibrates your ability to implement database security, backup and restore databases, manage database integrity, and implement high availability. You will be evaluated on your skills in administering a Microsoft SQL Server environment, database security, and implementing database fault tolerance. Learners who score high on this benchmark demonstrate that they have the skills to describe and administer Microsoft SQL Server.
20m    |   20 questions
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)