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 screenshots
  • 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

 

YOU MIGHT LIKE: