SQL vs NoSQL (Notes)

A quick overview of the differences between SQL and NoSQL. SQL Structured Query Language (SQL) is used for relational databases, which are table based. For example, an column in table A (e.g. User_ID) may have a relation with a column in table B (e.g. Order_Ref) and table B may have a relation to a column … Continue reading SQL vs NoSQL (Notes)

Data, Data Lakes and Data Warehouses (Notes)

Continuing on from my post looking at Data Architecture / Data Modelling, I am now going to look at data, data lakes and data warehouses by turning my notes into this blog post. Data Data can include emails, phone calls, financial transactions, sensor readings, metrics, logs, pretty much everything. When referring to corporate data, it … Continue reading Data, Data Lakes and Data Warehouses (Notes)

Data Architecture, Data Modelling and Data Processing (Notes)

Data Architecture (DA) Most organisations / companies have enterprise architecture which describes how a computer network (with storage, servers, switches, routers etc.) is laid out. Data architecture is very similar in that it shows the models, rules, standards, and policies that are used in the collection, storage, and use of data in an organisation / … Continue reading Data Architecture, Data Modelling and Data Processing (Notes)

One Hour

One hour. Originally I thought that it would be hard to keep a young person interested in coding for that amount of time each week after a day in school. After another successful Code Club lesson I have come to realise that one hour flies by way too fast. Children learning to move sprites, changing … Continue reading One Hour