Role Of Information
______________ is a critical asset for businesses
Information
What does SQL stand for?
Structured Query Language
What is a database?
Structured collection of data, organized into tables
What does it mean to have "structured data?"
Organizing data into tables, which consist of rows and columns
Are cellphones allowed?
No
What type of Information System deals with recording and processing daily business transactions?
Transaction Processing Systems
Does SQL understand spaces?
No, it does not. We use underscores (i.e. First_Name) to dictate where spaces should be.
Rows are otherwise known as:
Records
True or False: we can use Python scripts to clean our database
True!!
How do we properly leave the classroom?
Shut down computer, push in chair
What manages and processes data to provide meaningful information?
Information Systems
What is wrong with this command?
SELECT First_Name
FROM Employees
WHERE First_Name = John;
You need quotes on John
Columns are otherwise known as:
Attribute or Field
Why do people like using Google Sheets and Microsoft Excel?
User-friendly interface
If I go to the bathroom without letting Mr. Roessler know, and show up like 10 minutes late, and he marks me tardy...who is in the wrong?
YOU ARE, BUSTER!!
Of all the challenges and considerations when implementing a Information System, which is by far the hardest?
Training and User Adoption
What's wrong with this command?
SELECT *
FROM Employees
WHERE First_Name ('Emily', 'Robert');
IN is missing
Is web scraping illegal? Is it shady?
It is totally legal, however it's a bit sus
What enables us to write queries to retrieve data from one or more tables?
SQL
Where did Mr. Roessler go to college?
UMHB
What are the five components of an Information System?
Hardware, Software, Data, Procedures, and People
What is the most powerful command (per the context of this class) that SQL has?
JOIN
List as many methods of data collection as you can
Surveys / Questionnaires
Interviews / Focus Groups
Observations / Field Studies
Web Scraping
Sensor Data Collection
Social Media Monitoring
What's the difference between data manipulation and data definition?
Manipulation allows us to insert, update, and delete data
Definition allows us to define structure, constraints, and managing indexes
What is the Technology Code Of Conduct and where can I find it?
The Technology Code Of Conduct is a list of rules regarding using technology here at Lometa ISD. It can be found on the Lometa website.