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:


  • lecturesCourse lectures
  • QuizChapter-wise Quiz
  • AssignmentsCourse Assignments
  • ProjectCourse Project
  • libraryReference 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

Introduction to Data types
Database and Constraints
Introduction to SQL and Command

Course Syllabus

Introduction
1 Introduction to Data types
2 Database and constraints
3 Introduction to SQL and Command types
4 Quiz
Data Definition Language
1 Data Definition Language
2 Quiz
Data Manipulation Language
1 INSERT Command
2 UPDATE and DELETE Commands
3 Quiz
Data Query Language (SELECT)
1 Basics of SELECT Command
2 Class Exercises
3 Quiz
JOINS in SQL
1 Concept of JOINS
2 Examples on JOINS
3 Class Exercises
4 Quiz
Scalar Functions
1 Scalar Functions
2 Quiz
Aggregate Functions
1 Aggregate Functions
2 Quiz
Course Completion Test
1 Take the test

Meet Our Course Expert

Abhishek Srivastava 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 ...Read More , NTPC & many other International customer.
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 Read Less


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

To get Group Discount Click Here

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

To get Group Discount Click Here

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

₹ 5,492

₹ 11.940

(54% 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

To get Group Discount Click Here


Have questions? Call the learning advisor or join the Whatsapp community for career Q&A, expert guidance and more

Corporate and Group Training

Let us know about your company training requirements, we can also customize the program to suit your needs.

Special discounts available for a group of 3 or more.

Corporate Training Enquiry



Course Completion Certification

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

SQL-Training-Certificate




Related Courses

Banking-Domain

BA Training with Banking Domain

Investment-Banking-Domain

BA Training with Investment Banking Domain

US-Healthcare-Domain

BA Training with US HealthCare Domain

Banking-Domain

BA Training with Banking Domain

Investment-Banking-Domain

BA Training - Investment Banking Domain

US-Healthcare-Domain

BA Training with US HealthCare Domain

whatsapp

Copyright © Techcanvass | All Rights Reserved