Stock Market Data Visualisation App with ASP.NET Core 5 MVC
Learn data visualisation using Google Chart API, Historical Stock Market Data, EF Core, Azure SQL Database, Git Version Control System, Azure Repos
EarlyBird 50% Off Coupon Code : 50PERCENTOFF (Limited Offer!!)
Stock Market Data Visualisation App with .Net 5
(.NET Framework + .NET Core = .NET 5)
Whether you are creating a dashboard for a line of business application or a greenfield project for a financial institution the ability to use charts to present data is crucial and it is predominantly so with stock market data.
Data Visualisation is the representation of raw data and information using visual elements like graphs and charts, for the purpose of making data more understandable and easy to analyse. This enables experts to conceptualise trends and cyclics, also to explore reoccurring and hidden patterns.
In this course, we will be using objects exposed by the Google Chart Visualisation API to build the different Charts for our Stock Market Data Visualisation App. Google Chart is a richly featured client-side charting library, however, we will be using c# server-side code to provide data in json format used by google chart datatable to populate the charts.
This project will use the latest (as of time of production) ASP.NET Core Framework which is ASP.NET Core 5 (or simply, .NET 5), Entity Framework Core 5.0.0. and Azure SQL Database.
".NET Core is an open-source, general-purpose development platform maintained by Microsoft and the .NET community on GitHub. It's cross-platform (supporting Windows, macOS, and Linux) and can be used to build device, cloud, and IoT applications." - Microsoft.
Project Technology Stack & Tools used
- C# Programming language
- .NET Core 5 (.NET 5)
- MVC (Model-View-Controller)
- Entity Framework Core 5.0.0
- Visual Studio 2019 - Preview
- Bootstrap 4
- Azure SQL Database
- GIT Distributed Version Control System (VCS)
- Excel CSV file
- Windows Terminal
- Azure Repos - Remote Repository
- C# Programming basics.
- Html & CSS fundamentals.
What will I learn ?
Implement multi-layered architecture and their dependencies on each other.
Using .net core Class Libraries.
Downloading free historical Stock Market Data in a CSV file.
Database Seeding with downloaded data.
Write CsvHelper class for reading data from a csv file (no third-party library used).
Implementing several business logic.
Creating Interfaces and their Implementations.
Creating Controllers, Injecting Interfaces in Controllers.
Receiving data from request to Controllers.
Registering a Service for Dependency Injection (DI).
Passing data from Controllers to View.
Tracking changes in project files using GIT.
Creating Action Methods, Action Methods with Parameter.
Create Entity Data Model.
Query Entity Data Models using LINQ - Inserting, Updating, Retrieving, Filtering, Ordering etc....
Using ViewModels, access a ViewModel object.
User Input Data Validation.
Understanding Domain Classes vs ViewModel classes.
Model Binding & Mapping.
Creating a Layout View (Master Page).
Create the Entity Framework (EF) Core Context.
Using EF Core to initialize the database.
Configure EF Core to use SQL Server.
Setting up Microsoft Azure SQL Server Database & Subscription on Azure portal.
Configure connectionStrings in AppSetting.json file (for remote SQL Server Databases).
Using Azure Repos as a remote Source Code repository.
What students/developers say about my other courses :
"I was new to Core and this course is such a fantastic guide step by step how to create a Core application in a short time is really amazing. The reason this course stands out is because it demonstrates using each and every step for a real world enterprise application design standpoint. I mean consider the example where we could easily hardcode the DB connection string in OnConfiguring method in DBContext (which I found in most of the courses of EF core btw). This course even though primarily teaches Core MVC also focused on this point which I can leverage in other projects how to use a singleton DBContext object in other libraries. There are several other concepts explained in a similar fashion.
Thanks Everest for such a fantastic course!! Teaching some new technology is easy. Teaching it in the right way which can be leveraged right away in projects that is something exceptional."
"The course is very detailed. There are a lot of key take aways you may have and for me it was understanding of asp.net enterprise architecture, code first approach, an overview of the entity framework. I have used the approach for my next project.
Its one course I am definitely finishing for the first time. I love the fact that as ASP.net core moved from 2.2 to 3.0 a few things were depreciated and the instructor explains everything."
"Finally, I have completed the course, a very good real-life focused course. The Async part was very well explained, Specially the layering concept with dependency injection, Very clean coding concept everything very well explained. After completion of this course, u can be ready to become a real-world professional developer. The instructor Mr. Everest Nwosu is very clear in explaining and responsive. I'm very satisfied. A+++"
"Thanks for making this comprehensive course. Really very helpful!"
"The best course of ASP.NET Core MVC in Udemy, straight to the points, no fancy tricks"
"As a long-term JavaEE developer looking at .NET Core API features, this is perfect for what I was looking for. A practical approach to implementing layered architecture in .NET Core."
"Don't judge a book by its cover (popular saying). You might not like his accent but his knowledge is exceptional. What MVC ASP.NET Core all about? well this course is the right place to find out. It encapsulate the core idea of ASP.NET core really well. I was looking for a course that will not only show me this is Model View and Controllers. The example used in this course is very much applicable in any project and at the end of the course you'll be able to build your own site to add to your portfolio. I've been able to learn how to structure data which is missing in other courses I have done here. It's a little advanced for absolute beginner but would be best practice if you're a beginner rather than getting used to the messy way of doing things.
I like the occasional errors within the course which you can watch the instructor resolve. Now if you're programming enough you'll know bug is a common thing and being able to resolve gives a sense of fulfillment.
I'll definitely be building a lot on my own now after taking this course which is why I would recommend you take it as well as you won't regret. I have always ask for refund on other course but with this course I did not ask for refund and kept interest all the way through. Very well put together! Nice explanation and easy to follow.
Thanks instructor and please keep up bring more course."
"This course is amazing, easy to follow , focused on professional material, The instructor is very helpful and always respond to questions ASAP and offers solution for each problem. This is the course you should take if you looking to learn ASP/EF core in a professional way to build your own solutions. Thanks again for this course and I hope to see other courses specially in UI like Synfusion UI/ JQwidgets and how to integrate it with the EF Core and SQL server."
"Compared to other .NET videos, this project does the best of separating concerns - entities from services from database layer. But, doesn't do a whole lot of explaining of concepts. That said, if you have experience building simple .NET apps and want to follow along while building something moderately more complex, this tutorial provides exactly that learning experience."
프로젝트를 처음부터 훑어보면서 따라하기에는 좋습니다.
It is an amazing for someone with beginners knowledge and interested in knowing how real world applications are built. I would rate it A++.
-Muhammad Asad Jalil
Showcased below are other course(s) you might be interested in.