1. What is SQL? / 2. Table Basics

अब 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.


संबंधित स्टडी सेट्स

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