LearnKartS

Advanced SQL: Window Functions, Stored Procedures & Triggers

LearnKartS

Advanced SQL: Window Functions, Stored Procedures & Triggers

Nikhil Agarwal
LearnKartS

Instructors: Nikhil Agarwal

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

3 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

3 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Write database logic that runs reliably on its own using ACID transactions, Stored Procedures, and real-world rollback examples

  • Automate database responses with Triggers and build reusable functions using User Defined Functions across both MySQL and PostgreSQL

  • Analyze data across rows without collapsing your results using Window Functions, including ROW_NUMBER, RANK, LEAD, LAG, and Running Totals

  • Simplify complex queries with Common Table Expressions and recursive logic, and control database access using GRANT, REVOKE, and role-based security

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

June 2026

Assessments

5 assignments

Taught in Hindi

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the SQL From Beginner to Advanced Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 2 modules in this course

Learn how databases ensure reliability using ACID properties, transactions, and rollback operations. You will also explore stored procedures, triggers, and user-defined functions to automate database logic.

What's included

14 videos2 assignments

Learn advanced analytics using window functions like ROW_NUMBER, RANK, and running totals. You will also explore CTEs for structured queries and database security using GRANT, REVOKE, and role-based access control.

What's included

16 videos3 assignments

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Nikhil Agarwal
LearnKartS
17 Courses1,783 learners

Offered by

LearnKartS

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions