It feels like I am writing a new blog post to you guys every day, the weeks seem to be flying by so fast! We started off by carrying on where we left off last Friday, which was writing SQL statements and JOINS.
After going back over what we learnt previously, we then later moved on to talk about:
- SQL Updates and Referential Identity
- Defining and using views
- Summarised and sub – queries
- SQL EXAM
- Introduction to Stored Procedures
- LINQ primer with Entity Framework
- Introduction to web development
- Web Application architectures
- HTML and XHTML
As you can see, it has been a pretty busy week, both physically and mentally due to the amount of homework and the late nights doing it.
The leap from last week’s SQL topics to this week’s SQL INSERT, UPDATE and DELETE statements and also the summarised queries which consisted of MIN, MAX, AVG, COUNT statements.
We then faced a SQL City & Guilds exam which was based around everything we had learnt over the past week or so whilst studying the SQL topics. Towards the back end of the week I was awarded with a distinction for the exam. As you can imagine I was over the moon, a little bit of hard work really does go a long way!
Another topic I especially enjoyed was when we were learning how to write LINQ and lambda expressions in a C# project. I used Visual Studio to create an entity data model whilst using the Entity Framework to connect my database with my Windows Forms project. I particularly liked this because we were basically creating a new user friendly UI for a database which would normally be used in the real world.
Towards the end of the week we were given an introduction to web development and also the languages, software and tools involved, along with the actual architecture itself. I have previously written HTML code with a separate CCS file for a music artist, so I felt confident on those terms but I still think it will be good practice to still pay full attention, as I will most likely pick up bits of information I may have missed in the past.
Overall I think this week has been very productive. I’ve learnt that a little bit of work truly does go along way as I succeeded in gaining top marks in my SQL exam. I am looking forward to carrying on with web development and MVC3 next week.