SQL Training Course with Certification in Dubai
For a better experience please change your browser to CHROME, FIREFOX, OPERA or Internet Explorer.
Services Educational

SQL Training Course with Certification in Dubai


  • SQL Training Course with Certification in Dubai
Description
Price : Price On Call
Date : February 19, 2019
Location : M-06, Al Ahrar Building, Salahuddin Road,Dubai

Start querying databases and learn to code in SQL with KHDA certification in Dubai from the experts of MCTC Dubai, UAE!

Whoever you are, a beginner or a professional, MCTC Dubai will help you to acquire database management skills with pure hands-on from the scratch to advanced level. SQL is a standard language for storing, manipulating and retrieving data in a database and the most important part of software development. Free demo available. Affordable fees.

Our course content includes:

•Introduction to SQL

•Syntax of SQL

•Datatypes

•DDL, DML, TCL, DCL Commands

•Transactions

•Views

•Constraints

•Indexes

•Select, insert, update, delete, with, with ties clauses

•Arithmetic operators

•Wild card operators

•Intersect & Except clause

•USING Clause

•Create Table Extension

•ALTER (Rename, ADD, DROP, MODIFY)

•Limit clause

•Like, some, except clauses

•ALL and ANY

•EXISTS

•GROUP BY

•Union Clause

•Aliases

•ORDER BY

•SELECT TOP Clause

•AND/OR operators

•WHERE, DISTINCT Clause

•DROP, TRUNCATE

•Join (Cartesian Join & Self Join)

•Alternative Quote, Concatenation Operator

•MINUS, DIVISION, NOT Operators

•BETWEEN & IN Operator

•Join (Inner, Left, Right and Full Joins)

•Mathematical functions (SQRT, PI, SQUARE, ROUND, CEILING & FLOOR)

•Conditional Expressions

•Aggregate functions

•Functions (Aggregate and Scalar Functions)

•Date functions

•NULL

•How to Join three or more tables

•How to Get the names of the table

•Sub queries in From Clause

•Correlated Subqueries

•Top-N Queries

•SUB Queries

For further queries, Contact us on 0552239282 / 042970083 / 042556969

[email protected]

www.mctcdubai.com

Share This Ad

 


Similar Ads