Andy (@SQLBEK) posted the article T-SQL Tuesday 84: Growing New Speakers encouraging people interested in becoming a speaker to blog on a topic they would want to present on. This got me to thinking about a topic that would be ideal for me to get started on the road to becoming a speaker and contributor to the community overall.
Being fairly new to blogging and wanting to start with post that covers beginner level topics. The thought of a fundamental blog series on T-SQL Fundamentals popped up into my head.
Why a T-SQL fundamental series?
Understanding the foundations and basic concepts are key to mastering anything and SQL server is no different. My experience over the years working with SQL server has shown me that some database designs and applications have issues and bugs. We know that no application is without bugs. I am referring to the ones that are inflicted by the developers due to lack of understanding of the fundamental concepts of database and query design. In my career, I have come across database applications that needed to be redesigned due to issues like this. Bad design ultimately leads to bad data and bad data can’t be trusted. Understanding the fundamentals in the series will help beginners be successful in there journey.
What to expect from the series
This series is an opportunity for me to share what I have learned over the years with a bottom up approach. The intended audience of this series would be individuals that are just starting out with SQL Server. The series will be broken up into three blog articles as outlined below.
Introduction to SQL Server 2016
1. T-SQL history
2. Understanding data types
3. Referential Integrity
4. Creating database objects
Inserting, Updating and Deleting Data
1. Inserting Data
2. Updating Data
3. Delete Data
Getting started with queries
1. Logical Query Processing
2. Basic Select Statements
3. Advance Query’s
This outlines the topics that will be covered at a high level. Each subtopic will be broken down into theory and example scripts. The reader will be able to complete the serious and have a basic understanding of how to work with data in SQL Server.
Andy (@SQLBEK), Thank you for giving me the added inspiration to get this blog started and even more for offering to help people like myself. Your feedback on this post can and will be very valuable to me as I move forward and get more involved with the community.