T-SQL: murach’s SQL Server 2016

*NOTICE Code Snippets cannot be seen on WordPress Reader, must be viewed on original site ammccann.com

murach

Database?! I had no idea what I was getting into with this one. Turns out, though, I like it! There is some serious power in the back-end development side of the industry and I do believe that is the field I want to put more of my effort into. Just remember: SELECT, FROM, WHERE, ORDER BY! And other things… but we didn’t get there, yet.

A lot of my notes above are testing and structure practice, there’s quite a bit of dependency on logic when it comes to SQL I found even early on. Being a very highlevel language that depends little on formatting, it is very forgiving if you’re logic is spot on. I found I quite enjoyed it even from the beginning. This language remains less than glamorous as it is mainly used for data retrieval so far, but I can see the potential.

A little more structured first exercise:

What I got from this exercise was getting down the basic structure or the syntax and there was some syntax that was a bit out of reach from what I knew at the time such as the ‘[ABCE]%’ took me some research to find! After you get it down it all just seems so obvious, though, so funny, mostly frustrating, though, ha!

The last bit was another Database called Guitar Shop.

sql

Joining is a concept once foreign, now known, don’t forget! I once saw an Ad for a job posting that said specifically, “Can do ten table joins without fear,” as a requirement. Ha! I get it, but I started with two, not so bad once you figure out what the hell a relationship is. Code:

Unions seemed pretty important, too, but they can apparently have performance issues. Hey, though, they work! Work first, optimization second, right? Maybe, like I said, just getting started! A few more organized exercises. Code:

The last thing I worked on was the Guitar Shop selection. Code:

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