This course provides a practical introduction to database management, covering both SQL (MySQL) and NoSQL (MongoDB) concepts. You'll learn to create and manipulate databases and tables in MySQL using CRUD operations and essential SQL clauses (WHERE, GROUP BY, JOIN), and integrate it with back-end code. The course also explores the design and CRUD operations in MongoDB, equipping you with skills in both relational and non-relational database systems.

• Introduction to SQL and NoSQL database concepts: Work with SQL databases (MySQL) to create and delete databases, perform CRUD operations on tables, and utilize WHERE, GROUP BY, and JOIN clauses. 
• Integrate MySQL with backend code to connect to databases, perform CRUD operations, and display output data. 
• Understand the design and functionality of NoSQL databases using MongoDB, and perform CRUD operations.

Upon completion of the course, participants will be able to: 

• Distinguish between the fundamental concepts of SQL and NoSQL databases. 
• Create and delete SQL databases using MySQL. 
• Perform Create, Read, Update, and Delete (CRUD) operations on tables within MySQL databases. 
• Utilize WHERE clauses to filter data in SQL queries. 
• Employ GROUP BY clauses to aggregate and analyze data in SQL. 
• Implement JOIN clauses to combine data from multiple tables in SQL queries. 
• Connect backend code to MySQL databases.

This course will follow problem-solving techniques. Participants will collaborate on creating queries to retrieve specific data from database tables and integrate this knowledge with the backend logic for a web server. In addition to the interactive learning approach, this will encourage students to expand their logical thinking when it comes to backend scenarios.