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
- What is Database? What is SQL?
- MySQL Workbench Tutorial & MySQL Introduction
- Database Design Tutorial: Learn Data Modeling
- What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples
- What is ER Modeling? Learn with Example
- MySQL Create Database, Tables, Data Types
- MySQL SELECT Statement with Examples
- MySQL WHERE Clause with Examples - AND, OR, IN, NOT IN
- MySQL query INSERT INTO Table with Examples
- MySQL UPDATE & DELETE Query with Example
- ORDER BY in MySQL: DESC & ASC
- MySQL GROUP BY and HAVING Clause with Examples
- MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ )
- MYSQL Regular Expressions (REGEXP) with Syntax & Examples
- MySQL Functions: String, Numeric, User-Defined, Stored
- MySQL Aggregate Functions Tutorial : SUM, AVG, MAX, MIN , COUNT, DISTINCT
- MySQL IS NULL & IS NOT NULL Tutorial with EXAMPLES
- MySQL AUTO_INCREMENT with Examples
- MYSQL - ALTER, DROP, RENAME, MODIFY
- MySQL LIMIT & OFFSET with Examples
- MySQL SubQuery Tutorial with Examples
- MySQL UNION - Complete Tutorial
- MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS
- Views in MySQL Tutorial: Create, Join & Drop with Examples
- MySQL Index Tutorial - Create, Add & Drop
- Your First Application using MySQL and PHP
- Oracle MySQL 5.6 Certification with Study Guide
- SQL vs MySQL: What's the Difference?
Want alternative payment options? Contact us here
