SQL 2014 Developer, Part 7 of 13: Design and Deployment

In this course you will learn about a number of useful features in Data Tools, including its use for both online and offline database development. In online mode you can use the new SQL Server Object Explorer that provides many of the same features as Object Explorer in SQL Server’s Management Studio. You’ll see how to create databases and other objects as well as change existing objects. You’ll also see how to compare database schemas, a very useful tool used internally by the data tools that you can also use directly. In offline data base development you can create a database project using a Visual Studio template. You can ether import an existing database schema or create objects from scratch. You will see how both these modes work and see how you can publish changes to an existing database.

Lesson 1:

• Roots
• Goals for Database Edition
• Database Edition Flaws
• SQL Server Data Tools
• Kinds of Tasks
• Demo: SQL Server Data Tools
• Command-Line Tools
• Security
• Connected vs. Offline.

Lesson 2:

• Connect to an Instance of SQL
• Demo: Object Explorer
• Demo: Visual Studio vs Management Studio
• Create Server and Database Objects
• Demo: Creating Objects
• Demo: Adding Fields.

Lesson 3:

• Update a Connected Database
• Demo: Updating a Connected DB
• Demo: Executing Update Script
• Demo: Data Editor
• Demo: Changing Existing Data.

Lesson 4:

• Demo: New Objects with TSQL
• Demo: Create View in Database
• Demo: Create Stored Procedure
• Demo: Testing a Stored Procedure.

Lesson 5:

• Demo: Comparing Schemas
• Demo: Migrating Data
• Demo: Updating the Schema.

Lesson 6:

• Offline Database Development
• Create a Database
• Demo: Creating a Database
• Make Changes to DB Objects
• Demo: Changing DB Objects.

Lesson 7:

• Demo: Project Settings Tab
• Demo: SQLCLR Tabs
• Demo: Debug Tab
• Demo: Code Analysis Tab
• Demo: Publish Settings
• Demo: Publishing a Database.