Learn SQL databases in a weekend




Learn SQL databases in a weekend

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!

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

Url: View Details

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

Rating: 4.65

Level: Beginner Level

Duration: 8.5 hours

Instructor: Girts Strazdins


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of course-link.com.


© 2021 course-link.com. All rights reserved.
View Sitemap