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.

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

SQL Server Security Distilled, Second Edition by Morris Lewis (Repost)

SQL Server Security Distilled, Second Edition by Morris Lewis (Repost)

SQL Server Security Distilled, Second Edition by Morris Lewis (Repost)
Publisher: Apress; 2nd edition (April 5, 2004) | ISBN: 1590592190 | Pages: 376 | CHM | 2.42 MB

This book takes an in-depth look at what you can do to secure data in SQL Server, shows how to authenticate access to data on the server, and authorizes what users can and can't do with that data, in versions 6.5, 7.0, and 2000. SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional. SQL Server Distilled, Second Edition is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks, etc.). This second edition will have more practical advice on how to implement good practices that will ward off future viruses before they are even created. This book will contain new content that reflects all updates to SQL Server's security mechanisms.

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.

SQL Server 2012 Data Integration Recipes: Solutions for Integration Services (Repost)

SQL Server 2012 Data Integration Recipes: Solutions for Integration Services (Repost)

SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools - Adam Aspin
2012 | ISBN: 1430247916 | PDF/EPUB | 1056 pages | 64 Mb

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

Python Specialization Coursera Complete Learn to Program and Analyze Data

Python Specialization Coursera Complete Learn to Program and Analyze Data

Python Specialization Coursera Complete Learn to Program and Analyze Data
with Python Develop programs to gather, clean, analyze, and visualize data

WEBRip | English | MP4 + PDF Guides + work files | 960 x 394 | AVC ~101 kbps | 29.970 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | ~18 hours | 3.13 GB
Genre: eLearning Video / Development, Programming

This Specialization builds on the success of the Python for Everybody course and will introduce fundamental programming concepts including data structures, networked application program interfaces, and databases, using the Python programming language. In the Capstone Project, you’ll use the technologies learned throughout the Specialization to design and create your own applications for data retrieval, processing, and visualization.

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.