August 2021 - Terr For MER

How To Create the Perfect SQL Database- A blog on the basics of SQL database

By Terra08/30/202108/30/2021

What is SQL? SQL or Structured Query Language is a database language used to create and maintain databases in various applications. It works by storing the data in tables, columns, rows, etc. It comes with three basic commands: Select- This command fetches all the information from a table Insert- This command inserts new records into …

Persuasive Speech- College Athletes Should Not Be Paid

By Terra08/09/202108/09/2021

I’d like to explain the circumstances we would experience if we pay college athletes and let you all know that it’s best to not pay them, but to offer more for scholarships and incentives. I know some of you may think this is unfair therefore I will explain my reasoning as to why the money …

Here’s why SQLite is perfect for your day-to-day work. It doesn’t matter if you are a developer, analyst, tester, admin or product manager.

For starters, a few known facts:

SQLite is the most widely used database management system in the world, included in all popular operating systems.

Works without a server.

For developers, it is embedded directly into the application.

For everyone else – a convenient console (REPL) in one file (sqlite3.exe on Windows, sqlite3 on Linux / macOS).

The console is a killer feature of SQLite: a more powerful data analysis tool than Excel, and much simpler than any pandas. Data from CSV is loaded with one command, the table is created automatically:

> .import –csv city.csv city
> select count (*) from city;
1117

Basic SQL features are supported, and the console shows the result in a nice table. There are also advanced SQL features, but more about them later.

select
century || ‘th century’ as dates,
count (*) as city_count
from history
group by century
order by century desc;