Skip to main content

SQL and MySQL Basics

 

M1L10 Brief


This self-study guide will introduce you to SQL concepts, relational database management, and how to set up and work with MySQL on your local machine. You will explore database creation, table design, and SQL operations like querying, updating, and deleting records.

Videos


  1. Introduction to SQL
  2. Learn the basics of SQL (Structured Query Language), how it’s used to manage relational databases, and common SQL queries like SELECT, INSERT, UPDATE, and DELETE.
  3. Watch the video: https://www.youtube.com/watch?v=HXV3zeQKqGY
  4. Install and Set Up MySQL Locally
  5. Follow this step-by-step guide to installing MySQL on your local machine, creating databases, and managing users.
  6. Watch the video: 
  7. https://www.youtube.com/watch?v=u96rVINbAUI
  8. https://www.youtube.com/watch?v=wgRwITQHszU

Readings


  1. Introduction to SQL
  2. Get a solid understanding of SQL, relational database concepts, and how to perform basic SQL queries and operations.
  3. Read the guide: https://www.w3schools.com/sql/sql_intro.asp
  4. MySQL Basics
  5. Learn how to install and configure MySQL locally, create databases, tables, and manage data using SQL.
  6. Read the article: https://www.mysqltutorial.org/mysql-basics/
  7. SQL SELECT Statement
  8. Understand how the SELECT statement works in SQL, which allows you to retrieve data from one or more tables.
  9. Read more: https://www.geeksforgeeks.org/sql-select-query/
  10. Understanding SQL Joins
  11. Learn how SQL JOIN queries allow you to combine rows from two or more tables based on a related column.
  12. Read the guide: https://www.atlassian.com/data/sql/sql-join-types-explained-visually
  13. Backing Up and Restoring MySQL Databases
  14. Understand the process of backing up and restoring MySQL databases, including how to export and import databases.
  15. Read the tutorial: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/backup-and-recovery.html

Helpful Links (References)


  1. MySQL Documentation
  2. Explore the official MySQL documentation for everything from installation to advanced SQL queries.
  3. Visit: https://dev.mysql.com/doc/
  4. SQL Cheat Sheet
  5. This SQL cheat sheet will help you quickly reference common SQL commands and queries for managing databases.
  6. Visit: https://www.datacamp.com/cheat-sheet/sql-basics-cheat-sheet
  7. Advanced SQL Queries
  8. Learn how to work with more advanced SQL queries such as subqueries, unions, and case statements.
  9. Visit: https://learnsql.com/blog/25-advanced-sql-query-examples/

Comments

Post a Comment

Popular posts from this blog

Infrastructure as Code (IaC) (Part 2 of 2)

  M2L4 Brief This self-study module introduces the fundamental concepts of Infrastructure as Code (IaC) . It covers the benefits, core principles, tools, and hands-on exercises to help you get started with IaC. Videos What is Infrastructure as Code? Understand the concept of IaC, its importance, and how it replaces manual infrastructure management with automation. Watch the video: https://www.youtube.com/watch?v=zWw2wuiKd5o&ab_channel=IBMTechnology Introduction to Terraform Get introduced to Terraform, one of the most popular IaC tools, and see how it is used to provision and manage infrastructure. Watch the video: https://www.youtube.com/watch?v=l5k1ai_GBDE&t=30s&ab_channel=TechWorldwithNana https://www.youtube.com/watch?v=tomUWcQ0P3k&ab_channel=Fireship Readings What is Infrastructure as Code? Learn the basics of IaC, its principles, and how it automates infrastructure deployment. Read more: https://aws.amazon.com/what-is/iac/ Benefits of Infrastructure as Code Un...
Post a Comment
Read more

Principles in Cloud Architecture Design

  M2L1 Brief This self-study module focuses on the core principles of cloud architecture design . It explores best practices for designing scalable, resilient, and cost-efficient systems in cloud environments. You will gain insights into foundational concepts, practical approaches, and real-world examples. Videos Principles of Cloud Architecture Understand the key principles behind designing a robust cloud architecture. Topics include scalability, elasticity, and fault tolerance. Watch the video: https://www.youtube.com/watch?v=rwuSMi_rAkM&ab_channel=WiredThinkers Scalable and Resilient Architectures Learn how to build scalable and resilient cloud applications, covering design patterns and best practices. Watch the video: https://www.youtube.com/watch?v=8vzPwflhqZU&ab_channel=ByteMonk Readings AWS Well-Architected Framework Explore the five pillars of AWS Well-Architected Framework: operational excellence, security, reliability, performance efficiency, and cost optimizatio...
Post a Comment
Read more

Network Security Best Practices

  M1L7 Brief This self-study module focuses on understanding and implementing network security best practices, especially in cloud environments like AWS. Videos Introduction to Network Security Understand the basics of network security. Watch the video: https://www.youtube.com/watch?v=NQ1cvwEvh44 AWS VPC Network Security Learn how to implement security best practices in AWS VPCs, including Security Groups and NACLs. Watch the video: https://www.youtube.com/watch?v=lkksqUDlwJE Readings Network Security Best Practices Explore industry best practices for securing cloud networks and protecting data. Read the article: https://www.cisco.com/c/en/us/products/security/what-is-network-security.html AWS Network Security Learn how to secure your AWS VPCs and instances using services like Security Groups, NACLs, and VPC Endpoints. Read the article: https://docs.aws.amazon.com/vpc/latest/userguide/VPC_Security.html Helpful Links (References) AWS CloudTrail and Amazon Detective Understand how to...
Post a Comment
Read more