Scribd
Upload
3 views1 page

Database Tutorial

The document is a database tutorial containing questions and answers on key concepts such as primary keys, SQL, normalization, foreign keys, and joins. It provides concise definitions and examples for each topic, including SQL queries and the ACID properties. Additionally, it briefly mentions NoSQL databases as non-relational options.

Uploaded by

guiffoulrich
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views1 page

Database Tutorial

The document is a database tutorial containing questions and answers on key concepts such as primary keys, SQL, normalization, foreign keys, and joins. It provides concise definitions and examples for each topic, including SQL queries and the ACID properties. Additionally, it briefly mentions NoSQL databases as non-relational options.

Uploaded by

guiffoulrich
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Database Tutorial

Questions
1. Primary key?

2. SQL stands for?

3. Select all users query?

4. Normalization?

5. Foreign key?

6. INNER vs LEFT JOIN?

7. Index?

8. ACID?

9. Insert query?

10. NoSQL?

Solutions
1. Unique row identifier

2. Structured Query Language

3. SELECT * FROM users;

4. Reduce redundancy

5. Link tables

6. INNER=matches, LEFT=all left

7. Speeds queries

8. Atomicity, Consistency, Isolation, Durability

9. INSERT INTO users (name) VALUES ('John');

10. Non-relational DB

You might also like