You can practise SQL live online for Free. Here are a list of some websites in no particular order.

  1. Oracle Live SQL. This site also has lots of examples and tutorials which you can see the codes right there and then
  2. SQL Fiddle: You can practise various SQL by major players here as well.
  3. w3schools: Has lots of fundamental examples and sample database for practice

People Who Read The Above Post Also Read This:

Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding Free Entity Relationship and Relational Schema Diagram Tool SQL Statement Query Clause Evaluation Order – Which Part of SQL Statements Execute First and in What Order? Default ThumbnailHow To Use ER Assistant – FREE Entity Relationship Diagram (ERD) Creation Tool

Similar Posts

Drop Shipping Ecommerce Database ER Diagram and Conceptual Modeling
|

Drop Shipping Ecommerce Database ER Diagram and Conceptual Modeling

Bydatapandasadmin

In this short article, we look at a sample ERD Diagram which is designed using ER-Assistant software (usage of this software is covered here: How To Use ER Assistant) after we have finished with the Conceptual Modeling. Hence in the first place, we have to gather some Data requirements. This involves business logic and requirements,…

Teradata Viewpoint – SQL Scratchpad – Writing Queries Dillard’s Department Store Database
| |

Teradata Viewpoint – SQL Scratchpad – Writing Queries Dillard’s Department Store Database

Bydatapandasadmin

Analysing ‘Big Data’ from a database with real world data requires retrieving data from the database by writing relevant queries. As part of “Managing Big Data with MySQL” by Duke University on Cousera, I dealt with real world data that comprise hundreds to millions of entries/rows. This is the database of Dillard’s Department stores, specifically, the UA_DILLARDS that contains…

Get Numbers and Percentages from Tables – Microsoft Sql Server

Bydatapandasadmin

Sometimes you want to get some numbers and also percentages for quick analysis. This is a quick simple way to get quick overviews   People Who Read The Above Post Also Read This: Populating Superset Caravel MySQL database tables with Data via Heroku Rank a Place Visited By a Customer- Microsoft SQL Server – T-Transact…

Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding
|

Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding

Bydatapandasadmin

I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts of Transact-SQL (T SQL)  and  Microsoft SQL Server in general What is Transact-SQL or T SQL. T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query…

| |

How To Use ER Assistant – FREE Entity Relationship Diagram (ERD) Creation Tool

Bydatapandasadmin

There are a lot of ER Diagram Tools. However, by far, one of the favourite ones I use is the ER Assistant which is also free. You can download the ER Assistant free software from here: ER Assistant Download. Install the program after download. In this post, we will learn how to Create Entities Create…

Java Python R SQL Excel Compared Similarities For Data Science and Data Analytics – The Basics
| | | | |

Java Python R SQL Excel Compared Similarities For Data Science and Data Analytics – The Basics

Bydatapandasadmin

If you have ever worked with Java, Python, R, SQL, Excel and other Languages on a varied Data Science or Data Analytics projects, you will realise that all these languages have similar syntaxes, or at least, can achieve the same objective with very similar codes.   Below is a comparison and similarities of these various tools…

Leave a Reply

Your email address will not be published. Required fields are marked *