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.

udemypostgresql

udemyoffer

 

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. 

 

udemy1

 

Advanced SQL commands are next. This essentially covers

  • Mathematical Functions
  • Timestamps and the extract function
  • String Functions and Operators
  • SubQuery
  • Self-Join

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.
 

If you're interested in taking the course, Iprogrammer has negotiated a 75 percent discount code for The Complete SQL Bootcamp, valid until December 31, 2016. Click in the image below or on this link:

 

 udemypostgresqlsq

More Information

Udemy: The Complete SQL Bootcamp

Related Articles

Jumpstart Your Career In Game Development With Udemy

Get Up To Speed With iOS 10 with Udemy 

Udemy's Angular 2 The Complete Guide Course Review 

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

 

Banner


Meta Releases OpenSource Podcast Generating Tool
28/11/2024

Meta has released an open source project that can be used to automatically convert a PDF file into a podcast. Meta says Notebook Llama can be considered an open-source version of Google's NotebookLM.

 [ ... ]



C23 ISO Standard Is Here But You Probably Won't Read It
06/11/2024

At last ISO C23 has been published, but at $250 you probably aren't going to read it. Can we really tolerate this sort of profiteering on the work of others? This is worse than academic publishing!


More News

 

espbook

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Tuesday, 29 November 2016 )