Skip to main content

An introduction to working with a relational database using SQL - Workshop

When: Tuesday, January 19, 2016

Where: The King's Centre, King Street, Norwich, NR1 1PH

How much: £99

Sign-up: http://www.meetup.com/Norfolk-Developers-NorDev/events/226508456/

Level: Beginner
Prerequisites: Laptop

This one day workshop is designed to provide a familiarity with basic RDBMS concepts and the syntax required to construct simple SQL statements used to create, manipulate and report upon database records.

The workshop will be problem-centred and attendees will be invited to think about example problems in order to facilitate their appreciation of what a database is and why databases are used.

Once the basic concepts have been introduced, the remainder of the day will entail hands on practice writing and testing SQL statements using a database client program (Postgres). A worksheet will be provided to help guide this process. There will also be time for breaks and joint questions.

Attendees should be comfortable with running desktop applications (e.g. using Microsoft Word or Excel). No specialist knowledge is required to attend. Attendees are expected to bring their own laptops with them. As a preliminary to the workshop, attendees who do not have the relevant software installed will be guided through the installation process. Attendees will therefore need their relevant passwords to authenticate installation.

Summary of presentation

Installation procedure -- est. 45 minutes

1. A few remarks about learning new ideas, and new technologies. Distinguishing 'what a thing is' from 'the value of thing' -- est. 30 minutes

2. The value of an SQL RDBMS -- est. 90 mins

2.1 The idea of data persistence.

2.2 A shopping transaction history at a superstore example using index cards (an everyday example is used to allow everyone to focus upon what is new for them).

2.3 An example of using text files to persist the data is shown. The pros and cons of using text files as a form of persistence is discussed.

2.4 An example using a spreadsheet to persist the data is shown. The pros and cons of using spreadsheets is discussed.

2.5 The idea of a data persistence media that supports queries.

2.6 A summary of key limitations of the use of index cards, text files and spreadsheets is presented and discussed.

2.7 An SQL RDBMS is introduced as something that helps to resolve the problems previously identified.

2.8 Discussion

3. The basic structure of an SQL RDMBS -- est. 90 mins

3.1 What a relation is in this context of a relational database

3.2 Databases, tables, & records

3.3 SQL as a set of expressions to be used to manipulate and query databases, tables, and records including a brief glance through standard SQL commands, a step by step introduction to the SQL commands for CRUD and a brief caveat on syntactic differences used by different database vendors.

3.4 Some additional problems that relational databases help to resolve

3.5 A summary of what has been covered so far.

3.6 Discussion

[Break for lunch]

4. Working through the worksheets provided that elaborate on the shopping transacton data previously introduced -- est. 240 mins

4.1 Simple use of the four commands

4.2 Applying the commands to multiple rows of a table

4.3 Data types in more depth

4.4 Performing queries that use ids

4.5 Performaing other queuries

4.6 Additional exercises using different databases (optional)

5 Questions and discussion about what has been covered -- est 0 to 60 mins

6 What next? -- est 30 mins

6.1 A reminder about learning other commands in order to maintain a database

6.2 The complexities of database design: Inroductory steps into an important component of information technology.

6.3 References for further study

6.4 Closing remarks and feedback forms

Comments

  1. Hi Paul,
    Who will deliver the course? Is it certificated?
    many thx
    S

    ReplyDelete
    Replies
    1. Hey Sally, The course is being delivered by Huw Lloyd:

      https://uk.linkedin.com/in/huwlloyd

      No, it's not certified.

      Delete
  2. Hi Paul, many thx. Pls can you book me in provisionally, I'm trying to arrange leave for this day.
    Many thx
    Sally Hopper

    ReplyDelete
    Replies
    1. Good stuff! If you join norfolkdevelopers.com I can RSVP you. Please give my regards to Joseph S.

      Delete

Post a Comment

Popular posts from this blog

Write Your Own Load Balancer: A worked Example

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

Bloodstock 2009

This year was one of the best Bloodstock s ever, which surprised me as the line up didn't look too strong. I haven't come away with a list of bands I want to buy all the albums of, but I did enjoy a lot of the performances. Insomnium[6] sound a lot like Swallow the Sun and Paradise Lost. They put on a very good show. I find a lot of old thrash bands quite boring, but Sodom[5] were quite good. They could have done with a second guitarist and the bass broke in the first song and it seemed to take ages to get it fixed. Saxon[8] gave us some some classic traditional heavy metal. Solid, as expected. The best bit was, following the guitarist standing on a monitor, Biff Bifford ripped off the sign saying "DO NOT STAND" and showed it to the audience. Once their sound was sorted, Arch Enemy[10] stole the show. They turned out not only to be the best band of the day, but of the festival, but then that's what you'd expect from Arch Enemy. Carcass[4] were very disappoin

Catalina-Ant for Tomcat 7

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