MySQL Tips and Tricks

MySQL Tips and Tricks

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 0h 54m | 150 MB

You don’t need to wield high-level tools to start interacting with your data now. With a basic knowledge of MySQL, you’re just about ready to go. In this course, instructor Ava Meredith shows you how to use the MySQL database to manipulate, aggregate, summarize, and analyze data more effectively.

Find out how to get the most out of MySQL from a power user by learning how to retrieve data, join tables, and write subqueries and complex queries. Explore aggregate, numeric, string, and date and time functions, as well as other built-in functions to work with different data types. Get quick tips and expert tricks on best practices for navigating within the database, building up your skill set as a data analyst, and taking your productivity to the next level.

Table of Contents

Introduction
1 Why MySQL
2 What you should know

Exploring Data from a Single Table
3 Exploring the database
4 Most common MySQL data types
5 Selecting column data
6 Selecting rows of data
7 Inserting, modifying, and deleting rows of data

Exploring Data from Multiple Tables
8 Coding table joins and table aliases

Using Aggregate Functions to Summarize Data
9 Using aggregate functions to gain summarized data insights

Using Subqueries to Refine Your Data Exploration
10 Coding and when to use subqueries and correlated subqueries

Using Built-In Functions to Work with Different Data Types
11 Working with numeric data
12 Working with textual data
13 Working with date and time functions

Conclusion
14 Explore and keep learning

Homepage