SQL for Data Science Data Analytics and Data Visualization

Metla Sudha Sekhar

98 Lessons 7h 19m

15. Create a 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...

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

SQL Server setting up

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

SQL Azure Data Studio

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

SQL Database basic SSMS

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

SQL Statement for DATA

29. Section Introduction 1m 30. Insert statement 9m 31. Update statement 6m 32. Delete statement 4m

SQL Data Structure statements

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

SQL User Management

40. Create Database user 4m 41. GRANT permissions 7m 42. REVOKE permissions 5m

SQL Statement Basic

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

Filtering Data Rows

49. SELECT WHERE Clause – theory 4m 50. SELECT WHERE Clause – practical 8m

Aggregate Functions

51. Sum() 9m 52. Min()-Max() 6m

SQL Query statements

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

SQL Group by statement

58. Section Introduction 2m 59. Group by – theory 4m 60. Group by – practical 6m 61. HAVING statement 4m

JOINS for Multiple table Data Analysis

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

SQL Constraints

72. Section introduction 1m 73. Check constraint 7m 74. NOT NULL constraint 9m 75. UNIQUE constraint 6m

Views

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

Advanced SQL commands

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

SQL Stored procedures

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

Azure Data Studio Visualization

87. Installing SandDance Extension 3m 88. Visualization Charts 5m 89. Multiple Table Data Charts 7m

Azure Studio SQL for Data Analysis

90. Type Decision for Data Analysis 14m 91. Data Analysis with Case Statement and String Text 10m

Import and Export data

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

Backup and Restore Database

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

SQL for Data Science Data Analytics and Data Visualization

Ready for the next lesson?

15. Create a Database

Ask about what you’re watching

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar