Free #Databases and Data Visualisations course for kids aged between 9 to 14 years week 2 update

It was good to see all the kids come back to hear all about databases for the 2nd week.  There were a few new enrolments.
So first I started off with a Recap of last week, to help the 3 new kids understand the database concepts and also to test the knowledge that all the others have gained. It was good to see that they remembered most of the concepts except for the redundancy part.

The agenda for week 2 was to show them how they could access SSMS and create a database and a table.  Most of them had hands on experience creating a database named schools and a table named school.

I also wanted to cover how to insert data in this week but ran out of time so will do that next week.

I have also given them some homework to ensure that they practice what was learnt in the past 2 sessions.

I am looking forward for the session on next Monday.  . #sqlfamily #microsoftnz #mvpbuzz

Databases and Data Visualisations Course for kids Season 2 Week 1

Databases and Data Visualisations Course for kids Season 2 Week 1
I have started the second leg of Databases and Data Visualisations course for kids aged between 10 to 14 years yesterday.

This time I have asked the kids to fill out a survey to understand their current level of knowledge regarding what data is and what visualisation is. I also asked what they want to get out of this course.

The answers ranged from "understanding the basics of data" to "Learn about the basics of data visualization and what I can do about it in the future "

The best answer I liked was "I want to learn more about databases online. I also want to learn a little bit of coding since that is definitely not my best factor. I want to learnt things that I didn't know before to extend my thinking and become more all-rounder."

From the survey, I was confident that the kids already knew what data means and they could easily give some examples.

To explain about Relational Databases and Normalisation, I have asked each one of them to type in some information about their student ids names, classes, their emails, teachers and teacher's emails and schools.

This activity proved to be useful to make them understand the concept of redundancy and the disadvantages that arise out of it.  Then it was easy for me to explain the concept of Normalisation.

I have given them home work of installing SQL Server on their laptops.

I am looking forward for the session of Creating databases and tables using SQL Server next Monday.