bookmate game
Books
William Sullivan

SQL Programming & Database Management For Absolute Beginners

  • Yana Osokinahas quoted2 years ago
    ERD is the graphical representation of database scheme. ERD contains tables in the database, the columns within those tables and relationships between the tables.
  • Yana Osokinahas quoted2 years ago
    SQL is a scripting language which means that SQL code is not required to be compiled before execution
  • Yana Osokinahas quoted2 years ago
    Front end or commonly referred to as user interface and backend which consists of code that interact with the database.
  • Yana Osokinahas quoted2 years ago
    Foreign Key

    Foreign keys are used to create relationship between two tables. Foreign key column contains values from the primary key column of some other table.
  • Yana Osokinahas quoted2 years ago
    Primary Key

    Primary key is used to uniquely identify records within a table.
  • Yana Osokinahas quoted2 years ago
    When an application is being executed, it stores data in RAM (Random Access Memory)
  • Yana Osokinahas quoted2 years ago
    it stores data in RAM
  • Nelson Azinhas quoted2 years ago
    will be executed or none will execute
  • Nelson Azinhas quoted2 years ago
    set of queries in Boolean fashion.
  • Mhas quoted3 years ago
    UPDATE Examinations

    SET price = price * 1.1

    WHERE price < 250
fb2epub
Drag & drop your files (not more than 5 at once)