SQL Server Installing and Configuring SQL Server 2016

SQL Server Installing and Configuring SQL Server 2016
English | Size: 249.2 MB
Category: E-learning | Microsoft


Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. [Read more…]

Pluralsight – SQL Server Installing and Configuring SQL Server 2016

Pluralsight – SQL Server Installing and Configuring SQL Server 2016
English | Size: 252.05 MB
Category: Tutorial


Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. [Read more…]

Pluralsight – Azure SQL Database for the SQL Server DBA

Pluralsight – Azure SQL Database for the SQL Server DBA
English | Size: 428.59 MB
Category: Tutorial


Azure SQL Database is Microsoft’s Database as a Service in the cloud. This course, Azure SQL Database for the SQL Server DBA, will show you some of the similarities to SQL Server but also why experienced DBAs will still need to learn some of the key differences. You will get to see the differences in management, high availability, performance, and monitoring of this cloud-first solution. [Read more…]

O’Reilly – Getting Started with Microsoft Power BI

O’Reilly – Getting Started with Microsoft Power BI
English | Size: 558.03 MB
Category: Tutorial


Power BI is a new software product from Microsoft that helps you find meaning in your data. It’s used to take in, transform, analyze, and visualize data in new and exciting ways. [Read more…]

O’Reilly – Learning Path Understanding Tool Integration for Big Data Architecture

O’Reilly – Learning Path Understanding Tool Integration for Big Data Architecture
English | Size: 7.91 GB
Category: Tutorial


In this Learning Path, you’ll learn how to integrate Hadoop components to implement big data solutions for a variety of use cases, including clickstream analytics, time series problems, transferring data between Hadoop and relational databases, and applications in the finance sector. [Read more…]

O’Reilly – Learning Path SQL for Business Users

O’Reilly – Learning Path SQL for Business Users
English | Size: 6.30 GB
Category: Tutorial


If you’re looking for “just enough” SQL knowledge to wrangle data and do sophisticated analysis, this Learning Path is for you. You’ll get a solid understanding of basic database design principles and normalization. You’ll learn how to pipeline data to other analysis tools (R, Python, even Excel). You’ll be able to prototype a database that suits your business needs, and form accurate queries and database updates in several SQL environments-all without getting bogged down in the deeply technical aspects of SQL that you will never use. [Read more…]

Lynda – Developing Microsoft SQL Server 2016 Databases

Lynda – Developing Microsoft SQL Server 2016 Databases
English | Size: 542.56 MB
Category: Tutorial


In this course, Adam Wilbert shows experienced SQL Server DBAs how to develop a SQL Server 2016 database with more advanced features. Learn how to create data tables, including temporary tables and tables with variables, and schemas. Find out how to enforce data integrity with constraints and secure your database at the user level. [Read more…]

CBT Nuggets – MySQL 5.0 Database Administrator 1 (Exam 005-002)

CBT Nuggets – MySQL 5.0 Database Administrator 1 (Exam 005-002)
English | Size: 925.10 MB
Category: CBTs


In addition to prepping you for the first of two MySQL Certified Dabase Administrator (CMDBA) exam certification exams, Tim Warner packs this course with real-world practical examples and industry advice that you can apply immediately in your MySQL, Oracle, PostgreSQL or Microsoft SQL Server environments. [Read more…]

Statistics Fundamentals – Part 1 Beginning Lynda

Statistics Fundamentals – Part 1: Beginning | Lynda
English | Size:619.89 MB
Category:Tutorial


Statistics is not just the realm of data scientists. All types of jobs use statistics. Statistics are important for making decisions, new discoveries, investments, and predictions. Whether the subject is political races, sports rankings, shopping trends, or healthcare advancements, statistics is an instrument for understanding your favorite topic at a deeper level. With these beginner-level lessons, you too can master the terms, formulas, and techniques needed to perform the most common types of statistics. [Read more…]

Real World Hadoop – Hands on Enterprise Distributed Storage | Udemy

Real World Hadoop – Hands on Enterprise Distributed Storage | Udemy
English | Size: 1.71 GB
Category: Tutorial


Master the art of manipulating files within a distributed storage enterprise platform. It’s easier than you think!
The Hadoop Distributed File System (HDFS) is a distributed file system designed to run on commodity hardware. It has many similarities with existing distributed file systems. [Read more…]