ADMS 2511 Lecture Notes - Sql, Database, Database Schema

44 views4 pages

Document Summary

A table is a collection of records. A record (or object/entity) is a collection of related fields that make up a single database entry rows. Includes statements that specify database schemas as well as statements that add, modify, and delete database content: sql is not case sensitive. Keywords, table names, and attributes names can be uppercase, lowercase, or mixed case. Spaces are used as separators in a statement: queries, basic select statement includes a select clause, a from clause, and a where clause. Select attribute-list from table-list where condition: select * means all attributes are returned. Select * from movie where genre like %action%". Returns all attributes of records containing the word. Action : can also sort output by adding order by title at the end, modifying database content, sql"s insert, update, and delete statements allow data in table to be changed. Insert adds a new record to a table insert into customer values (9876, "john smith", "602 greenbriar.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents