Master SQL for Data Analysis
About The Course
MySQL is one of the most recognizable technologies in the modern big data ecosystem. Often called the most popular database and currently enjoying widespread, effective use regardless of industry, it’s clear that anyone involved with enterprise data or general IT should at least aim for a basic familiarity of MySQL.
With MySQL, even those new to relational systems can immediately build fast, powerful, and secure data storage systems. MySQL’s programmatic syntax and interfaces are also perfect gateways into the wide world of other popular query languages and structured data stores.
What Will You Learn?
SQL Installation
Creating and deleting database
Subqueries in MySQL
Trigers in MySQL
Primary keys
Foreign Keys
You can also check the course curricullum to see the full list of topics covered.
The Course Curriculam
SQL Installation
-
SQL Installation
03:53
Create Database And Deleting Database
Create, Drop, Show Tables
Inserting Values Into Tables
Primary Key In SQL
Alter Statement, Rename, Drop & Add
MySQL Functions Part One
MySQL Function Part Two
Update, Delete In MySQL
Triggers In MySQL
Subqueries In MySQL
Import Dataset Into MySQL
Logic And Limit Function
While Like Card
Order By & Distinct On MySQL
Order By, Distinct On MySQL
Operator Statement In MySQL
Views in MySQL
Trim, GroupBy, Tables In MySQL
Safe Mode
Joins Part One
Joins Part Two
Joins Part Three
Sales Analysis Project
Procedure Project
