Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Security and Encryption in SQL Server 2012 and 2014

Security and Encryption in SQL Server 2012 and 2014

1425/month
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Intermediate
Login to earn ₹ 100

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Why should you choose this course?

Description

Learn how to secure SQL Server: Access, authentication, permissions, SQL injections, encryption and much more.

Syllabus

Course Introduction
Why do we Need Security?
What do we Need to Secure?
Demo: Stealing Database Files
There are More Risks Than Data Access
What Tools do we Need?
How Clients are Connecting to SQL Server
Demo: Client Connections
Summary
Module Introduction and System Account
Other System Accounts
Surface Area Configuration
Opening Ports on Windows Firewall With the GUI
Opening Ports on Windows Firewall by Script
Enabling TCP on an Instance by Script
Hiding an Instance in SQL Server Browser
Fixing a TCP Port for an Instance
Encrypting the Connection Between Client and Server Using SSL
Using Extended Protection Against Authentication Relay Attacks
Conclusion
Introduction
Using Metasploit to Discover SQL Server Instance
Cracking the SA Password
Extracting Information From SQL Server Using Metasploit
Summary
Introduction
Demo: Login Modes
Authentication and Permission Model
Demo: Principals
Demo: Using SIDs
Demo: Creating Logins
Demo: Password Policies
Demo: Enabling and Disabling Logins and Users
Demo: Changing and Disabling sa
Conclusion
Introduction, Permissions
Principals, Roles, Owners, ...
What are Securables and How to Assign Permissions
Fixed Server Roles
Demo: Fixed Server Roles
Demo: Server Permissions
Demo: User-defined Server Roles
Demo: Setting Permissions
System Database Users
Database Roles
Demo: Mapping Windows Groups to Database Users
Summary
Introduction, What are SQL Injections?
Demo: Basic SQL Injection Techniques
The Different Types of Injections
Some SQL Injection Tools
Installing and Using SQLMap
Demo: Using SQLMap to Perform Injection Against our Server
How to Prevent Injection
Detecting Common Injection Patterns
Demo: Avoiding Dynamic SQL
Ownership Chaining
Summary
Introduction
Encryption Keys: Symmetric and Asymmetric Encryption
Service and Database Master Keys
Demo: Database Master Key
Transparent Data Encryption
Demo: Encrypted Backup in SQL Server 2014
Demo: Encrypting Data Using a Symmetric Key
Demo: Using Asymmetric Keys
Demo: Using Certificates
Demo: Encrypting Data With Authenticators
Non-reversible Encryption With Hashing
Summary

What others say about this course

FAQs

What is SQL?

Structured Query Language (SQL) is a domain-specific language designed for data management for RDBMS. SQL comes particularly handy in managing structured data and offers certain advantages, such as allowing the access of multiple records through a single command and eliminating the need to specify how to access a record. In simpler words, SQL provides tools to the programmer to define, control and manipulate data in a relational model including tables, rows, and columns.

What are the Prerequisites for learning SQL?

If you wish to learn SQL programming, know the prerequisites well for a smooth learning journey. SQL is a basic query language used primarily for databases, coming with no prerequisites as such. With a simple syntax, there aren't many specific requirements, but it would be helpful to learn database concepts, calculus theories, and basic RDBMS concepts. Once you get a hold of these concepts, you are good to go.

Why should you learn SQL?

SQL query is purely a text message application which can help you access data. SQL is used for most relational storage systems, and it is more of a query language than a programming language. Learning SQL helps the programmers in accessing data with greater efficiency through basic queries. It is predominantly effectual for data manipulation, and the data stored in SQL is dynamic, which means it can be manipulated and modified at any point of time using a set of basic queries. These features make SQL fully equipped to manage datasets of all shapes and sizes.

How can Edvicer help you find the best SQL courses?

Edvicer is a great place to learn SQL with a large number of SQL courses, both free and paid, and projects, both for practice and freelancing. Edvicer has helped a large number of people learn SQL online through the best courses from the top providers like Coursera, Udemy, Udacity, and Pluralsight.

What are the top jobs that I can get from learning SQL?

The top job profile for SQL experts are Dotnet Developer with an average salary of INR 5 LPA, Software Engineer with an average salary of INR 7 LPA, and Database Administrator with an average salary of INR 7 LPA. Get your career map for your skills here.

What can I learn after learning SQL?

After learning SQL, the top skills you can learn to open highest number of job profiles for you are Python, Java, and Data Analytics. The top skills that can get you jobs with highest salaries are Node.js, Data Mining, and Statistical Modeling

Write your review of Security and Encryption in SQL Server 2012 and 2014

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer