1 / 6

Learning Sql with Strata Scratch

This is great in the fact that they are easy to understand and most of the instructions are quite easy to follow. Once you begin practicing and submitting SQL demands you will receive the results immediately. Strata Scratch will show you how to create your own tables and you will also be able to perform deletes, updates, selects, inserts, as well as drops in your tables.

stratascratch
Download Presentation

Learning Sql with Strata Scratch

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LEARNING SQL WITH STRATA SCRATCH

  2. Data analytical skills are very important whether you are aspiring to become a data scientist or simply a student or a professional specializing in a different field but somehow needs to deal with a large chunk of data. The SQL Editor • Log in to your account to see your homepage as shown on the image below. The homepage consists of your account information, settings, tabs, and a number of dropdown menus located on the top toolbar. We will begin by exploring the functionalities of the SQL Lab menu which consists of all the basic tools you need to start your database. • Go ahead and click the SQL Lab menu. Here, you will see various options whether you want to start your SQL queries or upload your tables. • ​Under SQL Lab menu, choose SQL Editor.

  3. Your page should look like on the image below. You will notice the configuration bars on the left side, the editor box to type SQL commands, and a number of tabs below the editor.

  4. If you are a new user, you will see an untitled query tab on the left side of the page. Below the tab are configuration options which allow you to choose a database and dataset. A public schema dataset is uploaded by default for your convenience. It is composed of public datasets which you can use as a reference. However, the schema is read-only so you cannot make any changes to it. You also have access to your own dataset repository under your private schema username where you will have full privileges, such as reading or editing your datasets. Under your private schema, you are given the freedom to move data from other schemas or upload your own CSV file. Accessing Public and Private Datasets

  5. Contact us: Improve your business and marketing analytics skills with our practice problems, exercises, and guides team@stratascratch.com Strata Scratch San Francisco, CA​

More Related