Tuesday, August 13, 2019

Free Databases and Data Visualisations course for kids Week 4 update

Databases and Data Visualisations course for kids aged between 9 to 14 years week 4 update. It was another full house on Monday with 12 kids and 4 parents attending the course. #sqlfamily #microsoftnz  


The first 45 minutes were spent in solving issues with questions like --
- 'I created a table but I cannot see it'
- 'Why is my insert statement not working ?'
- 'I have inserted a lot of duplicate records.  How do I delete them ?'
- 'I am getting a syntax error'

After this, when I did the recap of what happened last week, I was pleased to see most of the kids eagerly answering my questions. I felt that now all the kids are able to genuinely understand what I am trying to teach them.

The agenda for this week was to explain the update and delete statements.  The Like and In operators in the where clause.  Some of the basic SQL functions like Min, Max, Count, AVG, SUM.  String functions like Left, Right and Substring.

It is interesting to see how some of the kids think.  One of them asked what if we accidentally deleted all records ?  Is there an undo?

As usual I felt very happy to see the enthusiasm in these kids. I am looking forward for the session on next Monday.




No comments:

Need admin approval -- Azure webapp message

Challenge encountered :  Today one of my colleague could not access a webapp that I have created in our Azure Tenant.  The error is as follo...