Learn how to back up a database in SQL. We will back up the database in a local directory with the extension .bak.
<
br/>
This clip is from the chapter "Advanced SQL" of the series "SQL Server Course for Beginners with 100+...

Learn how to implement the SELECT TOP statement in SQL. We will work with the SELECT TOP PERCENT statement as well.
<
br/>
This clip is from the chapter "Advanced SQL" of the series "SQL Server Course for Beginners with 100+...

Learn how to work with the SELECT INTO statement in SQL to create a backup copy of your table to a new table. The new table will have the same type and columns as in the first.
<
br/>
This clip is from the chapter "Advanced SQL" of...

Learn how to work with the CREATE INDEX statement in SQL to create indexes in a table. Indexes retrieve data quickly from the database. We will also see how to delete indexes using the DROP INDEX statement.
<
br/>
This clip is from...

Use the CREATE PROCEDURE statement to learn how to work with stored procedures in SQL. If you want to reuse a query again and again, then create a procedure and save the query in it. Call the procedure whenever you need that same...

Learn how to work with Aliases in SQL to give a temporary name to a table or column. The AS keyword creates an alias, making column names more readable. Remember that the alias's existence expires when that query's duration ends.
<
br/>...

Learn how to work with the UPDATE statement in SQL to update existing records in a table. Use the WHERE clause with the UPDATE statement to avoid updating all records in the table.
<
br/>
This clip is from the chapter "Alter and...

Learn how to work with the ALTER TABLE in SQL to add or delete columns in the existing table. To add a column to an existing table, use the ALTER TABLE with ADD command. To delete a column from an existing table, use the ALTER TABLE...

Learn how to work with the CHECK constraint in SQL to allow only specific values for a column. You can limit the value range set in a column, for example, Age > 18, Marks > 75, and so on.
<
br/>
This clip is from the chapter...

Learn how to work with the FOREIGN KEY constraint in SQL. A FOREIGN KEY is a field in one table that refers to the PRIMARY KEY in another. A child table is a table with a foreign key.
<
br/>
This clip is from the chapter...

Learn how to work with the PRIMARY KEY constraint in SQL. A PRIMARY KEY uniquely identifies each record. Not a Primary Key column can never have NULL values.
<
br/>
This clip is from the chapter "Constraints in SQL" of the series...

Learn how to work with the UNIQUE constraint in SQL to uniquely identify each record in a database table. It enforces the uniqueness of column values.
<
br/>
This clip is from the chapter "Constraints in SQL" of the series "SQL...

Learn how to work with the NOT NULL constraint in SQL to enforce a column with values, that is, not null. Remember, as columns can have NULL by default, we use the NOT NULL constraint to enforce a column NOT to accept values.
<
br/>...

Learn how to implement the AVG() function in SQL. We will find the average of column values.
<
br/>
This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This...

Learn how to implement the SUM() function in SQL. We will find the sum of column values.
<
br/>
This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This...

Learn how to implement the MIN() function in SQL. We will find the minimum of column values.
<
br/>
This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This...

Learn how to implement the MAX() function in SQL. We will find the maximum of column values.
<
br/>
This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This...

Learn how to implement the LIKE operator in SQL. We will find values based on a specific pattern using percentages and underscore.
<
br/>
This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for...

Learn how to implement the BETWEEN operator in SQL. We will find values in a range.
<
br/>
This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses on...

Learn how to work with the NOT operator in SQL to display records only if the condition isn't met, that is, FALSE.
<
br/>
This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+...

Learn how to work with the OR operator in SQL to display records only if one condition is TRUE. The OR operator should separate these two conditions.
<
br/>
This clip is from the chapter "Operators in SQL" of the series "SQL Server...

Learn how to work with the AND operator in SQL to display records only if both conditions are TRUE. These two conditions should be separated by the AND operator.
<
br/>
This clip is from the chapter "Operators in SQL" of the series...

Learn how to order records in SQL using the ORDER BY keyword. The default sorts in ascending order. We will see examples of both ASC and DESC keywords as well.
<
br/>
This clip is from the chapter "Order Records in SQL" of the...

Learn how to work with the WHERE clause in SQL. WHERE clause filters records based on condition(s).
<
br/>
This clip is from the chapter "Select Records in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This...