Master the Fundamentals of SQL with Python uDemy

Master the Fundamentals of SQL with Python | uDemy
English | Size: 915.24 MB
Category: Tutorial

Master the Fundamentals of SQL with Python
Integrating SQL based databases directly into your Python programms
4.5 (6 ratings)
99 students enrolled
Created by Maximilian Schallwig
Last updated 11/2017
English
English [Auto-generated]
[Read more…]

Udemy – SQL Advanced; The Ultimate Guide

Udemy – SQL Advanced; The Ultimate Guide
English | Size: 2.12 GB
Category: CBTs

A 15 chapter course with introduction

01 INTRODUCTION
02 INTRODUCING DATABASE OBJECTS
03 DATA DICTIONARY VIEWS
04 SEQUENCES
05 SYNONYMS
06 INDEXES
07 VIEWS
08 MATERIALIZED VIEWS [Read more…]

Udemy – Learn SQL & Excel

Udemy – Learn SQL & Excel
English | Size: 1.73 GB
Category: Tutorial

Learn how easy it is to combine the two most popular business analytics tools in this comprehensive course.
With Brian Haas

There is simply no more valuable combination of data analysis tools than SQL & Excel.

Many business users can be intimidated by a database. This course will help you understand that in many ways, a database is like a supersized version of Excel. This means that you can bring invaluable insight to your team by delivering metrics that others can’t, and that in turn leads to new job opportunities and increased job security. [Read more…]

Packt Publishing – SQL Fundamentals for Business Intelligence

Packt Publishing – SQL Fundamentals for Business Intelligence
English | Size: 452.76 MB
Category: CBTs

This course will teach you how to get a grip on real-world SQL and write complex queries to answer very specific questions and will help them “Think in SQL”.

Many of us know a bit of SQL. But when it comes to answering real-world business questions, our rusty memories of database classes let us down!
[Read more…]

Pluralsight – Accessing SQL Server Databases from PowerShell

Pluralsight – Accessing SQL Server Databases from PowerShell
English | Size: 106.35 MB
Category: Tutorial

SQL Server is the Database engine used for all the enterprise tools part of the Microsoft ecosystem and PowerShell is the most popular scripting language. This course will teach you how to use PowerShell to read and write data from/to SQL Databases.
[Read more…]

Pearson IT Certification – SQL Server 70-768 Developing SQL Data Models

Pearson IT Certification – SQL Server 70-768 Developing SQL Data Models
English | Size: 10.20 GB
Category: CBTs

Prepare for Microsoft Exam 70-768: Developing SQL Data Models and develop practical Business Intelligence (BI) skills with more than 6 hours of video instruction and hands-on demonstrations.

SQL Server Analysis Services (SSAS) provides a robust semantic environment for modeling data in support of analytic and ad hoc reporting needs. With each release of SQL Server, SSAS functionality is enhanced, with tabular models in particular becoming more capable and fully featured. [Read more…]

SQL Advanced

SQL Advanced
English | Size: 1.05 GB
Category: Tutorial

Senior SQL Developers are in high demand and demand 100k+ salary in the IT industry.
If we have to advance in our career and earn a good salary, we need these Advanced SQL skills. So let’s take the next step of learning these advanced concepts of Oracle SQL.
Learning these advanced SQL concepts would position you better in your working environment.
What will we learn? [Read more…]

SQL on Hadoop – Analyzing Big Data with Hive

SQL on Hadoop – Analyzing Big Data with Hive
English | Size: 406.67 MB
Category: Tutorial

This course will teach you the Hive query language and how to apply it to solve common Big Data problems. This includes an introduction to distributed computing, Hadoop, and MapReduce fundamentals and the latest features released with Hive 0.11
[Read more…]

Pluralsight – SQL Server Indexing for Performance

Pluralsight – SQL Server: Indexing for Performance
English | Size: 1.35 GB
Category: Tutorial

The most important feature in SQL Server when it comes to getting the required workload performance is probably indexing. But the indexing possibilities you have can be bewildering, and it’s easy to make the wrong choice, leading to wasted resources and maybe even worse performance! In this course, SQL Server: Indexing for Performance, you’ll learn how to correctly choose indexes for your environment. First, you’ll discover how clustered and nonclustered indexes work and how they are used by SQL Server, both of which are crucial when choosing the correct indexes to create. Next you’ll explore the tipping point – when an index can be used or not, the benefits of covering queries, and how to use the INCLUDE option to more effectively cover queries. Finally, you’ll learn how to use filtered indexes and get an introduction to index consolidation for effective server tuning. When you’ve finished this course, you’ll have the skills and knowledge to start adding and changing indexes in your environment for better performance! [Read more…]

LiveLesson MCSA SQL Server 70-761 Querying Data with Transact SQL Tutorial OXBRiDG

LiveLesson: MCSA SQL Server 70-761 Querying Data with Transact SQL Tutorial OXBRiDG
English | Size: 21.07 GB
Category: Tutorial

Training material for the MCSA 70-761 exam. [Read more…]