Tools We'll be Using3: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.
[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