SQL Tutorial for Beginners PDF

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?

Want alternative payment options? Contact us here

• Next