LESSON 4-5 MID

Cards (47)

  • STRUCTURED QUERY LANGUAGE - ACRONYM OF SQL
  • 2 SIGNIFICANT PERSON BEHIND THE SUCCESS OF SQL NOWADAYS
    • DONALD D. CHAMBERLIN
    • RAYMOND F. BOYCE
  • AMERICAN NATIONAL STANDARDS INTITUTE - ACRONYM OF ANSI
  • When were SQL and IBM created by Chamberlin and Boyce?
    early 1970s
  • Structured Query Language - It is use to communicate with a database so that a user can design databases, table structures, and perform multiple type of data manipulation.
  • AMERICAN NATIONAL STANDARDS INTITUTE - according to this, it is a standard language for relational database management systems.
  • Data Definition Language (DDL) - use to define the database structure or table.
  • Data Manipulation Language (DML) - are use for managing data in records within table object.
  • Create - Sql data definition command use for creating a database.
  • Create Table - Sql data definition command use for creating a new table or the user's database schema.
  • Alter Table - Sql data definition command to modifies table's definition (add, modifies, or delete attributes or constraints)
  • Drop - Sql data definition command use for permanently deletes a database or table together with its data.
  • Truncate - Sql data definition command use for remove all table records including allocated table spaces.
  • Rename - Sql data definition command use for renaming the database or table.
  • Insert - Sql data manipulation commands that are use for insert rows into a table.
  • Select - Sql data manipulation command that are use for select attributes from rows in one or more tables or views.
  • Update - Sql data manipulation command that are use for Modifies an attribute's values in one or more table rows.
  • Delete - Sql data manipulation command that are use for deleting one or more rows from a table.
  • AND/OR/NOT - Logical operators that are use in conditional expressions.
  • <>,=,<=,>=,<,>,!= - Comparison operators that are use in conditional expressions.
  • Between - Special Operator that are use to check an attribute value within a range.
  • In - Special Operator that are use to check whether an attribute value matches any value within a value list.
  • Where - Command that restricts the selection of rows based on a conditional expressions.
  • Group by - Command that groups the selected rows based on one or more attributes.
  • Having - Command that restricts the selection of grouped rows based on a condition.
  • Order by - Command that orders the selected rows based on one or more attributes.
  • Like - Special Operator that are use to checks whether an attribute value matches the given string pattern.
  • Is Null - Command that checks whether an attribute value is null.
  • Exists - Command that checks whether a subquery returns any rows.
  • SQL - Is a non procedural language
  • Variable - Length of character data and will not leave unused spaces.
  • CHAR - Fixed length data character up to 255 characters.
  • Integer - abbreviated as INT, are whole counting numbers.
  • Decimal - Number specification but the storage length is a minimum specification.
  • Float - The total number is specified by SIZE.
  • Source Code - is the part of software that most computer don't ever see its the code computer programmers can manipulate to change how a piece of software "program" or "application" works.
  • MySQL - the world's most popular open source database.
  • MySQL was develop by this three significant person.
    • Michael "Monty" Widenius
    • David Axmark
    • Allan Larson
  • MAY 23, 1995 - When were MySQL created by those 3 people?
  • MySQL was owned by Swedish Company called MySQL AB for around 1billion and Sun Microsystem was acquired by ORACLE in 2010.