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

  • 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:



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.



Let Oracle's Coding Assistant Do The Grunt Work

Oracle is getting into the coding assistants game. The aptly named "Oracle Code Assist" is going to be optimized for Java, SQL, and Oracle Cloud-based applications.

Learn Cryptography Without The Math

Are you sick of the math associated with cryptography?
You don't have to be any more. Applied Cryptography from the University of Tartu shows cryptography without the math! At last, a hands-o [ ... ]

More News


kotlin book



or email your comment to:

Last Updated ( Tuesday, 29 November 2016 )