Description

Technics Publications – Database Series The Definitive Guide to MySQL and MariaDB

Technics Publications – Database Series The Definitive Guide to MySQL and MariaDB-RiDWARE
English | Size: 591.08 MB
Category: Tutorial
Follow along with MySQL expert Victor Deras and master relational database constructs and MySQL (and MariaDB). Build powerful and robust relational databases after watching these 12 topics within the MySQL video series:

– Introducing MySQL. This first topic in the MySQL (and MariaDB) video series introduces you to this powerful open source relational database. Install both client and server, on Windows or Linux. MariaDB can also be used as an alternative to MySQL, and almost everything in this course also applies to MariaDB.

It’s used by many popular relational database management systems like MySQL or PostgreSQL. But it’s also used by data analysis and big data frameworks and tools like Apache Spark.

Hence knowing SQL opens up an endless amount of opportunities and jobs – no matter if you’re going to work with relational databases or if you’re becoming a data scientist, knowing SQL will be key!

This course teaches you SQL from the ground up and in extremely high detail!

In addition, this course comes with two main paths that you can take:

1. The “Complete Course” path where you go through the entire course, step by step, learning about ALL the key features and concepts you have to know
2. The “Quick Summary” path where you will learn the key SQL essentials within a few hours

Both paths are included in this course (i.e. with one single purchase) and you can switch between them or take both – simply as it makes most sense for you! Just dive into the free first course section to learn all about this course and these two paths (and how to take them).

SQL is a standardized language and therefore learning SQL will help you apply it in all kinds of contexts. Nonetheless, different database systems also support different aspects of SQL or bring their own variations of the SQL language. Therefore, this course dives into SQL by exploring all key features at the example of the two most popular database systems: MySQL and PostgreSQL. All query and command examples are shown for both database systems, ensuring that you feel comfortable working with SQL in either environment!