-
Jira Query Language (JQL) Essentials & Core Syntax
5 Lessons -
Time-Based & Dynamic JQL Querying
5 Lessons-
StartTime-Based Queries with startOfDay() and endOfDay() Functions
-
StartDynamic Personal Filters with currentUser() and membersOf()
-
StartQuerying Sprints: openSprints, closedSprints, and futureSprints
-
StartQuerying Parent Issues and Hierarchy in Jira
-
StartQuerying by Component, Fix Version, and Affected Version
-
-
Advanced JQL Tracking, Sorting & Unlinked Issues
4 Lessons -
Custom Jira Dashboards, Gadgets & Reporting
6 Lessons-
StartSaving, Managing, and Sharing Jira Filters
-
StartCreating a New Blank Dashboard in Jira
-
StartAnalyzing Metrics with the Two-Dimensional Filter Statistics Gadget
-
StartVisualizing Data with Jira Pie Chart Gadgets
-
StartMonitoring Sprint Health & Agile Team Performance
-
StartSetting Up and Reading the Jira Sprint Burndown Gadget
-
-
Real-World Triage, Automation & Portfolio Dashboards
5 Lessons-
StartCreating an Overdue Work Filter for Teams in Jira
-
StartBuilding Automated Rules in Jira Using JQL
-
StartCombining JQL and Dashboards for Portfolio-Level Visibility
-
StartSharing Jira Dashboards with External Users & Key Limitations
-
StartStep-by-Step: Building a Daily Morning Triage Dashboard
-
-
Jira AI & Atlassian Rovo Features
9 Lessons-
PreviewIntroduction to Rovo and AI Features in Jira
-
StartGenerating Complex JQL Queries Using Plain English AI Prompts
-
StartExplaining Complex JQL Queries in Plain English via Rovo Chat
-
StartDebugging Broken JQL Queries with Rovo AI Error Fixer
-
StartGenerating AI Summaries for Long Ticket Threads
-
StartAutomating Backlog Breakdown: Story to Sub-tasks with AI
-
StartGenerating AI Acceptance Criteria & BDD Content in Seconds
-
StartLinking Jira Context to Confluence Knowledge Base using Rovo
-
StartAI-Powered Backlog Refinement Engine for Agile Teams
-
-
COURSE VIDEOS OF OLD JQL VERSION (ARCHIVED)
30 Lessons-
PreviewCourse Contents and JQL Basics
-
StartQuick Search in Jira
-
StartSmart Querying in Jira
-
StartSmart Query by Project, Overdue and Reporter
-
StartSmart Querying by Priority, Resolution and Issue Type
-
StartSmart Query by Component
-
StartSmart Query with Version and Fix Version
-
StartSmart Query Based on Created, Updated and Due
-
StartJQL Query Basics
-
StartJQL Fields, Operators and Keywords
-
StartUnderstanding JQL Operators
-
StartJQL Operators - IN and NOT IN
-
StartJQL Operators - CONTAINS and NOT CONTAINS
-
StartJQL Operators - IS | IS NOT | WAS | WAS NOT
-
StartJQL Operators - WAS IN | WAS NOT IN | CHANGED
-
StartUnderstand JQL Keywords with Examples
-
StartJQL Function - cascadeOption
-
StartJQL Functions - openSprints | closedSprints | futureSprints
-
StartJQL Function - componentsLeadByUser
-
StartJQL Functions - currentLogin | lastLogin | currentUser | issueHistory
-
StartJQL Functions - releasedVersions | unreleasedVersions | latestReleasedVersion | earliestUnreleasedVersion
-
StartJQL Functions - linkedIssue | linkedIssues
-
StartJQL Functions - standardIssueTypes | subtaskIssueType | parentEpic
-
StartJQL Functions - updatedBy | votedIssues | watchedIssues
-
StartJQL Functions - now | startofDay | endOfDay
-
StartJQL Functions - startOfWeek | endOfWeek
-
StartJQL Functions - startOfMonth | endOfMonth
-
StartJQL Functions - startOfYear | endOfYear
-
StartJQL Functions - projectsLeadByUser
-
StartJQL Functions - projectsWhereUserHasPermission | projectsWhereUserHasRole
-
About This Course
Jira is the backbone of how modern teams manage work. But most people only scratch the surface of what it can do. They filter by status, maybe by assignee, and call it done. JQL, Jira Query Language, is where the real power is. With JQL you can ask Jira anything: which tickets changed priority in the last sprint, what has been sitting unresolved for more than two weeks, which work is overdue across every team right now. That is the difference between reacting to your board and actually understanding what is happening across your project.
This course starts from scratch and builds your JQL skills all the way to advanced. You will learn operators, text functions, date functions like startOfDay and endOfDay, and historical auditing keywords like WAS, CHANGED, DURING, and BEFORE. From there you move into dashboards, building Two Dimensional Stats reports, Pie Charts, Sprint Burndown gadgets, and morning triage boards that your whole team can use every day without needing to set up a single filter manually.
The second half of the course is where AI comes in. Atlassian Rovo AI lets you generate JQL queries from plain English, debug broken queries instantly, and even auto generate BDD acceptance criteria from your tickets. You will practice describing what you want in plain words and watching Rovo turn it into real JQL. Then you will verify it, refine it, and save it as a shared filter your team can reuse. This is how Jira should work in 2025 and beyond.
By the end you will not just know JQL syntax. You will have built dashboards that give your team instant visibility, created workflows that save hours every week, and learned how to use AI to make all of it even faster. Whether you are a QA engineer, a product manager, a scrum master, or an operations lead, this course gives you tools you will use on the very next day of work.
What You'll Learn
JQL from Scratch
Master operators like AND, OR, and NOT, text search functions, and date functions like startOfDay() and endOfDay() to write precise queries for any use case.
Historical Auditing Deep Dive
Use WAS, CHANGED, DURING, and BEFORE keywords to track how issues evolved over time and audit work history across your entire project.
Custom Reporting and Dashboards
Build Two Dimensional Stats reports, Pie Charts, and Sprint Burndown gadgets that give your team instant visibility without manual effort every morning.
Practical Team Workflows
Create morning triage boards, track overdue tasks, measure sprint velocity, and build shared filters your whole team can use every day.
Atlassian Rovo AI Integration
Generate JQL from plain English, debug broken queries instantly, and auto generate BDD acceptance criteria directly from your Jira tickets using Rovo AI.
Cross Functional Work Management
Apply JQL, filters, and AI summaries to business and marketing projects so every team in your organization can benefit from smarter Jira workflows.
Meet Your Instructor

Manish Verma
Founder & Senior QA Architect | Atlassian Jira Expert
20+ years of QA and project management experience, with deep expertise in Jira, JQL, and Atlassian tooling across global enterprise teams
Manish is the founder of RCV Academy and a recognized leader in software testing and QA education. With extensive experience delivering QA programs across IBM, Capgemini, and multiple enterprise environments, he brings practical testing knowledge grounded in real projects, not just textbook theory.
His teaching approach is practical and outcome focused. He simplifies complex topics like agentic AI, multi agent orchestration, and LLM based test automation into clear, actionable lessons that testers at every level can apply immediately. Over 225,000 students trust his content across multiple platforms, making him one of the most recognized QA and AI educators in the industry.
Choose Your Learning Plan
Start learning today with flexible pricing options designed for every budget and commitment level.
Monthly
Start with flexibility
$5.99/month
Cancel anytime. First payment is non refundable.
- 3.5+ hours of content
- Lifetime access
- All course materials
- Certificate included
- Cancel anytime
One Time
Best value for commitment
$29.99once
Own it forever with no recurring charges
- 3.5+ hours of content
- Lifetime access
- All course materials
- Certificate included
- 30 day guarantee
Most Popular
Lifetime
Ultimate value package
$99once
Access all courses + future releases
- All RCV Academy courses
- Lifetime updates
- All new courses included
- Priority support
- 30 day guarantee
What You Need
Course Requirements
- No prior coding or JQL knowledge required. The course starts from the very beginning.
- Basic Jira familiarity. You should know how to create and view issues in Jira Cloud.
- Standard Jira Cloud access. A free Jira Cloud account is enough to follow along.
- Interest in AI and workflow automation. Curiosity is your most important prerequisite.
Frequently Asked Questions
Do I need to know how to code to take this course? +
No coding knowledge is required at all. JQL is not a programming language. It is a structured query syntax you type directly in Jira. The course teaches everything from the very first operator. If you can use Jira to view and filter tickets, you are ready to start.
What version of Jira do I need? +
The course uses Jira Cloud, which is the standard version most teams use today. A free Jira Cloud account is enough to follow along with every lesson. If your team uses Jira Data Center, the JQL syntax is almost identical and the concepts transfer directly.
Do I need a paid Atlassian Rovo subscription? +
Atlassian Rovo AI is available as part of Atlassian's premium and enterprise Jira Cloud plans. If your organization already has access, you can follow the Rovo AI sections hands on. If not, the video walkthroughs show exactly how it works so you can learn the concepts and advocate for access at your company.
What is the difference between the three pricing options? +
Monthly at $5.99 per month lets you start with flexibility but costs $71.88 yearly if you keep it. One time at $29.99 lets you own this course forever with no further charges. Lifetime membership at $99 gives you access to all RCV Academy courses, all future updates, and every new course released. All plans include a 30 day guarantee.
What if I am not satisfied? +
We offer a 30 day money back guarantee with no questions asked. If you enroll and decide the course is not right for you within 30 days, we will refund your full payment. We are confident you will love it, but we want you to feel secure before you commit.
How many hours of content are there and how long will it take to finish? +
The course contains 3.5 hours of focused, practical video content. Most students complete it over a weekend or across a few evenings. You can watch at your own pace and revisit any section whenever you need to review a topic. Access never expires.
Who This Course Is For
Scrum Masters, Agile Coaches and Release Managers
Who need better visibility into sprint progress, overdue items, and team velocity without manually compiling data from multiple filters every morning.
Product Owners, Project Managers and Business Analysts
Who want to query Jira in plain English using Rovo AI, build reporting dashboards, and track delivery commitments without relying on a developer every time.
QA Engineers and Developers
Who use Jira every day and want to build smarter filters, automate bug triage views, and generate BDD acceptance criteria from tickets using Rovo AI.
Jira Admins and Tech Leads
Who support multiple teams and want to set up shared filters, dashboards, and JQL templates that everyone in the organization can use and reuse.
Operations Managers and Business Professionals
Who are using Jira for cross functional work beyond software delivery and want to apply JQL and AI summaries to business, marketing, and operations projects.
30 Day Money Back Guarantee
Your satisfaction is guaranteed. Enroll risk free. If the course is not what you expected within 30 days, get a full refund with no questions asked. We are this confident you will love it.
