Ad details
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
mctcdubai@mctcdubai.com
www.mctcdubai.com
