EP02 - BlazorChartJS - Create SQL Server Database
This video will cover how to setup a SQL Server Database that will be used in our Blazor Server-side project. The data from the SQL Database will be used later in this video series to build Charts from the Chart.js JavaScript library.
We'll use T-SQL to create a database called ChartStats as well as the table needed to build the Charts.
We are using Microsoft SQL Server Management Studio 2019 with a SQL Server Express installation. All software is free and is available on Microsoft's website for download. I have included the links in the description below.
Free Software Downloads from Microsoft.com:
• VS Community 2019: https://visualstudio.microsoft.com/do...
• SQL Server 2019: https://www.microsoft.com/en-us/sql-s...
Also if you missed the previous BlazorChartJS Overview video for this project, I've left the link in the below, as well as the source code to the project.
EP01 (Original) - BlazorChartJS - Server-side (.Net Core 3.1), ChartJS & SQL Server Overview / Demo:
• EP01 (Old Ver.) - BlazorChartJS - Server-s...
EP01 (Enhanced) - BlazorChartJS - Server-side (.Net Core 3.1), ChartJS & SQL Server Overview / Demo:
• EP01 (New Ver.) - BlazorChartJS - Server-s...
Complete BlazorChartJS Playlist - Blazor Server-side, Chart.js, C#, .NET Core & SQL Server:
• Blazor Server-side, Chart.js, C#, .NET Cor...
Source code: Coming soon on GitHub.
Don't forget to ... SUBSCRIBE • LIKE • SHARE • FOLLOW • COMMENT
Chapters
00:00 ... Intro, Title & Outline
01:03 ... Show SQL Server Management Studio
01:06 ... Create ChartStats SQL Server Database using T-SQL
01:47 ... Refresh Object Explorer to see ChartStats Database
02:01 ... Create Database Table named Cities
04:34 ... Refresh ChartStats Database to see Cities Table
05:04 ... Insert Test Records into the Cities Table using T-SQL
07:44 ... Write T-SQL SELECT Statement to Display Records in the Table
08:51 ... Next Video Announcement and Outro
Happy coding and thank you!
Travis
On this page of the site you can watch the video online EP02 - BlazorChartJS - Create SQL Server Database with a duration of hours minute second in good quality, which was uploaded by the user H-Impact 22 October 2020, share the link with friends and acquaintances, this video has already been watched 1,003 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
