COMP 102 Lecture Notes - Lecture 10: Sql, Management System, Wildcard Character
Document Summary
A database consists of one or more tables. A table is essentially an excel spreadsheet. Once you have a database, it"s very easy to manage and interact with data. Facebook and google are built on top of this. When retrieving data from a database from codenvy, you have to tell it what server to retrieve the data from. Used to communicate with a database (standard language for relational data management systems) Most have their own extensions as well. Database - basically multiple excel sheets that can communicate with one another. Standard commands: select, insert, update, create, drop. Objects within database are called tables , which are comprised of columns and rows. Select is used to query the database and retrieve selected data that is specified. Columns = name of column, data type, other attributes. The column name (after select) indicate which columns will be returned in the results.