SQL is the most commonly used data analysis tool for data analysts and data scientists. In this course, you’ll learn to extract and analyze data through Structured Query Language (SQL). You’ll first learn to extract data, join tables and perform aggregations. Then you’ll learn to do more complex analysis and. By the end of the course, you’ll be able to write efficient SQL queries to successfully handle a variety of data analysis tasks.
Assessment
This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: Udacity
Course Curriculum
| Lesson 1: Basic SQL | |||
| SQL Introduction | 00:01:00 | ||
| The Parch & Posey Database | 00:01:00 | ||
| The Parch & Posey Database 2 | 00:01:00 | ||
| Why SQL | 00:03:00 | ||
| How Databases Store Data | 00:01:00 | ||
| Types of Statements | 00:01:00 | ||
| SELECT & FROM | 00:02:00 | ||
| LIMIT | 00:01:00 | ||
| ORDER BY | 00:01:00 | ||
| ORDER BY Part II | 00:02:00 | ||
| WHERE | 00:02:00 | ||
| WHERE with Non-Numeric Data | 00:01:00 | ||
| Arithmetic Operators | 00:01:00 | ||
| LIKE | 00:01:00 | ||
| NOT | 00:01:00 | ||
| AND and BETWEEN | 00:02:00 | ||
| Lesson 2: SQL Joins | |||
| Motivation | 00:01:00 | ||
| Why Would We Want to Split Data Into Separate Tables? | 00:03:00 | ||
| Introduction to JOINs | 00:01:00 | ||
| Alias | 00:01:00 | ||
| Motivation for Other JOINs | 00:01:00 | ||
| LEFT and RIGHT JOINs | 00:05:00 | ||
| JOINs and Filtering | 00:02:00 | ||
| Lesson 3: SQL Aggregations | |||
| Introduction to Aggregation | 00:02:00 | ||
| Introduction to NULLs | 00:01:00 | ||
| NULLs and Aggregation | 00:02:00 | ||
| First Aggregation – COUNT | 00:01:00 | ||
| COUNT & NULLs | 00:02:00 | ||
| SUM | 00:01:00 | ||
| MIN & MAX | 00:01:00 | ||
| AVG | 00:01:00 | ||
| GROUP BY | 00:02:00 | ||
| GROUP BY Part II | 00:01:00 | ||
| DISTINCT | 00:01:00 | ||
| HAVING | 00:02:00 | ||
| DATE Functions | 00:03:00 | ||
| DATE Functions II | 00:03:00 | ||
| CASE Statements | 00:04:00 | ||
| CASE & Aggregations | 00:01:00 | ||
| Lesson 4: SQL Subqueries & Temporary Tables | |||
| Introduction to Subqueries | 00:01:00 | ||
| Write Your First Subquery | 00:03:00 | ||
| More On Subqueries | 00:02:00 | ||
| Solution Video: More On Subqueries | 00:07:00 | ||
| WITH | 00:02:00 | ||
| Subquery Conclusion | 00:01:00 | ||
| Lesson 5: SQL Data Cleaning | |||
| Introduction to SQL Data Cleaning | 00:01:00 | ||
| LEFT & RIGHT | 00:02:00 | ||
| POSITION, STRPOS, & SUBSTR | 00:02:00 | ||
| CONCAT | 00:01:00 | ||
| CAST | 00:02:00 | ||
| COALESCE | 00:01:00 | ||
| Lesson 6: [Advanced] SQL Window Functions | |||
| Introduction to Window Functions | 00:01:00 | ||
| Window Functions 1 | 00:03:00 | ||
| ROW_NUMBER & RANK | 00:03:00 | ||
| Aggregates in Window Functions | 00:02:00 | ||
| Aliases for Multiple Window Functions | 00:01:00 | ||
| Comparing a Row to Previous Row | 00:02:00 | ||
| Introduction to Percentiles | 00:01:00 | ||
| Percentiles | 00:01:00 | ||
| Lesson 7: [Advanced] SQL Advanced JOINs & Performance Tuning | |||
| Introduction to Advanced SQL | 00:01:00 | ||
| JOINs with Comparison Operators | 00:03:00 | ||
| Self JOINs | 00:02:00 | ||
| UNION | 00:02:00 | ||
| Performance Tuning Motivation | 00:01:00 | ||
| Performance Tuning 1 | 00:03:00 | ||
| Performance Tuning 2 | 00:03:00 | ||
| Performance Tuning 3 | 00:01:00 | ||
| JOINing Subqueries | 00:07:00 | ||
| Assessment | |||
| Submit Your Assignment | 00:00:00 | ||
| Certification | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
