SQL with Guru99 by Krishna Rungta

with Guru99 

Publisher: guru99 2013
Number of pages: 89

SQL stands for . It is the languages to talk to any ! This book is designed for beginners with little or no Database experience. Apart from teaching the SQL , this book also talks about Database design process and techniques.

Home page url

Download or read it online here: 
Read online
(online html)

SQL for Beginners Learn in 7 Days

Training Summary

Databases can be found in almost all software . SQL is the standard 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 ?
 Tutorial Introduction to MySQL & MySQL workbench

Database Design

 Tutorial Introduction To Database Design
 Tutorial Learn Database Normalization with the help of a 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 & Wild Cards in MySQL


 Tutorial Ultimate to Functions used in
 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 in MySQL
 Tutorial How to use Index in MySQL

What Next!

 Tutorial Creating an Application using MySQL

You might also like