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/downloads/ • SQL Server 2019: https://www.microsoft.com/en-us/sql-server/sql-server-downloads 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: https://www.youtube.com/watch?v=XHWztDqqIs8 EP01 (Enhanced) - BlazorChartJS - Server-side (.Net Core 3.1), ChartJS & SQL Server Overview / Demo: https://www.youtube.com/watch?v=owwKHcv_4-w Complete BlazorChartJS Playlist - Blazor Server-side, Chart.js, C#, .NET Core & SQL Server: https://www.youtube.com/playlist?list=PL18sVs24YATWxCkJYlxSPZJxr3yYyP5Pi 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