4 out of 5
4
6 reviews

SQL Server for Data Analytics

This course is for people who wish to use data to answer questions. SQL is the “meat and potatoes” of data analysis for many people—used to access, clean, and analyze data contained in databases. It’s simple to understand, but it’s used by the world’s top corporations to tackle extremely difficult problems.

This course is designed for prospective analysts who have some familiarity with Excel but none with coding. 

34 students enrolled

This course is for people who wish to use data to answer questions. SQL is the “meat and potatoes” of data analysis for many people—used to access, clean, and analyze data contained in databases. It’s simple to understand, but it’s used by the world’s top corporations to tackle extremely difficult problems.

This course is designed for prospective analysts who have some familiarity with Excel but none with coding. 

Although some of the lessons may be beneficial for software developers who use SQL in their applications, this course does not address how to set up SQL databases or how to utilize them in software applications, making it a limited resource for aspiring software developers.

Part I: Basic Concepts and Installation

1
 Relational Database Systems: An Introduction
2
Planning the Installation and Installing SQL Server
3
Front-End Tools for the Database Engine

Part II: Transact-SQL Language

1
SQL Components
2
Data Definition Language
3
Queries
4
Modification of a Table’s Contents
5
Stored Procedures and User-Defined Functions
6
System Catalog
7
Indices
8
Views
9
Security System of the Database Engine
10
Concurrency Control
11
Triggers

Part III: SQL Server: System Administration

1
System Environment of the Database Engine
2
Backup, Recovery, and System Availability
3
Automating System Administration Tasks
4
Data Replication
5
Query Optimizer
6
Performance Tuning
7
In-Memory OLTP
8
Senior additional topics

Part IV: SQL Server and Business Intelligence

1
Business Intelligence: An Introduction
2
SQL Server Analysis Services
3
Business Intelligence and Transact-SQL
4
SQL Server Reporting Services
5
Optimizing Techniques for Data Warehousing
6
Columnstore Indexes
7
Intelligent Query Processing

Part V: Beyond Relational Data

1
JSON Integration in the Database Engine
2
Spatial and Temporal Data
3
SQL Server Graph Databases

Part VI: Machine Learning

1
SQL Server Machine Learning Services: R Support
2
SQL Server Machine Learning Services: Python Support


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Get course
30-Day Money-Back Guarantee

Includes

30 hours
Full lifetime access
Access on mobile and TV

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
SQL Server for Data Analytics
Category:
4 out of 5
4
6 reviews
Price:
$200