From the course: Advanced SQL: Logical Query Processing, Part 1
Tooling - SQL Tutorial
From the course: Advanced SQL: Logical Query Processing, Part 1
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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.