JCLogo JUNIOR CODERS

Structured Query Language

Storing, manipulate and retrieve data in databases.

Description

Structured Query Language is a domain-specific language used to manage data, especially in a relational database management system. It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

In this course, students will be introduced to Structured Query Language through which they can execute queries for creatring schema, retrieve data,insert,update,delete records,create new databases, tables,stored procedures, views and set permissions on tables, procedures, and views.

What students will learn ?

  • Schema
  • Index and Constraints
  • Datatypes
  • In built functions
  • Select, Insert, Update, Delete Queries
  • Group / Order by
  • Joins
  • String Functions
  • Date/Time Functions
  • Numeric Functions
  • Projects
Server MySQL
Weekly Hours (Recommended) 2
Levels 3 (Each level of 16 hours)
Age 10+ years
Mode Online
Teacher Student Ratio 1:1 or 1:2
Language English
Time Slots Flexible