About us Contact post comment TEB Computer Kids Academy
TEB Computer Academy
-
more SQL Tutorial
- Basic Skills
- SAP Courses
- IT Consultant
- IT Security
- Programming
- IT FORENSIC
- An Administrator
- Informatiker
- Software Engineering
- DataBase
- Office Managment
- Our tutorial is structured as follows:
MySQL install and start
In the first part, you will learn how to install and start a MySQL server. The basic concepts are also explained.
phpMyAdmin
To manage the database, you should use the phpMyAdmin software. This tutorial will introduce you to the basics.
Establish a database connection
This tutorial explains how to connect to the MySQL database using PHP and PDO.
Simple data query via SELECT
This article describes the SQL SELECT command to query data from a table.
More complex data query via SELECT
Other ways to get SELECT specific records from a table. The article shows the use of WHERE, ORDER BY, and LIMIT.
Prepared Statements
Using prepared statements, you can embed parameters in SQL queries. This provides protection against SQL injections.
Insert data using INSERT
This tutorial deals with different ways to add new records to a table.
Update data by UPDATE
This article introduces the UPDATE command to update records.
Delete data using DELETE
This article introduces the DELETE command to delete records.
Entries found count with COUNT
This article introduces the SQL command COUNT and how to determine the number of records found.
DATE database columns
This article provides tips on how the time and date can be stored efficiently
in the database and which of the possible variants is best.
Date and time functions in MySQL
MySQL offers many functions to work with date and time fields.
MySQL error messages
Does the SQL query not do what it is supposed to do and return an error message?
Here are a few tips to understand the error messages.
Close database connection
The article explains how to close the connection to the database.
MySQL LEFT Join
Using JOIN, you can query two or more tables in SQL and merge their results.
MySQL Optimization: Use the index
Using INDEX, UNIQUE and PRIMARY KEY, you can define indexes in MySQL. These speed up the search for data.
MySQL normal forms
The 3 normal forms help you get a better design of your database.
MySQL foreign key Using foreign keys, you can ensure relationships between two tables in MySQL.
If values ??in the one table are changed or entries are deleted, this is transferred directly to the second table.
Overview of SQL commands
Compact overview of all major SQL commands.
Crash Course MySQL
Crash course to the outdated MySQL interface.
Crash Course MySQLi
Crash rate to the MsSQLi interface.
Crash Course PDO
Crash course to the PHP Data Objects (PDO).