Skip to content

Week 7: Lynda Course - Database Foundations

Lynda LinkedIn Learning 3: Database Management

In the realm of relational databases, the table is the main event, the showstopper, the lead singer, the king. However, there are several other components of databases that are just as vital to a fully functioning system. In this course—the third part of his Database Foundations series—Adam Wilbert turns the spotlight on the supporting cast of database management characters. He covers topics like view objects, query performance, transactions, and stored procedures, and shows how each is an integral part of database management.

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

Duration: Approximately 2 hours


Learning Objectives

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

  1. Create a database view and optimize queries.
  2. Understand ACID and transaction and data consistency
  3. Create stored procedures

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.


Submission

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.