jrm_solutions
  Send Enquiry    Call Now    Home

An Overview of Structured Query Language:

 

SQL (Structured Query Language) was first developed by IBM in the early 1970s. Since that time, the language has gone through a number of modifications and revisions, but it still remains true to its original purpose of managing and retrieving data stored in database systems.
MYSQL: MySQL is an open source Relational Database Management System large volumes of data at very high speed with security.
MySQL can be used for Free-software projects that require a full-featured database management system.
Advantage: MySQL is characterised as a free, fast, reliable open source relational database. It does lack some sophistication and facilities, but it has an active development team and, as it goes from release to release, more capabilities are added. At certain times there will be a trade-off between speed and capabilities, and the MySQL team intend to keep their database engine fast and reliable

COURSE SUMMARY:

  • Introduction to SQL
  • SQL Syntax
  • SQL Select
  • SQL Distinct
  • SQL Where
  • SQL And & Or
  • SQL Order By
  • SQL Insert
  • SQL Update
  • SQL Delete
  • SQL Drop

COURSE SUMMARY:

  • SQL Delete
  • SQL Right Join
  • SQL Joins
  • SQL Inner Join
  • SQL Left Join
  • SQL Right Join
  • SQL Right Join
  • SQL Create Table
  • SQL Constraints
  • SQL Not Nul
  • SQL Unique
  • SQL Primary Key
  • SQL Foreign Key