The Modern Web Development & MySQL Programming Bundle

This course is designed to equip students with the skills required for creating dynamic web pages using PHP and MySQL. It further equips students with the fundamentals of PHP programming, while providing them with advanced features of the language. Immerse yourself in an end-to-end full-stack development experience, as we explore user interface design, business logic, and hosting activities. By the end of this course, you will be able to build an attractive PHP application, styled using Bootstrap 4, track and manage changes with GitHub and deploy a fully data-driven application to Heroku Cloud Hosting.

• Access 39 lectures & 12 hours of content 24/7
• Setup Apache Server, PHP Environment & MySQL Database using XAMPP Server
• Understand the role of PHP in web-based programming applications
• Build data-driven & dynamic web applications
• Manipulate data using PHP PDO
• Use Bootstrap 4 Framework
• Use GitHub for source control
• Deploy a web application using Heroku

Writing modern web applications with a rich UI can be tedious. Blazor gives us .NET developers the chance to leverage our C# skills and build interactive web UIs. In this course, Modern Web Development with Blazor and .NET 5, you will gain the ability to build web applications using Blazor. We will explore: setting up your first Blazor application; how to work with an API and how data binding works; how to create components and integrate JavaScript components.

• Access 44 lectures & 8 hours of content 24/7
• Build a modern web application using Blazor
• Code first & entity framework
• Manage & track changes using GitHub
• Deploy Blazor application to Microsoft Azure
• Use Blazor & .NET 5
• Use NuGet package manager
• Understand identity core & identity server
• Get insights on custom CCS & JavaScript in Blazor

This is a zero hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Junior Database Administrator. We will explore best practices in database development using SQL Server Express 2017 (Free Edition) and will be building a small school management system database. At the end of this course, you should be comfortable writing queries for multiple situations and reports.

• Access 31 lectures & 6 hours of content 24/7
• Understand basic Database Design (tables, columns, data types, primary keys & more)
• Query related data from multiple tables
• Create relationships & foreign keys
• Use aggregate functions in SQL
• Export query results to Excel
• Create complex database objects like stored procedures, functions, views & triggers

C# is the most versatile programming language in .NET Framework and .NET Core. Not only can you build Windows client applications, but you can also use C# to build Web and mobile apps. In this course, you will learn C# programming for desktop applications. This journey will have you becoming proficient in Visual Studio interface and shortcuts, console application development with C#, data-driven graphical user interface applications using Windows Forms, and a whole lot more. By the end of this course, you will have enough knowledge to build a functional Windows Forms Application, connected to a Microsoft SQL Server Database, with all your program code and changes being tracked on GitHub.

• Access 39 lectures & 13 hours of content 24/7
• Understand how to create& run console applications
• Understand basic C# syntax - blocks of code, curly braces, comments
• Create & run Windows Forms Applications
• Know how to create Windows Forms & manipulate them (Open, Close, Hide, etc)
• Connect to & upload a project to GitHub
• Use C# operators for math & logic tasks
• Use string interpolation, concatenation & general manipulation

Learn how to build a RESTful API using ASP.Net Core API, Entity Framework, enterprise-grade practices for a scalable and future-proofed Web API solution. This course will implement various support tools for logging, documentation, security, and error handling. ASP.NET Core based on the new .NET 5 runtime, is Microsoft's modern, cross-platform framework for building enterprise-ready web applications. Here, you will learn everything you need to know about building a RESTful API using .NET Core 5, from understanding the folder structure and files to building and deploying a complete web REST API.

• Access 43 lectures & 8 hours of content 24/7
• Build a data driven API using Entity Framework & .NET 5
• Configure Cross-Origin Resource Sharing (CORS)
• Troubleshoot & fix practical errors
• Use NuGet Package Manager
• Build RESTful APIs with proper practices
• Learn C# & Visual Studio techniques
• Use AutoMapper & Data Transfer Objects (DTOs)
• Manage & track changes using GitHub