Home About Courses Admission Tutorials Contact
MySQL Tutorial
Welcome to the MySQL Tutorial website! You will learn MySQL fast, easy and fun. This website provides you with a complete MySQL tutorial presented in an easy-to-follow manner. Each tutorial has practical examples with SQL script and screenshots available.MySQL Tutorial for Developers
Are you a web developer looking for learning MySQL fast?
In this section, you will be getting started with MySQL right away. You will learn how to use MySQL effectively to get your work done more productively.
If you go through the entire tutorials, you will know how to manage MySQL databases and manipulate data using various techniques such as SQL queries, MySQL stored procedures, database views, triggers.
Getting Started with MySQL
This section helps you get started with the MySQL quickly if you have never worked with MySQL before.
Basic MySQL Tutorial
This section helps you get familiar with basic MySQL including managing MySQL database and manipulating data using various SQL statements such as INSERT, DELETE, UPDATE and SELECT. You will also learn about advanced data selection techniques including INNER JOIN, LEFT JOIN, Subquery, and UNION.
MySQL Stored Procedures
In this section, you will learn how to create stored procedures and stored functions in MySQL with clear explanation and practical examples.
MySQL Triggers
MySQL triggers are stored programs executed automatically to respond to specific events associated with a table such as an insert, update or delete. This section shows you how to work with MySQL triggers effectively.
MySQL Views
This tutorial introduces you to MySQL Views, which are named query stored in the database, and shows you step by step on how to manage views effectively.
MySQL Full-Text Search
In this section, we show you how to use MySQL full-text search with various full-text searching techniques such as natural language search, Boolean language search and query expansion.
MySQL Tips
We provide you with the advanced MySQL techniques and tips to help you solve the most difficult challenges in MySQL effectively.
MySQL Functions
MySQL Aggregate Functions
Aggregate functions allow you to perform a calculation on a set of records and return a single value. In this tutorial, you will learn various MySQL aggregate functions including SUM, AVG, MAX, MIN and COUNT functions.
MySQL Comparison Functions
In this section, you will learn about the comparison functions in MySQL including COALESCE, GREATEST, LEAST, and ISNULL.
MySQL Control Flow Functions and Expressions
The control flow functions allow you to add if-then-else logic to SQL queries without using the procedural code.
MySQL Date Functions
This page shows you the most commonly used MySQL Date Functions that allow you to manipulate date and time data effectively.
MySQL String Functions
This page shows you the most commonly used MySQL string functions that allow you to manipulate character string data effectively.
MySQL Window Functions
This tutorial introduces you to MySQL windows functions and provides you with some practical and motivational examples of the windows functions in MySQL.
MySQL Programming Interfaces
In this section, we will show you how to write MySQL-based applications for accessing MySQL databases.
PHP MySQL Tutorial
You will learn how to interact with MySQL using PHP Data Objects or PDO, which provides a lightweight and consistent interface for accessing MySQL Database.
MySQL Node.js
In this section, you will learn how to interact with MySQL from node.js applications using the mysql module.
MySQL JDBC Tutorial
Java JDBC API provides a standard interface to interact with any relational databases. In this MySQL JDBC tutorial section, we will show you how to use JDBC to interact with MySQL databases.
Python MySQL Tutorial
This Python MySQL tutorial section shows you how to use MySQL connector/Python to access MySQL databases.
Perl MySQL Tutorial
This Perl MySQL section shows you how to interact with MySQL by using Perl DBI API for connecting to and disconnecting from MySQL databases, creating tables, handling data, and managing transactions.
MySQL Tutorial for Database Administrators
This step-by-step tutorial gives you in-depth background information on MySQL administration.
We cover everything from basic to advanced MySQL administration and configuration. All MySQL administration tutorials presented in this section are practical and widely used in enterprise environments.
MySQL Administration
In this section, you will find a lot of useful MySQL administration tutorials including MySQL server start-up and shutdown, MySQL server security, MySQL database maintenance, backup and restore.
MySQL Tutorial in English
MySQL Tutorial Advanced
MySQL Tutorial in Hindi
No comments:
Post a Comment