SQL Server Data Tools for Visual Studio

Focused View

Walt Ritscher

2:54:10

357 View

[1] Introduction

[1] Work with your SQL Server databases from Visual Studio.mp4

00:58

[2] What you should know.mp4

01:33

[3] Further lessons and examples.mp4

00:34

[4] The programming setup and configuration.mp4

02:51

[5] How to access the sample code on GitHub.mp4

02:05

[2] 1. Overview

[1] Why developers need SSDT.mp4

06:14

[2] DACPAC and BACPAC files.mp4

02:46

[3] SQL Server and Azure Database versions.mp4

04:30

[4] Why LocalDB is essential for developers.mp4

03:33

[5] Connected and disconnected workflows with SSDT.mp4

05:17

[6] Install the SQL Server Data Tools (SSDT).mp4

04:11

[3] 2. Connect to a Database

[1] The SQL Server Express course databases.mp4

03:40

[2] The Azure SQL course databases.mp4

04:05

[3] SQL Server Object Explorer (SSOE).mp4

01:27

[4] The LocalDB named instances.mp4

03:25

[5] Connect to network or cloud SQL database.mp4

04:21

[6] Create Visual Studio data project and use disconnected workflow.mp4

04:32

[7] Connect to SQL Server Express in Server Explorer.mp4

03:39

[8] Use logical name for readability.mp4

02:09

[4] 3. SQL Server Object Explorer

[1] Copy database files.mp4

01:49

[2] Reconnect the databases.mp4

00:45

[3] Tour the Table Designer.mp4

03:39

[4] Add a column to a table.mp4

01:28

[5] Update the connected database with table modifications.mp4

04:09

[6] Handling errors in table updates.mp4

03:27

[7] Understand the Power Buffer.mp4

01:57

[8] Update multiple edits to the connected database.mp4

02:40

[5] 4. Work with Table Data

[1] View data in the table data grid.mp4

02:41

[2] Sort data in the table data grid.mp4

01:01

[3] Filter data in the table data grid.mp4

02:19

[4] Edit data in the table data grid.mp4

02:56

[5] Add and delete rows in the table data grid.mp4

01:04

[6] 5. More Table Operations

[1] Add and remove tables.mp4

02:14

[2] PRIMARY KEY and other column settings.mp4

02:18

[3] FOREIGN keys and tables.mp4

01:45

[4] Add CHECK constraints.mp4

02:42

[7] 6. Queries, Views, and Stored Procedures

[1] Use the query window.mp4

02:25

[2] Write a SELECT query.mp4

04:09

[3] Write a CREATE TABLE query.mp4

01:51

[4] Work with existing views.mp4

03:51

[5] Create a custom view.mp4

02:14

[6] Work with existing stored procedures.mp4

03:57

[7] Call a stored procedure with parameters.mp4

02:37

[8] Debug a stored procedure.mp4

02:59

[9] Create a custom stored procedure.mp4

02:23

[8] 7. Compare Databases

[1] Prepare to compare databases.mp4

01:24

[2] Create a Data Compare session.mp4

02:54

[3] Analyze the Data Compare information.mp4

02:22

[4] Update the data in the target database.mp4

02:44

[5] Create a Schema Compare session.mp4

01:52

[6] Analyze Schema Compare for object definitions changes.mp4

00:59

[7] Update the schema in the target database.mp4

02:06

[8] Preventing data loss in a schema update.mp4

02:19

[9] 8. SQL Server Data Project

[1] Databases and the project lifecycle.mp4

02:09

[2] Understand the data project template.mp4

01:44

[3] Create a data project.mp4

02:43

[4] Examine the SQL Server object types.mp4

02:17

[5] Add items to project.mp4

02:51

[6] Import schema from a .dacpac file.mp4

03:09

[7] Import schema from a connected database.mp4

01:29

[8] Change a table or other data item.mp4

01:28

[9] Build the project.mp4

03:00

[10] Auto-mount the database on project open.mp4

01:55

[11] Auto-populate the data items on project debug.mp4

02:19

[12] Refactor a database object.mp4

02:25

[13] Compare the data project with other databases.mp4

01:14

[14] Create snapshot DACPAC files.mp4

01:05

[10] Conclusion

[1] Next steps.mp4

00:32

Description

Data and databases are an important component in most applications. While developers have access to a wide choice of data sources, Microsoft SQL Server remains a popular relational database choice. In this course, Walt Ritscher looks at the Visual Studio tooling available for creating, modifying, and using SQL Server databases. He shows how to connect to databases and work with data on enterprise servers, in the Azure cloud, and even to the special LocalDB developer databases included in Visual Studio. With the Visual Studio tools, developers can perform necessary tasks without needing the admin-focused SQL Server Management tool on their developer computer. Essentially, Visual Studio removes unnecessary features like admin tools, and focuses on tools that are useful for developers, like database and schema comparison tools. Join Walt in this course to learn to develop, build, test, and publish your database from a source-controlled project, just like you develop your application code.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Visual Studio Code

Walt Ritscher

Instructor's Courses

I am a seasoned trainer, writer, and speaker who loves learning technology and sharing my discoveries with other technology enthusiasts. My enthusiasm for crafting software interfaces blossomed early. Just a few days after discovering how to move pixels around a computer screen I was devouring books on the topic of computer graphics and UI design. Teaching programming and UI design is one of my ongoing passions. I've taught hundreds of courses for universities, colleges, and private training companies. On the consulting side I've had the opportunity to work with customers like UPS, HP, Intel, Wintellect and Intuit. Now I'm a senior staff instructor at LinkedIn Learning. My content team produces hundreds of technical training courses for software developers each year. I'm creating courses on Microsoft developer tools and topics. I love speaking at tech conferences, I'm a frequent speaker at major industry events in Europe, Asia and the Americas. I received the Microsoft MVP award for thirteen years (2005-2018) I joined the ranks of video authors in 2002, producing a small series of .NET videos for Microsoft Press. 2010 saw my first video course on Lynda.com. Now I have hundreds of hours of video training courses available at LinkedIn Learning. My current UI obsession revolves around the Windows 10 and XAML based languages. If you want to know more about XAML based pixel shaders check out my "HLSL and Pixel Shaders for XAML Developers" book available from O'Reilly Media. I'm also a big fan of keyboard synthesizers, digital music and music production. Specialties: smart client , device and web UI technologies, audio and music production, writing, speaking, curriculum development, teaching.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.