Basic Knowledge
What does SQL Stand for?
Structured Query Language
Name 3 different data types?
Int, varchar, text, char, decimal, date
Name me four of our basic SQL commands.
SELECT, INSERT, DELETE, UPDATE
What is data integrity?
Refers to accuracy to consistency and reliability
What does the * stand for?
All
When was SQL first developed?
1970
What are the max amount of characters varchar can use?
255
What command can we use to add data into our table?
INSERT
Name the 4 types of data integrity
Entity, referential, domain, and user-defined.
What is the standard language for databases?
SQL
What company first developed SQL?
IBM
What is the syntax of the 'date' datatype?
date: (yyyy-mm-dd)
Give the Code that would select all the students from a table called 'Students', given the student has an A
Select * from students where grades = 'A';
Why is data integrity important? (3 reasons)
> To not duplicate records in our table (or extra tables)
-> Ensuring that data is valid
-> Avoids inconsistencies
What did SEQUEL stand for?
Structured English Language
What was SQL originally called?
SEQUEL
What is the different between char and text?
Char is for one character, text is for many characters.
Give the syntax used to modify a record in a table, given a condition.
UPDATE tableName set column1 = 'value1', column2 = 'val2' where condition;
How many levels do constraints have, and for what are those levels for?
Constaints have two levels: Column level, or table level
-Apples to either one column, or the entire table
When was MySQL released?
1995
Donald Chambelin
In MySQL, this data type is commonly used to store large amounts of text, but it cannot be indexed efficiently like.
Varchar
Give the code that would insert 3 records into the table "student_Info" (Fields include name, grades, class)
INSERT INTO student_Info (name, grades, class) VALUES ('John Doe', 85, 'Physics');
INSERT INTO student_Info (name, grades, class) VALUES ('Jane Smith', 92, 'Mathematics');
INSERT INTO student_Info (name, grades, class) VALUES ('Alex Johnson', 78, 'Chemistry');
Give the type of integrity that ensures that values in a column follow a set amount of rules.
Domain Integrity
Who was the second developer of SQL?
Raymond Boyce