OVerview

video Block
Double-click here to add a video by URL or embed code. Learn more

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque elementum mi a metus efficitur gravida. Etiam cursus sapien at commodo pulvinar. Ut id dui mi. Vivamus id nulla aliquet, finibus velit a, venenatis nibh. Donec in rutrum enim. Duis finibus justo vitae lacinia dapibus. Donec quis ipsum urna. Phasellus eget ultrices nulla, sodales gravida odio. Integer vel lacus a purus consequat feugiat. Pellentesque faucibus facilisis augue. Duis leo eros, fringilla in blandit at, suscipit vitae est. Cras at turpis ornare, gravida ipsum at, accumsan augue. Duis commodo justo at libero convallis egestas. Nam pellentesque vehicula ex, porta hendrerit dolor pharetra in.



COURse OUtline

 

Codecademy: Learn SQL (Estimated 3 hours)

  1. Lesson: Manipulation

  2. Activity: Create Table

  3. Activity: SQL Glossary

  4. Lesson: Read Relational Database Management Systems

  5. Lesson: Queries

  6. Activity: Writing Queries

  7. Lesson: Aggregate Functions

  8. Activity: Fake Apps

  9. Lesson: Multiple Tables

  10. Activity: Querying Tables

  11. Test: Learn SQL (Please see your teacher for a copy of your test.)

PIN for Test is: sql-1

 

 

Codecademy: SQL: Table Transformation (Estimated 5 hours)

  1. Lesson: Subqueries

  2. Lesson: Set Operations

  3. Lesson: Conditional Aggregates

  4. Lesson: Date, Number, and String Functions

 

Codecademy: SQL: Analyzing Business Metrics (Estimated 2 hours)

  1. Lesson: Advanced Aggregates

  2. Lesson: Common Metrics