Tips: Query Relational Data

This is the second course in the Microsoft Professional Program for Data Science. It is about Transact-SQL and the laboratory exercises in every module is done in an external site, i.e., DataCamp wherein you have to complete the SQL queries to gain the needed XP points. The last time I wholeheartedly used SQL was 2 years ago and before taking up this course I can say that I only know the basics– say, SELECT ___ FROM ___ WHERE. Right now I can say that my T-SQL skills have leveled up even though the exercises aren’t enough for me to fully practice.

The lab exercises and final exam are graded so only one attempt to answer per questions is allowed. I suggest take notes on where to use some of the queries and what will be the outcome when using different functions. The final exam doesn’t purely focus on the syntax– some questions will make you recall the concepts or the use of a particular SQL command that was brought up in the video so be patient in the modules (they’re 11!). Save the SQL queries / your answers in the lab exercises to a file because they might come in handy in the next questions.

See you in the next module and happy studying!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s