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...
Curated Video
SQL Server Course for Beginners with 100+ examples - NOT Operator
Learn how to work with the NOT operator in SQL to display records only if the condition isn't met, that is, FALSE. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for Beginners with 100+ Examples".This...
Curated Video
SQL Server Course for Beginners with 100+ examples - OR Operator
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. This clip is from the chapter "Operators in SQL" of the series "SQL Server Course for...
Curated Video
SQL Server Course for Beginners with 100+ examples - AND Operator
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. This clip is from the chapter "Operators in SQL" of the series "SQL Server...
Curated Video
SQL Server Course for Beginners with 100+ examples - ORDER BY Keyword in SQL
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. This clip is from the chapter "Order Records in SQL" of the series "SQL...
Curated Video
SQL Server Course for Beginners with 100+ examples - WHERE Clause in SQL
Learn how to work with the WHERE clause in SQL. WHERE clause filters records based on condition(s). This clip is from the chapter "Select Records 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 - SELECT Statement in SQL
Learn how to select records in SQL using the SELECT statement. We will also see how to choose multiple columns in a single query. This clip is from the chapter "Select Records in SQL" of the series "SQL Server Course for Beginners with...
Curated Video
SQL Server Course for Beginners with 100+ examples - Insert Records
Use the INSERT INTO Statement in SQL to learn how to insert records in a table. This clip is from the chapter "Create and Insert" of the series "SQL Server Course for Beginners with 100+ Examples".This section focuses over creating a...
Curated Video
SQL Server Course for Beginners with 100+ examples - Create a Table
Learn how to create a new table with SQL Server. The CREATE TABLE statement is used to create a new table in SQL Server. This clip is from the chapter "Create and Insert" of the series "SQL Server Course for Beginners with 100+...
Curated Video
SQL Server Course for Beginners with 100+ examples - Install SQL Server on Windows 11
Learn how to download and install Microsoft SQL Server on Windows 11. We will also install SQL Server Management Studio (SSMS). This clip is from the chapter "SQL Installation and Setup" of the series "SQL Server Course for Beginners...
Curated Video
SQL Server Course for Beginners with 100+ examples - Introduction
Learn what SQL is and how it is based on RDBMS. We will discuss the features and Microsoft SQL Server and SQL Server Management Studio. This clip is from the chapter "SQL Introduction" of the series "SQL Server Course for Beginners with...
Curated Video
Behavioral Design Patterns in C++ - Methods for States - IV
In this video, we will add a yellow state to the lamp. This clip is from the chapter "State" of the series "Behavioral Design Patterns in C++".This section focuses on the State design pattern.
Curated Video
Behavioral Design Patterns in C++ - Methods for States - I
This video demonstrates another approach—methods for state approach that can be implemented in the State design pattern. This clip is from the chapter "State" of the series "Behavioral Design Patterns in C++".This section focuses on...
Curated Video
Learn Tableau by Working on Exciting Dashboards - Table Calculations - Scope and Direction
This video explains the scope and direction of the table calculations.
Curated Video
Learn Tableau by Working on Exciting Dashboards - Quick Table Calculations
This video explains quick table calculations in Tableau Public.