SQL – Introduction

For this project, we expect you to look at this concept:

• Databases

Resources

Read or watch:

• What is Database & SQL?
• Install MySQL (MySQL Server)
• A Basic MySQL Tutorial
• Basic SQL statements: DDL and DML (no need to read the chapter “Privileges”)
• Basic queries: SQL and RA
• SQL technique: functions
• SQL technique: subqueries
• What makes the big difference between a backtick and an apostrophe?
• MySQL Cheat Sheet
• MySQL 8.0 SQL Statement Syntax

Learning Objectives

At the end of this project, you are expected to be able to explain to anyone, without the help of Google:

General

• What’s a database
• What’s a relational database
• What does SQL stand for
• What’s MySQL
• How to create a database in MySQL
• What does DDL and DML stand for
• How to CREATE or ALTER a table
• How to SELECT data from a table
• How to INSERT, UPDATE or DELETE data
• What are subqueries
• How to use MySQL functions