eTEXT
SQL Beginner to Guru
MySQL Edition - Master SQL with MySQL
By: John Thompson
eText | 29 May 2019 | Edition Number 1
At a Glance
eText
$283.79
Instant online reading in your Booktopia eTextbook Library *
Read online on
Not downloadable to your eReader or an app
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 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 searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'.
In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world.
In this course, you will:
Learn how to install MySQL workbench on your computer.
See how to import the famous MySQL employee database into your MySQL database.
Get hands-on experience generating SQL reports.
Master SQL join statements.
Create table joins using database tables with millions of records!
See how easy it is to use SQL to update one record or many records in the database.
Learn to use SQL sub-selects.
Write advanced SQL reports against an ecommerce database.
Understand what database transactions are, and the tools you have to control them with MySQL.
Use SQL to create tables in your MySQL database.
Learn the MySQL syntax to alter existing database tables.
Tackle challenging real world style assignments for SQL reporting and database maintenance tasks.
Leverage SQL views for common reports.
All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/SQL-Beginner-to-Guru-MySQL-Edition---Master-SQL-with-MySQL
Read online on
ISBN: 9781838982829
ISBN-10: 1838982825
Published: 29th May 2019
Format: PDF
Language: English
Publisher: Packt Publishing
Edition Number: 1
