Clicky

L O A D I N G
+1 732-654-0056 +91-868-881-0000 Job enquiry Job enquiry:+91-9121642626 عربى
search
Home / techtutorials

My SQL

Beginners

  1. MySQL Introduction 
    • What is Database?
    • RDBMS Terminology
      • Database 
      • Table 
      • Column
      • Row
      • Redundancy
      • Primary Key
      • Foreign Key
      • Compound Key
      • Index
      • Referential Integrity
    • MySQL Database
  2. MySQL Installation
    • Installing MySQL on Linux/Unix
    • Installing MySQL on Windows 
    • Verifying MySQL Installation 
    • Post-Installation Steps
    • Running MySQL at Boot Time 
  3. MySQL Administration
    • Running and Shutting down MySQL Server 
    • Setting Up a MySQL User Account 
    • Administrative MySQL Command
      • Use Databasename 
      • Show Databases 
      • Show Tables
      • Show Columns from tablename 
      • Show Index from tablename 
      • Show Table Status Like tablename\G
  4. MySQL PHP Syntax
  5. MySQL Connection
    • MySQL Connection Using MySQL Binary
    • MySQL Using PHP Script
      • mysql_connect()
        • server
        • user
        • passwd
        • new_link
        • client_flags
      • mysql_close()

 

Advanced

  1. MySQL Create Database
    • Create Database Using mysqladmin
    • Create Database Using PHP Script
      • mysql_query()
        • sql
        • connection
  2. Drop MySQL Database 
    • Drop a Database using mysqladmin
    • Drop a Database using PHP
      • mysql_query()
        • sql
        • connection
  3. Selecting MySQL Database
    • Selecting MySQL Database from the Command Prompt
    • Selecting MySQL Database Using PHP Script
      • mysql_select_db
        • db_name
        • connection
  4. MySQL Data Types
    • Numeric Data Types 
      • INT
      • TINYINT
      • SMALLINT
      • MEDIUMINT
      • BIGINT
      • FLOAT(M,D)
      • DOUBLE(M,D)
      • DECIMAL(M,D)
    • Date and Time Types 
      • DATE
      • DATETIME
      • TIMESTAMP
      • TIME
      • YEAR(M)
    • String Types
      • CHAR(M)
      • VARCHAR(M)
      • BLOB or TEXT
      • TINYBLOB or TINYTEXT
      • MEDIUMBLOB or MEDIUMTEXT
      • LONGBLOB or LONGTEXT
      • ENUM
  5. Use of Commands in MySQL 
    • SELECT
    • INSERT
    • DELETE
    • UPDATE
    • GROUP BY
  6. How to Query Data Using Where Clause in MySQL  
  7. How Sorting is Done by using
    • ORDER BY
    • DESC
    • ASC
  8. How to use the following in MySQL 
    • Wildcards
    • Regular Expressions & Wildcards 
    • Aggregate Function
    • Auto Increment 
    • Alter, Drop & Rename function
    • Limit Keyword 
    • Sub-Queries
    • Join
    • Union
    • Views
    • Index
    • Null value & Keyword 
  9. Creating an Application using MySQL 

 

Youtube

Certifications

Also Good To Learn

WE ARE REVIEWED
tvisha technologies click to call
Request A Call Back