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
Resolve the captcha to access the links!