Learn SQL Basics to Advance by Shilpa Jain

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