SQL Database Administration: SQL Server 2014 Intermediate

https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=63811&expertiselevel=63807 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=63808&expertiselevel=63809 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=63811&expertiselevel=63809 https://www.skillsoft.com/channel/sql-database-administration-d3de6ea0-e197-11e6-91a7-0242c0a80704?technologyandversion=63811&expertiselevel=63810
  • 11 Courses | 10h 52m 45s
  • 4 Books | 38h 31m
  • 45 Courses | 47h 49m 28s
  • 8 Books | 77h 32m
  • 19 Courses | 19h 37m 5s
  • 5 Books | 50h 57m
  • 11 Courses | 12h 22m 12s
  • 4 Books | 44h 20m
Likes 190
 
Explore all aspects of managing SQL database software.

GETTING STARTED

SQL Concepts & Queries

  • Playable
    1. 
    Introduction to the Database Concept
    10m 13s
    NOW PLAYING
  • Playable
    2. 
    The Relation of Data and the Various Databases
    8m 33s
    UP NEXT

GETTING STARTED

Encryption

  • Playable
    1. 
    Encryption Features
    9m 55s
    NOW PLAYING
  • Playable
    2. 
    Transparent Data Encryption
    7m 29s
    UP NEXT

GETTING STARTED

Designing & Implementing Dimensions

  • Playable
    1. 
    The SQL Server Business Intelligence platform
    10m 21s
    NOW PLAYING
  • Playable
    2. 
    Changing Dimensions
    5m 50s
    UP NEXT

GETTING STARTED

Planning Infrastructure

  • Playable
    1. 
    Infrastructure Planning
    7m 31s
    NOW PLAYING
  • Playable
    2. 
    Database Server Topologies
    5m 49s
    UP NEXT

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 17m 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 | 52m 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 32m 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 | 59m 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 43m 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 | 58m has Assessment available Badge