Learn MySQL from scratch for Data Science and Analytics

$35.00

~~$99.99~~

Description

Learn MySQL from scratch for Data Science and Analytics": ```html Unlock the power of data with our comprehensive course, Learn MySQL from scratch for Data Science and Analytics. This course is meticulously crafted for individuals eager to gain a robust understanding of MySQL and its applications in the realm of data science and analytics. Whether you are a complete beginner, a professional, or a student, this course will equip you with the essential skills to manage, analyze, and derive valuable insights from data. Throughout the course, you will delve into various critical topics including: - Installation and configuration of MySQL Server - Understanding database fundamentals and SQL syntax - Executing essential SQL commands for data manipulation - Employing advanced techniques such as joins, constraints, and views - Importing and exporting data efficiently - Backing up and restoring databases to safeguard your data By the end of this course, you'll be proficient in using MySQL, enabling you to tackle real-world data challenges in your projects and career.

Requirements

No prior technical experience is required! All you need a computer!

No SQL experience needed. You will learn everything you need to know

No software is required in advance of the course (all software used in the course is free)

Who This Course is For

Beginners who want to learn MySQL and SQL from scratch. Data science and analytics enthusiasts looking to enhance their SQL skills. Professionals aiming to use MySQL in their data analysis projects. Students pursuing studies in data science, analytics, or database management. Anyone interested in managing and analyzing data effectively.

What You Will be Learn

Introduction to MySQL and SQL: Understanding the basics and getting started with MySQL. SQL Server Setup: How to install and connect to MySQL server, and navigate MySQL Workbench. Database Fundamentals: Overview of databases, creating databases, and understanding data types. Data Manipulation Language (DML): Learning how to insert, update, and delete data using SQL commands. Data Definition Language (DDL): Creating, altering, and dropping database objects. Data Control Language (DCL): Managing permissions and creating database users. Basic SQL Statements: Important SQL statements for querying data. Data Filtering: Using the WHERE clause to filter data rows. Aggregate Functions: Analyzing data using functions like SUM, MIN, and MAX. SQL Analytic Statements: Techniques like ORDER BY, BETWEEN, and using LIKE for searching data. Group By Statements: Learning how to group and aggregate data with HAVING clause. Joins: Understanding different types of joins and how to combine data from multiple tables. Constraints: Implementing constraints to maintain data integrity. Views: Creating views for simplifying complex queries. Advanced SQL Functions: Utilizing advanced functions for data analysis. Stored Procedures: Creating and managing stored procedures for executing complex logic. Data Import and Export: Importing and exporting data using CSV files. Backup and Restore Techniques: Managing database backups and restoring them when necessary.

Introduction

6 Lessons

0H 15M

1. Introduction

2m 23s

2. How to get course requirements

1m 23s

3. Getting started on Windows, Linux or Mac

48s

4. How to ask great questions

1m 27s

5. FAQ’s

1m 3s

6. source code file

8m 47s

SQL Server setting up

5 Lessons

0H 39M

7. Section Introduction

1m 8s

8. MySQL Server Installation

13m 44s

9. Connect MySQL Server Instance

5m 50s

10. MySQL Workbench overview

10m 41s

11. Download and Restore Sample Database

7m 43s

SQL Database basics

11 Lessons

1H 9M

12. Section Introduction

1m 10s

13. Overview of Databases

9m 16s

14. Creating Database

6m 34s

15. SQL Data Types

3m 47s

16. Column Data Types on Workbench

7m 23s

17. Creating Table

3m 45s

18. Overview of Primary and Foreign Key

3m 29s

19. Primary Key

6m 9s

20. Foreign Key

11m 34s

21. Creating Temporary tables

12m 23s

22. EER – Enhanced Entity Relationship Diagrams

4m 21s

SQL DML ( Data Manipulation Language)

4 Lessons

0H 17M

23. Section Introduction

1m 17s

24. Insert statement

7m 12s

25. Update statement

6m 3s

26. Delete statement

3m 13s

SQL DDL ( Data Defination Language)

7 Lessons

0H 25M

27. Section Introduction

1m 11s

28. CREATE table statement

7m 51s

29. DROP statement

2m 59s

30. ALTER statement

4m 54s

31. TRUNCATE statement

3m 3s

32. COMMENT in query

2m 23s

33. RENAME table

3m 16s

SQL DCL ( Data Control Language)

3 Lessons

0H 12M

34. Create Database user

3m 16s

35. GRANT permissions

5m 6s

36. REVOKE permissions

3m 47s

SQL Statement Basic

7 Lessons

0H 18M

37. Section Introduction

56s

38. SQL Statement basic

3m 17s

39. SELECT Statement

3m 12s

40. SELECT DISTINCT

1m 31s

41. SELECT with column headings

1m 28s

42. Column AS statement

2m 21s

43. DASHBOARD Analytics

6m 4s

Filtering Data rows

2 Lessons

0H 9M

44. SELECT WHERE Clause – theory

3m 4s

45. SELECT WHERE Clause – practical

6m 16s

Aggregate functions for Data Analysis

2 Lessons

0H 9M

46. Sum()

6m 20s

47. Min()-Max()

2m 40s

SQL Data Analytic statements

5 Lessons

0H 19M

48. Order By statement

4m 43s

49. SELECT TOP 3 records

1m 44s

50. BETWEEN command

5m 46s

51. Search Data using LIKE cards

4m 35s

52. IN operator

2m 57s

SQL Group by statements

4 Lessons

0H 11M

53. Section Introduction

43s

54. Group by – theory

3m 34s

55. Data Analytics with Group By

3m 59s

56. HAVING statement

3m 1s

JOINS

9 Lessons

0H 23M

57. Overview of Joins

2m 2s

2m 18s

6m 43s

2m 5s

1m 53s

2m 54s

63. CERTESIAN Product or Cross Join

3m 14s

64. Query Exercise

1m 16s

65. Solution for Query Exercise

1m 3s

SQL Constraints

4 Lessons

0H 18M

66. Section introduction

1m 24s

67. Check constraint

8m 33s

68. NOT NULL constraint

2m 46s

69. UNIQUE constraint

5m 53s

Views

2 Lessons

0H 6M

70. Creating Views

3m 26s

71. Data Analytic Views from multiple tables

3m 15s

Advanced SQL Functions

8 Lessons

0H 28M

72. Section Introduction

1m 2s

73. Timestamp

3m 11s

74. Extract from timestamp

3m 1s

75. Mathematical scalar functions

2m 35s

76. String functions

7m 14s

77. Advanced functions

3m 59s

78. Sub Queries

3m 11s

79. SELECT with calculations

4m 45s

SQL Stored procedures

3 Lessons

0H 10M

80. Create stored procedure

5m 39s

81. Stored procedure with parameter

3m 19s

82. Drop Procedure

1m 21s

Import and Export data

3 Lessons

0H 7M

83. Section Introduction

1m 9s

84. Import .csv file

4m 7s

85. Export Data to .csv file

2m 13s

Backup and Restore Database

3 Lessons

0H 5M

86. Section Introduction

45s

87. Creating Database backup

2m 28s

88. Restoring Database backup

2m 10s

Metla Sudha Sekhar

Dragon Zap Instructor

0.00 Star Rating

24 Courses

Dragon Zap Instructor

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. He is Professional about web development and technologies: * Programming: Python, C# Asp.Net and PHP more.. * UI/UX : HTML, CSS, Bootstrap, JavaScript, AJAX and more... * Database : MS-SQL, MySQL, PostgreSQL, MongoDB, MariaDB and more... * Operating Systems / Servers: Administration of LINUX, Ubuntu, CentOS, Windows and more... Start solving your challenge now | Enroll today and learn real world practical example courses. He is passionate about: * Teaching students the correct way. * Making things simple and easy to understand. * Providing the best audio and video qualities to my courses. * Real-time Examples who will understand real-time skills easily.

0.0

Course Rating

Students Feedback (0)

Sort by:

$35.00

~~$99.99~~

65% off

5 days and 16 hours at this price

This course includes:

Full Lifetime Access
30 Days Money Back Guarantee
Free Exercises File
Watch online or offline
Certificate of Completion