Easily install MySQL on Windows with this step by step video. The video shows the installation of MySQL Workbench using the Community Edition that is free to download.
<
br/>
MySQL Workbench allows you to create database and...

Learn how to drop a table in SQL. Dropping will delete all the records of the table. It will also obliterate the existence of the table.
<
br/>
This clip is from the chapter "Advanced SQL" of the series "SQL Server Course for...

Learn how to work with Views in SQL. A view is a virtual table created from the actual table, displaying the current result set. We will use the CREATE VIEW and DROP VIEW statements to develop and delete views.
<
br/>
This clip is...

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 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 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 COUNT() function in SQL. We will find the count of the number of rows.
<
br/>
This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+...

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 implement the IN operator in SQL. We will check whether a specific value matches.
<
br/>
This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section...

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...