MySQL

ClusterPhi
Last Update September 6, 2022

About This Course

Explore, change, and export data in MySQL. Learn basic concepts like tables, data types, advanced techniques like join statements, and queries, subqueries, and stored procedures.

Tags

Learning Objectives

The course begins with basics like making databases and tables and then moves to more advanced topics like working with multiple databases and complex joins.
The course also teaches you how to build a web application using MySQL

Target Audience

  • Software Developers, IT Professionals, Engineers, Analysts, Tech Support Professionals, Freshers

Curriculum

2 Lessons

Introduction to MySQL

What is a database and why do we need SQL? Top 5 problems in Excel and why using SQL solves this problem Should we import from Excel and why? How it is done? Create a link to Excel spreadsheet with MySQL?

How to Create Tables

How to Create a Basic Query

Use the Where clause Conditional statements Multiple conditions Comparison Operators Logic Values Null Values Patterns also known as Wildcard characters Compare Column Values

Advanced Queries

Distinct Values Course Syllabus | MySQL Bootcamp 1 Top Values Date Functions Date Calculations Aggregate Functions String Functions Sort Data Rank Data Save a Query Execute a Query Modify a Saved Query

Data Wrangling

Group Data Filtering Grouped Data Summarize Group Data Pivot and Unpivot Operators

Data Analytics

Joins Inner Join Left Join Full Outer Join Self-Join Unions Except and Intersect Presenting and Making Sense of Query Results Saving the Query Results and Exporting Generating Reports

Tables & Queries

Importing and Exporting Data Update Data Queries Distinct Values Top Values Subqueries with “In” Inline Views

Views

Create a Simple View With Check Option Course Syllabus | MySQL Bootcamp 2

Locks and Transactions

Exclusive Table Locks Shared Table Locks Using Variables Setting Variables with Selects Select/Update Example Simple Transactions

MySQL Functions

String to Date and Date Format Control Flow Functions Casting Functions

Stored Procedures

Introduction to Stored Procedures Changing the Delimiter Editing a Stored Procedure Variable Scope A Data Generating Procedure

Triggers

Introduction to Triggers Validating Triggers Triggers and Transactions

User Defined Functions

Functions vs Procedures User-Defined Functions

Your Instructors

ClusterPhi

4.0/5
18 Courses
1 Review
66 Students
See more
Free
Level
All Levels
Lectures
2 lectures
Language
English
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Compare
Compare ×
Let's Compare! Continue shopping