Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]

Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]

Pluralsight - SQL Data Wrangling in Oracle: Table Data
MP4 | AVC 211kbps | English | 1024x768 | 15fps | 5h 18mins | AAC stereo 102kbps | 624 MB
Genre: Video Training

This course describes Oracle functionality useful to the SQL-savvy data analyst, and features topics such as ordering your data with NULLs appearing first or last, using FETCH to subset your data, using SAMPLE to randomly sample from a table, using CROSS APPLY and OUTER APPLY, how to use the MODEL feature to access the rows and columns of a database table like a spreadsheet, generating random numbers, computing occurrences, using nested tables, and much, more.

NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software

NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software

NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software by Ted Hills
English | 11 Mar. 2016 | ISBN: 1634621093 | 258 Pages | AZW3/MOBI/EPUB/PDF (conv) | 26.05 MB

How do we design for data when traditional design techniques cannot extend to new database technologies?

Pluralsight - SQL Data Wrangling in Oracle: Table Data

Pluralsight - SQL Data Wrangling in Oracle: Table Data

Pluralsight - SQL Data Wrangling in Oracle: Table Data
27 Nov 2014 | .MP4, x264, 1024x768 | English, AAC, 2 Ch | 5 hrs 18 mins | 624 MB
Instructor: Scott Hecht | Level: Intermediate

Azure SQL Data Warehouse: First Look (2016)

Azure SQL Data Warehouse: First Look (2016)

Azure SQL Data Warehouse: First Look
August 2016 | MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1H 45M | 329 MB
Genre: eLearning | Language: English

Azure SQL Data Warehouse is Microsoft Azure's Database as a Service offering. This course teaches the differences between this service and SQL Server, designing your database for the service, loading and migrating data, scaling and basic monitoring.

SQL For Anyone: A Complete Beginner’s Guide to Structured Query Language

SQL For Anyone: A Complete Beginner’s Guide to Structured Query Language

SQL For Anyone: A Complete Beginner's Guide to Structured Query Language by Mark Dinkel
English | Feb 21, 2016 | ASIN: B01C26KNIS | 67 Pages | AZW4/PDF (True) | 2.09 MB

An explanation of SQL data and statements to use the SQL data. It covers SELECT, UPDATE, DELETE, JOINS, UNION, NULL and aggregation using GROUP BY.

Coursera - Introduction to Data Science

Coursera - Introduction to Data Science

Coursera - Introduction to Data Science
MP4 | AVC 88kbps | English | 960x540 | 30fps | 16h 03mins | AAC stereo 113kbps | 3.88 GB
Genre: Video Training

Commerce and research is being transformed by data-driven discovery and prediction. Skills required for data analytics at massive levels – scalable data management on and off the cloud, parallel algorithms, statistical modeling, and proficiency with a complex ecosystem of tools and platforms – span a variety of disciplines and are not easy to obtain through conventional curricula. Tour the basic techniques of data science, including both SQL and NoSQL solutions for massive data management (e.g., MapReduce and contemporaries), algorithms for data mining (e.g., clustering and association rule mining), and basic statistical modeling (e.g., linear and non-linear regression).

Coursera - Web Intelligence and Big Data [repost]

Coursera - Web Intelligence and Big Data [repost]

Coursera - Web Intelligence and Big Data
MP4 | AVC 74kbps | English | 960x540 | 30fps | 13h 33mins | AAC stereo 128kbps | 1.19 GB
Genre: Video Training

The past decade has witnessed the successful of application of many AI techniques used at `web-scale’, on what are popularly referred to as big data platforms based on the map-reduce parallel computing paradigm and associated technologies such as distributed file systems, no-SQL databases and stream computing engines. Online advertising, machine translation, natural language understanding, sentiment mining, personalized medicine, and national security are some examples of such AI-based web-intelligence applications that are already in the public eye. Others, though less apparent, impact the operations of large enterprises from sales and marketing to manufacturing and supply chains. In this course we explore some such applications, the AI/statistical techniques that make them possible, along with parallel implementations using map-reduce and related platforms.

Coursera - Process Mining (2015)

Coursera - Process Mining (2015)

Coursera - Process Mining (2015)
MP4 | AVC 161kbps | English | 960x540 | 29.97fps | 14 hours | AAC stereo 128kbps | 1.68 GB
Genre: Video Training

Process mining is the missing link between model-based process analysis and data-oriented analysis techniques. Through concrete data sets and easy to use software the course provides data science knowledge that can be applied directly to analyze and improve processes in a variety of domains. Data science is the profession of the future, because organizations that are unable to use (big) data in a smart way will not survive. It is not sufficient to focus on data storage and data analysis. The data scientist also needs to relate data to process analysis. Process mining bridges the gap between traditional model-based process analysis (e.g., simulation and other business process management techniques) and data-centric analysis techniques such as machine learning and data mining.

Coursera - Web Intelligence and Big Data (2013)

Coursera - Web Intelligence and Big Data (2013)

Coursera - Web Intelligence and Big Data (2013)
English | MP4 | 960 x 540 | AVC ~36.4 kbps | 30 fps
AAC | 123 Kbps | 44.1 KHz | 2 channels | Subs: English (srt) | 13:33:03 | 1.37 GB
Genre: eLearning Video / Computer Science: Artificial Intelligence

The past decade has witnessed the successful of application of many AI techniques used at `web-scale’, on what are popularly referred to as big data platforms based on the map-reduce parallel computing paradigm and associated technologies such as distributed file systems, no-SQL databases and stream computing engines. Online advertising, machine translation, natural language understanding, sentiment mining, personalized medicine, and national security are some examples of such AI-based web-intelligence applications that are already in the public eye.

Coursera - Process Mining: Data Science in Action [repost]

Coursera - Process Mining: Data Science in Action [repost]

Coursera - Process Mining: Data Science in Action
WEBRip | English | MP4 | 960 x 540 | AVC ~151 kbps | 29.970 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | 13:23:25 | 1.68 GB
Genre: eLearning Video / Computer Science, Engineering and Technology

Process mining is the missing link between model-based process analysis and data-oriented analysis techniques. Through concrete data sets and easy to use software the course provides data science knowledge that can be applied directly to analyze and improve processes in a variety of domains. Data science is the profession of the future, because organizations that are unable to use (big) data in a smart way will not survive. It is not sufficient to focus on data storage and data analysis. The data scientist also needs to relate data to process analysis. Process mining bridges the gap between traditional model-based process analysis (e.g., simulation and other business process management techniques) and data-centric analysis techniques such as machine learning and data mining.

Coursera - Data Analysis [repost]

Coursera - Data Analysis [repost]

Coursera - Data Analysis
WEBRip | English | MP4 + PDF Slides | 960 x 540 | AVC ~33.8 kbps | 30 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | 12h 36mn | 949 MB
Genre: eLearning Video / Programming

This course is an applied statistics course focusing on data analysis. The course will begin with an overview of how to organize, perform, and write-up data analyses. Then we will cover some of the most popular and widely used statistical methods like linear regression, principal components analysis, cross-validation, and p-values. Instead of focusing on mathematical details, the lectures will be designed to help you apply these techniques to real data using the R statistical programming language, interpret the results, and diagnose potential problems in your analysis. You will also have the opportunity to critique and assist your fellow classmates with their data analyses.

Coursera - Introduction to Data Science (2013)

Coursera - Introduction to Data Science (2013)

Coursera - Introduction to Data Science (2013)
English | MP4 | 960 x 540 | AVC ~72.8 kbps | 30 fps
AAC | 125 Kbps | 44.1 KHz | 2 channels | Subs: English (srt) | 14:00:31 | 3.7 GB
Genre: eLearning Video / Software Engineering, Statistics and Data Analysis

Commerce and research is being transformed by data-driven discovery and prediction. Skills required for data analytics at massive levels – scalable data management on and off the cloud, parallel algorithms, statistical modeling, and proficiency with a complex ecosystem of tools and platforms – span a variety of disciplines and are not easy to obtain through conventional curricula.

Data Mining with Microsoft SQL Server 2000 Technical Reference

Data Mining with Microsoft SQL Server 2000 Technical Reference

Claude Seidman, «Data Mining with Microsoft SQL Server 2000 Technical Reference»
Microsoft Press | ISBN: 0735612714 | 2001 | CHM | 400 pages | 1.43 MB

With its state-of-the-art capabilities for rapidly processing and retrieving huge quantities of data, Microsoft SQL Server 2000 is quickly growing in popularity among large corporations. But learning how to take advantage of the powerful, built-in data-mining services in SQL Server to turn all that data into meaningful information takes time and effort. Data Mining with SQL Server 2000 Technical Reference is the ideal, in-depth reference guide for any database developer, administrator, or IT professional who needs comprehensive information about these powerful new data-mining services. In particular, it fully examines the data-warehousing architecture in SQL Server 2000 to show how to take full advantage of the data-mining services in this RDBMS. This is the only Microsoft-approved technical guide to the data mining services in SQL Server 2000.

Coursera: Algorithms - Princeton University (Part I + Part II) [repost]

Coursera: Algorithms - Princeton University (Part I + Part II) [repost]

Coursera: Algorithms - Princeton University
WEBRip | English | MP4 + PDF Guides + Excercises files | 960 x 540 | AVC ~76.2 kbps | 29.970 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | 28:38:37 | 2.78 GB
Genre: eLearning Video / Computer Science, Development, Programming

This course covers the essential information that every serious programmer needs to know about algorithms and data structures, with emphasis on applications and scientific performance analysis of Java implementations. An introduction to fundamental data types, algorithms, and data structures, with emphasis on applications and scientific performance analysis of Java implementations. Specific topics covered include: union-find algorithms; basic iterable data types (stack, queues, and bags); sorting algorithms (quicksort, mergesort, heapsort) and applications; priority queues; binary search trees; red-black trees; hash tables; and symbol-table applications.

SQL Server Master Data Services for Master Data Manag (2016)

SQL Server Master Data Services for Master Data Manag (2016)

SQL Server Master Data Services for Master Data Manag
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | Lec: 26 | 321 MB
Genre: eLearning | Language: English

MDM, SQL Server, Data Modeling, Data Integration, Data Quality, Data Management, Business Intelligence, Data Architect

Coursera - Data Analysis (2013)

Coursera - Data Analysis (2013)

Coursera - Data Analysis (2013)
MP4 | AVC 41kbps | English | 960x540 | 30fps | 12h 36mins | AAC stereo 111kbps | 949 MB
Genre: Video Training

This course is an applied statistics course focusing on data analysis. The course will begin with an overview of how to organize, perform, and write-up data analyses. Then we will cover some of the most popular and widely used statistical methods like linear regression, principal components analysis, cross-validation, and p-values. Instead of focusing on mathematical details, the lectures will be designed to help you apply these techniques to real data using the R statistical programming language, interpret the results, and diagnose potential problems in your analysis. You will also have the opportunity to critique and assist your fellow classmates with their data analyses.

Coursera - Genomic Data Science Specialization (2016)

Coursera - Genomic Data Science Specialization (2016)

Coursera - Genomic Data Science Specialization (2016)
WEBRip | English | MP4 + PDF Guides + work files | 960 x 540 | AVC ~63.6 kbps | 29.970 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~32 hours | 3.79 GB
Genre: eLearning Video / Medicine, Biology and Genetics, Science

This specialization covers the concepts and tools to understand, analyze, and interpret data from next generation sequencing experiments. It teaches the most common tools used in genomic data science including how to use the command line, Python, R, Bioconductor, and Galaxy. The sequence is a stand alone introduction to genomic data science or a perfect compliment to a primary degree or postdoc in biology, molecular biology, or genetics.

SQL Server: Transact-SQL Basic Data Retrieval

SQL Server: Transact-SQL Basic Data Retrieval

SQL Server: Transact-SQL Basic Data Retrieval
Flash Video | WMV / WMV3, ~156 kb/s | 1024x768 | Duration: 03:53:19 | English: WMA, 128 kb/s (2 ch) | 454 mb
Genre: Programming

If you need to retrieve data from a SQL Server database then you need to know how to use the SELECT statement. This course starts with the basics of a SELECT statement and its various sub-clauses, and progresses to how to select from multiple data sources in the same statement and a comprehensive section on the functions available to manipulate, aggregate, and convert data during the select operation. More then fifty demos help to give you a thorough understanding of how to perform these essential operations, all using a freely-available demo environment that you're shown how to set up and configure. This course is perfect for developers who need to query SQL Server databases to retrieve data, from complete beginners through to more experienced developers who can use some of the modules as reference material. The information in the course applies to all versions from SQL Server 2005 onwards.

Lynda - SQL for Data Reporting and Analysis

Lynda - SQL for Data Reporting and Analysis

Lynda - SQL for Data Reporting and Analysis
Size: 341 MB | Duration: 2h 16m | Video: AVC (.mp4) 1280x800 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English

Do you rely on IT to get you the data you need? Do you wish you could retrieve it yourself? SQL for Data Reporting and Analysis teaches you how to get the data you want by writing a bit of SQL code.

Coursera - Computational Methods for Data Analysis

Coursera - Computational Methods for Data Analysis

Coursera - Computational Methods for Data Analysis
University of Washington with J. Nathan Kutz

WEBRip | English | MP4 | 960 x 540 | AVC ~171 kbps | 30.920 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | 22:11:46 | 3.39 GB
Genre: eLearning Video / Data Analysis

Exploratory and objective data analysis methods applied to the physical, engineering, and biological sciences. Brief review of statistical methods and their computational implementation for studying time series analysis, spectral analysis, filtering methods, principal component analysis, orthogonal mode decomposition, and image processing and compression.