bookmate game
en
Bøger
William Sullivan

SQL Programming & Database Management For Absolute Beginners

  • Yana Osokinahar citeretfor 3 år siden
    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 Osokinahar citeretfor 3 år siden
    SQL is a scripting language which means that SQL code is not required to be compiled before execution
  • Yana Osokinahar citeretfor 3 år siden
    Front end or commonly referred to as user interface and backend which consists of code that interact with the database.
  • Yana Osokinahar citeretfor 3 år siden
    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 Osokinahar citeretfor 3 år siden
    Primary Key

    Primary key is used to uniquely identify records within a table.
  • Yana Osokinahar citeretfor 3 år siden
    When an application is being executed, it stores data in RAM (Random Access Memory)
  • Yana Osokinahar citeretfor 3 år siden
    it stores data in RAM
  • Nelson Azinhar citeretfor 3 år siden
    will be executed or none will execute
  • Nelson Azinhar citeretfor 3 år siden
    set of queries in Boolean fashion.
  • Mhar citeretfor 3 år siden
    UPDATE Examinations

    SET price = price * 1.1

    WHERE price < 250
fb2epub
Træk og slip dine filer (ikke mere end 5 ad gangen)