35 SQL and MySQL Tutorials
The Structured Query Language is used in manipulating data stored in
Relational Database Management Systems (RDBMS). SQL provides commands
through which data can be extracted, sorted, updated, deleted and
inserted. SQL
can be used with any RDBMS such as MySQL, PostgresSQL, Oracle,
Microsoft SQL Server, Access, Sybase, Ingres etc.
Webdevelopersnotes.com offers the following 35 SQL Tutorials using a MySQL database. SQL commands specific to MySQL are left out, however.
Related Posts:
MySQL Documentation and Reference Manuals 61 PHP Tutorials from phpro.org JDBC Slides, Labs, Code, and Tutorials 222 Open Source Online Books and Tutorials 21 PHP and Web Development Tutorials
Webdevelopersnotes.com offers the following 35 SQL Tutorials using a MySQL database. SQL commands specific to MySQL are left out, however.
35 SQL and MySQL Tutorials
Here are the SQL tutorial lessons:- SQL tutorial - Introduction
- Downloading MySQL
- Installing MySQL on Windows
- Installing MySQL on Linux
- MySQL database introduction
- Creating a database
- Creating MySQL tables
- MySQL lesson - MySQL tables
- Inserting data in MySQL tables
- Querying MySQL tables
- Selecting data using conditions
- Pattern Matching with text data
- SQL Logical Operators
- MySQL IN and BETWEEN
- Ordering data in MySQL
- Limiting data retrieval in MySQL
- MySQL DISTINCT keyword
- Finding the minimum and maximum values
- Finding the average and sum
- Naming Columns in MySQL
- Counting
- HAVING clause
- Detils of MySQL SELECT statement
- MySQL mathematical Functions
- Updating records in MySQL
- MySQL Date column type part 1
- MySQL Date column type part 2
- The Null column type
- MySQL table joins
- Deleting entries from tables
- Dropping (deleting) SQL tables
- MySQL Column Types
- MySQL Column Types part 2
- MySQL tutorial - What Next?
- MySQL guide - Last Words
Popularity: 4% [?]
Related Posts: