SQL General Rules | Get Arrays

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Full Stack Spring Boot API with Angular (ADVANCED)

Introduction

Application Demo (44:55)
Architecture Design (12:00)
Software Requirements (4:50)
About this Course (4:11)
Creating Spring Boot Application (2:00)
Run Spring Boot Application (6:57)
Source Code

Data Modeling - Forward Engineering

Introduction (6:19)
Modeling Tools (2:33)
Application Requirements (9:27)
Conceptual Model (4:46)
Logical Model (4:09)
Physical Model (8:10)
Foreign Key Constraints (2:59)
Forward Engineering (4:47)

Data Modeling - Reverse Engineering

Introduction (4:18)
SQL General Rules (4:17)
User Table (8:47)
User Role Table (7:55)
User Event Table (6:17)
Account Verification Table (4:27)
Reset Password Verification Table (1:55)
Two Factor Verification Table (4:02)
Run Application Schema (2:17)
Reverse Engineering with MySQL Workbench (3:51)

User Registration Feature

User Repository Interface (4:27)
User Class (5:08)
User Repository Implementation - Part 1 (5:46)
User Repository Implementation - Part 2 (4:20)
User Repository Implementation - Part 3 (6:00)
User Repository Implementation - Part 4 (6:25)
User Repository Implementation - Part 5 (8:03)
User Repository Implementation - Part 6 (10:27)
User Repository Implementation - Part 7 (1:35)
User Repository Implementation - Part 8 (10:02)
User Repository Implementation - Part 9 (6:32)
User Service - Part 1 (8:13)
User Resource - Part 1 (7:06)
User Resource - Part 2 (5:55)
Populate Roles Table (3:19)
Debugging and Testing (14:19)

Application Profiles

Profiles Setup (13:22)
Customizing Banner (6:17)

Spring Security

Introduction (10:22)
Security Configuration - Part 1 (5:19)
Security Configuration - Part 2 (5:36)
Security Configuration - Part 3 (15:28)
Security Configuration - Part 4 (6:11)
Security Configuration - Part 5 (3:50)
Security Configuration - Part 6 (3:49)
Security Configuration - Part 7 (7:38)
Security Configuration - Part 8 (10:15)
Testing Login Method (13:13)
Spring Security Update - Feb 11th 2024 (8:54)

Login Functionality

Review Architectural Design (1:20)
Verification Code - Part 1 (15:29)
Verification Code - Part 2 (7:16)
Verification Code - Part 3 (4:28)
Login Flow Review (3:57)
Token Provider - Part 1 (7:59)
Token Provider - Part 2 (6:22)
Token Provider - Part 3 (6:58)
Login Test with Token (11:20)
Verify Code (11:14)
Login Test with Code (10:11)
Code Refactoring (14:30)
Login Test after Refactoring (5:53)

Authorization Filter

Introduction (3:46)
Authorization Filter - Part 1 (11:34)
Authorization Filter - Part 2 (9:36)
Authorization Filter - Part 3 (10:32)

Exception Handling

Exception Handling - Part 1 (9:16)
Exception Handling - Part 2 (4:23)
Exception Handling - Part 3 (7:06)
Exception Handling - Part 4 (5:00)
Testing Exception Handling (2:16)
Overriding White Label Error Page (8:13)
Code Refactoring (10:40)
Testing Refactored Code (3:04)

Reset Password Feature

Introduction (2:40)
Reset Password - Part 1 (10:08)
Reset Password - Part 2 (4:33)
Reset Password - Part 3 (8:52)
Reset Password - Part 4 (2:54)
Reset Password - Part 5 (8:07)
Reset Password - Part 6 (5:33)

Account Verification

Account Verification - Part 1 (12:36)
Account Verification Test - Part 2 (3:25)

Refresh Token

Refresh Token - Part 1 (4:02)
Refresh Token - Part 2 (5:41)
Refresh Token Test (4:35)

Front End Application

Introduction (4:21)
Software Requirements (6:48)
Creating Angular App (2:48)
Main Components (2:52)
Routes Configuration (5:46)
Bootstrap Setup (3:32)
Login Page HTML Markup (4:43)
Login State (5:14)
Mapping HTTP Response (5:37)
User Service Login Function (10:05)
Login Form Template - Part 1 (15:14)
Login Form Template - Part 2 (8:10)
Login Form Template - Part 3 (4:58)
Login Form Template - Part 4 (5:15)
User Service Verify Code (4:04)
Test Login - Part 1 (11:21)
Test Login - Part 2 (2:23)
Test Verify Code (8:42)
Source Code (Angular app - no logic)

User Profile - User Information

Angular Module (4:03)
More Routes Configuration (4:58)
Homepage HTML Template (4:13)
Navigation Bar HTML Template (3:54)
Bootstrap JavaScript Update (2:22)
Profile HTML Template (3:05)
Profile Overview (5:42)
User Profile Page Data Mapping (6:21)
User Profile State (8:10)
Subscribing to Observables (3:43)
Hard Coded Token (for test only) (2:50)
Fetch User Profile Information (6:21)
User Profile Information - Part 1 (7:03)
User Profile Information - Part 2 (3:38)
User Profile Information - Part 3 (3:51)
User Profile Information - Part 4 (5:08)
Update User Profile - Part 1 (4:45)
Update User Profile - Part 2 (5:48)
Update User Profile - Part 3 (2:07)
Update User Profile - Part 4 (6:31)
Add User ID as Token Subject (10:35)
Update User Profile - Part 5 (8:54)
Fixing CORS Error (7:38)
Source Code

Authorization Interceptor

Interceptor Introduction (8:16)
JWT Token Interceptor - Part 1 (7:21)
JWT Token Interceptor - Part 2 (9:12)
JWT Token Interceptor - Part 3 (4:12)
JWT Token Interceptor - Part 4 (5:10)
JWT Token Interceptor - Part 5 (4:20)
JWT Token Interceptor - Part 6 (3:57)
JWT Token Interceptor - Part 7 (11:11)
JWT Token Interceptor - Part 8 (5:20)
JWT Token Interceptor - Part 9 (10:22)
Source Code

User Profile - Update Password

User Update Password - Part 1 (9:23)
User Update Password - Part 2 (6:05)
User Update Password - Part 3 (4:51)
User Update Password - Part 4 (3:24)
User Update Password - Part 5 (8:25)
User Update Password - Part 6 (8:11)
Source Code

User Profile - Authorization

User Role Update - Part 1 (6:47)
User Role Update - Part 2 (11:45)
User Role Update - Part 3 (4:56)
User Role Update - Part 4 (6:13)
User Role Update - Part 5 (2:41)
Source Code

User Profile - Account Settings

User Account Settings - Part 1 (8:15)
User Account Settings - Part 2 (5:11)
Source Code

User Profile - Multi-Factor Authentication

Multi-Factor Authentication - Part 1 (7:50)
Multi-Factor Authentication - Part 2 (8:49)
Source Code

User Profile - User Profile Image

User Profile Image Update - Part 1 (11:26)
User Profile Image Update - Part 2 (3:00)
User Profile Image Update - Part 3 (7:01)
User Profile Image Update - Part 4 (7:03)
User Profile Image Update - Part 5 (8:58)
Source Code

User Profile - Account Activities

User Account Activities - Part 1 (5:35)
User Account Activities - Part 2 (4:05)
User Account Activities - Part 3 (4:42)
User Account Activities - Part 4 (3:57)
User Account Activities - Part 5 (9:35)
User Account Activities - Part 6 (5:50)
User Account Activities - Part 7 (5:14)
User Account Activities - Part 8 (6:20)
User Account Activities - Part 9 (3:14)
User Account Activities - Part 10 (8:48)
User Account Activities - Part 11 (4:21)
User Account Activities - Part 12 (7:42)
User Account Activities - Part 13 (6:26)
User Account Activities - Part 14 (6:52)
User Account Activities - Part 15 (15:18)
Source Code

User Profile - Clean Up

Authenticated User (7:08)
Authentication Check (4:18)
Source Code

Route Configuration Guard

Authorization Route Guard - Part 1 (6:03)
Authorization Route Guard - Part 2 (3:14)
Navigation Bar User Data (9:46)
Source Code

Customer and Invoice API

Application Requirements Review (2:04)
Customer Domain Model (2:08)
Invoice Domain Model (2:38)
Customer Invoice JPA Mapping (4:54)
Customer Service (4:12)
Customer Service Implementation - Part 1 (1:28)
Customer Repository (2:43)
Customer Service Implementation - Part 2 (7:20)
Customer Resource - Part 1 (6:09)
Customer Resource - Part 2 (3:05)
Customer Resource - Part 3 (4:59)
Customer Resource - Part 4 (6:56)
Customer Resource Testing (5:00)
Source Code

Customer Home Page

Customer Service (3:21)
Home Component - Part 1 (2:56)
Home Component - Part 2 (4:07)
Home Component - Part 3 (4:50)
Home Component - Part 4 (6:10)
Home Component - Part 5 (2:35)
Home Component - Part 6 (6:49)
Home Component - Part 7 (6:32)
Home Component - Part 8 (8:31)
Source Code

Home Page Statistics

Home Page Statistics - Part 1 (3:45)
Home Page Statistics - Part 2 (1:37)
Home Page Statistics - Part 3 (5:26)
Home Page Statistics - Part 4 (2:04)
Home Page Statistics - Part 5 (6:27)
Source Code

New Customer

New Customer - Part 1 (3:50)
New Customer - Part 2 (3:24)
New Customer - Part 3 (1:50)
New Customer - Part 4 (7:08)
New Customer - Part 5 (4:40)
New Customer - Part 6 (7:32)
Source Code

Search Customer

Search Customer - Part 1 (4:39)
Search Customer - Part 2 (8:26)
Search Customer - Part 3 (2:55)
Search Customer - Part 4 (11:24)
Source Code

Customer Detail

Customer Detail - Part 1 (5:34)
Customer Detail - Part 2 (2:14)
Customer Detail - Part 3 (9:16)
Customer Detail - Part 4 (2:45)
Customer Detail - Part 5 (11:44)
Customer Detail - Part 6 (9:48)
Source Code

New Invoice

New Invoice Template and Service (4:53)
Loading New Invoice Page Information (1:45)
New Invoice Template From (7:26)
New Invoice Component Request (5:04)
Saving a New Invoice (4:09)
Displaying New Invoice Message (3:03)
Source Code

All Invoices

Invoices Template and Service (8:07)
Displaying All Invoices (6:30)
Source Code

Downloading Invoices as PDF

Invoice Template (2:11)
Invoice Service (6:19)
Showing Invoice Information (13:06)
Downloading Invoice as PDF (13:07)
Source Code

Extract Array Value Pipe

Creating an Angular Pipe (3:52)
Pipe Number Implementation (5:45)
Pipe Invoice Array Implementation (8:07)
Source Code

HTTP In Memory Cache

HTTP Cache Service - Part 1 (4:42)
HTTP Cache Service - Part 2 (6:45)
HTTP Cache Interceptor - Part 1 (4:03)
HTTP Cache Interceptor - Part 2 (6:52)
Using HTTP In Memory Cache - Part 1 (6:40)
Using HTTP In Memory Cache - Part 2 (4:37)
Source Code

Customer Excel Report

Creating Report Fields (6:23)
Creating Report Headers (6:28)
Adding Customers to Report (6:06)
Creating Report Endpoint (6:15)
Downloading Report in Postman (4:31)
Updating Customer Creation Date (4:05)
Report Service (3:36)
Calling Report Service (5:39)
Reporting File Download Progress (6:34)
Downloading and Saving Excel Customer Report (8:01)
Source Code

Register New Account

Introduction (1:37)
Create Account Service (1:16)
Create Account State (5:58)
Create Account Template (1:34)
Implementing State Logic (4:07)
Create Account Form (2:47)
Creating a New Account (3:47)
Resetting New Account State (8:09)
Source Code

Reset Password Request

Introduction (1:20)
Reset Password Service and State (2:54)
Sending Reset Password Request (8:51)
Source Code

Verifying Account and Password

Verify Account and Password Service (3:09)
Verify Account and Password State (5:31)
Intercepting Key and Account Type - Part 1 (6:28)
Intercepting Key and Account Type - Part 2 (5:44)
Verify Account and Password Template (5:55)
Verify Account and Password Error Handling (2:43)
Verify Account and Password Loading Template (5:36)
Refactoring Reset Password Endpoint (5:32)
Reset Password Service (6:10)
Reset Password Successful Response (4:16)
Verify Password Form (7:42)
Resetting User Password (6:25)
Source Code

Verification Email

Verification Email Service (2:47)
Verification Email Service Implementation - Part 1 (5:30)
Verification Email Service Implementation - Part 2 (3:16)
Email Configuration (4:44)
Using Email Service in Separate Thread (5:33)
Creating a New Account with Email (2:55)
Refactoring New Thread Service Call (5:59)
Sending Text Message in Separate Thread (Assignment) (4:50)
Source Code

Angular Modules

Introduction (3:26)
Module Architecture (4:57)
Core Module (6:53)
Shared Module (7:53)
Authentication Module (10:02)
Customer Module (7:44)
Home Module (3:24)
Invoice Module (4:56)
Navigation Bar Module (5:03)
Profile Module (3:37)
Statistics Module (2:15)
Routing Module (3:12)
Modular Application (5:39)
Lazy Loading (8:29)
Change Detection Strategy (4:23)
Source Code

Notification Module

Introduction (4:14)
Notification Module Configuration (5:37)
Notification Service - Part 1 (4:06)
Notification Service - Part 2 (2:24)
Using Notification Service (5:00)
Testing Notification (9:22)
Source Code

Code Cleanup

Updating Spring Boot (8:07)
Constant Class (6:02)
Refactoring User Principal (7:03)
Fixing Typo (7:03)
Running the Application (1:18)
Source Code

Docker - Back End Deployment

Intro (6:05)
Environments Variables (8:50)
Development Configurations (8:40)
Using Environment Variables (4:32)
Dockerfile (12:37)
Docker Compose (6:22)
Env File (2:49)
Environment Specific Env Files (7:32)
Starter Script (5:57)
Docker Deployment (18:06)
Source Code

Docker - Front End Deployment

Introduction (0:35)
Dockerfile (11:10)
Docker Ignore (3:11)
Building Bundles (5:31)
Environment (7:17)
Docker Compose (2:41)
Common JS Dependency (3:40)
Run Container (7:44)
Nginx Not Found (5:42)
Nginx Config (7:14)
Source Code

CI/CD Pipeline - AWS

CI/CD Pipeline Overview (2:47)
Creating Demo Application (5:01)
Github Repository (1:54)
ECR Repository (4:21)
Code Build Project (5:37)
Dockerfile (Updated) (1:38)
Build Spec File (7:47)
Running Project Build (6:13)
Cluster and Service (6:35)
Load Balancer (4:12)
Running Tasks (8:11)
CI/CD Pipeline (14:44)

Teach online with

SQL General Rules

Complete and Continue