Second, connect to the Local Storage connection then double click on the Local Storage Connection. The Call to Action below has the links to the EMP and DEPT spreadsheet data that will be used throughout this learning series.įirst, start traditional Toad Data Point. Toad Data Point has an internal database called 'Local Storage,' a MySQL database, that will be used throughout this course. The SQL you will learn in this series can be used to tweak SQL generated by Toad Data Point's Query Builder and can be used in any application where SQL is exposed. The better you know SQL, the more refined your SQL can become to select the desired data from data stores using tools such as Toad Data Point. SQL stands for Structured Query Language and has been the standard query language for all relational databases since the mid-1980s. By accessing relational data directly using the SQL language, or simply by tweaking the code snippets and SQL produced by the Toad Data Point Query Builder, you can better perform your role.

Learning SQL can be a challenge, but one that’s made much easier by using tools that make finding, preparing, extracting and reporting on data simple.

Toad data point tutorial