CAT-Reloaded Back-End journey

This repository is to document my journey through Back-End Development with CAT-Reloaded Team. It will cover tasks and resources that would be useful for anyone seeking Back-End Development.

Week 1

Topics

  • Introduction to HTML, CSS
  • How Browser Works

Team Resources

Recommended Resources

Quiz

Week 2

Topics

  • Introduction to JavaScript
  • HTTP Protocol

Team Resources

Quiz

Week 3

Topics

  • Google Chrome Developer tools
  • Version Control Systems (Git)
  • Working with remote repositories (GitHub)

Team Resources

Recommended Resources

Quiz

Week 4

Topics

  • What is a database
  • DBMSs
  • SQL Basics & SELECT statament
  • Intro to Relational Databases and Database Terms

Team Resources

Recommended Resources

Theoritical Task

Summarization

Practical Tasks

Week 5

Topics

  • SQL Aggregations
  • Creating Tables and Constraints
  • INSERT, UPDATE, DELETE
  • Types of Database Relations
  • Database Keys

Team Resources

Recommended Resources

Theoritical Task

Summarization

Practical Tasks

Week 6

Topics

  • Database Storage
  • Foreign Keys
  • Entity Relationship Modelling
  • Database Normalization
  • Basic Queries and Wildcards
  • Unions and Joins

Team Resources

Recommended Resources

Theoritical Task

Summarization

Practical Tasks

Problems

Week 7

Topics

  • Data Types
  • Joins and Aliases in detail
  • Nested Queries
  • Triggers
  • Designing ER Diagrams and Schemas

Team Resources

Recommended Resources

Theoritical Task

Summarization

Practical Tasks

Database Implementation