Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

SQL Basics

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Tools We'll be Using

3:57 with Andrew Chalkley

In this video, we'll look at some different tools that you may use in a professional setting and what you'll use while learning here; SQL Playgrounds.

Different Database Tools

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    [MUSIC] 0:00
    Throughout this course you'll be using Treehouse's interactive database 0:04
    environment, SQL Playground to write SQL programming code. 0:09
    You can press the launch SQL button at the beginning of each video to 0:13
    launch an interactive SQL environment. 0:17
    You can use the Playground to run the code that I'll be talking about in the video. 0:20
    Now, don't worry if this looks slightly different from what 0:23
    you have on your screen. 0:27
    That just means you've probably got a newer version 0:29
    of SQL Playground with all the latest and greatest features. 0:31
    Each Playground will have a number of pre-populated coding areas listed here 0:36
    at the top left. 0:40
    [SOUND] As I discuss the SQL programming code, 0:41
    feel free to hit the Run button to run the SQL programming code. 0:45
    Don't worry if you don't understand what this means right now. 0:50
    I'll be explaining this in detail in the next video. 0:53
    Just realize that when you run any of your code, you write in this section here, 0:56
    this SQL Playground will show the results here, in the lower section. 1:01
    Since this is a playground, feel free to play around with any of the code you want. 1:07
    If you made a mistake and want to go back to the original SQL code hit Reset. 1:14
    Feel free to pause any of the videos at any point as you use the SQL Playground. 1:21
    It's also normal to re-watch videos to help you cement what you learn. 1:26
    If you want to try something out for yourself, click on New Query, and 1:31
    it will open up a fresh coding area. 1:35
    You can start something new of your own from scratch. 1:38
    You can add as many coding areas as you like. 1:42
    However, when you close SQL Playground, none of your code will be saved. 1:46
    If you open up SQL Playground again from the video page, 1:50
    it will reset to the initial state. 1:53
    If you want to save something, copy and paste it into a safer place. 1:56
    To explore the database structure, click Database Schema. 2:00
    This will show you all the tables with their names, number of rows, 2:05
    their columns, and the date types. 2:12
    Finally, we have a list of tables. 2:19
    Clicking on a table will give you an overview of that particular table, 2:23
    its columns, data types, and its content. 2:28
    When you're writing SQL code in one of the coding areas, you can press on 2:38
    the icon on the right of the table name to show the columns in that table. 2:42
    This is nice because you don't want to click away when writing your code. 2:48
    You can hover your mouse over the column name, and it shows the data type. 2:53
    Now this is the environment you'll be laying to use SQL. 2:58
    But let me show you a couple of quick examples of 3:01
    other places that you could write SQL in your professional career. 3:03
    Many companies use third party services like Mode Analytics to generate reports. 3:08
    See how this area where you can write the SQL code and 3:13
    the results are shown at the bottom. 3:16
    If you're a PHP developer, you may come across a tool called phpMyAdmin. 3:21
    See there's an area for a SQL code, and then you get the results. 3:26
    And there are countless other tools. 3:31
    They are all variants on the same theme. 3:34
    Some have more features than others. 3:36
    But they all have the same requirement, a knowledge of SQL. 3:38
    I've included some other examples in the teacher notes. 3:44
    Remember, every coding video will have its own dedicated SQL Playground. 3:47
    So when moving from video to video, remember to open up a new SQL Playground. 3:52

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up