bestcourses is supported by learners. When you buy through links on our website, we may earn an affiliate commission. Learn more

Learn SQL databases in a weekend

SQL crash-course with everything you need to jump into database programming projects. Learn it all in a single weekend!

4.85 / 5.0
112 students8 hours 22 minutes

Created by Girts Strazdins, offered on Udemy

bestcourses score™

Student feedback

5.1/10

To make sure that we score courses properly, we pay a lot of attention to the reviews students leave on courses and how many students are taking a course in the first place. This course has a total of 112 students which left 30 reviews at an average rating of 4.85, which is average.

Course length

9/10

We analyze course length to see if courses cover all important aspects of a topic, taking into account how long the course is compared to the category average. This course has a length of 8 hours 22 minutes, which is pretty short. This might not be a bad thing, but we've found that longer courses are often more detailed & comprehensive. The average course length for this entire category is 7 hours 54 minutes.

Overall score

5.9/10

This course currently has a bestcourses score of 5.9/10, which makes it an average course. Overall, there are probably better courses available for this topic on our platform.

Description

This is an intensive crash-course of SQL databases, the absolute essence. It contains everything you need to know to jump into real SQL database projects. And you can do it in a single weekend!

You will learn:

  • What SQL databases are and how they are structured

  • How to set up the necessary tools to get started

  • How to CREATE TABLEs and modify their structure later

  • How to export the data and table structure to a backup-file, and restore a database from a backup

  • How to INSERT data

  • How to write queries to SELECT the necessary data, including WHERE conditions, ORDERing, aggregation and GROUP BY, conditions * and functions.

  • What the mysterious NULL values are and why they behave so weirdly

  • How to DELETE data

  • How to UPDATE data

  • How to link together tables and select data from multiple tables using JOINs

The course contains a great deal of practical exercises:

  • Short quizzes to test your understanding along the way

  • Exercises in every section, including an extensive set of exercises using multi-table SELECTs with JOIN

  • A course project in Python and Java where you will read data from an SQL databases in your program

We will use the MySQL database engine - one of the most popular choices of SQL, a free and open-source solution.

Check out the free videos and see you in the course!

What you will learn

  • Understand what SQL databases are and how to work with them
  • Be able to jump in a project requiring SQL knowledge
  • Create your own SQL database with multiple tables
  • Write simple SQL queries to fetch the data you need
  • Have a stable basis for further exploration of more advanced SQL topics
  • Find community help and documentation for SQL
  • Use SQL databases in Python, Java and other programming languages

Requirements

  • Basic programming skills are advised (not strictly necessary)
Udemy logo
Available on

Udemy

With almost 200,000 courses and close to 50 million students, Udemy is one of the most visited online learning platforms. Popular topics include software development, the digital economy, but also more traditional topics like cooking and music.

Frequently asked questions

  • Price: $29.99
  • Platform: Udemy
  • Language: English
  • 8 hours 22 minutes
Learn SQL databases in a weekend thumbnail

bestcourses score: 5.9/10

There might be better courses available for this topic.