1. What is SQL? / 2. Table Basics

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan 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.


Set pelajaran terkait

Chapter 26: Concepts of Care for Patients with Noninfectious Upper Respiratory Problems

View Set

Chapter 16: Disorders of Brain Function Patho Prep U

View Set

Chapter 1 Review- Macroeconomics

View Set

APES test unit 4 (+ AP classroom questions)

View Set

GMU IT 343 Midterm Chpt 1-8 review quizzes

View Set

Chapter 21: Nursing management of labor and birth at risk

View Set

Human Development: Life Span (Broderick) #3

View Set