sql-zoo-database

KO | EN

gitlite — search

#react #ai #typescript #go #android #machine-learning #rust #deep-learning #linux #docker #nodejs #awesome #kubernetes #mcp

sql-zoo-database

(★ 8)

I write SQL statements taken by SQL Zoo website and did Tutorials 0-9 listed under the “Tutorial Section” and the quizzes listed at the end of each.

sql-zoo-database 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Sql Zoo statements
[SQL Zoo](https://sqlzoo.net/wiki/) is one of the few resources online that actually lets you build and run queries against existing tables. Each tutorial will show you a table and then have you run queries against it to answer specific questions. Some of the queries, particularly at first, are quite simple. They definitely get more challenging towards the end and can be real head scratchers

## Summary
This project was solved as completion database lessons at the Microverse program. I've solved almost all required on the SQL ZOO web site

<details markdown="block">
  <summary> Solved solutions </summary>
  
**SELECT basics**
- Some simple queries to get you started

**SELECT name**
- Some pattern matching queries

**SELECT from World**
- In which we query the World country profile table.

**SELECT from Nobel**
- Additional practice of the basic features using a table of Nobel Prize winners.

**SELECT within SELECT**
- In which we form queries using other queries.

**SUM and COUNT**
- In which we apply aggregate functions. more the same

**JOIN**
- In which we join two tables; game and goals. previously music tutorial

**More JOIN operations**
- In which we join actors to movies in the Movie Database.

**Using Null**
- In which we look at teachers in departments. previously Scottish Parliament

**Numeric Examples**
- In which we look at a survey and deal with some more complex calculations.

**Window function**
- In which we examine UK general election results.

**COVID 19**
- In which we measure the impact of COVID-19

**Self join**
- In which we join Edinburgh bus routes to Edinburgh bus routes.

**Tutorial Quizzes**
- Test your knowledge with multiple choice quizzes

**Tutorial Student Records**
- Creating a database

**Tutorial DDL**
- Instructions on how to import data and analyse it in mysql
</details>

## Built With

- SQL

## Author

👤 **Bertil Tandayamo**

- Github: [@bertil291utn](https://github.com/bertil291utn)
- Twitter: [@btandayamo](https://twitter.com/batandayamo)
- Linkedin: [Bertil Tandayamo](http://bit.ly/bertil_linkedin)

## 🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to submit a new suggestion [issues page](https://github.com/bertil291utn/ruby-linters/issues).

## Show your support

Hit the ⭐️ button if you like this project!

sql-zoo-database

sql-zoo-database 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

sql-zoo-database

sql-zoo-database 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README