Computer CORE

Level 301

Note: This is a TWO hour class. Well worth it!

The objectives of the course will be the following:

1. Why SQL and course objectives
2. Relevance in today’s job market
3. Download an Open Source tool called SQL Lite Studio.
4. Define data
5. Identify types of data
6. Organize data
7. Define a data base
8. Data relationships
9. Retrieve data stored in a database
10. Allow students to have their own data base on their computers.
11. Basic SQL commands including, but not limited to:

a. Build a simple data table

b. Select

c. Connect tables (joins)

d. Basic math

e. Conditional logic

f. Detail and Summary results

Prerequisites:

• Windows Computer (No phones or tablets) 
• Previous 100 level course. Previous 200 level course is preferred