Checklist

Certification

You will get a certificate on completing this course.

University

The course is from one of the top universities of the world - University of California, Davis.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Data Wrangling, Analysis and AB Testing with SQL

Data Wrangling, Analysis and AB Testing with SQL

FREE (Audit)
Start anytime
17 hours
English
University of California, Davis
Course by
CourseraCourses from Coursera
Certificate awarded
For Rs. 2182
Intermediate
Login to earn ₹ 100

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

The course is from one of the top universities of the world - University of California, Davis.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Why should you choose this course?

Description

This course allows you to apply the SQL skills taught in "SQL for Data Science" to four increasingly complex and authentic data science inquiry case studies. We'll learn how to convert timestamps of all types to common formats and perform date/time calculations. We'll select and perform the optimal JOIN for a data science inquiry and clean data within an analysis dataset by deduping, running quality checks, backfilling, and handling nulls. We'll learn how to segment and analyze data per segment using windowing functions and use case statements to execute conditional logic to address a data science inquiry. We'll also describe how to convert a query into a scheduled job and how to insert data into a date partition. Finally, given a predictive analysis need, we'll engineer a feature from raw data using the tools and skills we've built over the course. The real-world application of these skills will give you the framework for performing the analysis of an AB test.

Syllabus

Data of Unknown Quality
Creating Clean Datasets
SQL Problem Solving
Case Study: AB Testing

What others say about this course

Reviews from Coursera

I liked the content of this course. It is very practical. The teaching style was frustrating for me, though. I understand that the instructor wanted us to "see" that everyone, even experts, make silly   Read More ...

There is a big gap between what was taught in the previous class and what is expected to be known in this class. Moreover, the instructor often poorly explains the codes that she is teaching in the sol  Read More ...

Lots of "oh wait, let me catch my own mistakes" on the videos. It appears to be sloppy, rather than a "teaching moment" for how one might debug the query.

It was awful. The whole course was poorly structured or at least I couldn't understand the logic between the lessons.Watching the videos was truly painful: I don't understand the virtues of watching so  Read More ...

I was quite disappointed with this course1) They don't teach advanced SQL concepts adequately well (For example Windowing functions/Pivoting). I recommend self-learning from https://mode.com/sql-tutori  Read More ...

Show more reviews

FAQs

What is SQL?

Structured Query Language (SQL) is a domain-specific language designed for data management for RDBMS. SQL comes particularly handy in managing structured data and offers certain advantages, such as allowing the access of multiple records through a single command and eliminating the need to specify how to access a record. In simpler words, SQL provides tools to the programmer to define, control and manipulate data in a relational model including tables, rows, and columns.

What are the Prerequisites for learning SQL?

If you wish to learn SQL programming, know the prerequisites well for a smooth learning journey. SQL is a basic query language used primarily for databases, coming with no prerequisites as such. With a simple syntax, there aren't many specific requirements, but it would be helpful to learn database concepts, calculus theories, and basic RDBMS concepts. Once you get a hold of these concepts, you are good to go.

Why should you learn SQL?

SQL query is purely a text message application which can help you access data. SQL is used for most relational storage systems, and it is more of a query language than a programming language. Learning SQL helps the programmers in accessing data with greater efficiency through basic queries. It is predominantly effectual for data manipulation, and the data stored in SQL is dynamic, which means it can be manipulated and modified at any point of time using a set of basic queries. These features make SQL fully equipped to manage datasets of all shapes and sizes.

How can Edvicer help you find the best SQL courses?

Edvicer is a great place to learn SQL with a large number of SQL courses, both free and paid, and projects, both for practice and freelancing. Edvicer has helped a large number of people learn SQL online through the best courses from the top providers like Coursera, Udemy, Udacity, and Pluralsight.

What are the top jobs that I can get from learning SQL?

The top job profile for SQL experts are Dotnet Developer with an average salary of INR 5 LPA, Software Engineer with an average salary of INR 7 LPA, and Database Administrator with an average salary of INR 7 LPA. Get your career map for your skills here.

What can I learn after learning SQL?

After learning SQL, the top skills you can learn to open highest number of job profiles for you are Python, Java, and Data Analytics. The top skills that can get you jobs with highest salaries are Node.js, Data Mining, and Statistical Modeling

Write your review of Data Wrangling, Analysis and AB Testing with SQL

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer