Save for later

Advanced MySQL Topics

Meta Database Engineer,

In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering. By the end of this course, you'll be able to: - Use control statements and variables in different contexts in MySQL - Develop user defined functions and procedures - Optimize MySQL database queries - Demonstrate a working knowledge of common table expressions and the JSON data type - Understand how and when to use triggers and events - Utilize subqueries, JOINS, views and transactions to perform data analysis - and use database optimization techniques such as MySQL transactions You'll gain experience with the following advanced MySQL database skills: - MySQL user defined functions - Advanced MySQL stored procedures - MySQL optimization techniques including Indexes, Transactions, CTE and JSON - MySQL triggers and events - Database analytics in MySQL - Advanced SQL queries for data analysis with JOINS, views and subqueries Through this course you'll develop new skills, improve your productivity, learn to act effectively with data and boost your career prospects. To be successful in this course, you should have already completed the previous course, “Database Structures and Management with MySQL,” or have prior experience with the skills taught in that course.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Coursera and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating Not enough ratings
Length 5 weeks
Effort 4 weeks of study, 3-5 hours/week.
Starts Jun 26 (43 weeks ago)
Cost $49
From Meta via Coursera
Instructor Taught by Meta Staff
Download Videos On all desktop and mobile devices
Language English
Subjects Programming IT & Networking Data Science
Tags Computer Science Mobile And Web Development Information Technology Data Management

Get a Reminder

Send to:

Similar Courses

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Defined Contribution Plans Adjustments Processor $40k

Defined Benefits Analyst $48k

Defined Benefits Administration Specialist $52k

Defined Contribution Specialist $65k

Defined Benefit Analyst $68k

Senior Defined Contribution Analyst $72k

Defined Contribution/Retirement Marketing Writer $79k

Defined Contribution/Retirement Marketing Writer $79k

Senior Defined Benefit Calculation Analyst $87k

Defined Contribution Product Manager $106k

Product Manager - Software Defined Networking $109k

Senior Software Defined Infrastructure Analyst $139k

Write a review

Your opinion matters. Tell us what you think.

Rating Not enough ratings
Length 5 weeks
Effort 4 weeks of study, 3-5 hours/week.
Starts Jun 26 (43 weeks ago)
Cost $49
From Meta via Coursera
Instructor Taught by Meta Staff
Download Videos On all desktop and mobile devices
Language English
Subjects Programming IT & Networking Data Science
Tags Computer Science Mobile And Web Development Information Technology Data Management

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now