Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Visual Studio Intermediate: SQL
Learn how to connect, navigate, and consume data from a SQL backend datastore using Microsoft Visual StudioPreview the first lesson free — get full access to all 5 lessons.
Intermediate Provider : Mark Young 5 Lessons · 24m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
In modern software systems, the need for an external data storage solution is often universal. These storage systems play a vital role in preserving crucial data, including user information, application state, and application configuration, as well as other critical components. Microsoft Visual Studio offers robust support for a diverse range of external data storage types. By harnessing the rich ecosystem of storage options available within Visual Studio, developers can seamlessly integrate and manage data within their software applications.
In this course, we will explain the main difference between relational and non-relational databases and discuss the concept of data providers. You will also learn how to navigate and use the SQL-related tools available within Microsoft Visual Studio to connect to a SQL database. By the end of this course, you will be able to explain the differences between data storage types and identify the data storage facilities best suited for your team’s development needs.
What You'll Learn
- Describe the differences between external data storage mechanisms used for software applications
- Explain the distinction between relational and non-relational databases
- Understand the purpose of different data providers
- Connect to a SQL database using the SQL-related tools within Microsoft Visual Studio
- Understand the purpose and details of connection strings
- Troubleshoot SQL-related configuration issues
Key Takeaways
- In modern software systems, external data storage solutions are often universal and play a vital role in preserving crucial data such as user information, application state, and application configuration.
- Microsoft Visual Studio offers robust support for a diverse range of external data storage types, letting developers integrate and manage data within their applications.
- The course explains the main difference between relational and non-relational databases and introduces the concept of data providers.
- Learners use the SQL-related tools available within Microsoft Visual Studio to connect to a SQL database.
- By the end of the course, learners can explain the differences between data storage types and identify the data storage facilities best suited for their team's development needs.
Frequently Asked Questions
What does this course cover?
It explains the main difference between relational and non-relational databases, discusses the concept of data providers, and shows how to navigate and use the SQL-related tools within Microsoft Visual Studio to connect to a SQL database. Lessons include Databases Overview, Connecting to a SQL Database (Parts 1 and 2), Understanding Connection String Details, and Troubleshooting SQL-Related Configuration Issues.
What will I be able to do after completing this course?
By the end, you will be able to explain the differences between data storage types and identify the data storage facilities best suited for your team's development needs, including understanding data providers and connection strings.
What skills does this course help develop?
It covers Database Development, Database Programming, SQL (Programming Language), SQL Azure, SQL Server Management Studio, and Sql2016.
Who is this course suited for?
It is suited for developers who need to integrate and manage data within their software applications using Microsoft Visual Studio's support for external data storage types.
