Course Presentation
  • What is SQL?
  • What is a database?
  • What is a table?
Installing the necessary software
  • Installing MySql Server & MySql Workbench
Data types
  • What data types can we work with?
How to create and alter a database
  • CREATE DATABASE & CREATE TABLE - theory
  • CREATE DATABASE & CREATE TABLE - practice
  • ALTER TABLE - modify a table structure - theory
  • ALTER TABLE - modify a table structure - practice
  • Unique identifiers
  • AUTO_INCREMENT
Inserting data
  • INSERT : inserting data in our tables - theory
  • INSERT : inserting data in our tables - practice
Reading data
  • SELECT- reading data from our tables - theory
  • SELECT- reading data from our tables - practice
Filtering data
  • WHERE - theory
  • WHERE - practice
Modifying data
  • UPDATE- updating data in our tables - theory
  • Settings
  • UPDATE- updating data in our tables - practice
Deleting data
  • DELETE - deleting our table data - theory
  • DELETE - deleting our table data - practice
Become a Software Developer!
  • Employment Program + Gift