100%
LESSONS & TOPICS

Lesson 2 – Data Types and Combining tables

Lesson 2 – Data Types and Combining tables

In this lesson we will start by going through some methods to import data into tables. We’ve learned how to insert data into the database through a script, but there will be cases where there is existing data that we will need to import in bulk. We will try out a couple methods to import data, and practice further techniques in MySQL using the data that we’ve imported. The main technique we will be practicing will be combining tables. Combining, or joining tables, is a very powerful and popular technique to provide further insights from the data that is housed within the tables. It’s definitely an area that you will need to get familiar with to be fluent in working with databases.