1. What is SQL? / 2. Table Basics

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

What does SQL stand for?

Structured Query Language. Standard language for relational database management systems.

What are Tables?

Data or information for the database is stored. Uniquely identified by their names & are comprised of columns & rows.

What are some types of SQL relational database management systems?

1. Oracle 2. Sybase 3. Microsoft SQL server 4. Access 5. Ingres

What are some standard SQL commands?

1. SELECT 2. INSERT 3. UPDATE 4. DELETE 5. CREATE 6. DROP

What's SQL used for?

Communicate w/ a database.

What are Columns?

Contain the column name, data type, & any other attributes for the column.

What are Rows?

Contain the records or data for the columns.

What are SQL statements used for?

Perform tasks such as update data on a database, or retrieve data from a database.

Ensembles d'études connexes