SQL Server 2014: Security Fundamentals

Enroll for Free

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free to learn, certificate paid
  • Credits: CPD Credits
  • Learning style: Self-paced, start anytime
  • Format: Video Based
  • Video access: Offline Download (App)
  • Refund: Conditional Refund
Available onAlisonAlison

Course Details
Learning Style

Start Anytime

Level

Beginner

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Academic Credits

CPD Credits

Career Support

Resume & Interview Prep

Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Content (Paid certificate)

Refund Policy

Conditional Refund

Technical
Content Medium

Video Based

Video Access

Offline Download (App)

Specification
Access

Free Access

SKU: sql-server-2014-security-fundamentals Category: Tags: , , , , Brand:

Learn how SQL Server 2014 handles logins, permissions, contained databases and data encryption in a short video course on database security.

At a glance
Duration3-4 Hours
LevelBeginner
CertificateCertificate of Completion
LanguageEnglish
AccessFree access
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
Newer version. For SQL Server 2025, see Explore SQL Server 2025 capabilities.

Keeping a SQL Server 2014 database safe means answering three questions: who is connecting, what each user or process may reach, and how sensitive data is protected. You follow how the server verifies a login and identifies principals, how permissions on securable objects can follow the principle of least privilege, and how a key or password is used to encrypt data as one layer of a defense-in-depth approach.

What You Will Achieve

  • Create a SQL Server login and pick an authentication method for client applications that connect to a database
  • Move a database between servers more easily by setting it up as a contained database
  • Apply GRANT, REVOKE and DENY so each principal gets only the access to securable objects it needs
  • Protect sensitive information by encrypting it as one layer of defense-in-depth security


Program Overview

Relational Databases and SQL Server Authentication

Sets out why data belongs in a relational database and how SQL Server checks that a principal is who they claim to be.

  • Why use a relational database
  • Authentication and principals
  • Windows and SQL Server authentication
  • Login creation procedure

Contained Databases, Authorization and Permissions

Covers the security elements of contained databases and how authorization, permissions and default schemas decide what each principal can reach.

  • Contained databases and moving between servers
  • Principals and securable objects
  • The three permission statements and least privilege
  • Default schemas, the code owner exception and metadata

Data Encryption and Defense in Depth

Explains the encryption features built into SQL Server and how layered protection keeps sensitive data objects safe.

  • Built-in protection for data objects
  • Encrypting data with a key or password
  • Types of encryption keys
  • Defense in depth

Certificate Awarded (Paid)

Pass the course assessment to earn it. The course is free to study; the certificate is optional and has a fee.


Job Outlook

Login setup, permission design and data encryption are routine work for the people who run and design SQL Server databases, and they matter to developers and analysts whose applications connect to them.

  • Database Administrator
  • Database Architect
  • Data Engineer

Our take

Good for: Newcomers to database administration who want a short, structured look at how SQL Server controls logins, permissions and encryption before working on a real server.

Keep in mind: It teaches SQL Server 2014, and newer SQL Server versions are available, so check current documentation for security options that have changed since.

Bottom line: A compact tour of the security layers in one SQL Server release, giving permission statements and contained databases particular attention.

Frequently Asked Questions

Which SQL Server version do the lessons use?

The lessons are built on SQL Server 2014, including its contained database feature. Newer releases of SQL Server exist, so compare with their documentation wherever options or defaults differ from what the course shows.

What is a principal in SQL Server?

A principal is a user or a process that is allowed to access secured objects. The course shows how SQL Server identifies each principal uniquely so it can authorize access to a database and its objects.

What are GRANT, REVOKE and DENY?

They are the three statements the course uses to manage permissions. Together they set what access a principal has to a securable object, which is how the lessons put the principle of least privilege into practice.

Why do contained databases matter for security?

The lessons present contained databases as a SQL Server 2014 feature that brings its own security elements and eases the work of moving a database to a different server.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    SQL Server 2014: Security Fundamentals
    SQL Server 2014: Security Fundamentals
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0