Course Link: https://www.coursera.org/learn/cloudera-big-data-analysis-sql-queries
Analyzing Big Data with SQL
In this course, we’ll explore the object-relational programming model that is used to construct SQL statements and our common use of SQL as a service (SAS) service. We’ll also cover the standard input, output, and standard output operations that we see from SQL, as well as how we can use these to extract meaningful information from our data. We’ll use Visual Studio 2015 as our SVC. The course is the first half of a three-part sequence that explores SQL as a service in more depth.
Learning Outcomes
By completing this course, you’ll have a high level understanding of the SQL language and its core functionality. You’ll also have some basic programming skills to get started using in your team. You’ll need to install Visual Studio as your SVC if you do not have a previous version. You’ll continue to use the command prompt as your IDE. You should have a basic understanding of HTML, CSS, JavaScript, and related technologies like Bootstrap 3. You should also have a good understanding of SQL, as described in the larger sequence of this course.
Recommended background
You should be comfortable writing SQL statements in SQL. You should also have a basic understanding of SQL, as described in the larger sequence of this course.
Tools we’ll use
We’ll use many of the tools offered in this course, including SQLite3, Excel, and Hadoop. You’ll also have access to SQL from any computer.
Course outline
The course consists of three parts. In the first part we cover SQLite3 basics, then move on to exploring large data sets using SQL and related programming models. The course wraps up with a focus on SQL as a service (SAS) and how you can use SQL to build SQL statements in your own applications. The third part of the course focuses on an intermediate level of SQL administration and includes a small project to make you comfortable with using SQL in your team.Getting Started
SQLite3
MSSQL
SQL Interoperability
Applied Statistics for Geography I
Applied Statistics for Geography I
Course Overview: https://youtu.be/g-9uLU.In this course you will learn the basic concepts and methods of statistics, along with an introduction to descriptive statistics, their appropriate application, and their limitations. You will also learn about the different types of statistical scales and their use in Geographic Information Systems (GIS). The course consists of three parts. First part covers descriptive statistics, methods of finding values for a fixed variable, and a sample size calculation. Second part covers random sampling, standard deviation reduction, and extrapolating data to represent the complete dataset. Third part focuses on population density and population size estimation. You will also learn about density estimates from 3D GIS as well as other applications.
Course
Course Link: https://www.coursera.org/learn/cloudera-big-data-analysis-sql-queries