Skip to content

ramsun/sakila-sql-queries

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

sakila-sql-queries


Purpose:

This repo includes a sample database from MySQL's website known as sakila as well as a script that makes queries to the database. The queries I made are in quries.sql.

Contents of queries.sql

This script has 8 parts, each of which composes of about 1 to 8 querries each. The goal of this script is to showcase some of the queries that can be made in MySQL. The database sakila can be downloaded directly from MYSQL's website: https://dev.mysql.com/doc/sakila/en/sakila-installation.html

Table of Contents:

  1. Basic Querries
  2. Filtering
  3. Basic DDL Commands
  4. Groupbys and More DDL
  5. Creating tables
  6. Joins
  7. Sub Queries
  8. Views

About

DDL and DML queries made to a sample saikla database provided by MySQL's website.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors