最新消息:请大家多多支持

Lynda – Developing Microsoft SQL Server 2016 Databases

其他教程 dsgsd 156浏览 0评论


Lynda - Developing Microsoft SQL Server 2016 Databases

Lynda – Developing Microsoft SQL Server 2016 Databases
Size: 547 MB | Duration: 4h 6m | Video: AVC (.mp4) 1280×720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Advanced | Language: English
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 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 with more advanced features. 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 MCSE: Data Platform certification. Find out more about the certification at https://www. microsoft. com/en-us/learning/mcse-sql-data-platform. aspx.

Topics include:
* Creating and altering tables
* Creating calculated columns
* Implementing advanced features like temporary tables, table variables, and compression
* Working with database views
* Ensuring data integrity through constraints
* Creating secure user accounts
* Implementing data types
* Writing stored procedures
* Creating in-memory tables
* Indexing and index optimization
* Optimizing query performance
* Designing and implementing user-defined functions (UDFs)
* Monitoring database performance
Lynda - Developing Microsoft SQL Server 2016 DatabasesLynda - Developing Microsoft SQL Server 2016 Databases

Download 百度云

你是VIP 1个月(1 month)赞助会员,

资源下载此资源仅限VIP下载,请先

转载请注明:0daytown » Lynda – Developing Microsoft SQL Server 2016 Databases

您必须 登录 才能发表评论!