Learn MySQL Server from Scratch for Data Science and Analytics | |||
Section 01: Getting Started | |||
Introduction | 00:02:00 | ||
How to get course requirements | 00:01:00 | ||
Getting started on Windows, Linux or Mac | 00:01:00 | ||
How to ask great questions | 00:01:00 | ||
FAQ’s | 00:01:00 | ||
What is Source Code? | 00:09:00 | ||
Section 02: SQL Server setting up | |||
Section Introduction | 00:01:00 | ||
MySQL Server Installation | 00:14:00 | ||
Connect MySQL Server Instance | 00:06:00 | ||
MySQL Workbench overview | 00:11:00 | ||
Download and Restore Sample Database | 00:08:00 | ||
Section 03: SQL Database basics | |||
Section Introduction | 00:01:00 | ||
Overview of Databases | 00:09:00 | ||
Creating Database | 00:07:00 | ||
SQL Data Types | 00:04:00 | ||
Column Data Types on Workbench | 00:07:00 | ||
Creating Table | 00:04:00 | ||
Overview of Primary and Foreign Key | 00:03:00 | ||
Primary Key | 00:06:00 | ||
Foreign Key | 00:12:00 | ||
Creating Temporary tables | 00:12:00 | ||
EER – Enhanced Entity Relationship Diagrams | 00:04:00 | ||
Section 04: SQL DML (Data Manipulation Language) | |||
Section Introduction | 00:01:00 | ||
Insert statement | 00:07:00 | ||
Update statement | 00:06:00 | ||
Delete statement | 00:03:00 | ||
Section 05: SQL DDL (Data Definition Language) | |||
Section Introduction | 00:01:00 | ||
CREATE table statement | 00:08:00 | ||
DROP statement | 00:03:00 | ||
ALTER statement | 00:05:00 | ||
TRUNCATE statement | 00:03:00 | ||
COMMENT in query | 00:02:00 | ||
RENAME table | 00:03:00 | ||
Section 06: SQL DCL (Data Control Language) | |||
Create Database user | 00:03:00 | ||
GRANT permissions | 00:05:00 | ||
REVOKE permissions | 00:04:00 | ||
Section 07: SQL Statement Basic | |||
Section Introduction | 00:01:00 | ||
SQL Statement basic | 00:03:00 | ||
SELECT Statement | 00:03:00 | ||
SELECT DISTINCT | 00:02:00 | ||
SELECT with column headings | 00:01:00 | ||
Column AS statement | 00:02:00 | ||
DASHBOARD Analytics | 00:06:00 | ||
Section 08: Filtering Data rows | |||
SELECT WHERE Clause – theory | 00:03:00 | ||
SELECT WHERE Clause – practical | 00:06:00 | ||
Section 09: Aggregate functions for Data Analysis | |||
Sum() | 00:06:00 | ||
Min()-Max() | 00:03:00 | ||
Section 10: SQL Data Analyticstatements | |||
Order By statement | 00:05:00 | ||
SELECT TOP 3 records | 00:02:00 | ||
BETWEEN command | 00:06:00 | ||
IN operator | 00:03:00 | ||
Search Data usingLIKE cards | 00:05:00 | ||
Section 11: SQL Group by statement | |||
Section Introduction | 00:01:00 | ||
Group by – theory | 00:04:00 | ||
Data Analytics with Group By | 00:04:00 | ||
HAVING statement | 00:04:00 | ||
Section 12: JOINS | |||
Overview of Joins | 00:02:00 | ||
What are Joins | 00:02:00 | ||
Inner join | 00:07:00 | ||
Left outer join | 00:02:00 | ||
Right outer join | 00:02:00 | ||
Union | 00:03:00 | ||
CERTESIAN Product or Cross Join | 00:03:00 | ||
Query Exercise | 00:01:00 | ||
Solution for Query Exercise | 00:01:00 | ||
Section 13: SQL Constraints | |||
Section introduction | 00:01:00 | ||
Check constraint | 00:09:00 | ||
NOT NULL constraint | 00:03:00 | ||
UNIQUE constraint | 00:06:00 | ||
Section 14: Views | |||
Creating Views | 00:03:00 | ||
Data Analytic Views from multiple tables | 00:03:00 | ||
Section 15: Advanced SQL Functions | |||
Section Introduction | 00:01:00 | ||
Timestamp | 00:03:00 | ||
Extract from timestamp | 00:03:00 | ||
Mathematical scalar functions | 00:03:00 | ||
String functions | 00:07:00 | ||
Advanced functions | 00:04:00 | ||
Sub Queries | 00:03:00 | ||
SELECT with calculations | 00:05:00 | ||
Section 16: SQL Stored procedures | |||
Create stored procedure | 00:06:00 | ||
Stored procedure with parameter | 00:03:00 | ||
Drop Procedure | 00:01:00 | ||
Section 17: Import & Export data | |||
Section Introduction | 00:01:00 | ||
Import .csv file | 00:04:00 | ||
Export Data to .csv file | 00:02:00 | ||
Section 18: Backup and Restore Database | |||
Section Introduction | 00:01:00 | ||
Creating Database backup | 00:02:00 | ||
Restoring Database backup | 00:02:00 | ||
Order Your Certificate | |||
Order Your Certificate Now | 00:00:00 |
No reviews found for this course.
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.