![]() You retrieve data and perform analysis with queries, which are a sets of instructions written in SQL.Those tables usually look like one sheet in Excel, with rows and columns. Your data is stored in a relational database, which is made of tables.When we say "use SQL," this is what we mean: SQL is just a language used in programming. ![]() ![]() If you've ever been stuck staring at a "Pinwheel of Death" or an "Excel quit unexpectedly" message, you know the pain. If the number of rows is in the thousands, it could really hurt our workflow. In Excel, we have to use step-by-step instructions to get the data:īy this point we've edited the data (potential errors), we don't have a copy of the steps saved anywhere (hard to replicate), and we'll need to email the whole file to our fellow Pokémon trainers (painful version control).Īs the Pokémon table grows, Excel-or Google Sheets-slows down. Suppose that we want to use Excel to filter out everything but the name and type of every Grass type Pokémon in the table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |