Databases

Introduction to SQL

Jasmin Ludolf

Senior Data Science Content Developer, DataCamp

Course goals

  1. Understand databases and their structure → Chapter 1
  2. Extract information from databases using SQL → Chapter 2
Introduction to SQL

Structured Query Language (SQL)

  • SQL communicates with databases

SQL is the language people use to communicate to databases

Introduction to SQL

Introducing databases

three tables in a database with sample data

Introduction to SQL

A closer look at tables

 

a database table called patrons

Introduction to SQL

Rows and columns

                                                                                                                                           

  • Individual data

  • Specific part of data
Introduction to SQL

Relational databases

  • Define relationships between tables of data inside the database

Table relationships

Introduction to SQL

Database advantages

many people querying a database

Introduction to SQL

Let's practice!

Introduction to SQL

Preparing Video For Download...