SQL Beginner to Guru

MySQL Edition - Master SQL with MySQL

By: John Thompson

Write A Review

eText | 29 May 2019 | Edition Number 1

At a Glance

Format
PDF

eText

$59.39

or 4 interest-free payments of $14.85 with

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!

Key Features

Learn to aggregate and analyze data using SQL functions
Get up to speed with SQL using MySQL

Book Description

SQL is the programming language used to get data in and out of databases. Relational databases are extremely popular with companies of all sizes.

Employers are also constantly searching for people with SQL skills, which is ideal if you're looking to pursue a career in this domain.

In this course, you will learn how to use SQL using the MySQL relational database - one of the most popular databases in the world. You'll start by installing MySQL workbench on your computer. Next, you'll understand how to import the famous MySQL employee database into your MySQL database. Gradually, you'll get hands-on with generating SQL reports, before going on to exploring all about SQL join statements. In addition to this, you'll create table joins using database tables with millions of records. You'll discover how easy it is to use SQL to update one record or multiple records in the database. As you progress, you'll delve into using SQL sub-selects and writing advanced SQL reports against an e-commerce database.

Later, you'll focus on what database transactions are, and the tools you have to control them with MySQL. The course will then take you through using SQL to create tables in your MySQL database. You'll also learn the MySQL syntax to alter existing database tables. Finally, you'll tackle challenging real-world-style assignments for SQL reporting and database maintenance tasks, along with using SQL views for common reports.

By the end of this course, you will be well-versed with SQL and have the skills to use it effectively for your database management needs.

All code and supporting files for this course are available at https://github.com/PacktPublishing/SQL-Beginner-to-Guru-MySQL-Edition---Master-SQL-with-MySQL