DATE
WEEK DATE
DAILY POINTS
WEEKLY POINTS
TOTAL POINTS
DAY STREAK
LEARNED
LEAGUE
2. TABLE MANAGEMENT
DATE WEEK DATE DAILY POINTS WEEKLY POINTS TOTAL POINTS DAY STREAK LEAGUE LEARNED
27/05/2024 MONDAY 1810 54100 35883 28
golden
LEARNED
  • ASC - ascending
  • DESC - descending order
  • SELECT (column names) - select
  • *< - select all the columns/li>
  • FROM - the table name
  • ORDER BY
  • WHERE major = '(somthing)'
    		•
    28/05/2024 TUESDAY 573 54543 36326 29

    golden
    LEARNED
  • WHERE year <> 1;
  • WHERE year <= 1;
  • WHERE year < 1;
  • WHERE year => 1;
  • WHERE year > 1;
    		•
    29/05/2024 WEDNESDAY 300 6283 36756 30

    golden
    LEARNED
    30/05/2024 THURSDAY 710 6993 36466 31

    golden
    LEARNED
  • INSERT INTO
  • VALUE
  • DELETE FROM
  • UPDATE
    		•
    31/05/2024 FRIDAY 0 6993 36466 32

    golden
    LEARNED
  • INSERT INTO
  • VALUE
  • DELETE FROM
  • UPDATE
    		•
    Learn Adding and Removing Data
      insert into and value
      VALUES("Poker", 6); dont foget the "" and the ;
      delete from
    Learn SQL Update
    UPDATE
  • UPDATE Reservations SET time = '19:00' WHERE name = 'Smith';
  • UPDATE (table) SET (column) = '(what you want to put in) WHERE (column specific) >= 100
  • UPDATE SONGS SET streams = 88 WHERE songname = 'California Highway';
  • UPDATE Directory SET company = ;
  • UPDATE Reservations SET partysize = 2;
    • UPDATE Flights SET mealservice = 1 WHERE number = 'PA76' OR number = 'PA67' ;
    Learn SQL Table Creation
      CREATE TABLE DIRECTORY
      INTEGER floor
      Valid column data types include INTEGER, REAL (for floats), or TEXT. You can also use BLOB or NULL, but we won't cover those here.
      What column characteristics must your table creation syntax include at a minimum? Each column's name and its data type

    Learn SQL Alter We can add new columns with the ADD keyword, the new column's name discount, and its datatype int. Note that ADD adds a column without data!
    Learn Listing and Dropping Tables
    Practice SQL Table Management 2
    Supercharge SQL Table Management 2
    Filters Use one or more advanced filters to narrow down results
    03. Filters Learn Filtering By Patterns Learn Filtering With Options Practice SQL Filters 1 Supercharge SQL Filters 1 Learn Using AND Learn Using OR Learn Using NOT Practice SQL Filters 2 Supercharge SQL Filters 2 Coding challenge Recreate the code output without additional guidance
    SQL BASICS
    1. Learn Selecting Data
  • Many apps you interact with store data like a username, password, or friends list.
  • This kind of data lives in a database. Most databases are collections of tables storing different pieces of data.
  • What kind of data do you think an app like Mimo stores?
    •
  • data like users'names, emails, active streak, and progress

  • When requesting data with SQL statements like SELECT, we say that we're making a query.
  • When selecting multiple columns, we use commas , to separate column names, like here with name, email.
  • To avoid wasting time coding all column names, we can select all columns of a table using the select all symbol * instead.
    • SELECT
    SELECT DISTINCT
    FROM
    USERS
    2 Learn Ordering Data
    ORDER BY name ;
    We can order items ascending starting with the smallest value, or descending.
  • Click the buttons to order ascending or descending by age.
    • ORDER BY
  • orders items ascending by default, which is the same as adding the ASC keyword at the end.
    • ASC - ascending
    DESC - descending
    3 Learn Filtering Data
    WHERE major = 'something that you want'
  • - We use WHERE to only select items that fulfill a condition, like having the value Biology on the major column.
    • WHERE type = 'basic'
  • Code a condition so that we only get users with a membership of type pro.
    • WHERE (COLUMN TITLE) (VALUE INTHE COLUMN)

    Learn Using the Inequality Operator
    WHERE YEAR < > 1
  • Sometimes we want to select data that doesn't satisfy a condition, like all students that are not in their first year.
  • We can also use the inequality operator with text values, like getting all students that don't major in 'Biology'.
    • Which operator do we use to check if two values are not equal?
  • < >
    • Learn Using Comparisons
      ULWHERE PRICE <=2;
    • We can use conditions to select items having a property less than a threshold value, like chocolate items with a price of less than 2$.
      WHERE price < 2;
    • We can use conditions to select items having a property less than a threshold value, like chocolate items with a price of less than 2$.
    Practice SQL Basics 2
    • SELECT name AS oldest
    • Select the name value for the oldest game under the alias oldest.
      • Select the newest game's name under an alias, with SELECT name, AS and the alias newest.
  • Supercharge SQL Basics 2
  • Coding challenge Recreate the code output without additional guidance
  • Table Management Learn how to create and manage tables in SQL