Skip to content

Week 9: Lynda Course - Database Foundations

Lynda LinkedIn Learning 4: Administration

Ongoing, regular administration is critical to the security and performance of databases such as SQL Server. In this course—the fourth installment in the Database Foundations series—explore vital techniques and best practices for administering a database. Instructor Adam Wilbert covers a variety of core concepts, including how to secure a server with user authentication and roles, protect your database by setting up permissions for authorized user accounts, and perform a backup and restore.

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

Duration: Approximately 2 hours


Learning Objectives

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

  1. Restore a database
  2. Incremental backup strategies
  3. Understand server security and permissions

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.