1. All topics
  2. Technology
  3. Database Management
  4. Database Administration
Developing Microsoft SQL Server 2016 Databases Preview

Developing Microsoft SQL Server 2016 Databases

With Adam Wilbert Liked by 592 users
Duration: 4h 5m Skill level: Advanced Released: 12/19/2016

Start my 1-month free trial Buy for my team

Course details

SQL Server is Microsoft's de facto relational database software. While you can build a simple database relatively easily straight out of the box, most administrators need to know how to take advantage of more advanced features in the latest release, SQL Server 2016, to give their clients everything they've come to expect in an enterprise database. In this course, Adam Wilbert shows experienced SQL Server DBAs how to develop a SQL Server 2016 database. Learn how to create data tables, including temporary tables and tables with variables, and schemas. Find out how to enforce data integrity with constraints and secure your database at the user level. Then discover how to create indexes to optimize performance, work with functions, and make sure your SQL database is as fast and secure as possible.

Note: This course will also help you prepare for the Developing Microsoft SQL Server Databases exam—a crucial component of the MCSA: Solutions Associate certification. Find out more about the certification at https://www.microsoft.com/en-us/learning/exam-70-762.aspx.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.7 out of 5

105 ratings
  • 5 star
    Current value: 77 73%
  • 4 star
    Current value: 25 24%
  • 3 star
    Current value: 2 2%
  • 2 star
    Current value: 0 0%
  • 1 star
    Current value: 1 <1%
  • Khaled M. Ali Aklan Albanna Khaled M. Ali Aklan Albanna

    Khaled M. Ali Aklan Albanna

    IT Advisor | AI (Expert Systems & Data Science) | Banking and ERP Systems

    5/5 October 3, 2023
    Excellent content and overview. thank you
    Helpful · Report
  • Edward Taylor Edward Taylor

    Edward Taylor

    Turning Data into Insight

    4/5 June 22, 2023
    worth your time
    Helpful · Report
  • Jhonathan Santacana Jhonathan Santacana

    Jhonathan Santacana

    Data Scientist | Electrical Engineer | Project manager | Machine learning

    5/5 February 3, 2023
    The course is an excellent resource for anyone looking to build a solid foundation in SQL Server. It is packed with a wealth of information and is delivered in a way that is both engaging and easy to understand. One of the key strengths of the course is the way that it covers all of the essential concepts and skills needed to work with SQL Server. The course covers everything from the basics of database to advanced topics. This comprehensive approach means that even those who are new to SQL Server will be able to quickly get up to speed and start using the software effectively. Another great thing about this course is the quality of the instructor. Adam Wilbert is definitely an expert in the field , It is able to communicate complex ideas in a way that is easy to understand. Overall, the course is a fantastic resource for anyone looking to build their skills in SQL Server.
    Helpful · Report

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Test your knowledge 14 quizzes
  • Learn on the go Access on tablet and phone

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play