logiicon

Basics of SQL


  • How to write SQL queries with SELECT
  • How to use outer and inner joins to generate ad-hoc reports
  • How to use pattern-based and other searches in your queries
  • How to use functions to enhance your query

Course Comprises the following:


  • logoCourse lectures
  • logoChapter-wise Quiz
  • logoCourse Assignments
  • logoCourse Project
  • logoReference library

Course Takeaway

logo Get in-depth knowledge of SQL fundamentals
logo Get hands-on and practical knowledge of Joins and search
logo Get enabled in creating ad-hoc reports for customers on-demand


Who can take up the Course?


logo It is an ideal course for business analysts at any stage of their career to understand the SQL basics
logo It can also be taken up by any professional who would like to get started with SQL

Course Preview

Course Syllabus

Introduction to Jira
1 What is Jira
2 Usage of Jira
3 Key Concepts in Jira
4 Chapter Quiz
Creating Jira board
1 Creating Scrum board
2 Creating Kanban board
3 Difference between Kanban and Scrum
4 Chapter Quiz
Creating and managing issues, user stories, Epics etc
1 What are issues in JIra
2 Types of Issues
3 How to create an Epic
4 Use of Clone and Link
5 Workflows for managing Issues
6 Managing Issues on Kanban and Scrum Boards
7 Chapter Quiz
Filter and Search options in Jira
1 Using Quick Filters
2 Conducting Quick Search
3 Creating your own filters
4 Chapter Quiz
Generating reports in Jira
1 Generating pre-built reports in Jira
2 Getting insights from the reports
Project Roadmaps
1 What are Roadmaps
2 How to create Roadmaps in Jira
3 Creating a roadmap in Jira (Hands-on Demo)
Managing Jira Board Settings
1 Detailed walkthrough of Jira Interface
2 General Jira Board Settings
3 Settings in Kanban Board
A Case Study
1 Understanding the requirements
2 Writing User Stories
3 Raise Jira issues/stories
4 Monitoring the Progress


Meet Our Course Expert

Abhishek-Srivastava

Abhishek Srivastava

Senior IT Professional , CBAP Certified

Abhishek Srivastava is a seasoned IT professional with diverse experience in Banking, Insurance, Utility, and Education domains. Managing large accounts, Program Management & Business Analysis has been his forte, having done so for customers like ICICI Bank, NTPC & many Read Moreother International customers. In the past, he has been associated with companies like Mastek and 3i Infotech Ltd (erstwhile ICICI Infotech Ltd). An NIT (Erstwhile REC) / IIM Kozhikode graduate, now an entrepreneur, he is pursuing his dream of creating an organization for providing quality training in the fields of Project Management and Business Analysis. His other areas of interest are Business Analysis consulting and mentorship. Over the years, he has mentored and guided more than 1000 professionals


Course Fees

(Please Select Currency)

  
SQL Training for Business Analysts


₹ 2,958

₹ 3,480

(15% OFF)

[GST Extra]

Expires in 01 D 11 H 09 M 25 S



  • Practical course
  • With exercises and class examples
  • All types of joins
  • Aggregate & other functions
  • Course proficiency certificate

MS Visio Training with UML Diagrams + SQL Course for Business Analysts

₹ 4,800

₹ 6,000

(20% OFF)

[GST Extra]

Expires in 01 D 11 H 09 M 25 S



  • With a case study
  • Use cases, Activity diagrams, and class diagrams
  • SQL Fundamentals covered with examples and exercises
  • Hands-on take on MS Visio tool to create UML diagrams
  • Course proficiency certificate

JIRA + UML Modeling + MS-Visio + SQL for Business Analysts Course Combo Offer

₹ 5,625

₹ 7,500

(25% OFF)

[GST Extra]

Expires in 01 D 11 H 09 M 25 S



  • End-to-end requirements elicitation process
  • Use cases, scenarios & Activity diagrams
  • SQL hands-on Course
  • MS-Visio Tools training with case




Course Completion Certification

Every course participant will receive a course completion certification from Techcanvass as shown.

Certificate



Explore Courses

ECBA-certification

IIBA ECBA Certification Course

BA-banking

BA Training with Banking Domain

BA-Investment

BA Training with Investment Banking Domain

BA-healthcare

BA Training with US HealthCare Domain

Copyright © Techcanvass | All Rights Reserved