Course info

SQL is THE most important query language you can learn!

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

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Primer introduces you to a solid foundation in databases in a way that’s both informative and engaging.

In detail, you will learn:

• What exactly SQL is and how the core syntax looks like

• How to write SQL commands

• How to install MySQL workbench

• How to create and structure database tables

• Which data types you may use and when to use which data type

• How to perform CRUD operations: Create, Read, Update & Delete Data

• How to insert data into tables

• How to query and filter data

• Why you should split data across multiple tables (and how to do that)

• How to join (merge) data into combined result sets

• How to write basic and more complex queries

• How to aggregate and group data

• How to use built-in database functions to work with numbers, text or dates

• How to optimize databases with indexes

So, let’s do this! Enroll today and start learning SQL!

Happy Learning !!