Get $1 credit for every $25 spent!

The Modern Web Development & MySQL Programming Bundle

Ending In:
Add to Cart - $19.99
Add to Cart ($19.99)
$1,000
98% off
wishlist
Courses
5
Lessons
196

What's Included

Product Details

Access
Lifetime
Content
12.0 hours
Lessons
39

Modern PHP Web Development with MySQL, GitHub & Heroku

Develop Data-Drive Web Applications Using PHP & MySQL, Manage with GitHub and Deploy to Heroku

By Trevoir Williams | in Online Courses

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.

4.6/5 average rating: ★ ★ ★ ★

  • 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
Trevoir Williams
4.5/5 Instructor Rating: ★ ★ ★ ★

Trevoir Williams is a Software Engineer and a part-time lecturer. With a Master's Degree in Computer Science, he has spent over a decade teaching Web, Software and Database Development Courses. He also have as much industry experience in Web Application Development and Azure Cloud System and Server Administration. He enjoys teaching IT and Development courses and hope to impart the latest in industry standards and knowledge to my students.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Course Outline

  • Full Course
    • Introduction - 5:54
    • Setup a PHP Environment using XAMPP - 15:39
    • Install Composer Package Manager - 2:59
    • Visual Studio Code - Web Development Add Ons - 11:31
    • Create a GitHub Account - 13:01
    • Create a Heroku Account - 8:01
    • How PHP Works - 28:52
    • IF...ELSE Statements - 18:55
    • Switch Statements - 9:07
    • FOR Loop - 10:27
    • WHILE AND DO...WHILE Loops - 14:20
    • PHP Arrays and Manipulation - 13:21
    • String Manipulation Functions - 27:42
    • Date and Time Manipulation Functions - 14:56
    • User Defined Functions - 22:15
    • PHP Include and Require - 22:08
    • PHP Website Layout - With Bootstrap - 22:48
    • Add Project to Github - 8:24
    • Publish Website to Heroku - 20:09
    • Project and Website Setup - 20:52
    • Create a Bootstrap 4 Form - 28:22
    • PHP Form - $_GET Action - 23:14
    • PHP Form - $_POST Action - 10:49
    • Design Database with phpMyAdmin - 19:02
    • Connect to Database using PHP PDO - 18:20
    • Save Records to Database - 37:55
    • View Database Records - 35:38
    • View One Record's Details - 27:55
    • Update Database Records - 33:41
    • Delete Database Records - 10:58
    • Final Touches: Form Validation, Error Messages, Success Messages - 16:41
    • Add Project to GitHub - 5:39
    • Create Heroku App and Remote Database - 20:39
    • Setup Authentication Tables in Database - 20:05
    • Setup Login and Authentication - 28:59
    • Control User Access - 8:20
    • Sending Confirmation Emails - 31:03
    • Upload Profile Pictures - 30:48
    • Final Touches - 14:18

View Full Curriculum


Access
Lifetime
Content
8.0 hours
Lessons
44

Modern Web Development with Blazor & .NET Core 5

Build a Modern Blazor Application While Implementing Enterprise Level Concepts, Design Patterns & Features

By Trevoir Williams | in Online Courses

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.

4.7/5 average rating: ★ ★ ★ ★

  • 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
Trevoir Williams
4.5/5 Instructor Rating: ★ ★ ★ ★

Trevoir Williams is a Software Engineer and a part-time lecturer. With a Master's Degree in Computer Science, he has spent over a decade teaching Web, Software and Database Development Courses. He also have as much industry experience in Web Application Development and Azure Cloud System and Server Administration. He enjoys teaching IT and Development courses and hope to impart the latest in industry standards and knowledge to my students.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Basic understanding on HTML & CSS

Course Outline

  • Course Content
    • Introduction - 1:52
    • Install Visual Studio 2019 Community Edition and .Net 5 SDK - 6:46
    • Create a GitHub Account - 2:28
    • Create Blazor Project - 7:04
    • Tour Project Files and Folders - 19:43
    • Customize Blazor Layout - 13:11
    • Creating Blazor Components - 9:01
    • Review and Add Changes to GitHub - 2:25
    • Working With Authentication and Entity Framework - 1:31
    • Understanding Authentication and Identity Server - 25:46
    • Create Database With Entity Framework Core - 21:18
    • Configure Data Seeding - 19:00
    • Seed Default User and User-Role - Compare Notes - 6:07
    • Review and Add Changes to GitHub - 3:10
    • REST API and Database Access Setup - 1:43
    • Create and Test REST API Endpoints - 18:10
    • Implement Unit of Work - 30:21
    • Refactor Existing Controllers to use Unit of Work. - 3:49
    • Refactor Existing Controllers to use Unit of Work - Compare Notes - 23:33
    • Review and Add Changes to GitHub - 2:56
    • Working with Blazor and Data - 3:37
    • Blazor Display Data - List - 26:20
    • Blazor Display Data - List - Compare Notes - 16:31
    • IMPORTANT - Fix Delete Endpoint - 1:33
    • Setup Create Form - Part 1 - 22:34
    • Setup Create Form - Part 2 - 19:26
    • Setup Update Form - Part 1 - 18:14
    • Setup Update Form - Part 2 - 9:06
    • Setup Update Form - Bookings Additional Work - 10:59
    • IMPORTANT - Fix User Audit Fields - 6:33
    • Blazor Display Data - Details - 7:40
    • Add Validation to Forms - 18:16
    • Code Clean Up and Add Changes to GitHub - 3:11
    • Using a Code-Behind Approach to Blazor Components - 6:22
    • Global Error Handling - 21:36
    • Add Changes to GitHub - 1:43
    • Customize Identity Layout and Logic - 20:55
    • JavaScript Interop With Third Party Libraries - 19:24
    • Secure JavaScript Interop With Content Security Policy (CSP)
    • File Upload Support - 26:06
    • Generic HttpClient Repository - 15:06
    • Progressive Web Application Support - 4:26
    • Add Changes to GitHub - 8:58
    • Deploy to Azure - 27:13

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
31

Microsoft SQL Server Development for Everyone

Learn the Fundamentals of Database Design, Development & Querying Using Microsoft SQL Server

By Trevoir Williams | in Online Courses

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.

4.5/5 average rating: ★ ★ ★ ★

  • 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
Trevoir Williams
4.5/5 Instructor Rating: ★ ★ ★ ★

Trevoir Williams is a Software Engineer and a part-time lecturer. With a Master's Degree in Computer Science, he has spent over a decade teaching Web, Software and Database Development Courses. He also have as much industry experience in Web Application Development and Azure Cloud System and Server Administration. He enjoys teaching IT and Development courses and hope to impart the latest in industry standards and knowledge to my students.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Course Outline

  • Your First Program
  • Full Course
    • Introduction to SQL Server and Databases - 4:08
    • Download and Install SQL Server Express 2017 - 5:21
    • Connect to Database Instance and Create a Database - 5:55
    • Drop or Remove Database - 4:16
    • What is a Database Table? - 2:08
    • Create an SQL Database Table - 31:40
    • Insert Data into the Table with SQL Script - 15:03
    • Insert Data into the Table with Management Studio - 4:33
    • Select Data from the Table with SQL Script - 9:19
    • More Advanced Select Queries Part 1 - 17:50
    • Update Data in the Table - 9:49
    • Update Data in the Table with Management Studio GUI - 2:13
    • Delete Data from the Table with SQL Script - 6:27
    • Delete Data from the Table with Management Studio GUI - 1:23
    • What are Relationships, Foreign Keys and Normalization - 11:29
    • Create a Relationship in SQL Server - 19:24
    • Insert Records in Related Tables - 12:58
    • Run Queries on Related Tables (Inner Joins) - 19:22
    • Left, Right and Full Joins - 10:41
    • Grouping Data using SQL GROUP BY Clause - 11:41
    • SQL AVG Aggregate Function - 11:00
    • SQL COUNT Aggregate Function - 3:46
    • SQL MAX and MIN Aggregate Functions - 3:29
    • SQL SUM Aggregate Function - 4:02
    • Create and Manage Views - 23:12
    • Scalar Valued Functions - 26:52
    • Inline Table Valued Functions - 9:25
    • Multi Statement Table Valued Functions - 12:28
    • Stored Procedures - 27:38
    • Table Triggers - 19:13
    • Database Scripting, Backup and Restore - 14:35

View Full Curriculum


Access
Lifetime
Content
13.0 hours
Lessons
39

C# Console & Windows Forms Development with LINQ and ADO.NET

Build a Practical Data Driven Windows Forms Application Using C#, LINQ & SQL Server Express

By Trevoir Williams | in Online Courses

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.

4.7/5 average rating: ★ ★ ★ ★

  • 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
Trevoir Williams
4.5/5 Instructor Rating: ★ ★ ★ ★

Trevoir Williams is a Software Engineer and a part-time lecturer. With a Master's Degree in Computer Science, he has spent over a decade teaching Web, Software and Database Development Courses. He also have as much industry experience in Web Application Development and Azure Cloud System and Server Administration. He enjoys teaching IT and Development courses and hope to impart the latest in industry standards and knowledge to my students.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Course Outline

  • Full Course
    • Introduction - 3:28
    • Install Visual Studio 2019 Community Edition - 3:39
    • Install .Net Core SDK - 1:31
    • Setup GitHub Account - 2:28
    • Tour Of Visual Studio - 11:05
    • Write a Simple Hello World Program - 15:06
    • Input and Output Programs - 17:47
    • C# Data Types and Conversion - 22:17
    • Operators in C# - 16:39
    • Condition Statements - 32:08
    • Repetition Statements - 27:57
    • Methods and Return Types - 26:36
    • String Manipulation Functions - 21:24
    • Handling Exceptions - 12:52
    • Classes and Objects - 37:10
    • Arrays, Lists and Other Collections - 34:55
    • Create a Simple Winforms Application (Car Rental Application) - 25:58
    • Understand Winforms Controls, Properties and Events - 21:15
    • Form Validation and Exception Handling - 34:01
    • Install SQL Server Express Edition - 5:21
    • Create Database in SQL Server - 9:36
    • Create Database Model with ADO.NET - 12:53
    • Select Data from the Database Using LINQ - 15:12
    • Submit to Database from Form - 16:46
    • Creating Additional Forms and Windows - 13:38
    • Create an MDI Application - 16:33
    • View Data In A Grid - 28:32
    • Managing Database Changes - 18:23
    • Create and Edit Records (Using one form) - 47:45
    • Activity - Add Try...Catch Logic to the forms and a Refresh Button and Logic
    • Activity - Refresh Button Code Solution
    • Vehicle Data Validations and Exception Handling - 7:07
    • Manage Car Rental Records - 45:20
    • Enhancing Application Flow and User Experience - 28:02
    • Simple Login Form - 38:59
    • Control Features Based on User Roles - 34:31
    • User Password and Active Status Reset - 20:58
    • Add New Users and Password Reset - 44:32
    • Add Project to GitHub - 19:13

View Full Curriculum


Access
Lifetime
Content
8.0 hours
Lessons
43

Ultimate ASP.NET 5 Web API Development Guide

Create a Maintainable Web API using ASP.NET Core 5, Entity Framework & Enterprise Level Design Patterns

By Trevoir Williams | in Online Courses

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.

4.5/5 average rating: ★ ★ ★ ★

  • 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
Trevoir Williams
4.5/5 Instructor Rating: ★ ★ ★ ★

Trevoir Williams is a Software Engineer and a part-time lecturer. With a Master's Degree in Computer Science, he has spent over a decade teaching Web, Software and Database Development Courses. He also have as much industry experience in Web Application Development and Azure Cloud System and Server Administration. He enjoys teaching IT and Development courses and hope to impart the latest in industry standards and knowledge to my students.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Course Outline

  • Course Content
    • Introduction - 3:49
    • Setup GitHub Account - 2:28
    • Install Visual Studio 2019 Community Edition and .Net 5 SDK - 6:46
    • Install and Explore PostMan - 9:39
    • Create and Tour Web API Project - 7:55
    • Configure Logging using SeriLog - 14:17
    • Explore Swagger UI - 10:48
    • CORS Configuration - 6:40
    • Review and Add Changes to GitHub - 4:39
    • Implement Data Classes and Entity Framework - 26:12
    • Seed Data In Tables - 8:10
    • Setup Service Repositories and Dependency Injection - 31:30
    • Setup AutoMapper and DTOs - 21:20
    • Review and Add Changes to GitHub - 3:28
    • Overview of GET Requests - 4:49
    • Construct GET Endpoint - 26:42
    • Construct GET By Id Endpoint - 9:33
    • Setup GET Endpoints For Hotels - 4:03
    • Final Touches and Add Changes to GitHub - 0:48
    • Security Overview - 6:52
    • Setup User Identity Core - 13:39
    • User Registration Endpoint - 30:19
    • IMPORTANT - User Registration Endpoint Fix - 0:56
    • Add User Roles - 10:37
    • Explore JSON Web Tokens (JWT) - 5:10
    • Implement JWT Authentication - 31:39
    • Protecting Endpoints - 8:11
    • Review and Add Changes to GitHub - 0:22
    • Construct POST Endpoint - 13:35
    • Construct PUT Endpoint - 23:38
    • Construct DELETE Endpoint - 7:24
    • Review and Add Changes to GitHub - 0:44
    • Value Added Features - 1:16
    • Implement Paging - 17:51
    • Global Error Handling - 11:25
    • Implementing API Versioning - 12:38
    • Implementing Caching - 13:49
    • Rate Limiting and Throttling - 7:15
    • Review and Add Changes to GitHub - 3:24
    • Configure Hosting Environment - 6:39
    • Publish Application to IIS and SQL Server - 24:58
    • Create Microsoft Azure Account - 7:12
    • Deploy Application and Database to Microsoft Azure - 17:27

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.