^ Good post
Had planned on replying last night but ended up losing everything so gave up as I was exhausted.
But just to add to 2nd year Databases, if you can practice SQL queries and get your head around them then you should be away with it. Reason Im saying this is they form a huge percentage (as in marks) of the overall module. You will probally see it on a written CA, a Lab CA and the FE. So even if you cant swallow the theory (which is mindnumbing at best) you can still do well.
some tutorials http://www.w3schools.com/sql/default.asp
Structured Analysis and Design (aka SAD, for a very good reason) is a fairly time consuming module. You will have a project (design some sort of system i.e a booking or rental system, no coding just designing). On top of that there is a block of theory to swallow aswell, so this is another one you will have to watch. But I think if you do well enough in the project you can pretty much pass the module (apart from that 30% rule).
As mentioned above if you are MM then you will be coding your design as part of the sem2 project.
Everything else was grand as I rememeber, java is moving away from using tutorial style lab sheets to working on your own initative using the API which is pretty much how it works in industry.
Networking ... yeah more theory but also involving practicals. I found it interesting, its not everyones cup of coffee.
Overall, y2 semester 1 is tough, no point trying to sugar coat it, but work at it and you will be fine. Semester 2 should be alot more relaxed with more laid back modules.