MySQL Tips and Tricks

Focused View

54:22

298 View

01 - Introduction

01 - Why MySQL.mp4

00:49

02 - What you should know.mp4

01:26

02 - 1. Exploring Data from a Single Table

01 - Exploring the database.mp4

05:52

02 - Most common MySQL data types.mp4

05:04

03 - Selecting column data.mp4

03:10

04 - Selecting rows of data.mp4

06:58

05 - Inserting, modifying, and deleting rows of data.mp4

02:27

03 - 2. Exploring Data from Multiple Tables

01 - Coding table joins and table aliases.mp4

04:14

04 - 3. Using Aggregate Functions to Summarize Data

01 - Using aggregate functions to gain summarized data insights.mp4

06:05

05 - 4. Using Subqueries to Refine Your Data Exploration

01 - Coding and when to use subqueries and correlated subqueries.mp4

07:15

06 - 5. Using Built-In Functions to Work with Different Data Types

01 - Working with numeric data.mp4

03:46

02 - Working with textual data.mp4

03:46

03 - Working with date and time functions.mp4

02:32

07 - Conclusion

01 - Explore and keep learning.mp4

00:58

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.