Databases can be found in almost all software applications. Infact it's hard to find a software that doesn’t use a database. SQL is the standard language to query a database. SQL stand for: Structured Query Language. SQL provides basic to advance commands to retrieve, update, delete, insert data into database.This book is designed for beginners with little or no prior database experience.Here is what you will learn:Chapter 1: Introduction to Database and MySQLWhat is Data?What is a database?What is a Database Management System?Types of DBMSWhat is SQL?What is NoSQL?Chapter 2: Install MySQL workbenchWhat is MySQL?Why use MySQL?Introducing MySQL WorkbenchMySQL workbench- Modeling and Design toolMySQL workbench - SQL development toolInstall MySQL workbench GuideChapter 3: Introduction To Database DesignWhy Database Design is Important?Database development life cycleRequirements analysisDatabase designingImplementationTypes of Database TechniquesChapter 4: Database NormalizationWhat is Normalization?1NF RulesWhat is Composite Key2NF Rules3NF RulesBoyce-Codd Normal Form (BCNF)Chapter 5: ER ModelingWhat is ER Modeling?Enhanced Entity Relationship (EER) ModelWhy use ER Model?Entities in the "MyFlix" libraryDefining the relationships among entitiesChapter 6: How To Create A DatabaseCreate DatabaseCreating Tables MySQLData typesMySQL workbench ER diagram forward EngineeringChapter 7: How to use SELECT in MySQLChapter 8: Where clause in MySQLChapter 9: How to use INSERT Into in MySQLChapter 10: How to Delete & Update data in MySQLChapter 11: ORDER BY, DESC and ASCChapter 12: Group ByChapter 13: WildcardsChapter 14: Regular ExpressionsChapter 15: MySQL PHPChapter 16: Aggregate Function in MySQLChapter 17: Null value & Keyword in MySQLChapter 18: Auto IncrementChapter 19: Alter, Drop & RenameChapter 20: Limit keywordChapter 21: Sub-QueriesChapter 22: JoinsChapter 23: UnionsChapter 24: ViewsChapter 25: Index in MySQL
Author: Krishna Rungta