SQL Server 2016 New Features for Developers from Pluralsight

This course teaches the new developer features in SQL Server 2016, including Drop If Exists (DIE), SESSION_CONTEXT, dynamic data masking (DDM), row-level security (RLS), Always Encrypted, stretch database, temporal data, and built-in JSON support.

This demo-packed course, SQL Server 2016 New Features for Developers, teaches the many powerful features for developers that have been added in SQL Server 2016. First, you'll discover new security features such as dynamic data masking (DDM), row-level security (RLS), and Always Encrypted. Next, you'll learn about the innovative capabilities, including "stretch" database (allow select tables in an on-premises database to be transparently relocated in Azure SQL Database), and temporal data (enable "time travel" to access data as it existed at any point in time). You'll also learn about the new built-in Javascript Object Notation (JSON) support which enables bi-directional manipulation of JSON data in SQL Server. By the end of this course, you'll be ready for SQL Server 2016 and its exciting new developer features.

What's inside

Syllabus

Course Overview

Introduction and Overview

Dynamic Data Masking

Row-level Security

Always Encrypted

Stretch Database

Temporal Data

Built-in JSON Support

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches in-demand security features including dynamic data masking, row-level security, and Always Encrypted, highly relevant skills for database administrators and developers

Explores innovative capabilities, stretch database and temporal data, enhancing data management and analysis practices

Provides up-to-date coverage of built-in JSON support, empowering developers to work with JSON data natively within SQL Server

Taught by industry experts Leonard Lobel, a recognized authority on SQL Server technologies

Examines emerging security practices like dynamic data masking and row-level security, valuable for protecting sensitive data in the cloud and on-premises environments

Course explicitly requires learners to come in with extensive background knowledge first

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL Server 2016 New Features for Developers with these activities:

SQL Basics Refresher

Show steps

Refresh your understanding of SQL basics, including data types, operators, and basic queries, to strengthen your foundation for this course.

Show steps

Review online tutorials or articles on SQL basics.
Complete practice exercises on SQL basics.
Take a SQL basics quiz or assessment to test your understanding.

Create a Course Materials Compilation

Show steps

Strengthen your understanding of course concepts by compiling and organizing notes, assignments, quizzes, and exams, which will allow you to easily review and reinforce what you have learned.

Show steps

Gather all course materials, including notes from lectures and readings.
Organize the materials into logical sections or topics.
Review the materials regularly to solidify your understanding.

SQL Server Discussion Group

Show steps

Engage in discussions with peers to exchange knowledge, ask questions, and clarify concepts related to the course topics, fostering a collaborative learning environment.

Show steps

Join online discussion forums or communities dedicated to SQL Server.
Participate in discussions, ask questions, and share your insights.
Connect with other learners and professionals to build your network.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Attend SQL Server Workshops

Show steps

Expand your knowledge and skills in SQL Server 2016 by attending immersive workshops led by industry experts, which provide hands-on practice and interactive learning opportunities.

Show steps

Search for upcoming SQL Server workshops in your area or online.
Register for and attend workshops that align with your learning goals.
Actively participate in the workshops, ask questions, and network with other attendees.

SQL Server Scripting Project

Show steps

Develop your practical skills in SQL Server 2016 by creating a script that demonstrates the application of multiple course concepts, such as dynamic data masking and temporal data.

Show steps

Identify a business scenario or problem that can be solved using SQL Server 2016 features.
Design and write a SQL Server script that implements the solution, incorporating the learnings from the course.
Test and refine your script to ensure it meets the requirements.

Volunteer as a SQL Server Mentor

Show steps

Enhance your understanding of SQL Server 2016 by mentoring others, which requires you to have a deep grasp of the concepts and the ability to effectively communicate your knowledge.

Show steps

Identify opportunities to mentor junior developers or students who are learning SQL Server.
Provide guidance, answer questions, and share your expertise.
Reflect on your own understanding and identify areas for further improvement.

Contribute to SQL Server Open Source Projects

Show steps

Deepen your understanding of SQL Server 2016 by contributing to open source projects, which allows you to collaborate with others, learn from different perspectives, and enhance your problem-solving abilities.

Show steps

Identify open source projects related to SQL Server on platforms like GitHub.
Review the project documentation and identify areas where you can contribute.
Submit bug reports, feature requests, or code contributions to the project.

Career center

Learners who complete SQL Server 2016 New Features for Developers will develop knowledge and skills that may be useful to these careers:

Data Architect

Data Architects design and build data architectures. SQL Server 2016 New Features for Developers is an excellent choice as this course provides a comprehensive overview of the latest SQL Server features, including stretch database, temporal data, and built-in JSON support. These features can be critical for designing and building robust and scalable data architectures that can handle complex data workloads.

See salaries and explore the career path for Data Architect

Database Developer

Database Developers design, build, and maintain databases. SQL Server 2016 New Features for Developers is an excellent choice as this course provides a comprehensive overview of the latest SQL Server features, including dynamic data masking, row-level security, and temporal data. These features can be critical for building robust and scalable databases that can handle complex data workloads.

See salaries and explore the career path for Database Developer

Data Engineer

Data Engineers design, build, and maintain data pipelines. SQL Server 2016 New Features for Developers may be useful as this course helps build a foundation in the latest SQL Server features, including stretch database, temporal data, and built-in JSON support. These features can be critical for building robust and scalable data pipelines that can handle complex data workloads.

See salaries and explore the career path for Data Engineer

Software Developer

Software Developers design, build, and maintain software applications. SQL Server 2016 New Features for Developers may be useful as this course helps build a foundation in the latest SQL Server features, including dynamic data masking, row-level security, and temporal data. These features can be critical for ensuring the integrity and security of data, which is essential for building robust and reliable software applications.

See salaries and explore the career path for Software Developer

Information Security Analyst

Information Security Analysts protect organizations from cyber threats. SQL Server 2016 New Features for Developers may be useful as this course helps build a foundation in the latest SQL Server security features, including dynamic data masking, row-level security, and Always Encrypted. These features can be critical for protecting sensitive data from unauthorized access.

See salaries and explore the career path for Information Security Analyst

Business Intelligence Analyst

Business Intelligence Analysts use data to improve business outcomes. SQL Server 2016 New Features for Developers may be useful as this course builds a foundation in the latest SQL Server features, including dynamic data masking, row-level security, and temporal data. These features can be critical for ensuring the integrity and security of data, which is essential for accurate analysis and decision-making.

See salaries and explore the career path for Business Intelligence Analyst

Database Architect

Database Architects design and build database systems. SQL Server 2016 New Features for Developers may be useful as this course helps build a foundation in the latest SQL Server features, including dynamic data masking, row-level security, and temporal data. These features can be critical for ensuring the integrity and security of data, which is essential for designing and building robust and scalable database systems.

See salaries and explore the career path for Database Architect

Cloud Architect

Cloud Architects design and build cloud computing systems. SQL Server 2016 New Features for Developers may be useful as this course helps build a foundation in the latest SQL Server features, including stretch database, temporal data, and built-in JSON support. These features can be critical for building robust and scalable cloud systems that can handle complex data workloads.

See salaries and explore the career path for Cloud Architect

Data Scientist

Data Scientists use data to solve business problems. SQL Server 2016 New Features for Developers may be useful as this course builds a foundation in the latest SQL Server features, including row-level security, temporal data, and built-in JSON support. These features can be critical for ensuring the integrity and security of data, which is essential for accurate analysis.

See salaries and explore the career path for Data Scientist

Software Engineer

Software Engineers design, develop, and maintain software systems. SQL Server 2016 New Features for Developers may be useful as this course helps build a foundation in the latest SQL Server features, including dynamic data masking, row-level security, and temporal data. These features can be critical for ensuring the integrity and security of data, which is essential for building robust and reliable software systems.

See salaries and explore the career path for Software Engineer

Data Analyst

Data Analysts collect, clean, and analyze data to extract meaningful insights. SQL Server 2016 New Features for Developers may be useful as this course builds a foundation in the latest SQL Server features, including data masking, row-level security, temporal data, and built-in JSON support. These features can be critical for ensuring the integrity and security of data, which is essential for accurate analysis.

See salaries and explore the career path for Data Analyst

Database Administrator

Database Administrators oversee an organization's database systems. They ensure data remains available, secure, and protected from corruption. SQL Server 2016 New Features for Developers may be useful as this course helps build a foundation in the latest SQL Server features, including dynamic data masking, row-level security, and temporal data. These features can be critical for ensuring data integrity and security.

See salaries and explore the career path for Database Administrator