Learn MySQL from scratch for Data Science and Analytics

Metla Sudha Sekhar

88 Lessons 5 Hours

8. MySQL Server Installation

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...

No suggested offers right now

Continue through the course and check back later for relevant recommendations.

View Downloads

Course Content

0% Completed

Introduction

1. Introduction 2m 2. How to get course requirements 1m 3. Getting started on Windows, Linux or Mac 1m 4. How to ask great questions 1m 5. FAQ’s 1m 6. source code file 8m

SQL Server setting up

7. Section Introduction 1m 8. MySQL Server Installation 13m 9. Connect MySQL Server Instance 5m 10. MySQL Workbench overview 10m 11. Download and Restore Sample Database 7m

SQL Database basics

12. Section Introduction 1m 13. Overview of Databases 9m 14. Creating Database 6m 15. SQL Data Types 3m 16. Column Data Types on Workbench 7m 17. Creating Table 3m 18. Overview of Primary and Foreign Key 3m 19. Primary Key 6m 20. Foreign Key 11m 21. Creating Temporary tables 12m 22. EER – Enhanced Entity Relationship Diagrams 4m

SQL DML ( Data Manipulation Language)

23. Section Introduction 1m 24. Insert statement 7m 25. Update statement 6m 26. Delete statement 3m

SQL DDL ( Data Defination Language)

27. Section Introduction 1m 28. CREATE table statement 7m 29. DROP statement 2m 30. ALTER statement 4m 31. TRUNCATE statement 3m 32. COMMENT in query 2m 33. RENAME table 3m

SQL DCL ( Data Control Language)

34. Create Database user 3m 35. GRANT permissions 5m 36. REVOKE permissions 3m

SQL Statement Basic

37. Section Introduction 1m 38. SQL Statement basic 3m 39. SELECT Statement 3m 40. SELECT DISTINCT 1m 41. SELECT with column headings 1m 42. Column AS statement 2m 43. DASHBOARD Analytics 6m

Filtering Data rows

44. SELECT WHERE Clause – theory 3m 45. SELECT WHERE Clause – practical 6m

Aggregate functions for Data Analysis

46. Sum() 6m 47. Min()-Max() 2m

SQL Data Analytic statements

48. Order By statement 4m 49. SELECT TOP 3 records 1m 50. BETWEEN command 5m 51. Search Data using LIKE cards 4m 52. IN operator 2m

SQL Group by statements

53. Section Introduction 1m 54. Group by – theory 3m 55. Data Analytics with Group By 3m 56. HAVING statement 3m

JOINS

57. Overview of Joins 2m 58. What are Joins 2m 59. Inner join 6m 60. Left outer join 2m 61. Right outer join 1m 62. Union 2m 63. CERTESIAN Product or Cross Join 3m 64. Query Exercise 1m 65. Solution for Query Exercise 1m

SQL Constraints

66. Section introduction 1m 67. Check constraint 8m 68. NOT NULL constraint 2m 69. UNIQUE constraint 5m

Views

70. Creating Views 3m 71. Data Analytic Views from multiple tables 3m

Advanced SQL Functions

72. Section Introduction 1m 73. Timestamp 3m 74. Extract from timestamp 3m 75. Mathematical scalar functions 2m 76. String functions 7m 77. Advanced functions 3m 78. Sub Queries 3m 79. SELECT with calculations 4m

SQL Stored procedures

80. Create stored procedure 5m 81. Stored procedure with parameter 3m 82. Drop Procedure 1m

Import and Export data

83. Section Introduction 1m 84. Import .csv file 4m 85. Export Data to .csv file 2m

Backup and Restore Database

86. Section Introduction 1m 87. Creating Database backup 2m 88. Restoring Database backup 2m

Learn MySQL from scratch for Data Science and Analytics

Ready for the next lesson?

8. MySQL Server Installation

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar