ABC SQL

Coming from a non technical background, it took me a while to start coding and understand it. Having met so many people who came into coding from different backgrounds, I decided that it is time to share some of my experience.

Today is my first technical blog explaining the basic SQL statement in plain English. You use SQL to query data held in a relational databases.

The core of SQL is the below Statement:

  1. SELECT “fields”
  2. FROM “table”

The above is the core SQL statement which you use to to be able to query. You are basically telling SQL which fields you want and where to find them. Select is getting the fields you want, the order of the fields you ask for are the order of the fields the table will be created with. If you put “*” instead of names of fields, all the fields in the same order as the original table will be provided. From is where the query can go and find the fields, which table does it look into.

In my example, I am asking SQL to get me all the fields in customers table.

This is a short blog, let me know what you think and based on feedback will be sharing more.

#AnalyticsDrivenStratege #DataAnalytics #DataEngineering #DataScience #DataManipulation #DataCleansing #coding #sql

Follow my Blog via Email

Enter your email address to follow this blog and receive notifications of new posts by email.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s