Data Base Schema:-

Data Base Schema:- 

What is constraint?

What is constraint:

Constraints are used to limit the type of data that can go into a table. There are five types of constraints:

v  Primary key

v  Unique Key

v  Foreign Key

v  Not Null

v  Check

Primary key: In a database table, the Primary Key is a column which has a unique value for each of the row within that column. It can’t have NULL value. Primary key in one table can be Foreign key in other table.

Foreign key: Foreign key is the key that make a link with other table. It can’t have NULL value. Foreign key in one table can be primary key in other table.

Unique key: In a database table, the Unique Key is a column which may or may not have null value of each of the row within that column.

Not Null: This means the column should always put the value. It can’t be Null.

Cheek: Limit the value range that can be placed in a column.

What Can SQL do?

What Can SQL do:-

• SQL can create new tables in a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create stored procedures in a database
• SQL can retrieve data from a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

Some of the Most Important SQL Commands:

 Some of the Most Important SQL Commands:

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database
• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database
• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index

ALM Documents And XL Add-ins Exe File

ALM Documents:

Hello Everyone, Please download your ALM Class Documents And XL Add-ins File From The Below Links.

ALM_Documents_Batch1_2015 Download Here

ALM XL Add-ins Exe File Download Here

ITCloud Technologies Corporation Overview:-

Download ITCloud_Registration_Form

Download Here........

ITCloud_Registration_Form.Pdf

SDLC Phases:-

SDLC:- Software Development Life Cycle.

STLC Phases:-

STLC- Software Testing Life Cycle :-

Ramadan Schedule:-

Dear Consultants,

 

Hope you are doing well.

 

As we all know that Ramadan is approaching to us within few days. And ITCloud Technologies Corporation fully understand and respect the value of Ramadan. We know most of our consultants and team members will keep fasting and pray during Ramadan. With this important thing keeping in mind, we are planning to change our meeting session only for Ramadan. After Ramadan we will get back to our normal meeting time. We proposed to attend sessions on every Saturday and Sunday from 9:00 am to 12:00 pm. So, we will able to fulfill our agenda during Ramadan. We also understand that some of your schedule will conflict due to change of this plan. But keeping mind that  most of the consultants and team members availability, we came to this decision which can be changed based on your opinion or thoughts since your opinion is very important to us. Please let us know your thoughts regarding Ramadan Plan ASAP. Hope to hear back from you soon.

 

Please feel free to contact us for any concern at support@itcloudtechnologies.com or 954-544-8870.

 

Best wishes,

ITCloud Technologies Corporation Team