Skip to main content

SQL Workshops are coming back to Norwich – have your say.

Image
By
On 19th January this year Norfolk Developers ran the ‘An introduction to working with a relational database using SQL’ workshop. We would like to know what sort of follow-up SQL workshop(s) you would be interested attending. We’re also intending to run the same beginners workshop again, so if you’re interested in attending, please join: norfolkdevelopers.com

Huw LLoyd has very kindly provided us with the following ideas for follow-up workshops:

(1) For a 'follow up' course/workshop (i.e. for people who attended the first and want to go further), a natural progression is to build upon the central idea of the introductory workshop which is notion of databases serving particular questions.

So we have:

i). What kinds of questions a database can support (recap and expansion).
ii) The kinds of questions we are interested in for some business function, and the implications for this in terms of record structures.
iii). The writing of richer queries, use of filters (where clause), functions (summation, count, average), and joins.

(2) For a separate day, people might also be interested in building sql scripts: transactions, use of temporary tables, possible use of variables.

(3) For programmers there are a number of design issues which could be highlighted with a day's workshop and discussion, central to this is the issue of impedance mismatch with respect to object-oriented class hierarchies.

(4) To round out the offering to 5 days, a day could also be spent on design considerations for record structures with respect to entity models and normalisation.

As you can see there are plenty of options for a single or multiple follow-up days. Please read through the suggestions and let me (paul@nakedelement.co.uk) know which would be of interest to you. We’re also happy to tailor workshops, so if there are other aspects of SQL (or indeed anything else related to software) you would like to learn about please do let me know.

Comments

Post a Comment

Popular posts from this blog

It's great to be back at the ACCU Conference 2025!

By
Last week I was back at the ACCU Conference in Bristol, for the first time since I gave an opening keynote in 2019 . In March 2020, COVID hit the UK and I got out of the habit of attending and speaking at conferences. Plus the ACCU Conference, and the organisation in general, took a big step back towards C++ and that hasn’t been relevant to me for nearly two decades. It’s taken until now, 2025 for me to want to talk again, and I was really pleased to be accepted for the ACCU Conference again. It was just a 20 minute session and I only attended for the day I was speaking. There was enough varied content for it to be interesting to me and I’m hoping to be back for the full conference next year. I really enjoyed attending and it was great to catch up with people I hadn’t seen for years. I felt re-engaged and particularly liked being asked if I’d been to nor(DEV):con . Learning to stop writing code (and why you won't miss it) Daisy Hollman I should have read the summary of the openin...
1 comment
Read more

Write Your Own Load Balancer: A worked Example

By
I was out walking with a techie friend of mine I’d not seen for a while and he asked me if I’d written anything recently. I hadn’t, other than an article on data sharing a few months before and I realised I was missing it. Well, not the writing itself, but the end result. In the last few weeks, another friend of mine, John Cricket , has been setting weekly code challenges via linkedin and his new website, https://codingchallenges.fyi/ . They were all quite interesting, but one in particular on writing load balancers appealed, so I thought I’d kill two birds with one stone and write up a worked example. You’ll find my worked example below. The challenge itself is italics and voice is that of John Crickets. The Coding Challenge https://codingchallenges.fyi/challenges/challenge-load-balancer/ Write Your Own Load Balancer This challenge is to build your own application layer load balancer. A load balancer sits in front of a group of servers and routes client requests across all of the serv...
Post a Comment
Read more

Catalina-Ant for Tomcat 7

By
I recently upgraded from Tomcat 6 to Tomcat 7 and all of my Ant deployment scripts stopped working. I eventually worked out why and made the necessary changes, but there doesn’t seem to be a complete description of how to use Catalina-Ant for Tomcat 7 on the web so I thought I'd write one. To start with, make sure Tomcat manager is configured for use by Catalina-Ant. Make sure that manager-script is included in the roles for one of the users in TOMCAT_HOME/conf/tomcat-users.xml . For example: <tomcat-users> <user name="admin" password="s3cr£t" roles="manager-gui, manager-script "/> </tomcat-users> Catalina-Ant for Tomcat 6 was encapsulated within a single JAR file. Catalina-Ant for Tomcat 7 requires four JAR files. One from TOMCAT_HOME/bin : tomcat-juli.jar and three from TOMCAT_HOME/lib: catalina-ant.jar tomcat-coyote.jar tomcat-util.jar There are at least three ways of making the JARs available to Ant: Copy the JARs into th...
22 comments
Read more