| | |
Introduction to SQL
What is SQL and database management
Standard SQL functions ( commands )
| Functions | Description |
|---|
| AVG | Average value of a column and other math functions |
| Alter | Changing the table Structure |
| Between | Records between two ranges |
| Count | Number of records in a table with different combinations |
| Copy Table | Copy data from one table to another table |
| Create Table | Create table by using SQL |
| Delete | Delete records from table |
| Drop | Deleting table or table column |
| Distinct | Unique records of a table |
| Group by | Grouping data of a column of MySQL table |
| Having | Matching data by Having command with group by |
| Insert | Adding records to a table |
| Insert Set | Adding record with matching column and value |
| Inner Join | Joining table to itself |
| IN | Matching record with set of data |
| Left join | Joining two tables and getting matching records with unique combination |
| Limit | Getting limited records with starting and ending limit |
| Like | Matching record with wildcard and formatting |
| Locate | Matching record and getting position of the search string |
| MAX | Highest number of a column ( math functions: min, sum, average etc ) |
| NULL value | Missing or unknown data |
| Order By | displaying A to Z or Maximum to Minimum data |
| OR AND | Logical operators to use in a query |
| Rand | Random records from a table |
| Replace | Updating part of data |
| Rename Table | Rename table by query |
| Select Query | Select record from a table |
| Subqueries | Query inside a querry |
| Union | Joining tables and getting records |
| Update | Update record with new data |
| Where | Getting records with conditions |
MySQL Functions
| Functions | Description |
|---|
| Date & Time | Managing Date & time field of MySQL table by formatting outputs and applying calculations on year, month, day etc.
|
| Math Functions | Counting total, average, Sum of a range of records by using Math Functions |
Joining More than one table
| Functions | Description |
|---|
| left join | Managing Date & time field of MySQL table by formatting outputs and applying calculations on year, month, day etc.
|
| Linking Table | Displaying records connecting more than one table |
| Union | Join two tables and display unique records |
| Innter Join | Joining tables with itself and displaying records |
Collecting records from table
| Functions | Description |
|---|
| Record exists | Record is already available in a table ( checking userid ) |
| second highest | Getting the second highest number in a table column |
| sub groups | Grouping within a group by sub-groups |
| Changing order | Displaying highest or lowest or changing the display order |
| Sum storing | Inserting sum of a column in other table |
| Length of Data | Length of characters present in a field |
More on SQL and Database Management
| |
|
|
|
