CourseAnalyticsBeginner

SQL for Data Analysis

Master SQL within few hours

0 enrolledEnglish
Z

Zep Admin

SQL for Data Analysis

₹999

  • 19 lessons
  • 0 students enrolled
  • English
  • Beginner

About this course

This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. After completing the course and all of it's assignments, I promise you, you'll never be afraid to look at a large SQL query again. 
 

Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueriesaggregationsjoinswindow functionstransposing & ranking data and using conditional expressions in very interesting ways. 

Curriculum

13 sections · 19 lessons

  • Welcome

  • MySQL Workbench Installation

  • Basics of Data Architecture

  • Introduction to SQL
  • Constraints in SQL

  • Data Definition Language
  • Data Query Language
  • Data Manipulation Language

  • Joins

  • Data Import & Export

  • Aggregation Functions
  • String Functions
  • Date Time Functions
  • Regular Expressions

  • Nested Queries

  • Views

  • Stored Procedures

  • Windows Functions

  • SQL-Python Connectivity
SQL for Data Analysis | ZepAnalytics