AED1

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

Offered by: mctcdubai

27 Oct, 18 2:38 pm Hover for Location individual

Advertisement Info

Condition:Experienced,

Brand:Service,

Contact with

Phone number 0552239282 Reply by email

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 @ [email protected]

Short Info