Course Highlights
Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This SQL For Data Science, Data Analytics And Data Visualization
course has been specially designed to help learners gain a good command of SQL For Data Science, Data Analytics And Data Visualization, providing them with a solid foundation of knowledge to become a qualified professional.
Through this SQL For Data Science, Data Analytics And Data Visualization
course, you will gain both practical and theoretical understanding of SQL For Data Science, Data Analytics And Data Visualization
that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.
Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.
Learning outcome
- Familiar yourself with the recent development and updates of the relevant industry
- Know how to use your theoretical knowledge to adapt in any working environment
- Get help from our expert tutors anytime you need
- Access to course contents that are designed and prepared by industry professionals
- Study at your convenient time and from wherever you want
Course media
Why should I take this course?
- Affordable premium-quality E-learning content, you can learn at your own pace.
- You will receive a completion certificate upon completing the course.
- Internationally recognized Accredited Qualification will boost up your resume.
- You will learn the researched and proven approach adopted by successful people to transform their careers.
- You will be able to incorporate various techniques successfully and understand your customers better.
Requirements
- No formal qualifications required, anyone from any academic background can take this course.
- Access to a computer or digital device with internet connectivity.
Course Curriculum
-
How to get course requirements
00:03:00 -
Getting started on Windows, Linux or Docker
00:01:00
-
Introduction
00:03:00
-
FAQ’s
00:01:00
-
Section Introduction
00:02:00
-
Microsoft SQL Server Installation
00:19:00
-
SQL Server Management Studio (SSMS) Installation
00:08:00
-
How to connect MS SQL (Windows Authentication)
00:04:00
-
How to connect MS SQL (SQL Server Authentication)
00:03:00
-
Download and Restore Sample Database
00:07:00
-
What is Azure Data Studio
00:06:00
-
Azure Data Studio Installation steps
00:07:00
-
Azure Data Studio to Connect SQL Server
00:09:00
-
Create a Database
00:07:00
-
Create a Table
00:09:00
-
Insert Data rows
00:07:00
-
View the Data returned by Query
00:03:00
-
Section Introduction
00:01:00
-
Overview of Databases
00:11:00
-
Creating Database
00:05:00
-
SQL Data Types
00:03:00
-
Column Data Types on SSMS
00:04:00
-
Creating Table
00:09:00
-
Overview of Primary Key and Foreign Key
00:04:00
-
Primary Key
00:04:00
-
Foreign Key
00:07:00
-
Creating Temporary tables
00:06:00
-
Section Introduction
00:01:00
-
Insert statement
00:08:00
-
Update statement
00:05:00
-
Delete statement
00:03:00
-
Section Introduction
00:01:00
-
CREATE table statement
00:03:00
-
DROP statement
00:02:00
-
ALTER statement
00:05:00
-
TRUNCATE statement
00:04:00
-
COMMENT in query
00:01:00
-
RENAME
00:02:00
-
Create Database user
00:04:00
-
GRANT permissions
00:06:00
-
REVOKE permissions
00:04:00
-
Section Introduction
00:01:00
-
SQL Statement basic
00:03:00
-
SELECT Statement
00:07:00
-
SELECT DISTINCT
00:03:00
-
SELECT with column headings
00:03:00
-
Column AS statement
00:02:00
-
SELECT WHERE Clause – theory
00:03:00
-
SELECT WHERE Clause – practical
00:07:00
-
Sum()
00:08:00
-
Min()-Max()
00:06:00
-
Order By statement
00:05:00
-
SELECT TOP clause in SQL
00:04:00
-
BETWEEN command
00:08:00
-
IN operator
00:04:00
-
Wildcard Characters and LIKE
00:05:00
-
Section Introduction
00:01:00
-
Group by – theory
00:03:00
-
Group by – practical
00:05:00
-
HAVING statement
00:04:00
-
Overview of Joins
00:02:00
-
What are Joins
00:02:00
-
Inner join
00:08:00
-
Left outer join
00:03:00
-
Right outer join
00:02:00
-
Full outer join
00:01:00
-
Union
00:03:00
-
Cartesian Product with the Cross Join
00:03:00
-
Query Exercise
00:01:00
-
Solution for Query Exercise
00:01:00
-
Section introduction
00:01:00
-
Check constraint
00:07:00
-
NOT NULL constraint
00:08:00
-
UNIQUE constraint
00:05:00
-
Creating Views
00:04:00
-
Reporting with multiple tables
00:03:00
-
Section Introduction
00:01:00
-
Timestamp
00:04:00
-
Extract from timestamp
00:03:00
-
Mathematical scalar functions
00:04:00
-
String functions
00:05:00
-
Sub Query
00:03:00
-
SELECT with calculations
00:06:00
-
Create stored procedure
00:05:00
-
Stored procedure with parameter
00:04:00
-
Installing SandDance Extension
00:03:00
-
Visualization Charts
00:05:00
-
Multiple Table Data Charts
00:06:00
-
Type Decision for Data Analysis
00:13:00
-
Data Analysis with Case Statement and String Text
00:09:00
-
Section Introduction
00:01:00
-
Import Flat File
00:05:00
-
Import .csv or excel file
00:03:00
-
Export Data to Excel or any format
00:06:00
-
Section Introduction
00:01:00
-
Creating Database backup
00:04:00
-
Restoring Database backup
00:04:00
-
Duration:7 hours, 13 minutes
-
Access:1 Year
-
Units:97
Want to get everything for £149
Take Lifetime Pack
