Skip to content

Week 5: Lynda Course - Database Foundations

Lynda LinkedIn Learning 2: Data Structures

This course focuses on seven core concepts: data types, designing a normalized database, identifying rows with primary keys, linking data with foreign keys, formalizing data relationships, indexes, and constraints. You’ll be engaging with “Database Foundations” by Adam Wilbert on LinkedIn Learning.

Link: https://www.linkedin.com/learning/database-foundations-data-structures

Duration: Approximately 3 hours


Learning Objectives:

By the end of this week, you should be able to:

  1. Assess the impact of precision levels for time-based data types in databases.
  2. Evaluate suitable data types for storing currency values in a multinational scenario.
  3. Differentiate between primary keys in relational databases and data organization in spreadsheets.
  4. Apply many-to-many relationships through linking tables.
  5. Explain the role of indexing primary key columns in data retrieval efficiency.
  6. Demonstrate understanding of default value behavior during row insertions in databases.

Your Tasks for the Week:

  1. Enroll in the Course: Access the course on LinkedIn Learning. If you encounter any issues accessing the course, please reach out for assistance.

  2. Watch and Learn: Dedicate time to watch the course modules. The course is split into sections; make sure to complete all of them. Take notes as you go along, especially on topics that are new or challenging.

  3. Practical Exercises: The course includes practical exercises using Docker and SQL commands. Ensure you complete these exercises to apply what you’ve learned. Remember, practical application is key in understanding database concepts. Make sure you complete the practical exercises, you will be turning in a short video of what you completed.

  4. Get Certified: LinkedIn Learning Certificate


Additional Resources:

  • Office Hours: I’m available for office hours on Monday @ 7:30 pm EST for any questions or further discussion.

Reminder:

Stay on track with your learning! Consistent progress is crucial in an asynchronous course like ours. If you have any concerns or need extra support, please don’t hesitate to reach out.

Video Showcase: Create a 60-second video demonstrating your course achievements, including Docker container projects and certificates.

Reflection: In the assignment’s comment section, write a short paragraph reflecting on your learning experience. Highlight what you enjoyed and found intriguing about the assignment.


Rubric for Assignment Evaluation (Total: 50 Points)

  1. Course Completion (20 Points): Full completion of course modules.
  2. Practical Exercise Completion (20 Points): Successful completion and demonstration of Docker and SQL exercises.
  3. Video Presentation (5 Points): Clarity and thoroughness in showcasing course accomplishments.
  4. Reflective Commentary (5 Points): Insightfulness and thoughtfulness in the written reflection.