Developing Microsoft SQL Server 2016 Databases/ with Adam Wilbert.

Format:

Video

Author/Creator:

Wilbert, Adam, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Video recordings.

Physical Description:

1 online resource

polychrome

Place of Publication:

Carpenteria, CA:: linkedin.com, 2016.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

Learn how to develop a SQL Server 2016 database with more advanced features, like temporary tables, stored procedures, indexes, and secure user accounts.

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.

Participant:

Presenter: Adam Wilbert

Notes:

12/19/20161

Access Restriction:

Restricted for use by site license.