2014
Pluralsight
Deborah Kurata
3h 17m
English
Do you work with a database as part of your development tasks? This course covers the data tools available for developers within Visual Studio. These tools, called SQL Server Data Tools (SSDT) allow you to perform database tasks, create and manage database scripts, and easily deploy database changes all from within Visual Studio. Enjoy!
01. Introduction
01. Introduction.mp4
02. Managing SQL Server Objects from Visual Studio
01. Introduction.mp4
02. Connecting and Exploring.mp4
03. Databases and Tables.mp4
04. Stored Procedures.mp4
05. Data.mp4
06. Summary.mp4
03. Managing Scripts with a Database Project
01. Introduction.mp4
02. Creating a Database Project.mp4
03. Importing a Database.mp4
04. Editing Scripts.mp4
05. Setting Project Settings.mp4
06. Summary.mp4
04. Publishing Database Scripts
01. Introduction.mp4
02. Publishing to a Connected Database.mp4
03. Using a Publish Profile.mp4
04. Creating a New Database.mp4
05. What is a DACPAC .mp4
06. Deploying with a DACPAC.mp4
07. Summary.mp4
05. Scripting Data
01. Introduction.mp4
02. Creating Insert Scripts.mp4
03. Defining a Post-Deployment Script.mp4
04. Using Merge Scripts.mp4
05. Summary.mp4
06. Working with the SQL Menu Options
01. Introduction.mp4
02. Schema Comparison.mp4
03. Data Comparison.mp4
04. Query.mp4
05. Summary.mp4
07. Final Words
01. Introduction.mp4
02. Refactoring.mp4
03. Unit Testing.mp4
04. Summary.mp4
http://pluralsight.com/
Download File Size:612.19 MB