Advertisement
 

Learn SQL course from our experts in Dubai || MCTC Dubai

Details
Posted:
October 27, 2018
Location:
UAE » Dubai  » Deira
Description
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
• Transactions
• Views
• Constraints
• Indexes
• Select, insert, update, delete, with, with ties clauses
• Arithmetic operators
• Wild card operators
• Intersect & Except clause
• USING Clause
• DDL, DML, DCL and TCL Commands
• 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
• How to print duplicate rows in a table?
• How to find Nth highest salary from a table
• DBMS | Nested Queries in SQL
• SQL query to find second highest salary?
For further queries about admission, feel free to call us on 0552239282/ Email us @ mctcdubai@mctcdubai.com.
Comments
Posted by:
0.0366