Mastering Full Stack Development : Frontend to Backend Excellence

Introduction

Getting started on Windows, macOS, and Linux

How to ask great questions

FAQ’s

Understanding the role of a full-stack development

Introduction to front-end, back-end, and database technologies

What is ChatGPT

Set up an account with ChatGPT

How to use ChatGPT

ChatGPT for your day-to-day tasks

HTML5 and CSS3 fundamentals

Using ChatGPT to create HTML5 source code

Using ChatGPT to create CSS3 source code

Installing code editor – Sublime Text

HTML – heading

HTML – paragraph

HTML - formatting text

HTML – forms

HTML – tables

HTML – navbar / menu

HTML – div tag

HTML5 – audio

HTML5 – video

HTML5 – drag and drop

HTML5 – iframe

HTML5 – YouTube video setting

HTML5 – registration form

HTML5 – login form

Coding exercise

Solution for a coding exercise

CSS – creating a webpage with CSS

CSS – Inline CSS

CSS – Internal CSS

CSS – External

CSS – Classes

CSS - id

CSS – colors

CSS – backgrounds

CSS – padding

CSS – borders

CSS – box model

CSS – forms

CSS – Website Layout

CSS – Rounded Corners

CSS – pseudo classes

CSS – gradients

CSS – shadows

CSS – button styles

CSS – creating flexbox

CSS – creating grids

CSS – social media icons

CSS – coding exercise

CSS – solution for coding exercise

Introduction to the frontend JavaScript Scripting language

Using ChatGPT to create JavaScript source code

JavaScript First program

Variables

Data types

Internal JavaScript

External JavaScript

Inline JavaScript

Async and defer

String formatting

String methods

Use ChatGPT for DOM string manipulation

Comparison operators

Logical operators

If statements

If-else statements

Switch-case statements

Use ChatGPT for DOM decision making

While Loop

For Loop

Use ChatGPT to create list of items

Coding Exercise

Solution for Coding Exercise

Create a Function

Function call()

ChatGPT to create a function with arguments

Error Handling – Try-catch

Error Handling – Try-catch-finally

Login form validations

Use ChatGPT to ES6 arrow functions

Use ChatGPT to ES6 Classes

Introduction to server-side programming languages

Using ChatGPT to create Python source code

Python installation step by step

PyCharm code editor installation

Getting started, PyCharm code editor

First “Hello World”

Use ChatGPT to write variables

Use ChatGPT to write data types

Use ChatGPT to type casting

Use ChatGPT to write strings

Use ChatGPT to learn operators

Use ChatGPT to write if-else statements

Use ChatGPT to write while loop

Use ChatGPT to write for loop

Use ChatGPT to write a nested loop

Exercise and Solution for Pyramid Pattern

Use ChatGPT to write functions

Use ChatGPT to Overview Object Oriented Programming

Use ChatGPT to write class object programs

Use ChatGPT to write polymorphism

Use ChatGPT to write abstract classes

Use ChatGPT to write encapsulation

Use ChatGPT to write validations

Introduction to MySQL database system

Using ChatGPT to get SQL Query solutions

MySQL Installation

Connect MySQL Server instance

MySQL Workbench overview

Get a Sample Database and Restore

Overview of databases

Create database

SQL Data types

Creating table

EER – Enhanced Entity Relationship Diagrams

DML - INSERT statement

DML - UPDATE statement

DML - DELETE statement

DDL - CREATE table statement

DDL – DROP statement

DDL – ALTER statement

DDL – TRUNCATE statement

DCL – CREATE database user

DCL – GRANT permissions

DCL – REVOKE permissions

SELECT statement

DASHBOARD Analytics

What are JOINS

SQL – INNER JOIN

SQL – LEFT JOIN

SQL – RIGHT JOIN

SQL – UNION statement

CERTESIAN Product or CROSS Join

CHECK constraint

UNIQUE constraint

Creating views

Data Analytics view from multiple tables

Timestamp

Advanced functions

Sub Queries

SELECT with calculations

Create stored procedures

Stored procedures with parameters

Import .csv file

Export data to .csv file

Create Database backup

Restore Database backup

Exploring backend frameworks

Using ChatGPT to create source code

Introduction to web framework and Django

Installing Django and setting up a project

Understanding Django architecture and structure

Creating a Django app

Installing PostgreSQL server

pgAdmin secure login and create a database

Connecting Django to PostgreSQL

Creating HTTP view method

URL pattern on app

Include apps to project urls

Installing the psycopg2 module for database drivers

Writing models and creating database tables

Applying ORM to communicate database tables

Migrations to Database tables

Creating Superuser as Admin

Authentication and Authorization

User access permissions

CRUD functionality

Creating views methods for requests and responses

Creating HTML template page

Building Dynamic form handling

Project – Creating model

Project – Creating forms

Project – Creating views

Project – Applying ORM – migrations

Project – my_form template

Project – Adding urls

Project – Creating success_view template

Project – Urls update and adding apps to project

Project – Run and submit data to database

Introduction to web framework and Django

Installing Django and Django framework

Django(CORS) installation

Creating Django project

Creating Django application

Registering the app to project

Postman API platform installation

Building Django models for the REST API data structures

Installing psycopg2 module for Database connection

Database connection Django to PostgreSQL

Applying Migrations for PostgreSQL

Serializers in Django REST API

Serializing data with Django REST Framework serializers

Import required modules to write API methods

Implement API GET method using REST framework

Implement API POST method using REST framework

Implement API PUT method using REST framework

Implement API DELETE method using REST framework

Writing App URLs and path setting

Write Project URLs and include app

API GET method testing

API POST method testing

API PUT method testing

API DELETE method testing