Get Me Coding
How To Install MySQL on Windows - Step By Step
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. MySQL Workbench allows you to create database and either use software...
Curated Video
SQL Server Course for Beginners with 100+ examples - Drop a Table in SQL
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. This clip is from the chapter "Advanced SQL" of the series "SQL Server Course for Beginners with...
Curated Video
SQL Server Course for Beginners with 100+ examples - SQL Views
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. This clip is from the...
Curated Video
SQL Server Course for Beginners with 100+ examples - Back Up a Database in SQL
Learn how to back up a database in SQL. We will back up the database in a local directory with the extension .bak. This clip is from the chapter "Advanced SQL" of the series "SQL Server Course for Beginners with 100+ Examples".null
Curated Video
SQL Server Course for Beginners with 100+ examples - SELECT TOP Clause in SQL
Learn how to implement the SELECT TOP statement in SQL. We will work with the SELECT TOP PERCENT statement as well. This clip is from the chapter "Advanced SQL" of the series "SQL Server Course for Beginners with 100+ Examples".null
Curated Video
SQL Server Course for Beginners with 100+ examples - SELECT INTO Statement in SQL
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. This clip is from the chapter "Advanced SQL" of the series...
Curated Video
SQL Server Course for Beginners with 100+ examples - Indexes in SQL
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. This clip is from the chapter...
Curated Video
SQL Server Course for Beginners with 100+ examples - Stored Procedures in SQL
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 query....
Curated Video
SQL Server Course for Beginners with 100+ examples - Aliases
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. This...
Curated Video
SQL Server Course for Beginners with 100+ examples - UPDATE Statement
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. This clip is from the chapter "Alter and Update in SQL"...
Curated Video
SQL Server Course for Beginners with 100+ examples - ALTER TABLE Statement
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 with...
Curated Video
SQL Server Course for Beginners with 100+ examples - CHECK Constraint
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. This clip is from the chapter "Constraints in...
Curated Video
SQL Server Course for Beginners with 100+ examples - FOREIGN KEY Constraint
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. This clip is from the chapter "Constraints in SQL" of...
Curated Video
SQL Server Course for Beginners with 100+ examples - PRIMARY KEY Constraint
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. This clip is from the chapter "Constraints in SQL" of the series "SQL Server...
Curated Video
SQL Server Course for Beginners with 100+ examples - UNIQUE Constraint
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. This clip is from the chapter "Constraints in SQL" of the series "SQL Server Course...
Curated Video
SQL Server Course for Beginners with 100+ examples - NOT NULL Constraint
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. This clip...
Curated Video
SQL Server Course for Beginners with 100+ examples - COUNT() Function
Learn how to implement the COUNT() function in SQL. We will find the count of the number of rows. This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section...
Curated Video
SQL Server Course for Beginners with 100+ examples - AVG() Function
Learn how to implement the AVG() function in SQL. We will find the average of column values. This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section...
Curated Video
SQL Server Course for Beginners with 100+ examples - SUM() Function
Learn how to implement the SUM() function in SQL. We will find the sum of column values. This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses on...
Curated Video
SQL Server Course for Beginners with 100+ examples - MIN() Function
Learn how to implement the MIN() function in SQL. We will find the minimum of column values. This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section...
Curated Video
SQL Server Course for Beginners with 100+ examples - MAX() Function
Learn how to implement the MAX() function in SQL. We will find the maximum of column values. This clip is from the chapter "Built-In Functions in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section...
Curated Video
SQL Server Course for Beginners with 100+ examples - LIKE Operator
Learn how to implement the LIKE operator in SQL. We will find values based on a specific pattern using percentages and underscore. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+...
Curated Video
SQL Server Course for Beginners with 100+ examples - BETWEEN Operator
Learn how to implement the BETWEEN operator in SQL. We will find values in a range. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses on the...
Curated Video
SQL Server Course for Beginners with 100+ examples - IN Operator
Learn how to implement the IN operator in SQL. We will check whether a specific value matches. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses on...