Professional Mysql – media3training

PROFESSIONAL MYSQL

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. Also, they are using different dialects, such as −MS SQL Server using T-SQL,Oracle using PL/SQL,MS Access version of SQL is called JET SQL (native format) etc.

PROFESSIONAL MYSQL

Course Overview

  • SQL – Home
  • SQL – Overview
  • SQL – RDBMS Concepts
  • SQL – Databases
  • SQL – Syntax
  • SQL – Data Types
  • SQL – Operators
  • SQL – Expressions
  • SQL – Create Database
  • SQL – Drop Database
  • SQL – Select Database
  • SQL – Create Table
  • SQL – Drop Table
  • SQL – Insert Query
  • SQL – Select Query
  • SQL – Where Clause
  • SQL – AND & OR Clauses
  • SQL – Update Query
  • SQL – Delete Query
  • SQL – Like Clause
  • SQL – Top Clause
  • SQL – Order By
  • SQL – Group By
  • SQL – Distinct Keyword
  • SQL – Sorting Results

Advanced SQL

  • SQL – Constraints
  • SQL – Using Joins
  • SQL – Unions Clause
  • SQL – NULL Values
  • SQL – Alias Syntax
  • SQL – Indexes
  • SQL – Alter Command
  • SQL – Truncate Table
  • SQL – Using Views
  • SQL – Having Clause
  • SQL – Transactions
  • SQL – Wildcards
  • SQL – Date Functions
  • SQL – Temporary Tables
  • SQL – Clone Tables
  • SQL – Sub Queries
  • SQL – Using Sequences
  • SQL – Handling Duplicates
  • SQL – Injection

Leave A Comment

    RELATED COURSE

  • GET IN TOUCH
    Call: 903 206 6166
    Mail: info@media3training.com
  • Head Office

    Media3 Empire,Kshatriya Kalayanamandapam
    Seethammadhara, Visakhapatnam – 530013

  • Hyderabad

    205, Aditya Trade Center, Ameerpet, Hyderabad,Telangana 500016,  90320  66166

  • Vijayawada

    Opp. Sweet Magic, DV Manor Road, Below Kotak Mahindra Bank, Bandar Road, Vijayawada, Andhra Pradesh  520002, 90320 66166,  90009 14648

  • Vizianagaram

    Suit-303, Vijaya Mansion, Opp.Commercial Tax Office,LIC Complex  Back Side, Lower Tank Bund Road, Siddarth Nagar, Vizianagaram 535003,  90320 66166

  • Kurnool

    9642668768, 9121099933

  • Tirupathi
    D/No:7-43-46, Venkatadri Plaza Building Main Road, near Flipkart Office, Mangalam, Tirupati, Andhra Pradesh 517501
    9642668768, 9121099933

  • Rajahmundry

    47-7-47, Upstairs of AYASYA showroom ,PARK road Danvaipeta,Rajahmundry 9542055666, 8555003678