WEEK 7 Flashcards
What is a structured collection of organized data that is managed in a way that allows efficient retrieval , modification and analysis information
Database
A data base is like a what
Paper filler cabinet
(Can choose what and where info is stored)
How do you get data records on database
Input them yourself
Import them from somewhere else
(It’s like Placing documents in filling cabinet)
What is a question on request for info from a database and is the way to retrieve data in the database
Query
(Can ask it any question)
(Example.
Who has the most money according to the files in the cabinet?)
What is a summary of queried data that is designed to provide a clear, concise, and structured view of data
Report
(Presentation of your data)
Flat File vs Database
What’s the difference
Flat File is when a small group of people manage data in text files and spread sheets
Database is when you are dealing with complex data and lots of it which require advance data relationships and query capabilities
Database benefits
Multiple Concurrent Users
Scalability
(Increase data and traffic)
Increased speed
(Indexing, caching, query optimization etc..)
Can handle a variety of data
What is a collection of related data fields that represent a single unit of info
It’s often used to store and retrieve specific info
(COLLECTION OF DATA FIELDS)
Database Records
Long term retention of data within a database even when system is not being used or is off
Data Persistence
Name the 3 Database Structure Types
Structured (well organized)
Unstructured (includes text, vids, audio)
Semi-Structured (use meta tags to organize)
Structured data pros and cons
Fast data retrieval
Low data flexibility
Unstructured data pros and cons
Low data retrieval
High data flexibility
Semi-structured data pros and cons
Medium data retrieval
Medium data flexibility
What is a structured data system that stored structured data in tables
(Links multiple tables together)
(Organizes tables that relate to eachother)
Relational Database
How does Relational Database connect other tables together and create table relationships
Keys
(Primary key and Foreign key link together)
What is an outline or a blueprint for a database that describes its component and how they work
Schema
(Table name
Fields in table
Data type required for table
Primary key, Foreign key, and other attributes)
What is a constraint in a database
Rules and conditions we set for the data in the database
What are Non-Relational Databases
Uses storage model to optimize for the specific requirements for data being stored
(NON sql database)
(does NOT use Tables)
Explain Key/Value database
Its a Non-Relational Databases that uses keys and assigns values to that key
(used for caching
session management
user profile)
What is a Document Database
Its a Non-Relational Database
Works just like the file system on your computer
(stores stuff that cant be fit into a table or row sheet)
(stores files
music
photos
video)
What is SQL
is a specialized computer language used to communicate and manipulate databases
(sends request for actions it wants to be preformed)
In SQL what are DDL Commands
Commands that manage the STRUCTURE of your database
In SQL what are DML Commands
Commands that manage the DATA of your database
What does the CREATE command do in SQL
can create the tables and the names of the tables ect…
What does the ALTER command do in SQL
Example
It allows you to add delete and modify a column
You can also change a columns data type
Example
ALTER TABLE employees
REMANE COLUMN emp_id to emp_number;
In SQL what does the DROP command do
It is used to delete database data like tables
Example
DROP TABLE employees;
What are some commands that DDL uses
CREATE
ALTER
DROP
What are some commands that DML uses
INSERT
UPDATE
DELETE
In SQL what does the INSERT command do
Used to add new records in a table
Example
INSERT INTO employees
VALUES
(4233, ‘John Smith’, 65000.00);
In SQL what does the UPDATE command do
Allows to modify existing records in a table
Example
UPDATE employees
SET emp_salary = 67000.00
WHERE emp_id = 4233;
In SQL what does the DELETE command do
Used to delete records in a table
Example
DELETE FROM employees
WHERE emp_id = 4693;
In SQL What does the SELECT command do
It is used to query/retreat specific data from a database table
Example
SELECT column1, column2
FROM table_name
WHERE condition;
Example 2
SELECT * FROM Student Table
WHERE Age >=20;
What are Database Permissions
Can grant certain users the ability to preform specific actions like reading and editing data
What commands are used for Database Permissions
GRANT COMMAND gives permissions
(GRANT SELECT ON Customers TO UserA; )
DENY COMMAND denies permissions
(DENY DELETE ON Customers TO UserA; )
When wanting to get data into a database its what
Import
When wanting to get data out of a database its
Export
What are some ways to import data into a database
Using CSV files
(uses commas to separate files)
(included headers)
What is Database Access Methods
Are the processes by which a user might run SQL commands in order to update or extract info from a database
Name some Database Access Methods
Direct/Manual Access
Query/Report Builders
Programmatic Access
User Interface/Utility Access
What is Direct/Manual Access
Logging into the database directly and running the SQL code within the database management system
What is Query/Report Builders
The user uses a Graphical User Interface where actions are selected and then converted into SQL commands
What is Programmatic Access
Use programing language to connect with the database and execute Querys
What is User Interface/Utility Access
User Friendly Interface
(without the user being aware of its presence )
Data Driven Dashboard
