Quizlet – Practice Test: heat/C170 (Double OA ) Passed - Study Materials and "Cheat Sheet" for LabHey all, I want to add my quick experience with this class. I passed the C175 pre-req last Thurs and took both OA tests for C170 tonight (Wed) and passed. You build on the information you learn in C175 so I strongly suggest doing these back to back without any delay so you don't lose momentum. I feared that these classes would take me forever because out of everything I know about IT stuff, databases was a dark corner of the room for me. But, in less than 2 weeks I was able to pass both classes.I am a huge fan of Pluralsight and have said in other course reviews I've done that it is well worth the cost if you are buying a license on your own. I didn't even know about it until my work bought like 300 licences to give to everyone in IT and it has been a God-send. I have used almost nothing but Pluralsight videos for this entire degree so far (13 classes and counting - CSIA). Not only is the info well organized and well presented, the app lets you download the vids, listen vs watch if you have the screen off, and sync progress between your device and the website. Ok, enough nut swinging...I used these courses for these 2 classes:WTF is a database?WTF is SQL?How do I write SQL part 1?How do I write SQL part 2?
I didn't read anything from the uCertify book cause it is so mind-numbingly dry and boring that all the Adderall in the world couldn't keep me focused. I have heard lots of people also really like Caleb Curry onYouTube. I couldn't get into his videos, it's just not my style or cadence, but give him a shot yourself.Alright so specifically for C170, I HIGHLY, HIGHLY recommend that you do the 16 labs found in the uCertify text (from the course overview page, click on "Go to course material" > click on the 9 box navigation icon in the top left by the WGU logo > click on "Labs"). These are almost WORD FOR WORD what you'll see on the 11 question OA. For example, the labs talk about a donut shop, and the actual testtalks about a coffee shop. But they are exactly the same. I read another person say if you can do the labs without peeking at the results when you click "Submit" (it gives you the correct SQL query to run), then you're golden. I agree with that 100%. I took 2 hours this afternoon running through the labs once more then took my OA and it was all still fresh in my mind that I got done with the OA in like 20 minutes.