SQL with Guru99 by Krishna Rungta

with Guru99 
by

Publisher: guru99 2013
Number of pages: 89

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

Home page url

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

for Beginners Learn in 7 Days

Training Summary


Databases can be found in almost all software applications. is the standard to query a database. This course will teach you design. Also, it teaches you basic to advanced SQL.

What should I know?


The course is designed for beginners. No prior DB experience is required. 

Training Syllabus

 


Fundamentals

 Tutorial What is a database? What is MySQL?
 Tutorial Introduction to MySQL & workbench

Design

 Tutorial Introduction To Design
 Tutorial Learn Normalization with the help of a study
 Tutorial Learn ER Modeling with a Study

Basics

 Tutorial How To Create A Database & DataTypes
 Tutorial How to use SELECT in
 Tutorial How to query data using Where clause in
 Tutorial How to use Insert Into in
 Tutorial How to Delete & Update data in

Data Sorting

 Tutorial How sorting is done in using ORDER BY, DESC and ASC
 Tutorial How to use Group By in
 Tutorial How to use Wildcards in
 Tutorial Using Regular Expressions & Wild Cards in
 

Functions

 Tutorial Ultimate to Functions used in
 Tutorial How to use Aggregate Function in

Must Know Stuff!

 Tutorial All about Null value & Keyword in
 Tutorial How to use Auto Increment in
 Tutorial How to use Alter, Drop & Rename function in
 Tutorial How to use Limit keyword in

Most Dreaded Topics!

 Tutorial Using Sub-Queries in
 Tutorial How to use Joins in
 Tutorial How to use Unions in
 Tutorial How to use in
 Tutorial How to use Index in

What Next!

 Tutorial Creating an Application using
You might also like
Leave A Reply