TIL

TIL

  • Docs
  • Contact
  • Feedback
  • Contribute

›Week 9

Getting Started

  • Introduction

Principles of Programming Languages

    Week 3

    • Pattern Matching and Recursive Data Types

    Week 8

    • Monads

Introduction to Databases

    Week 3

    • Cinema Database

    Week 4

    • Pine Valley Furniture
    • Pine Valley Furniture - Solution

    Week 5

    • ERD to Shorthand Conversions
    • ERD to Shorthand Conversions - Solution

    Week 6

    • Normalizations
    • Normalizations - Solutions

    Week 7

    • Other Normal Forms
    • Other Normal Forms - Solutions

    Week 8

    • SQL Introduction

    Week 9

    • More SQL

    Week 10

    • Joins and Subqueries

    Week 11

    • Functions, Procedures, Triggers and Embedded SQL

    Week 12

    • Prepared SQL Statements
Edit

More SQL

Introduction

We'll be working with data manipulation with your own databases and the WORLD database which can be downloaded here.

Questions

Using the tables created in the last session:

  1. Try to insert data when no columns are specified (i.e. you have to enter a value for each column)
  2. Try to insert data for some of the columns
        1. Try to insert data excluding a column that is defined as NOT NULL and see if MySQL allows it
        2. Try to insert data excluding the PK and see if MYSQL allows it
  3. Create a table similar to the first table and try coping all the data from the original table using the INSERT command
  4. Delete data with some conditions from the table
  5. Update the data using some conditions

Using the WORLD database, create different reports from the available tables:

  1. With no condition
  2. With a single condition
  3. With multiple conditions using AND
  4. With multiple conditions using OR
  5. Order the result based on different attributes in ascending order
  6. Order the result based on different attributes in descending order
  7. By grouping a single field
  8. By grouping multiple fields
  9. By grouping a field and having a condition
  10. By grouping multiple fields and having a condition
  11. By using a wild card (* , %)
  12. By use of LIKE, IS NULL
Last updated on 1/4/2019
← SQL IntroductionJoins and Subqueries →
  • Introduction
  • Questions
TIL
Docs
Getting StartedPrinciples of Programming Languages (C24)Introduction to Databases (C43)
Community
PiazzaQuercus
More
GitHubStar
Facebook Open Source
Copyright © 2019 Rakin Uddin