Learn SQL in 24 Hours
Entdecke diesen und 400.000 weitere Titel mit der Flatrate von Skoobe. Ab 12,99 € im Monat.
Beschreibung zu „Learn SQL in 24 Hours“
This book is designed for beginners with little or no prior database experience.
Table Of Content
Here is what you will learn:
Chapter 1: Introduction to Database and MySQL
What is Data?
What is a database?
What is a Database Management System?
Types of DBMS
What is SQL?
What is NoSQL?
Chapter 2: Install MySQL workbench
What is MySQL?
Why use MySQL?
Introducing MySQL Workbench
MySQL workbench- Modeling and Design tool
MySQL workbench - SQL development tool
Install MySQL workbench Guide
Chapter 3: Introduction To Database Design
Why Database Design is Important?
Database development life cycle
Requirements analysis
Database designing
Implementation
Types of Database Techniques
Chapter 4: Database Normalization
What is Normalization?
1NF Rules
What is Composite Key
2NF Rules
3NF Rules
Boyce-Codd Normal Form (BCNF)
Chapter 5: ER Modeling
What is ER Modeling?
Enhanced Entity Relationship (EER) Model
Why use ER Model?
Entities in the "MyFlix" library
Defining the relationships among entities
Chapter 6: How To Create A Database
Create Database
Creating Tables MySQL
Data types
MySQL workbench ER diagram forward Engineering
Chapter 7: How to use SELECT in MySQL
Chapter 8: Where clause in MySQL
Chapter 9: How to use INSERT Into in MySQL
Chapter 10: How to Delete & Update data in MySQL
Chapter 11: ORDER BY, DESC and ASC
Chapter 12: Group By
Chapter 13: Wildcards
Chapter 14: Regular Expressions
Chapter 15: MySQL PHP
Chapter 16: Aggregate Function in MySQL
Chapter 17: Null value & Keyword in MySQL
Chapter 18: Auto Increment
Chapter 19: Alter, Drop & Rename
Chapter 20: Limit keyword
Chapter 21: Sub-Queries
Chapter 22: Joins
Chapter 23: Unions
Chapter 24: Views
Chapter 25: Index in MySQL