SQL for Data Science Data Analytics and Data Visualization

Metla Sudha Sekhar

98 Lessons 7 Hours

11. Download and Restore Sample Database

Welcome to SQL for Data Science, Data Analytics, and Data Visualization! This comprehensive course is designed to take you from a complete beginner to a confide...

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 2m 3. Getting started on Windows, Linux or Docker 1m 4. How to ask great questions 1m 5. FAQ’s 1m

SQL Server setting up

6. Section Introduction 1m 7. Microsoft SQL Server Installation 18m 8. SQL Server Management Studio (SSMS) Installation 8m 9. How to connect MS SQL (Windows Authentication) 3m 10. How to connect MS SQL (SQL Server Authentication) 3m 11. Download and Restore Sample Database 7m

SQL Azure Data Studio

12. What is Azure Data Studio 6m 13. Azure Data Studio Installation steps 7m 14. Azure Data Studio to Connect SQL Server 9m 15. Create a Database 6m 16. Create a Table 8m 17. Insert Data rows 6m 18. View the Data returned by Query 3m

SQL Database basic SSMS

19. Section Introduction 1m 20. Overview of Databases 10m 21. Creating Database 4m 22. SQL Data Types 3m 23. Column Data Types on SSMS 3m 24. Creating Table 9m 25. Overview of Primary Key and Foreign Key 4m 26. Primary Key 4m 27. Foreign Key 6m 28. Creating Temporary tables 6m

SQL Statement for DATA

29. Section Introduction 1m 30. Insert statement 8m 31. Update statement 5m 32. Delete statement 3m

SQL Data Structure statements

33. Section Introduction 1m 34. CREATE table statement 2m 35. DROP statement 2m 36. ALTER statement 5m 37. TRUNCATE statement 4m 38. COMMENT in query 1m 39. RENAME 1m

SQL User Management

40. Create Database user 3m 41. GRANT permissions 6m 42. REVOKE permissions 4m

SQL Statement Basic

43. Section Introduction 1m 44. SQL Statement basic 3m 45. SELECT Statement 7m 46. SELECT DISTINCT 2m 47. SELECT with column headings 2m 48. Column AS statement 2m

Filtering Data Rows

49. SELECT WHERE Clause – theory 3m 50. SELECT WHERE Clause – practical 7m

Aggregate Functions

51. Sum() 8m 52. Min()-Max() 5m

SQL Query statements

53. Order By statement 5m 54. SELECT TOP clause in SQL 4m 55. BETWEEN command 8m 56. IN operator 4m 57. Wildcard Characters and LIKE 4m

SQL Group by statement

58. Section Introduction 1m 59. Group by – theory 3m 60. Group by – practical 5m 61. HAVING statement 3m

JOINS for Multiple table Data Analysis

62. Overview of Joins 1m 63. What are Joins 2m 64. Inner join 7m 65. Left outer join 2m 66. Right outer join 2m 67. Full outer join 1m 68. Union 2m 69. Cross join 3m 70. Query Exercise 1m 71. Solution for Query Exercise 1m

SQL Constraints

72. Section introduction 1m 73. Check constraint 6m 74. NOT NULL constraint 8m 75. UNIQUE constraint 5m

Views

76. Creating Views 3m 77. Reporting with multiple tables 3m

Advanced SQL commands

78. Section Introduction 1m 79. Timestamp 4m 80. Extract from timestamp 3m 81. Mathematical scalar functions 3m 82. String functions 4m 83. Sub Query 3m 84. SELECT with calculations 6m

SQL Stored procedures

85. Create stored procedure 4m 86. Stored procedure with parameter 4m

Azure Data Studio Visualization

87. Installing SandDance Extension 2m 88. Visualization Charts 4m 89. Multiple Table Data Charts 6m

Azure Studio SQL for Data Analysis

90. Type Decision for Data Analysis 13m 91. Data Analysis with Case Statement and String Text 9m

Import and Export data

92. Section Introduction 1m 93. Import Flat File 5m 94. Import .csv or excel file 2m 95. Export Data to Excel or any format 6m

Backup and Restore Database

96. Section Introduction 1m 97. Creating Database backup 3m 98. Restoring Database backup 3m

SQL for Data Science Data Analytics and Data Visualization

Ready for the next lesson?

11. Download and Restore Sample Database

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar