SQL for Data Science Data Analytics and Data Visualization

$43.75

~~$124.99~~

Description

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 confident SQL user, equipping you with essential skills in data management and analysis.

In this course, you'll learn:

How to set up SQL Server and Azure Data Studio for effective database management.
The fundamentals of database creation, table structure, and data types.
How to write SQL statements to manipulate and query data efficiently.
Advanced SQL commands, including JOINs, constraints, and stored procedures.
Data visualization techniques using Azure Data Studio, helping you transform raw data into meaningful insights.
Best practices for importing and exporting data to and from SQL databases.

This course is ideal for:

Beginners looking to learn SQL from scratch.
Data analysts wanting to enhance their data manipulation skills.
Students and professionals aiming for a career in data science.
Anyone interested in managing and analyzing data effectively.
Individuals aspiring to work with data visualization tools and techniques.

Join us and take the first step towards mastering SQL and transforming your career in data!

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 SQL from scratch.

Data analysts looking to enhance their skills in SQL for data manipulation and analysis.

Students and professionals aiming to pursue a career in data science or data analysis.

Anyone interested in learning how to manage and analyze data using SQL databases.

Those aspiring to work with data visualization tools and techniques.

What You Will be Learn

Introduction to SQL and Database Management Systems

Installation and Setup

- Setting up SQL Server and Azure Data Studio

- Connecting to SQL Server

Data Structures and Statements

- Understanding SQL Data Types, Creating Tables, and Using Keys

- Basic SQL statements such as INSERT, UPDATE, DELETE

- Data structure statements like CREATE, DROP, ALTER, and TRUNCATE

User Management

- Creating users and managing permissions

Querying and Data Analysis

- SQL SELECT statements, filtering data using WHERE clauses

- Using aggregate functions and group by statements

- Joining multiple tables for comprehensive data analysis

Views and Advanced SQL Commands

- Creating views for better data reporting

- Utilizing advanced SQL features and functions

Stored Procedures and Data Visualization

- Creating and using stored procedures

- Visualizing data using Azure Data Studio visualization tools

Importing and Exporting Data

- Techniques for importing and exporting data from various formats

Backup and Data Recovery

- Creating and restoring database backups

Introduction

5 Lessons

0H 8M

1. Introduction

2m 57s

2. How to get course requirements

2m 32s

3. Getting started on Windows, Linux or Docker

58s

4. How to ask great questions

1m 20s

5. FAQ’s

1m 9s

SQL Server setting up

6 Lessons

0H 43M

6. Section Introduction

1m 42s

7. Microsoft SQL Server Installation

18m 35s

8. SQL Server Management Studio (SSMS) Installation

8m 28s

9. How to connect MS SQL (Windows Authentication)

3m 40s

10. How to connect MS SQL (SQL Server Authentication)

3m 13s

11. Download and Restore Sample Database

7m 27s

SQL Azure Data Studio

7 Lessons

0H 47M

12. What is Azure Data Studio

6m 25s

13. Azure Data Studio Installation steps

7m 9s

14. Azure Data Studio to Connect SQL Server

15. Create a Database

6m 32s

16. Create a Table

8m 46s

17. Insert Data rows

6m 37s

18. View the Data returned by Query

3m 5s

SQL Database basic SSMS

10 Lessons

0H 54M

19. Section Introduction

1m 16s

20. Overview of Databases

10m 47s

21. Creating Database

4m 54s

22. SQL Data Types

3m 23s

23. Column Data Types on SSMS

3m 55s

24. Creating Table

9m 10s

25. Overview of Primary Key and Foreign Key

4m 5s

26. Primary Key

4m 6s

27. Foreign Key

6m 52s

28. Creating Temporary tables

6m 29s

SQL Statement for DATA

4 Lessons

0H 17M

29. Section Introduction

49s

30. Insert statement

8m 25s

31. Update statement

5m 7s

32. Delete statement

3m 12s

SQL Data Structure statements

7 Lessons

0H 18M

33. Section Introduction

54s

34. CREATE table statement

2m 58s

35. DROP statement

2m 10s

36. ALTER statement

5m 28s

37. TRUNCATE statement

4m 4s

38. COMMENT in query

55s

39. RENAME

1m 41s

SQL User Management

3 Lessons

0H 14M

40. Create Database user

3m 55s

41. GRANT permissions

6m 9s

42. REVOKE permissions

4m 11s

SQL Statement Basic

6 Lessons

0H 19M

43. Section Introduction

1m 14s

44. SQL Statement basic

3m 19s

45. SELECT Statement

7m 24s

46. SELECT DISTINCT

2m 42s

47. SELECT with column headings

2m 35s

48. Column AS statement

2m 5s

Filtering Data Rows

2 Lessons

0H 10M

49. SELECT WHERE Clause – theory

3m 40s

50. SELECT WHERE Clause – practical

7m 15s

Aggregate Functions

2 Lessons

0H 13M

51. Sum()

8m 1s

52. Min()-Max()

5m 48s

SQL Query statements

5 Lessons

0H 26M

53. Order By statement

5m 26s

54. SELECT TOP clause in SQL

4m 6s

55. BETWEEN command

8m 9s

56. IN operator

4m 4s

57. Wildcard Characters and LIKE

4m 53s

SQL Group by statement

4 Lessons

0H 13M

58. Section Introduction

1m 10s

59. Group by – theory

3m 11s

60. Group by – practical

5m 28s

61. HAVING statement

3m 32s

JOINS for Multiple table Data Analysis

10 Lessons

0H 26M

62. Overview of Joins

1m 56s

2m 16s

7m 55s

2m 50s

2m 19s

1m 21s

2m 46s

3m 10s

1m 6s

71. Solution for Query Exercise

1m 9s

SQL Constraints

4 Lessons

0H 21M

72. Section introduction

55s

73. Check constraint

6m 54s

74. NOT NULL constraint

8m 29s

75. UNIQUE constraint

5m 2s

Views

2 Lessons

0H 7M

76. Creating Views

3m 58s

77. Reporting with multiple tables

3m 6s

Advanced SQL commands

7 Lessons

0H 26M

78. Section Introduction

51s

79. Timestamp

4m 27s

80. Extract from timestamp

3m 11s

81. Mathematical scalar functions

3m 50s

82. String functions

4m 55s

83. Sub Query

3m 9s

84. SELECT with calculations

6m 18s

SQL Stored procedures

2 Lessons

0H 9M

85. Create stored procedure

4m 36s

86. Stored procedure with parameter

4m 29s

Azure Data Studio Visualization

3 Lessons

0H 13M

87. Installing SandDance Extension

2m 37s

88. Visualization Charts

4m 57s

89. Multiple Table Data Charts

6m 2s

Azure Studio SQL for Data Analysis

2 Lessons

0H 22M

90. Type Decision for Data Analysis

13m 1s

91. Data Analysis with Case Statement and String Text

9m 15s

Import and Export data

4 Lessons

0H 14M

92. Section Introduction

1m 8s

93. Import Flat File

5m 3s

94. Import .csv or excel file

2m 40s

95. Export Data to Excel or any format

6m 8s

Backup and Restore Database

3 Lessons

0H 8M

96. Section Introduction

59s

97. Creating Database backup

3m 52s

98. Restoring Database backup

3m 35s

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:

$43.75

~~$124.99~~

65% off

2 days and 22 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