Engaging Databases and Web Development lessons

During their recent lesson, Muskan and Elena delved into various SQL concepts, including the distinctions between `WHERE` and `HAVING` clauses, the order of execution for SQL statements, and the functionalities of `UPDATE`, `DELETE`, and `ALTER TABLE`. Elena gained practical experience by writing SQL queries and received valuable guidance on common errors. Muskan concluded the lesson by assigning Elena to review all covered topics and practice easy SQL questions on sqlpractractice.com in preparation for their next meeting.

Muskan assisted a learner from Fishers with uploading a previous assignment to GitHub and began troubleshooting a new data analysis assignment. They clarified the project requirements, reviewed the provided datasets (cardiovascular and Starbucks), and started to evaluate the learner's initial EDA work using the Starbucks dataset. Muskan will take over the project to complete the EDA, model building, and Streamlit app creation, with a follow-up lesson planned to explain the process and upload the completed project.

Muskan assisted a University of Arizona student with uploading her data science assignment to GitHub, troubleshooting file size issues and platform-related transfer problems. They explored various methods, including zipping the files and using VS Code, before deciding to upload the project to Google Drive and link it in GitHub. The student was instructed to create a ticket in the Wingi app to resolve the lesson transfer issue and will upload the project to Google Drive before the next lesson.

Muskan instructed an individual, a student at Palomar College in Escondido, on SQL, covering relational databases, SELECT statements, WHERE clauses for filtering, ORDER BY for sorting, and the use of LIMIT and OFFSET. The learner practiced writing SQL queries on a movie database and received a link to a SQL join visualizer. Muskan assigned a review of the theory and additional practice questions on the topics covered.

During a recent lesson, Muskan and Mohsin delved into SQL queries, covering essential topics such as joins, null values, aggregate functions, and subqueries. Mohsin gained practical experience by writing queries, understanding the nuances between inner and outer joins, and the usage of 'UNION' and 'UNION ALL'. To prepare for his upcoming interview, Mohsin received an assignment to review lessons on joins and aggregate queries.

Muskan and Mohsin recently reviewed various SQL query components, such as SELECT statements, WHERE clauses, ORDER BY, LIMIT, and OFFSET. Mohsin actively practiced constructing SQL queries on both movie and city datasets. For continued practice, he was assigned to complete lessons up to lesson 3 on SQLBolt. The upcoming lesson is scheduled to cover new topics and include a review of the exercises already finished.