Databases can be found in almost all software applications. SQL is the standard language to query a database. This eBook will teach you database design. Also, it teaches you basic to advanced SQL.

Key Highlights of SQL Tutorial PDF are

  • 220+ pages
  • eBook Designed for beginners
  • Beautifully annotated with screenshot
  • You will get lifetime access

Inside this PDF

  1. What is Database? What is SQL?
  2. MySQL Workbench Tutorial & MySQL Introduction
  3. Database Design Tutorial: Learn Data Modeling
  4. What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples
  5. What is ER Modeling? Learn with Example
  6. MySQL Create Database, Tables, Data Types
  7. MySQL SELECT Statement with Examples
  8. MySQL WHERE Clause with Examples - AND, OR, IN, NOT IN
  9. MySQL query INSERT INTO Table with Examples
  10. MySQL UPDATE & DELETE Query with Example
  11. ORDER BY in MySQL: DESC & ASC
  12. MySQL GROUP BY and HAVING Clause with Examples
  13. MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ )
  14. MYSQL Regular Expressions (REGEXP) with Syntax & Examples
  15. MySQL Functions: String, Numeric, User-Defined, Stored
  16. MySQL Aggregate Functions Tutorial : SUM, AVG, MAX, MIN , COUNT, DISTINCT
  17. MySQL IS NULL & IS NOT NULL Tutorial with EXAMPLES
  18. MySQL AUTO_INCREMENT with Examples
  19. MYSQL - ALTER, DROP, RENAME, MODIFY
  20. MySQL LIMIT & OFFSET with Examples
  21. MySQL SubQuery Tutorial with Examples
  22. MySQL UNION - Complete Tutorial
  23. MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS
  24. Views in MySQL Tutorial: Create, Join & Drop with Examples
  25. MySQL Index Tutorial - Create, Add & Drop
  26. Your First Application using MySQL and PHP
  27. Oracle MySQL 5.6 Certification with Study Guide
  28. SQL vs MySQL: What's the Difference?

Top Programming Books  

Want alternative payment options? Contact us here

 

Guru99 is Sponsored by AQUAFOLD
Aquafold

Aqua Data Studio is proud to sponsor Guru99's informative website for database professionals. Take your productivity to new heights with query tools, visual analytics, and ER diagramming for multiple platforms.