Getting around in SQL
Published on Monday 10th February, 2020.
In preparation, I watched Tyler's first course on SQL that is hosted on egghead. It was really interesting and, though I knew most of it, I appreciated the clarity and focused nature of Tyler's delivery.
Almost all of my experience with SQL has been with MySQL. Tyler delivers his course using PostgreSQL which is almost entirely new to me. I realised that while a lot of the syntax is the same between the two implementations, there are some basic differences when it comes to navigation between databases and tables.
I put together a quick screencast to show these and I thought I'd share the screencast and a summary table.
|Connect to database|
|List tables in database|
|List rows in table|