-
Adding Data Using INSERT Statement
After watching this video; you will be able to use the INSERT statement in SQL.
-
ALTER and CHANGE
After watching this video; you will be able to use SQL to ALTER and CHANGE data.
-
AVG and GROUP BY
After watching this video; you will be able to use SQL AVG and GROUP BY.
-
Basic Math Operators and Functions
After watching this video; you will be able to describe the various math operators and functions.
-
Benefits of Normal Forms
After watching this video; you will be able to describe normal forms and their benefits in SQL architecture.
-
Changing an Existing Table
After watching this video; you will be able to use SQL to alter an existing table.
-
Concept of Locks
After watching this video; you will be able to describe locks and their use in SQL.
-
Connecting Tables Together
After watching this video; you will be able to use SQL for the process of connecting tables.
-
Correlated and Noncorrelated Queries
After watching this video; you will be able to use correlated and noncorrelated queries in SQL.
-
Correlated Query with EXISTS and NOT EXISTS
After watching this video; you will be able to use correlated query with EXISTS and NOT EXISTS operators.
-
Creating a View
After watching this video; you will be able to use SQL to create a simple view.
-
Creating and Managing Users in SQL
After watching this video; you will be able to use SQL to describe how to create a user and how to manage them.
-
Creating more Complex Tables
After watching this video; you will be able to use SQL to create more complex tables.
-
Creating Tables with a FOREIGN KEY
After watching this video; you will be able to use FOREIGN KEY with CREATE in SQL architecture.
-
Defining COMMIT Statement
After watching this video; you will be able to use the COMMIT statement in SQL.
-
Defining ROLLBACK Statement
After watching this video; you will be able to use ROLLBACK statement in SQL.
-
Deleting a Record Using a DELETE Query
After watching this video; you will be able to use DELETE to remove data from a table in SQL.
-
Deleting an Existing Table
After watching this video; you will be able to use SQL to delete an existing table.
-
Describing ACID Transactions
After watching this video; you will be able to describe the various ACID transactions and their use.
-
Dissecting the Code behind Structured Query Language
After watching this video; you will be able to describe in high level; structured query language and its use.
-
DROP COLUMN Introduction
After watching this video; you will be able to describe DROP COUMN and its use in SQL.
-
Dropping Views
After watching this video; you will be able to use SQL to drop views.
-
EQUI JOINs and NON-EQUI JOINs
After watching this video; you will be able to use equijoins and non-equijoins and describe their differences in SQL architecture.
-
Example of a Query With A Natural Join
After watching this video; you will be able to use a query with a natural join.
-
Example of Implementing Locks on Transactions
After watching this video; you will be able to use SQL to create an implementation using locks.
-
Filter Results with WHERE Clause
After watching this video; you will be able to use WHERE to filter data and retrieve requested results in SQL.
-
Functional Dependencies
After watching this video; you will be able to describe the functional dependencies and their use.
-
Group IDs and the Use of Roles
After watching this video; you will be able to use SQL to describe the use of group IDs and roles in.
-
How to Create a Table
After watching this video; you will be able to describe tables and how to create them in SQL.
-
Inner Joins – An Introduction
After watching this video; you will be able to use inner joins in SQL.
-
Introducing Transactions
After watching this video; you will be able to describe the various transactions and their use in SQL.
-
Introduction to Multi-table Architecture
After watching this video; you will be able to define multiple tables and describe their use in SQL.
-
Security Concepts
After watching this video; you will be able to describe the various security concepts in SQL.
-
Introduction to Subquery
After watching this video; you will be able to describe a subquery and its use in SQL.
-
Introduction to SUBSTRING() Function
After watching this video; you will be able to describe the SUBSTRING() functioning in SQL.
-
Introduction to the Database Concept
After watching this video; you will be able to identify a database and how it relates to SQL.
-
Introduction to the SQL Syntax
After watching this video; you will be able to use SQL to create a simple statement.
-
Introduction to Transact-SQL
After watching this video; you will be able to use SQL to define Transact-SQL and the relation with transaction types.
-
Introduction to Using UPDATE
After watching this video; you will be able to use UPDATE to change data in SQL.
-
Introduction to Views
After watching this video; you will be able to describe views and their relation to the SQL architecture.
-
Learning the NULL Statement
After watching this video; you will be able to use the NULL statement in SQL.
-
LENGTH() Function
After watching this video; you will be able to using the LENGTH function in SQL.
-
Levels of Locking
After watching this video; you will be able to use SQL to identify the levels of locking.
-
Limit Results Using LIMIT and SELECT DISTINCT
After watching this video; you will be able to use LIMIT and SELECT DISTINCT.
-
Making Tables More Normal
After watching this video; you will be able to describe the normalization processes in more detail in SQL.
-
Multilevel Architecture with a Twist
After watching this video; you will be able to describe the multiple layers of tables and their management with various queries in SQL.
-
Multiple Conditions Using Multiple Joins
After watching this video; you will be able to use multiple joins and multiple conditions in SQL.
-
Normalizing and More SQL Data Processes
After watching this video; you will be able to describe normalization and other SQL data processes.
-
Operational Transaction Logs
After watching this video; you will be able to use transaction logs and define their purpose in SQL.
-
Ordering Results with ORDER BY
After watching this video; you will be able to use ORDER BY with results to sort data in SQL.
-
OUTER JOINs
After watching this video; you will be able to use Outer Joins in SQL.
-
Patterns of Data in SQL
After watching this video; you will be able to describe relationships between tables and the different patterns.
-
Privileges and Access Rights
After watching this video; you will be able to use SQL to define the use of privileges and restrictions.
-
Putting String Functions Together
After watching this video; you will be able to use SQL string functions to create a query.
-
Query Your Data Types in SQL
After watching this video; you will be able to use SQL to create several data types.
-
Quick Peek Using SELECT Statement
After watching this video; you will be able to use SELECT to take a look at a table.
-
Ready to Create a Database
After watching this video; you will be able to use SQL to create a simple database example.
-
REVERSE() Function
After watching this video; you will be able to use the REVERSE() function in SQL.
-
SELECT in More Detail
After watching this video; you will be able to use the SELECT statement in SQL queries.
-
Selecting Data from More Than One Table
After watching this video; you will be able to use SELECT to retrieve data from more than one table in SQL.
-
Setting Modes for Locks
After watching this video; you will be able to use SQL to describe the various lock modes.
-
SOUNDEX() and DIFFERENCE() Functions
After watching this video; you will be able to Use SOUNDEX() and DIFFERENCE() functions in SQL.
-
SQL Composite Keys Using Multiple Values
After watching this video; you will be able to use composite keys and their relative values.
-
SQL Main Components and Why They're Used
After watching this video; you will be able to use all data management components in an example in SQL.
-
SQL Views; Transactions; & Security Model
After watching this video; you will be able to describe views; transactions; and the security model and the relation to SQL.
-
Table Altering
After watching this video; you will be able to describe how to rename and alter a table in SQL.
-
Tables by Example
After watching this video; you will be able to use tables to further dive into the complexities of SQL.
-
The PRIMARY KEY Rules
After watching this video; you will be able to use PRIMARY KEY in SQL.
-
The Relation of Data and the Various Databases
After watching this video; you will be able to describe the relational concepts of SQL; various database types; and when and why they are used.
-
Tips for Efficient Queries
After watching this video; you will be able to use SQL more efficiently with operational tips.
-
TRIM() Function
After watching this video; you will be able to use the TRIM() function in SQL.
-
Types of Views in SQL
After watching this video; you will be able to use the various views in SQL architecture.
-
Understanding Data Types
After watching this video; you will be able to describe data types and their relation to SQL.
-
Understanding Rounding Numbers in SQL
After watching this video; you will be able to use SQL rounding numbers process.
-
Understanding the Atomic Value
After watching this video; you will be able to describe Atomic values and their relation to Normalization in SQL.
-
UNION Operator and Combining Results
After watching this video; you will be able to use the UNION operator and describe how it combines results.
-
Updating Views in SQL
After watching this video; you will be able to use SQL to update a view.
-
Use Case Example of the Use of Access Rights
After watching this video; you will be able to use SQL security processes to create a user and a group with privileges.
-
Use Case Example Using Data Management Components
After watching this video; you will be able to use all data management components in an example in SQL.
-
Use Case Example Using Functional Dependencies
After watching this video; you will be able to use functional dependencies in a example.
-
Use Case Example Using SQL Arithmetic and Grouping
After watching this video; you will be able to use SQL arithmetic and grouping to create queries.
-
Use Case Transactional Data
After watching this video; you will be able to use Transactions in SQL.
-
User IDs
After watching this video; you will be able to use SQL to describe the philosophy behind User IDs and their use.
-
Using ALTER TABLE with a PRIMARY KEY Constraint
After watching this video; you will be able to use both ALTER TABLE and PRIMARY KEY constraint in SQL.
-
Using CREATE TABLE with PRIMARY KEY Constraint
After watching this video; you will be able to use both CREATE TABLE and add PRIMARY KEY constraint in SQL.
-
Using DROP COLUMN; ALTER; and CHANGE in SQL
After watching this video; you will be able to describe a use case example of executing altering queries in SQL.
-
Using HAVING Clause with Queries
After watching this video; you will be able to use HAVING clause in SQL with queries.
-
Using IN; NOT IN in SQL
After watching this video; you will be able to use IN; NOT IN commands in SQL.
-
Using MIN and MAX in SQL
After watching this video; you will be able to use SQL MIN and MAX processes.
-
Using Queries with DELETE FROM Statement
After watching this video; you will be able to use queries with the DELETE FROM statement in SQL.
-
Using Queries with INSERT Statement
After watching this video; you will be able to use queries with the INSERT statement in SQL.
-
Using Queries with the UPDATE Statement
After watching this video; you will be able to use queries with the UPDATE statement in SQL.
-
Using query as a SELECT Column
After watching this video; you will be able to use query as a SELECT column in SQL.
-
Using ROLLBACK and COMMIT Statements in SQL
After watching this video; you will be able to use ROLLBACK and COMMIT in an SQL query.
-
Variations of Query
After watching this video; you will be able to use SQL to describe the differences between SQL and other languages.
-
Various Levels of locking
After watching this video; you will be able to use SQL to introduce the various levels of locking and their use.
-
Why use DEFAULT?
After watching this video; you will be able to use the DEFAULT statement in SQL.
-
Working with Difficult Queries
After watching this video; you will be able to use SQL to create a more complex query.
-
Date Functions
After watching this video; you will be able to use date functions in SQL.