SQL Server 2014: Security Fundamentals
Learn how SQL Server 2014 handles logins, permissions, contained databases and data encryption in a short video course on database security.
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
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.



There are no reviews yet.