SQL Server for Data Analytics (Remote)

From: KSh 20,000.00

Categories: ,

Description

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 tutorial 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.

 

Course Outline

Week 1

Part I: Basic Concepts and Installation

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

Part II: Transact-SQL Language

  • SQL Components
  • Data Definition Language
  • Queries
  • Modification of a Table’s Contents
  • Stored Procedures and User-Defined Functions
  • System Catalog
  • Indices
  • Views
  • Security System of the Database Engine
  • Concurrency Control
  • Triggers

 

Week 2

Part III: SQL Server: System Administration

  • System Environment of the Database Engine
  • Backup, Recovery, and System Availability
  • Automating System Administration Tasks
  • Data Replication
  • Query Optimizer
  • Performance Tuning
  • In-Memory OLTP

 

*Senior additional topics

Part IV: SQL Server and Business Intelligence

  • Business Intelligence: An Introduction
  • SQL Server Analysis Services
  • Business Intelligence and Transact-SQL
  • SQL Server Reporting Services
  • Optimizing Techniques for Data Warehousing
  • Columnstore Indexes
  • Intelligent Query Processing

Week 3

Part V: Beyond Relational Data

  • JSON Integration in the Database Engine
  • Spatial and Temporal Data
  • SQL Server Graph Databases

Part VI: Machine Learning

  • SQL Server Machine Learning Services: R Support
  • SQL Server Machine Learning Services: Python Support

You may also like…