วีดีโอ

In this tutorial, I talked about the order by clause and aggregate functions. The GROUP BY clause divides a table into sets. This clause is most often combined with aggregate functions that produce summary values for each of those sets, and An aggregate function in SQL performs a calculation on multiple values and returns a single value, we discussed about the max, min, count, sum aggregate fun...

In this SQL tutorial, we learnt about operators in SQL, we learnt about operators like the =, !=, IN, BETWEEN, LIKE and many more, these tutorial will help you understand in details how to use SQL operators with ease

In this tutorial, we discussed about the select statement. The select statement is used to retrieve values from a table, in this section, we discussed about the use of wild card (*) to retrieve all the records in a table, we discussed on how to filter records with the where clause, we discussed how to do multiple select conditions

This tutorial, talks about unique key constraint in SQL, the unique key constraint is used to ensure that there are no duplicate values in a column, we have studied about other constraints, and you can find the links below for a better understanding about constraint. Check Constraint : th-cam.com/video/aISnkGy81IM/w-d-xo.html Default constraint : th-cam.com/video/YkSM9Lc9YYo/w-d-xo.html

This tutorial is about how to reset an identity column, we discussed about identity column in the previous tutorials, you can find the link for that tutorial below for more understanding th-cam.com/video/DUlJ6mtaooQ/w-d-xo.html

Identity Column or auto increment is used to automatically generate sequence of number used as primary key to uniquely identify a record in a database. This is called auto increment in other databases

This video talks about check constraint and Check constraint is used to limit the rage of values that can be entered in a column and it is a Boolean expression. we also talked about the various ways we can do this using the graphical method and queries as stated below Creating a constraint: Alter table [table name] Add constraint [constraint name] Check [Expression ] Deleting/Dropping a constra...

This Video talks about Cascading referential integrity constraint, but the below part 3 and 4 are recommended for a better understanding of this tutorial Part 3 = th-cam.com/video/5qVzdq-fics/w-d-xo.html Part 4 = th-cam.com/video/YkSM9Lc9YYo/w-d-xo.html

This video talks about default constraint. The DEFAULT constraint is used to set a default value for a column. The default value will be added to all new records, if no other value is specified.

This tutorial emphasizes on working with table, where we covered so many things about table like the below A primary (PK) key is the column or columns that contain values that uniquely identify each row in a table. A database table must have a primary key for Optim to insert, update, restore, or delete data from a database table. A foreign key (FK) is a column or combination of columns that is ...

This video talks about Creating, altering and dropping a database. A Database can be created, altered and dropped 1. Graphically using SQL Server Management Studio (SSMS) 2. Using Query Create database using Query Create database DatabaseName Files Generated after creating a database .MDF File-Data File (Contains actual data) .LDF File- Transaction Logfile (Used to recover the database) To alte...

This video talks about the Crop Tool, virtual Segment delete tool, knife tool and eraser tool

In this tutorial, we discussed about the Twirl tool which is used to make a spiral shape

This video is about the smooth tool and the smear tool, we learnt how to use the smooth tool to smoothen the rough edges of a line and also how to use the smear tool to change the shape of an object in Corel Draw.

Corel Draw Tutorial Shape Tool Cont Designing the Barcelona Logo

Corel Draw Tutorial Shape Tool part 1

Corel Draw Tutorial Pick tool Cont

Corel Draw Tutorial Pick Tool Group

Corel Draw Tutorial Corel Working Environment

Introductio