Skip to content

Latest commit

 

History

History

0x0D-SQL_introduction

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
0-list_databases.sql
0-list_databases.sql
 
 
1-create_database_if_missing.sql
1-create_database_if_missing.sql
 
 
10-top_score.sql
10-top_score.sql
 
 
100-move_to_utf8.sql
100-move_to_utf8.sql
 
 
101-avg_temperatures.sql
101-avg_temperatures.sql
 
 
102-top_city.sql
102-top_city.sql
 
 
103-max_state.sql
103-max_state.sql
 
 
11-best_score.sql
11-best_score.sql
 
 
12-no_cheating.sql
12-no_cheating.sql
 
 
13-change_class.sql
13-change_class.sql
 
 
14-average.sql
14-average.sql
 
 
15-groups.sql
15-groups.sql
 
 
16-no_link.sql
16-no_link.sql
 
 
2-remove_database.sql
2-remove_database.sql
 
 
3-list_tables.sql
3-list_tables.sql
 
 
4-first_table.sql
4-first_table.sql
 
 
5-full_table.sql
5-full_table.sql
 
 
6-list_values.sql
6-list_values.sql
 
 
7-insert_value.sql
7-insert_value.sql
 
 
8-count_89.sql
8-count_89.sql
 
 
9-full_creation.sql
9-full_creation.sql
 
 
README.md
README.md
 
 
quiz.md
quiz.md
 
 
temperatures.sql
temperatures.sql
 
 

README.md

img

sql-meme

About

SQL! Structured Query Language (SQL) is a programming language that is widely used for managing and manipulating relational databases. With its ability to extract valuable insights and data from large and complex databases, SQL has become an essential tool for businesses of all sizes. In this project, we'll dive into the basics of SQL, its key features and benefits, and how you can use it to manage your own databases. Whether you're a beginner or an experienced user, this project will provide you with a comprehensive overview of SQL and its applications. So, let's get started!

Resources

Read or watch

  1. What is a Database & SQL
  2. Basic mySQL tutorial
  3. Basic SQL statments DDL and DML
  4. Basic Queries SQL and RA
  5. SQL techniques: functions
  6. SQL techniques: subqueries
  7. What makes a big difference between backticks and apostrophe
  8. MySQL cheatsheet
  9. MySQL 8.0 Statement syntax
  10. Installing MySQL on ubuntu

Learning objectives

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

  • 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

More info

Comments for your SQL files

$ cat my_script.sql
-- 3 first students in the Batch ID=3
-- because Batch 3 is the best!
SELECT id, name FROM students WHERE batch_id = 3 ORDER BY created_at DESC LIMIT 3;
$

Install MySQL 8.0 on Ubuntu 20.04 LTS

$ sudo apt update
$ sudo apt install mysql-server
...
$ mysql --version
mysql  Ver 8.0.25-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
$

Connect to your MySQL server

$ sudo mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.25-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
mysql> quit
Bye
$

Quizes

Quiz