EarlyBird 50% Off Coupon Code : 50PERCENTOFF (Limited Offer!!)



Course Description

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
- LINQ
- Visual Studio 2019 - Preview
- Bootstrap 4 
- Azure SQL Database
- GIT Distributed Version Control System (VCS)
- Excel CSV file
- Windows Terminal
Azure Repos - Remote Repository


Prerequisite Knowledge

- 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.


Course Curriculum


  Introduction
Available in days
days after you enroll
  Application Structure
Available in days
days after you enroll
  Domain Models, Database Context & Azure SQL Database
Available in days
days after you enroll
  CSV Helper Class & Data Seeding
Available in days
days after you enroll
  Azure Repos
Available in days
days after you enroll
  Sector Service
Available in days
days after you enroll
  Symbol Service
Available in days
days after you enroll
  Stock Price Service
Available in days
days after you enroll
  Sector Controller & View
Available in days
days after you enroll
  Symbol Controller & View
Available in days
days after you enroll
  Google Chart Visualisation Api
Available in days
days after you enroll
  Stock Price Controller, Action Methods & View
Available in days
days after you enroll
  Stock Market Data Charts
Available in days
days after you enroll
  Bonus lessons
Available in days
days after you enroll
  Source Code
Available in days
days after you enroll

Choose a Pricing Option

What students/developers say about my other courses :


Rating: ⭐⭐⭐⭐⭐
"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."

-Debayan Mitra




Rating: ⭐⭐⭐⭐⭐
"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."

-Valentine Masina




Rating: ⭐⭐⭐⭐⭐
"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+++"

-Siddhartha Dikshit




Rating: ⭐⭐⭐⭐⭐
"Thanks for making this comprehensive course. Really very helpful!"

-Sudi Dav




Rating: ⭐⭐⭐⭐⭐
"The best course of ASP.NET Core MVC in Udemy, straight to the points, no fancy tricks"

-Vinh Hoang




Rating: ⭐⭐⭐⭐⭐
"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."

-Olushola Odutola




Rating: ⭐⭐⭐⭐⭐
"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."

-George Siafa





Rating: ⭐⭐⭐⭐⭐
"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."

-Moanes Ibrahim




Rating: ⭐⭐⭐⭐⭐
"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."

-Steve Bogucki






Rating: ⭐⭐⭐⭐
프로젝트를 처음부터 훑어보면서 따라하기에는 좋습니다.

현수 김







Rating: ⭐⭐⭐⭐⭐
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