Blog 11 – Week 14 by Eclipse-73 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 Eclipse-73 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 Eclipse-73 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 Eclipse-73 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 Eclipse-73 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 Eclipse-73 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 Eclipse-73 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 Eclipse-73 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 Eclipse-73 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 Eclipse-73 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