From the course: Advanced SQL: Logical Query Processing, Part 1

Tooling - SQL Tutorial

From the course: Advanced SQL: Logical Query Processing, Part 1

Start my 1-month free trial

Tooling

- [Instructor] The concepts you will learn are universal and apply to all relational database management systems. I will be using SQL Server for most of the demos, occasionally switching to show you how other databases behave or misbehave. For an ID, I will use SQL Server Management Studio and for the other databases, I'll use DBeaver Community Edition, which supports all mainstream databases. I will not cover installation or configuration of any of these databases or tools. In the code file for this video, you will find links to step-by-step installation articles for all databases I'll use in this course. If you can't install any of these and don't have access to a network server or a cloud-hosted database, you still have the option of using an online query service. An online query service requires no installation as everything is done inside your browser. There are a few such online services, SQL Fiddle, DB Fiddle, Rextester, and others, but my favorite one by far is db<>fiddle UK. It has proven to be highly reliable and free of commercial interest, qualities that most other services have not, let's say, excelled at. You will find db<>fiddle UK links to copies of all code files, including the database creation script embedded and hidden.

Contents