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!
Skill LevelIntermediate
Estimated Learning Time7h 19m
Lessons98
Your ProgressStart anytime
What you'll 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
</>
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.
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)
Curriculum
98 Lessons • 7h 19m estimated learning time
98 videos7h 19m video
Introduction
5 Lessons9m
3m
3m
3. Getting started on Windows, Linux or Docker
1m
4. How to ask great questions
2m
2m
SQL Server setting up
6 Lessons44m
6. Section Introduction
2m
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
7 Lessons48m
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
10 Lessons55m
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
4 Lessons18m
29. Section Introduction
1m
30. Insert statement
9m
31. Update statement
6m
32. Delete statement
4m
SQL Data Structure statements
7 Lessons19m
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
3 Lessons15m
40. Create Database user
4m
41. GRANT permissions
7m
42. REVOKE permissions
5m
SQL Statement Basic
6 Lessons20m
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
2 Lessons11m
49. SELECT WHERE Clause – theory
4m
50. SELECT WHERE Clause – practical
8m
Aggregate Functions
2 Lessons14m
51. Sum()
9m
52. Min()-Max()
6m
SQL Query statements
5 Lessons27m
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
4 Lessons14m
58. Section Introduction
2m
59. Group by – theory
4m
60. Group by – practical
6m
61. HAVING statement
4m
JOINS for Multiple table Data Analysis
10 Lessons27m
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
4 Lessons22m
72. Section introduction
1m
73. Check constraint
7m
74. NOT NULL constraint
9m
75. UNIQUE constraint
6m
Views
2 Lessons8m
76. Creating Views
4m
77. Reporting with multiple tables
4m
Advanced SQL commands
7 Lessons27m
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
2 Lessons10m
85. Create stored procedure
5m
86. Stored procedure with parameter
5m
Azure Data Studio Visualization
3 Lessons14m
87. Installing SandDance Extension
3m
88. Visualization Charts
5m
89. Multiple Table Data Charts
7m
Azure Studio SQL for Data Analysis
2 Lessons23m
90. Type Decision for Data Analysis
14m
91. Data Analysis with Case Statement and String Text
10m
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.
