Medium of instruction: | English |
-
1. DML
-
1.1 Select
-
1.2 Update
-
1.3 Delete
-
1.4 Select into
-
-
2. DDL
-
2.1 create database
-
2.2 alter database
-
2.3 create table
-
2.4 alter table
-
2.5 drop table
-
2.6 create index
-
2.7 drop index
-
-
3. Where condition
-
4. Operator
-
4.1 Equal
-
4.2 not equal
-
4.3 Less than
-
4.4 Greater than
-
4.5 BETWEEN
-
4.6 LIKE
-
4.7 IN
-
-
5. Order by
-
6. Wild characters
-
7. SQL alias
-
8. SQL indexes
-
9. SQL view
-
10. NULL values
-
11. SQL constraints
-
11.1 NOT NULL
-
11.2 UNIQU E
-
11.3 Primary key
-
11.4 Foreign key
-
11.5 Check
-
11.6 Default
-
-
12. SQL joins
-
12.1 Join
-
12.2 Left
-
12.3 Right
-
12.4 Full
-
-
13. SQL UNION Operators
-
13.1 UNION
-
13.2 UNION ALL
-
-
14.SQL Functions
-
14.1 Aggregate Functions
-
14.1.1 AVG
-
14.1.2 COUNT
-
14.1.3 FIRST
-
14.1.4 MIN
-
14.1.5 SUM
-
-
14.2 Scalar Functions
-
14.2.1 UCASE
-
14.2.2 LCASE
-
14.2.3 MID
-
14.2.4 LEN
-
14.2.5 ROUND
-
-
-
15. SQL Group by
-
16. SQL Having
-
17.SQL Dual Table
Classroom - Regular | ||||
When | Duration | Where | Remarks | Price |
Not Specified | Not Specified | All Venues | Not Specified | Price On Request |
F I T Computer Education
F I T Computer Education helps you find out the right training, course or education for your requirements. F I T Computer Education has the way out to your training needs that is lucrative, tailored to individuals and organizations.
F I T Computer Education, the true leader in Information Technology training, has been providing high-quality Career Training programs to individuals starting their careers or undergoing a career change.. The programs are led by senior consultant trainers who are dedicated to helping our students find the key that will unlock the door to a successful future . We are dedicated to delivering high quality training that helps our students increase their job effectiveness and enables organizations to maximize the utilization of technology.
Our Culture
F I T Computer Education unique culture is often praised by students, partners and employees. It is a culture of learning, team building and exceeding expectations. Our culture fosters an employee work environment that allows for success. Outstanding achievement is to be recognized and rewarded, open communication is always encouraged and career growth is expected.
Satisfaction Is Guaranteed
With F I T Computer Education, you can be sure of receiving training that significantly increases your understanding retention and ability to apply new knowledge and skills to maximum effect. What's more, we are so confident in our ability to deliver reliable, effective training that unless you feel 100% satisfied that F I T Computer Education delivered even more than you expected, there is no fee for your course attendance.