Lyt når som helst, hvor som helst

Nyd den ubegrænsede adgang til tusindvis af spændende e- og lydbøger - helt gratis

  • Lyt og læs så meget du har lyst til
  • Opdag et kæmpe bibliotek fyldt med fortællinger
  • Eksklusive titler + Mofibo Originals
  • Opsig når som helst
Start tilbuddet
DK - Details page - Device banner - 894x1036

Learn SQL in 24 Hours

1 Anmeldelser

3

Sprog
Engelsk
Format
Kategori

Fakta

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

© 2021 PublishDrive (E-bog): 6610000317578

Release date

E-bog: 12. november 2021

Andre kan også lide...

Vælg dit abonnement

  • Over 600.000 titler

  • Download og nyd titler offline

  • Eksklusive titler + Mofibo Originals

  • Børnevenligt miljø (Kids Mode)

  • Det er nemt at opsige når som helst

Flex

For dig som vil prøve Mofibo.

89 kr. /måned
  • 1 konto

  • 20 timer/måned

  • Gem op til 100 ubrugte timer

  • Eksklusivt indhold hver uge

  • Fri lytning til podcasts

  • Ingen binding

Prøv gratis
Den mest populære

Premium

For dig som lytter og læser ofte.

129 kr. /måned
  • 1 konto

  • 100 timer/måned

  • Eksklusivt indhold hver uge

  • Fri lytning til podcasts

  • Ingen binding

Start tilbuddet

Unlimited

For dig som lytter og læser ubegrænset.

149 kr. /måned
  • 1 konto

  • Ubegrænset adgang

  • Eksklusivt indhold hver uge

  • Fri lytning til podcasts

  • Ingen binding

Start tilbuddet

Family

For dig som ønsker at dele historier med familien.

Fra 179 kr. /måned
  • 2-6 konti

  • 100 timer/måned pr. konto

  • Fri lytning til podcasts

  • Kun 39 kr. pr. ekstra konto

  • Ingen binding

2 konti

179 kr. /måned
Prøv gratis