Learn MySQL - SQL Mastery for Business Analytics and Data Science

	Name	Provider	Expiry	Type	Purpose
	Google Analytics	Google	1 Year	HTTPS	To track visitors to the site, their origin & behaviour.
	iBeat Analytics	Ibeat	1 Year	HTTPS	To track article's statistics

Name	Provider	Expiry	Type	Purpose
optout	Times Internet	1 Year	HTTPS	Stores the user's cookie consent state for the current domain
PHPSESSID	Times Internet	1 day	HTTPS	Stores user's preferences
accessCode	Times Internet	2.5 Hours	HTTPS	To serve content relevant to a region
pfuuid	Times Internet	1 Year	HTTPS	Uniquely identify each user
fpid	Times Internet	1 Year	HTTPS	Browser Fingerprinting to uniquely identify client browsers

Course Description

Embark on your journey with the "MySQL for Beginners" course, designed to deliver foundational and advanced skills in data analytics and management using MySQL Server paired with Workbench. This comprehensive program addresses essential SQL concepts, advancing towards intricate queries relevant to real-world business logic. Led by a seasoned instructor, the course offers an interactive learning experience through step-by-step tutorials. Participants will build proficiencies in data extraction and manipulation, enabling them to independently create and manage databases. Emphasizing practical application, the course empowers students to draw actionable insights from data, preparing them for diverse roles in data-driven fields. By the conclusion, learners will possess a versatile SQL toolkit applicable to data science, analytics, and business intelligence careers.

Master foundational SQL operations and database management
Construct complex queries to support business analytics
Design and manage databases with Workbench
Implement GROUP BY and aggregate functions for data insights
Perform sophisticated JOIN operations for comprehensive analysis
Handle data imports, exports, and ensure database security
Create and refine SQL scripts for efficient data handling
Develop tables with appropriate constraints and structures

Who Should Enrol

Novices in SQL, data science, and analytics
Individuals keen on diversifying income through tech skills
Enthusiasts aiming to venture into business intelligence roles
Entrepreneurs and freelancers wanting enhanced data skills
Aspiring data scientists and full-stack developers
Industry professionals, such as those in marketing, finance, and healthcare, seeking to enhance data competency

Requirement

No previous technical experience necessary
A computer with internet connectivity

This course includes

6hr 2min of Recorded Sessions

88 Lectures

Access on Mobile

Certificate of completion

Course Curriculum

Getting Started 6 lectures
- Introduction
  
  02 minutes 22 seconds
- How to get course requirements
  
  01 minute 23 seconds
- Getting started on Windows, Linux or Mac
  
  48 seconds
- How to ask great questions
  
  01 minute 27 seconds
- FAQ’s
  
  01 minute 02 seconds
- What is source code
  
  08 minutes 47 seconds
SQL Server setting up 5 lectures
- Section Introduction
  
  01 minute 07 seconds
- MySQL Server Installation
  
  13 minutes 44 seconds
- Connect MySQL Server Instance
  
  05 minutes 49 seconds
- MySQL Workbench overview
  
  10 minutes 41 seconds
- Download and Restore Sample Database
  
  07 minutes 43 seconds
SQL Database basics 11 lectures
- Section Introduction
  
  01 minute 09 seconds
- Overview of Databases
  
  09 minutes 15 seconds
- Creating Database
  
  06 minutes 34 seconds
- SQL Data Types
  
  03 minutes 47 seconds
- Column Data Types on Workbench
  
  07 minutes 23 seconds
- Creating Table
  
  03 minutes 44 seconds
- Overview of Primary and Foreign Key
  
  03 minutes 29 seconds
- Primary Key
  
  06 minutes 08 seconds
- Foreign Key
  
  11 minutes 33 seconds
- Creating Temporary tables
  
  12 minutes 23 seconds
- EER – Enhanced Entity Relationship Diagrams
  
  04 minutes 21 seconds
SQL DML (Data Manipulation Language) 4 lectures
- Section Introduction
  
  01 minute 17 seconds
- Insert statement
  
  07 minutes 12 seconds
- Update statement
  
  06 minutes 02 seconds
- Delete statement
  
  03 minutes 13 seconds
SQL DDL (Data Definition Language) 7 lectures
- Section Introduction
  
  01 minute 11 seconds
- CREATE table statement
  
  07 minutes 51 seconds
- DROP statement
  
  02 minutes 58 seconds
- ALTER statement
  
  04 minutes 54 seconds
- TRUNCATE statement
  
  03 minutes 02 seconds
- COMMENT in query
  
  02 minutes 22 seconds
- RENAME table
  
  03 minutes 15 seconds
SQL DCL (Data Control Language) 3 lectures
- Create Database user
  
  03 minutes 16 seconds
- GRANT permissions
  
  05 minutes 06 seconds
- REVOKE permissions
  
  03 minutes 46 seconds
SQL Statement Basic 7 lectures
- Section Introduction
  
  56 seconds
- SQL Statement basic
  
  03 minutes 16 seconds
- SELECT Statement
  
  03 minutes 12 seconds
- SELECT DISTINCT
  
  01 minute 30 seconds
- SELECT with column headings
  
  01 minute 27 seconds
- Column AS statement
  
  02 minutes 21 seconds
- DASHBOARD Analytics
  
  06 minutes 04 seconds
Filtering Data rows 2 lectures
- SELECT WHERE Clause – theory
  
  03 minutes 03 seconds
- SELECT WHERE Clause – practical
  
  06 minutes 16 seconds
Aggregate functions for Data Analysis 2 lectures
- Sum()
  
  06 minutes 20 seconds
- Min()-Max()
  
  02 minutes 40 seconds
SQL Data Analyticstatements 5 lectures
- Order By statement
  
  04 minutes 43 seconds
- SELECT TOP 3 records
  
  01 minute 43 seconds
- BETWEEN command
  
  05 minutes 45 seconds
- IN operator
  
  02 minutes 57 seconds
- Search Data usingLIKE cards
  
  04 minutes 35 seconds
SQL Group by statement 4 lectures
- Section Introduction
  
  43 seconds
- Group by – theory
  
  03 minutes 34 seconds
- Data Analytics with Group By
  
  03 minutes 59 seconds
- HAVING statement
  
  03 minutes 01 second
JOINS 9 lectures
- Overview of Joins
  
  02 minutes 01 second
- What are Joins
  
  02 minutes 18 seconds
- Inner join
  
  06 minutes 43 seconds
- Left outer join
  
  02 minutes 04 seconds
- Right outer join
  
  01 minute 53 seconds
- Union
  
  02 minutes 54 seconds
- CERTESIAN Product or Cross Join
  
  03 minutes 14 seconds
- Query Exercise
  
  01 minute 16 seconds
- Solution for Query Exercise
  
  01 minute 02 seconds
SQL Constraints 4 lectures
- Section introduction
  
  01 minute 23 seconds
- Check constraint
  
  08 minutes 32 seconds
- NOT NULL constraint
  
  02 minutes 45 seconds
- UNIQUE constraint
  
  05 minutes 53 seconds
Views 2 lectures
- Creating Views
  
  03 minutes 25 seconds
- Data Analytic Viewsfrom multiple tables
  
  03 minutes 14 seconds
Advanced SQL Functions 8 lectures
- Section Introduction
  
  01 minute 02 seconds
- Timestamp
  
  03 minutes 10 seconds
- Extract from timestamp
  
  03 minutes 01 second
- Mathematical scalar functions
  
  02 minutes 35 seconds
- String functions
  
  07 minutes 14 seconds
- Advanced functions
  
  03 minutes 58 seconds
- Sub Queries
  
  03 minutes 11 seconds
- SELECT with calculations
  
  04 minutes 44 seconds
SQL Stored procedures 3 lectures
- Create stored procedure
  
  05 minutes 39 seconds
- Stored procedure with parameter
  
  03 minutes 19 seconds
- Drop Procedure
  
  01 minute 20 seconds
Import & Export data 3 lectures
- Section Introduction
  
  01 minute 08 seconds
- Import .csv file
  
  04 minutes 07 seconds
- Export Data to .csv file
  
  02 minutes 13 seconds
Backup and Restore Database 3 lectures
- Section Introduction
  
  44 seconds
- Creating Database backup
  
  02 minutes 28 seconds
- Restoring Database backup
  
  02 minutes 09 seconds

About the Expert

Metla Sudha Sekhar

IT Specialist and Developer

Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passionate to teach every single real-time step that leads students as well as professionals to become successful and the vision to impart Good Quality Software Education to all I.T to aspirants make a strong bridge the gap between the software companies requirements and the beginners.

Earn a career certificate

Your Name

MySQL for Beginners: Learn Data Science and Analytics Skills

Enhance your LinkedIn profile, resume, or CV with this credential. Share your accomplishment on social media and highlight it in your performance reviews.

	Name				Purpose
	Daily Newsletter				Receive daily list of important news
	Promo Mailers				Receive information about events, industry, etc.

Accept the updated privacy & cookie policy

MySQL for Beginners: Learn Data Science and Analytics Skills

Create by Metla Sudha Sekhar

Expert

Categories

Course Description

What you'll learn

Who Should Enrol

Requirement

This course includes

Course Curriculum

Getting Started 6 lectures

SQL Server setting up 5 lectures

SQL Database basics 11 lectures

SQL DML (Data Manipulation Language) 4 lectures

SQL DDL (Data Definition Language) 7 lectures

SQL DCL (Data Control Language) 3 lectures

SQL Statement Basic 7 lectures

Filtering Data rows 2 lectures

Aggregate functions for Data Analysis 2 lectures

SQL Data Analyticstatements 5 lectures

SQL Group by statement 4 lectures

JOINS 9 lectures

SQL Constraints 4 lectures

Views 2 lectures

Advanced SQL Functions 8 lectures

SQL Stored procedures 3 lectures

Import & Export data 3 lectures

Backup and Restore Database 3 lectures

About the Expert

Earn a career certificate

Your Name

MySQL for Beginners: Learn Data Science and Analytics Skills

Earn a career certificate

57%

300+

5/6

500+

Advance your subject-matter expertise

Earn a career certificate

Already Purchased!

Preview this course

Get Personal Learning Recommendations

MySQL for Beginners: Learn Data Science and Analytics Skills