SQL with Guru99 by Krishna Rungta
SQL with Guru99
by Krishna Rungta
Publisher: guru99 2013
Number of pages: 89
Description:
SQL stands for Structured Query Language. It is the communication languages to talk to any database! This book is designed for beginners with little or no Database experience. Apart from teaching the SQL syntax, this book also talks about Database design process and techniques.
Download or read it online here:
Read online
(online html)
SQL Tutorial for Beginners Learn in 7 Days
Training Summary
Databases can be found in almost all software applications. SQL is the standard language to query a database. This course will teach you database design. Also, it teaches you basic to advanced SQL.
What should I know?
The course is designed for SQL beginners. No prior DB experience is required.
Training Syllabus
Database Fundamentals
| Tutorial | What is a database? What is MySQL? |
| Tutorial | Introduction to MySQL & MySQL workbench |
Database Design
| Tutorial | Introduction To Database Design |
| Tutorial | Learn Database Normalization with the help of a case study |
| Tutorial | Learn ER Modeling with a Case Study |
SQL Basics
| Tutorial | How To Create A Database & MySQL DataTypes |
| Tutorial | How to use SELECT in MySQL |
| Tutorial | How to query data using Where clause in MySQL |
| Tutorial | How to use Insert Into in MySQL |
| Tutorial | How to Delete & Update data in MySQL |
Data Sorting
| Tutorial | How sorting is done in MySQL using ORDER BY, DESC and ASC |
| Tutorial | How to use Group By in MySQL |
| Tutorial | How to use Wildcards in MySQL |
| Tutorial | Using Regular Expressions & Wild Cards in MySQL |
Functions
| Tutorial | Ultimate guide to Functions used in PHP |
| Tutorial | How to use Aggregate Function in MySQL |
Must Know Stuff!
| Tutorial | All about Null value & Keyword in MySQL |
| Tutorial | How to use Auto Increment in MySQL |
| Tutorial | How to use Alter, Drop & Rename function in MySQL |
| Tutorial | How to use Limit keyword in MySQL |
Most Dreaded Topics!
| Tutorial | Using Sub-Queries in MySQL |
| Tutorial | How to use Joins in MySQL |
| Tutorial | How to use Unions in MySQL |
| Tutorial | How to use Views in MySQL |
| Tutorial | How to use Index in MySQL |
What Next!
| Tutorial | Creating an Application using MySQL |