About Alex

The Apprentice!

Boot-Camp Week 6 – Time Flies

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.

QA Apprenticeships

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
  • ADO.NET
  • 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.

QA Boot-Camp Week 5

Week 5 of C# boot-camp was one of the best yet. It was nice to have a break from just C# as this week we were learning all about data and SQL.

SQLServer2008

This week we learnt about;

I had previously used the entity framework to connect to a SQL database, so I already knew the basics. It was still very interesting though to sit down and fully understand the ins and outs of SQL as I had previously self-taught myself.

One of the important things I learnt was, you have to fully understand your data and it must initially have been modelled correctly for you to get your desired results. I realised that it is not very practical to start amending your tables when writing queries, as this wouldn’t happen in a ‘real life’ situation.

Another topic I found interesting this week was when we were writing simple SQL statements and querying the database. I found this fairly important because any company, or even a program that stores information back to a SQL database will at some point need to be queried to retrieve the required set of data.

We started off by writing simple SELECT statements specifying the column names, then using keywords such as DISTINCT and sorting results using ORDER BY. We then moved on to slightly more complex statements by limiting rows using the WHERE clause and the BETWEEN, IN, NOT and LIKE clauses. We also started retrieving data from different tables using INNER joins, OUTER joins and very briefly COMPOSITE joins.

Overall I have really enjoyed this week as it was nice to have a break from C# and learn something new. I am looking forward to what our tutor has in store for us next week, as we carry on learning about SQL and I believe we also get to have an introduction to web development.

 

 

Week 3 of QA C# Boot-Camp

Yesterday, I finished my third week of C# Boot-Camp at the QA training centre in London.  It was a pretty difficult week this week as we carried on building on what we have previously learnt in the beginning weeks. It’s really important to get a good understanding of the work we are doing because if you don’t you will have nothing to build on!

This week we mainly learnt about:

Exceptions weren’t that hard to get my head around, as the syntax was pretty easy to learn. Exceptions, realistically should never happen, as it is an ‘exception’ and therefore a one off (they should hardly ever happen).  The reason behind exceptions is that you try and predict what will go wrong and cause the program to crash, before it happens. The way we do this is to put the code we are hoping will work inside a ‘try’ block, the code we want to run if ‘try’ black code doesn’t work inside a ‘catch’ block and the code that will always run no matter what after the ‘try’ and ‘catch’ is the, ‘finally’ block. They are the three fundamental pieces of code you will need to remember when writing good Object Orientated code. Don’t forget to use ‘throw’ when you want to throw an exception, either one that you have made yourself or a built in one.

Statics was particularly hard subject for me in the third week of boot-camp. I struggled to get to grips with static classes and constructors and getting them to work with each other. After doing a lot of exercises in both the training room and at home I began to understand what it was all about. Afterwards I had a base to build on so then I started to compare the difference between the static and instance methods and started applying read-only fields.

Also in my third week I learnt how to use the Visual Studio Testing Tools, mainly Unit Testing. I created Unit Test Projects in Visual Studio 2010 and started testing methods that I had written to add, subtract, multiply and divide using looping! This was a very interesting task to do as you think that adding, subtracting, multiplying and dividing are easy, but programmatically they are much more difficult than you think. I later added programmatic methods for calculation the power and modulus and tested them also. You have to be carefully when testing the methods you have written because you need to make sure that the method will work no matter what numbers you want to give it to test, and that you know what the result is before you test it.

The ‘working with files’ topic wasn’t particularly anything new to me, as I had previously been set a project at work which consisted of me writing information about a PC to a .txt file. Although I had learnt the syntax on my own and managed to get the code to work, it was also important that went through the work in the training room as well so that I could pick up on any little bits that I may have missed. Before you go ahead and write some code to read or write from a file, please do not forget to add the following reference as it may save you alot of time de-bugging!

Using    System.IO;

The last thing we did on our 3rd Week of C# Boot-Camp is a City and Guilds Exam which was ‘Creating an Object Orientated Computer Program using C#’. We had previously completed a mock exam earlier on in the week and I didn’t find it too difficult. Most of the marks are gained by meeting the specification requirements I.e. naming controls, comments etc. It was a 4hr exam, so after I had completed it, I made sure I had time at the end to scan through my code and add extra comments where appropriate. I also compared and ticked off requirements on my spec when going through my code to make sure I had met them. I am looking forward to writing another blog next week and also letting you guys know what my result was!

City and Guilds