Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

MySQL Tutorial

This MySQL Tutorial explains everything about MySQL Server which includes Database creation, modification, and delete database and tables. DML, DDL statements, Built-in functions etc.

  1. How to Download MySQL
  2. Install MySQL on Windows
  3. Create Database
  4. Drop Database
  5. Create Table
  6. Drop Table
  7. Select Statement
  8. Where Clause
  9. Alias Names
  10. Group By Clause
  11. Having Clause
  12. Order By Clause
  13. Limit
  14. Insert Statement
  15. Delete Command
  16. Select Distinct Statement
  17. Truncate Table

Operators

  1. Arithmetic Operators
  2. AND
  3. NOT
  4. OR
  5. XOR
  6. Between
  7. Not Between
  8. GREATEST
  9. LEAST
  10. LIKE
  11. NOT LIKE
  12. Coalesce
  13. IFNULL
  14. NULLIF
  15. Interval
  16. IN
  17. IS
  18. NOT IN
  19. IS NULL
  20. IS NOT NULL

Learn MySQL Joins

  1. Inner Join
  2. Left Join
  3. Right Join
  4. Cross Join

Aggregate Functions

This MySQL tutorial section covers the list of available aggregate functions with practical examples

  • Introduction
  • AVG
  • BIT_AND
  • BIT_OR
  • BIT_XOR
  • MAX
  • MIN
  • STD
  • STDDEV
  • STDDEV_POP
  • STDDEV_SAMP
  • SUM
  • VAR_POP
  • VAR_SAMP
  • Variance

MySQL Date Functions

This section of MySQL tutorial covers the list of Date functions with an example of each. Refer to Date Functions introduction to understand everything about these functions.

  • AddDate
  • AddTime
  • Convert_Tz
  • CURDATE
  • Curent_Date
  • CURTIME
  • Current_Time
  • Current_timestamp
  • Date
  • Date_Add
  • Date_Diff
  • Date_Format
  • Date_Sub
  • Day
  • DayName
  • DayOfMonth
  • DayOfYear
  • DayOfWeek
  • Extract
  • From_Days
  • from_unixtime
  • Get_Format
  • Hour
  • Last_day
  • LocalTime
  • LocalTimeStamp
  • MakeDate
  • MakeTime
  • Microsecond
  • Minute
  • Month
  • MonthName
  • NOW
  • Period_Add
  • Period_Diff
  • Quarter
  • Second
  • Sec_To_Time
  • Str_To_Date
  • SubDate
  • SubTime
  • SYSDATE
  • Time
  • TimeDiff
  • TimeStamp
  • TimeStampAdd
  • TimeStampDiff
  • Time_Format
  • Time_To_Sec
  • To_Days
  • To_Seconds
  • Unix_TimeStamp
  • UTC_Date
  • UTC_Time
  • Utc_timestamp
  • Week
  • Weekday
  • WeekOfYear
  • Year
  • YearWeek

MySQL tutorial on String Functions

Use this section to learn mysql String functions that are available. For each one them, we provided multiple examples. Please refer String functions article to get the introduction, and definitions of each and every function.

  • ASCII
  • Bin
  • Bit_Length
  • Char
  • Char_Length
  • Character_Length
  • Concat
  • Concat_Ws
  • Elt
  • Export_Set
  • Field
  • Find_In_Set
  • Format
  • Hex
  • Insert
  • Instr
  • Lcase
  • Left
  • Length
  • Like
  • Load_File
  • Locate
  • Lower
  • Lpad
  • Ltrim
  • Mid
  • Make_Set
  • Match
  • Not_Like
  • Not_Regexp
  • Oct
  • Octet_Length
  • Ord
  • Position
  • Quote
  • Repeat
  • Replace
  • Regexp
  • Reverse
  • Right
  • Rlike
  • Rpad
  • Rtrim
  • Space
  • Soundex
  • Sound Like
  • strcmp
  • Substr
  • Substring
  • Substring_Index
  • Trim
  • Unhex
  • Ucase
  • Upper

MySQL tutorial on Numeric Functions

This section of MySQL tutorial explains you the list of Mathematical and Trigonometric functions.

  • Introduction
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • CEILING
  • CONV
  • COS
  • COT
  • CRC32
  • DEGREES
  • EXP
  • FLOOR
  • LN
  • LOG
  • LOG2
  • LOG10
  • MOD
  • PI
  • POW
  • POWER
  • RADIANS
  • RAND
  • ROUND
  • SIGN
  • SIN
  • SQRT
  • TAN
  • TRUNCATE

  • SQL DML, DDL, DCL & TCL Cmds
  • SQL NOT EXISTS Operator
  • SQL UPDATE from SELECT
  • SQL AFTER UPDATE Triggers
  • SQL Get Column Names in Table
  • SQL IF ELSE
  • SQL ACID Properties
  • SQL FOR XML PATH
  • Java Two Dimensional Array
  • Java Perfect Number Program
  • Java Count Digits in a Number
  • C Compare Two Strings Program
  • C Print Prime Numbers 1 to 100
  • C program to Reverse a String
  • C Palindrome Number Program
  • C Program for Palindrome String
  • C Remove Duplicate String Chars
  • C Square of a Number Program
  • C Sum and Average of N Number
  • Python Fibonacci Series program
  • Python Area Of Circle Program
  • Python Prime Numbers 1 to 100
  • Python Program for Leap Year
  • Tableau Rank Calculation
  • Tableau Google Maps usage
  • Power BI Format Dates
  • Power BI Top 10 Filters
  • Power BI – Create Hierarchy
  • Power BI DAX Math Functions
  • Learn SSIS in 28 Days
  • SSIS Transformations
  • SSIS Incremental Load
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • R Programming Tutorial
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy