Learn SQL in 24 Hours

Alex Nordeen

Bisher keine Bewertungen
0.0

+ Merken

Entdecke diesen und 400.000 weitere Titel mit der Flatrate von Skoobe. Ab 12,99 € im Monat.

Beschreibung zu „Learn SQL in 24 Hours“

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.


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


Verlag:

PublishDrive

Veröffentlicht:

2021

Druckseiten:

ca. 87

Sprache:

English

Medientyp:

eBook


Ähnliche Titel wie „Learn SQL in 24 Hours“

Lesen. Hören. Bücher erleben.

Jetzt kostenlos testen