Beginning Your SQL Journey | Tables
SQL stands for Structured Query Language; It's a database language which you can use to interact with data stored in relational databases.
A database is nothing more than a structured set of data that is held in a computer and in that respect, knowing SQL is like having access to one very big spreadsheet where you can find many details on your customers: what plans they are on, what marketing campaigns they saw when they signed up, their address, birth date, ... You name it. Knowing how to use SQL allows you to retrieve just about any data you could ever want to know about your customers.
A relational database is a database structured to recognize relations among stored items of information. These items are stored in tables, and each single table contains information on one single topic. This means that a table might represent personal information on clients of a bank or the results of the marketing campaign, but not both.
For this course, you'll be using a database containing information on marketing campaigns of a bank. To the right, underneath the editor, you can see the data in this database by clicking through the tabs.
From looking at the tabs, who is the first client identification number or
clientid
listed in the clients
table?This exercise is part of the course
SQL Tutorial for Marketers
Exercise instructions
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
