Haku
Kirjaudu sisään
  • Kotisivu

  • Kategoriat

  • Äänikirjat

  • E-kirjat

  • Lapsille

  • Top listat

  • Ohje

  • Lataa sovellus

  • Käytä kampanjakoodia

  • Lunasta lahjakortti

  • Kokeile nyt ilmaiseksi
  • Kirjaudu sisään
  • Kieli

    🇫🇮 Suomi

    • FI
    • EN

    🇧🇪 Belgique

    • FR
    • EN

    🇩🇰 Danmark

    • DK
    • EN

    🇩🇪 Deutschland

    • DE
    • EN

    🇪🇸 España

    • ES
    • EN

    🇫🇷 France

    • FR
    • EN

    🇳🇱 Nederland

    • NL
    • EN

    🇳🇴 Norge

    • NO
    • EN

    🇦🇹 Österreich

    • AT
    • EN

    🇨🇭 Schweiz

    • DE
    • EN

    🇸🇪 Sverige

    • SE
    • EN
  1. Kirjat
  2. Tieto
  3. Tietokoneet ja IT

Lue ja kuuntele ilmaiseksi 42 päivää!

Peruuta milloin vain

Kokeile nyt ilmaiseksi
0.0(0)

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


Kirjailija:

  • Alex Nordeen

Muoto:

  • E-kirja

Kesto:

  • 137 sivut

Kieli:

englanti

Kategoriat:

  • Tieto
  • Tietokoneet ja IT

Lisää kirjoittajalta Alex Nordeen

Ohita lista
  1. Learn Design and Analysis of Algorithms in 24 Hours

    Alex Nordeen

    book
  2. Python: Learn Python in 24 Hours

    Alex Nordeen

    book
  3. Learn VBScript in 24 Hours

    Alex Nordeen

    book
  4. Linux: Learn in 24 Hours

    Alex Nordeen

    book
  5. C++ Learn in 24 Hours

    Alex Nordeen

    book
  6. Learn Operating System in 24 Hours

    Alex Nordeen

    book
  7. Learn DBMS in 24 Hours

    Alex Nordeen

    book
  8. Hacking : Guide to Computer Hacking and Penetration Testing

    Alex Nordeen

    book
  9. C# for Beginners: Learn in 24 Hours

    Alex Nordeen

    book
  10. Learn Excel in 24 Hours

    Alex Nordeen

    book
  11. Learn SAP BI in 24 Hours

    Alex Nordeen

    book
  12. Learn Data Warehousing in 24 Hours

    Alex Nordeen

    book

Muut ovat myös lukeneet

Ohita lista
  1. The Fix

    Michelle P. King

    book
  2. Fast Cycle Time: How to Align Purpose, Strategy, and Structure for

    Christopher Meyer

    book
  3. My Beautiful Despair : The Philosophy of Kim Kierkegaardashian

    Kim Kierkegaardashian

    book
  4. Etiquette

    Emily Post

    book
  5. The Incontrovertible Code of (Formerly) Unwritten Rules: From Airline- Armrest Etiquette to Flushing Twice, 251 Universal Laws of Common Civility that We Wish Everything Knew

    Quentin Parker

    book
  6. Information Security Handbook

    Darren Death

    book
  7. What to Do with The Rest of Your Life: America's Top Career Coach Shows You How to Find or Create the Job You'll LOVE

    Robin Ryan

    book
  8. The Sleeping Beauty : Suite from the Ballet

    Pyotr Ilyich Tchaikovsky

    book
  9. Samuel R. Wells's How to Behave: The Classic Pocket Manual of Good Manners and Model Behavior

    Samuel R Wells

    book
  10. The Art of Manliness: Classic Skills and Manners for the Modern Man

    Brett McKay, Kate McKay

    book
  11. THE THEORY OF BUSINESS ENTERPRISE (Nature, Causes, Utility & Drift of Business Enterprise) : A Political Economy Book

    Thorstein Veblen

    book
  12. A Woman Looking at Men Looking at Women : Essays on Art, Sex, and the Mind

    Siri Hustvedt

    book

Ohjeet ja yhteystiedot


Tietoa meistä

  • Tarinamme
  • Ura
  • Media
  • Saavutettavuus
  • Ryhdy kumppaniksemme
  • Sijoittajasuhteet
  • Instagram
  • Facebook

Tutki

  • Kategoriat
  • Äänikirjat
  • E-kirjat
  • Aikakauslehdet
  • Lapsille
  • Top listat

Suositut kategoriat

  • Dekkarit
  • Elämäkerrat ja reportaasit
  • Romaanit
  • Rakkaus ja feelgood
  • Hyvinvointi
  • Lastenkirjat
  • Tositarinat
  • Uni ja rentoutuminen

Nextory

Tekijänoikeus © 2025 Nextory AB

Yksityisyyden suoja · Ehdot ·
Erinomainen4.3 / 5