Mondadori Store

Trova Mondadori Store

Benvenuto
Accedi o registrati

lista preferiti

Per utilizzare la funzione prodotti desiderati devi accedere o registrarti

Vai al carrello
 prodotti nel carrello

Totale  articoli

0,00 € IVA Inclusa

Learn SQL in 24 Hours

Alex Nordeen
pubblicato da Guru99

Prezzo online:
9,36

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 MySQL

  1. What is Data?
  2. What is a database?
  3. What is a Database Management System?
  4. Types of DBMS
  5. What is SQL?
  6. What is NoSQL?

Chapter 2: Install MySQL workbench

  1. What is MySQL?
  2. Why use MySQL?
  3. Introducing MySQL Workbench
  4. MySQL workbench- Modeling and Design tool
  5. MySQL workbench - SQL development tool
  6. Install MySQL workbench Guide

Chapter 3: Introduction To Database Design

  1. Why Database Design is Important?
  2. Database development life cycle
  3. Requirements analysis
  4. Database designing
  5. Implementation
  6. Types of Database Techniques

Chapter 4: Database Normalization

  1. What is Normalization?
  2. 1NF Rules
  3. What is Composite Key
  4. 2NF Rules
  5. 3NF Rules
  6. Boyce-Codd Normal Form (BCNF)

Chapter 5: ER Modeling

  1. What is ER Modeling?
  2. Enhanced Entity Relationship (EER) Model
  3. Why use ER Model?
  4. Entities in the "MyFlix" library
  5. Defining the relationships among entities

Chapter 6: How To Create A Database

  1. Create Database
  2. Creating Tables MySQL
  3. Data types
  4. 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

Dettagli down

Generi Informatica e Web » Linguaggi e Applicazioni » Database » Programmazione e sviluppo del software » Programmazione web

Editore Guru99

Formato Ebook (senza DRM)

Pubblicato 23/10/2020

Lingua Inglese

EAN-13 1230004303497

0 recensioni dei lettori  media voto 0  su  5

Scrivi una recensione per "Learn SQL in 24 Hours"

Learn SQL in 24 Hours
 

Accedi o Registrati  per aggiungere una recensione

usa questo box per dare una valutazione all'articolo: leggi le linee guida
torna su Torna in cima