• Learn SQL Basics to Advance by Shilpa Jain
5% Off

Learn SQL Basics to Advance by Shilpa Jain

By Shilpa Jain more
747 Views
Offer Price : ₹12,350.00
Course Fees : ₹13,000.00
You will save : ₹650.00 after 5% Discount

Select your batch timings:

Product Specifications

Publisher Live Tutor All Technology books by Live Tutor
Author: Shilpa Jain
Subject SQL
Available
Available in all digital devices

Tutor Brief :- 

Shilpa Jain has 10+ year of experience in imparting Training to variety of audience and for 5+ Years delivering in various domain to corporate.

Trained more than 3,000 professional & Trainees on various technologies with flair of handling queries/escalations from trainees.

Working as Freelance Corporate Trainer – nearly 5 Years now Working as Freelance Data analyst– nearly 2 Years now Professional Experience

 

CERTIFICATION

  • MICROSOFT OFFICE SPECIALISTS (2013, 2016)
  • GOOGLE SHEETS SPECIALISTS
  • CIA COURSE CERTIFICATION FROM INSTITUTE OF COMPUTER ACCOUNTANT
  •  B.COM – VIVEKANANDA COLLEGE (DELHI UNIVERSITY)

 

Topics to be Covered

1. SQL ─ Overview

2. SQL ─ RDBMS Concepts

3. SQL ─ RDBMS Databases

4. SQL – Syntax

5. SQL ─ Data Types

6. SQL – Operators

7. SQL – Expressions

8. SQL – CREATE Database

9. SQL ─ DROP or DELETE Database

10. SQL ─ SELECT Database, USE Statement

11. SQL ─ CREATE Table 1

2. SQL ─ DROP or DELETE Table

13. SQL ─ INSERT Query

14. SQL ─ SELECT Query

15. SQL ─ WHERE Clause

16. SQL ─ AND & OR Conjunctive Operators

17. SQL ─ UPDATE Query

18. SQL ─ DELETE Query

19. SQL ─ LIKE Clause

20. SQL ─ TOP, LIMIT or ROWNUM Clause

21. SQL ─ ORDER BY Clause

22. SQL ─ Group By

23. SQL ─ Distinct Keyword

24. SQL ─ SORTING Results

25. SQL ─ Constraints

26. SQL ─ Using Joins

27. SQL ─ UNIONS CLAUSE

28. SQL ─ NULL Values

29. SQL ─ Alias Syntax

30. SQL – Indexes

31. SQL ─ ALTER TABLE Command

33. SQL ─ Using Views

 

Total No. of Classes - 20
 
Available Days - Monday, Wednesday & Friday