Learn MySQL from scratch for Data Science and Analytics

Metla Sudha Sekhar

88 Lessons 5h 50m

4. How to ask great questions

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

Lesson assistant

Ask about what you’re watching

Subscriber benefit

See something confusing? Subscribe to ask the lesson assistant about it.

Ask about what’s on screen. The assistant uses the current video frame and available subtitles.
Get clear answers to up to 5 lesson questions each day.
Enrol in up to 4 included courses each month and learn while subscribed.
Save 75% on eligible courses outside the subscription.

Already subscribed? Sign in

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 3m 2. How to get course requirements 2m 3. Getting started on Windows, Linux or Mac 1m 4. How to ask great questions 2m 5. FAQ’s 2m 6. source code file 9m

SQL Server setting up

7. Section Introduction 2m 8. MySQL Server Installation 14m 9. Connect MySQL Server Instance 6m 10. MySQL Workbench overview 11m 11. Download and Restore Sample Database 8m

SQL Database basics

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

SQL DML ( Data Manipulation Language)

23. Section Introduction 2m 24. Insert statement 8m 25. Update statement 7m 26. Delete statement 4m

SQL DDL ( Data Defination Language)

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

SQL DCL ( Data Control Language)

34. Create Database user 4m 35. GRANT permissions 6m 36. REVOKE permissions 4m

SQL Statement Basic

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

Filtering Data rows

44. SELECT WHERE Clause – theory 4m 45. SELECT WHERE Clause – practical 7m

Aggregate functions for Data Analysis

46. Sum() 7m 47. Min()-Max() 3m

SQL Data Analytic statements

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

SQL Group by statements

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

JOINS

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

SQL Constraints

66. Section introduction 2m 67. Check constraint 9m 68. NOT NULL constraint 3m 69. UNIQUE constraint 6m

Views

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

Advanced SQL Functions

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

SQL Stored procedures

80. Create stored procedure 6m 81. Stored procedure with parameter 4m 82. Drop Procedure 2m

Import and Export data

83. Section Introduction 2m 84. Import .csv file 5m 85. Export Data to .csv file 3m

Backup and Restore Database

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

Learn MySQL from scratch for Data Science and Analytics

Ready for the next lesson?

4. How to ask great questions

Ask about what you’re watching

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar