We may earn an affiliate commission when you visit our partners.
Leonard Lobel
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.
Read more
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.
Read more
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.
This course is no longer available. Find something similar by browsing:
SQL Server 2016
Dynamic Data Masking
Row-Level Security
Always Encrypted
Stretch Database
Temporal Data
JSON Support
Register for this course and see more details by visiting:
OpenCourser.com/course/atoog8/sql
What's inside
Syllabus
Course Overview
Introduction and Overview
Dynamic Data Masking
Row-level Security
Read more
Syllabus
Course Overview
Introduction and Overview
Dynamic Data Masking
Row-level Security
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause 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
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Sql server 2016 developer features overview
According to students, this course offers a clear and practical guide to the new developer features in SQL Server 2016. Learners frequently praise the knowledgeable instructor for providing clear explanations and helpful demonstrations that make complex topics understandable. Many found the course concise and effective for quickly getting up to speed on features like dynamic data masking, row-level security, and JSON support. While generally well-received for its overview, some indicate it is not a deep dive and suggest it might require prior SQL Server experience or supplementary study for mastering the topics. A few older reviews noted concerns about potentially dated content, given newer SQL Server versions, yet recent feedback remains largely positive regarding its stated focus.
Focuses specifically on 2016 features, with some dated feedback.
"Some content might be a bit outdated now that SQL Server 2019 is out."
"Okay course, but honestly, some of the information feels a bit old. SQL Server 2016 is not the newest anymore."
"Still, for learning 2016 specifics, it's decent."
Course features useful and effective practical demonstrations.
"The demos were useful, though some were a bit fast-paced."
"The practical examples made it easy to grasp complex concepts like temporal data and stretch database."
"The instructor's expertise shines through, and the demos are spot on. Helped me get up to speed quickly for a new project."
Instructor delivers concepts with notable clarity.
"Excellent course! Very clear explanations and practical demos for all new features."
"Fantastic instructor, very clear and concise. The topics are well-explained with excellent examples."
"I feel much more confident using these new features now thanks to the clear explanations."
Beneficial for those with existing SQL Server experience.
"If you're completely new to SQL Server, you might need some prior experience to keep up."
"Good starting point, but not a deep dive."
"It felt like a rapid fire overview rather than a proper tutorial. Not suitable for someone who wants to master these features."
Provides a good overview but may lack in-depth coverage.
"The course is okay. It covers the features, but sometimes the explanations felt a bit superficial."
"Disappointing. The course barely scratches the surface. I was expecting more in-depth coverage..."
"It's not exhaustive, but for a quick understanding of SQL Server 2016 new dev features, it's perfect."
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.
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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.
Database Developer
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.
Information Security Analyst
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.
Data Engineer
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.
Software Developer
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.
Business Intelligence 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.
Data Scientist
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.
Cloud 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.
Database Architect
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.
Software Engineer
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.
Data Analyst
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.
Database Administrator
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.
For more career information including salaries, visit:
OpenCourser.com/course/atoog8/sql
Reading list
We've selected eight books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server 2016 New Features for Developers.
Provides a complete guide to Temporal Data in SQL Server 2016, and valuable resource for learners seeking to implement and manage time-based data.
Offers practical wisdom and principles for software developers, complementing the course's emphasis on professional development.
Provides a collection of recipes for solving common SQL Server 2016 performance problems. It good resource for developers who want to learn how to tune SQL Server 2016 performance.
Provides a detailed guide to Row-Level Security in SQL Server 2016, and valuable resource for learners seeking to implement and manage fine-grained access control.
Save
Provides a practical guide to using Temporal Tables in SQL Server 2016, and valuable resource for learners seeking to implement and manage time-based data in their applications.
A fundamental textbook that provides a foundational understanding of database systems and their concepts. Offers a solid background for individuals new to the field or seeking a refresher.
Provides a foundation for understanding domain-driven design principles, enhancing the course's focus on data-centric development.
Provides a comprehensive guide to SQL Server 2016 performance tuning. It good resource for both beginners and experienced database administrators.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/atoog8/sql
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser