More and more organisations are making their way slowly on the data-driven path. As a result, it’s becoming more and more necessary for people from different backgrounds to access the data and potentially query the database storing business-critical data.
Therefore it is becoming necessary for more people to write SQL queries. In addition, just about every business is trying to become data-driven, and just about every company has a relations database.
I have written a series of blog posts that have been published over the last week or so that I hope will help people start on their SQL journey.
If learning SQL is one of your goals for the year, then this series will hopefully give you a place to start. I’m intending to continue this series over the coming year so look out for future posts too
How to Write SQL Queries
If you want to read our How to Write SQL Queries in order, then the links and the order are provided below
- Database fundamentals – How to Write SQL Queries series. In this post, we discuss why it’s important to understand the database design and schema and talk about some basic database fundamentals
- Simple SELECTS –Â How to Write SQL Queries series. In the second post, we look at how to write a SELECT statement from a single table
- Column Expressions – How to Write SQL Queries series. We look at column expressions, aliases
- Filter with WHERE – How to Write SQL Queries Series. We will learn how to filter rows returned by our SELECT statement
- Using LIKE for Wildcard searches – How to Write SQL Queries – We look at using LIKE for wildcard searches.
- Using ORDER BY to sort our results We look at sorting the data returned by our query
- Understanding NULLs – In the final post in this series we talk about NULLs and how to handle them
If you would like to learn more about writing SQL Queries, then maybe our Querying Data with Microsoft Transact-SQL course running in February.
You can sign up here
Useful Links
Subscribe to our YouTube Channel
0 Comments