Blog 11 – Week 14 by DustyFennec This week we covered some more information and examples that we can use in our applications. For example:DataGridView eventsUsing DataGridView to manipulate dataCreating a user in MySQL Mostly though it … Uncategorised | Sunday 27th June 2021
Blog 08 – Week 11 by DustyFennec This week we had a look at isolation levels and linq. Isolation levels allows you to define how select statements work during the execution of a transaction and can be … Uncategorised | Sunday 27th June 2021
Blog 07 – Week 10 by DustyFennec This week we looked into how we would set up the console app that is required in Milestone 2.This involved looking into using a data access class to communicate with … Uncategorised | Sunday 27th June 2021
Blog 06 – Week 9 by DustyFennec This week we are continuing from week 8 and covering subqueries, referential integrity and cascades. Subqueries are a select statement within another select statement and are used to obtain data … Uncategorised | Sunday 27th June 2021
Blog 05 – Week 8 by DustyFennec This week we covered more on ‘Group by’ and ‘Having’ as well as users, permissions, procedures and functions. Users and permissions control who is allowed to do what in the … Uncategorised | Sunday 27th June 2021
Blog 04 – Week 7 by DustyFennec This week we covered MySQL ‘Group by’ and it’s extension ‘Having’.‘Group by’ groups the output of a select statement by combining rows that have a column with repeating data, which … Uncategorised | Sunday 27th June 2021
Blog 03 – Week 6 by DustyFennec This week we covered SQL Joins, handed in Milestone One and started work on Milestone Two. Joins are used to combine two tables using a column from each table that … Uncategorised | Sunday 27th June 2021
Blog 02 – Week 5 by DustyFennec This week we learnt about the following SQL functionalities: Alter Table:The update command allows you to add a column, alter a column, rename a column, drop a column and rename … Uncategorised | Saturday 27th March 2021
Blog 01 – Week 4 by DustyFennec This week I learned about creating SQL procedures and how to change the delimiter (;). The delimiter sometimes needs to be temporarily changed so that procedures can be made, because … Uncategorised | Sunday 21st March 2021
Blog 00 – Week 2-3 by DustyFennec For the DAT602 course we will be building a game that makes use of a database. I have chosen to build the historic game of “Snake”. I have learnt:What CRUD … Uncategorised | Thursday 11th March 2021