|Complete SQL Bootcamp Course
|Written by Kay Ewbank
|Monday, 21 November 2016
A SQL bootcamp that starts from the very beginning is available from Udemy. While it is based around PostgreSQL, the majority of the lectures are agnostic about the dialect of SQL you're using so could apply more generally and we have an offer that makes it worth a closer look.
The Complete SQL Bootcamp is taught by Jose Marcial Portilla, Head of Data Science for Pierian Data Inc. and provider of personal data science and Python training courses to a variety of companies all over the world. There are 87 lectures, a total of eight and a half hours of video, in the course.
Once the topic of databases has been introduced as a concept, there are a few PostgreSQL specific lessons on installing the database server on Mac and Windows, and how to create databases and tables in the PostgreSQL administrative interface. Most of the material on databases and tables does apply generally, and the administrative interface is similar to those of other servers. It's at this point in the course that you receive your first 'challenge'. The concept is that you've been hired as a SQL consultant by DVD rental store, and throughout the course you face challenges that you need to complete in your role as consultant. The first one is to restore a database. The challenges start off reasonably simple - essentially repeating what the previous lecture explained. As the course progresses, though, they become more complicated.
The heart of the course starts with SQL statement fundamentals, working up from a simple SELECT through SELECT DISTINCT and SELECT WHERE. Operators such as COUNT, LIMIT, ORDER BY, BETWEEN, IN and LIKE are all brought into the mix. The GROUP BY and HAVING statements have their own lectures, after which you get an assessment test.
Joins are next on the agenda. This is in my experience where people get into a mess, and I thought the explanations here were done well. There are links to additional resources if you want more information after the lectures are finished. Inner, outer and Union joins are all covered, and explained in a way that I think would make sense even if you'd not encountered them before.
Advanced SQL commands are next. This essentially covers
The next section of lectures covers database design in terms of data types, primary and foreign keys, constraints, INSERT, UPDATE, DELETE and ALTER TABLE.
A fairly meaty lecture on Views is next, with good descriptions of what views are and why they're useful. The final section of the course is on using PostgreSQL with Python. If you're working with PostgreSQL, this is a good introduction to using it with Python.
Overall, this course seemed to offer comprehensive coverage of SQL. It would be ideal if you want to work with PostgreSQL, but would still be useful for other SQL databases.
or email your comment to: firstname.lastname@example.org
|Last Updated ( Tuesday, 29 November 2016 )