-
Understanding Relationships
After watching this video; you will be able to define relationships in a database such as one-to-many; one-to-one; and many-to-many; outlining the role of primary; composite; and foreign keys in the context of SQL Server examples.
-
Creating and Using Stored Functions
After watching this video; you will be able to compare stored functions with stored procedures and create and use a stored function within a SQL Server database.
-
Using Inner Joins
After watching this video; you will be able to use INNER JOINS to retrieve data from multiple SQL Server tables.
-
Using Outer Joins
After watching this video; you will be able to use OUTER JOINS to retrieve data from multiple SQL Server tables.
-
Altering and Dropping Databases
After watching this video; you will be able to using SMSS and DDL; use; alter; and drop SQL Server databases.
-
Altering and Dropping Tables
After watching this video; you will be able to using SMSS and DDL; alter and drop SQL Server tables.
-
Backing up Databases with SSMS
After watching this video; you will be able to use SQL Server to back up databases.
-
Bulk Inserts
After watching this video; you will be able to use BULK INSERT to insert data into a SQL Server database.
-
Column Design
After watching this video; you will be able to define the standards used in column design and its properties such as auto increment columns; default and null values; and modifying size and format in the context of SQL Server examples.
-
Combining Result Sets
After watching this video; you will be able to use the UNION statement to combine the results from multiple SELECT statements executed on a SQL Server database.
-
Creating and Assigning Permissions
After watching this video; you will be able to create; assign; and manage permissions to a SQL Server login .
-
Creating and Using Stored Procedures
After watching this video; you will be able to create and use stored procedures in SQL Server databases.
-
Creating Databases
After watching this video; you will be able to using SMSS and DDL; create a new SQL Server database with its specific syntax and parameters and review its schema.
-
Creating Indexes
After watching this video; you will be able to create clustered and nonclustered indexes in SQL Server databases.
-
Creating Views
After watching this video; you will be able to describe the purpose and performance impact of views and create a view in a SQL Server database by using SMSS graphical designer or by using T-SQL.
-
Data Integrity and Constraints
After watching this video; you will be able to describe the importance of data integrity to related database tables and list the methods for enforcement.
-
Data Types
After watching this video; you will be able to describe the data types supported by SQL Server.
-
DBMS and RDBMS
After watching this video; you will be able to define database management systems (DBMS) and relational database management systems (RDBMS).
-
Exercise: Creating and Normalizing Tables
After watching this video; you will be able to use the appropriate commands to create and normalize tables in a SQL Server database.
-
Exploring Server and User-defined Roles
After watching this video; you will be able to using SMSS; identify and describe SQL Server fixed and user-defined server and database roles; the guest account and how to revoke it.
-
Filtering Results
After watching this video; you will be able to use SELECT statements with WHERE; AND; NOT; BETWEEN to filter results.
-
Indexes
After watching this video; you will be able to describe clustered and nonclustered indexes in the context of their use in a SQL Server database.
-
Inserting Data
After watching this video; you will be able to describe how data is inserted into a database and use INSERT statements to insert one or more rows into a SQL Server database.
-
Introducing Databases
After watching this video; you will be able to define a database; describe how data is stored in tables containing records and fields; and describe flat; hierarchal; and relational databases.
-
Introducing SQL Server Management Studio (SSMS)
After watching this video; you will be able to describe the purpose of and navigate SQL Server Management Studio (SSMS); a SQL Server instance; and its objects .
-
Manipulating Result Sets
After watching this video; you will be able to use INTERSECT and EXCEPT to compare and extract data from result sets returned from SQL Server data.
-
Normalization Guidelines - 1NF
After watching this video; you will be able to describe the normalization guidelines for relational databases and define the first normal form (1NF).
-
Normalization Guidelines - 2NF
After watching this video; you will be able to describe the normalization guidelines for relational databases and define the second normal form (2NF).
-
Normalization Guidelines - 3NF
After watching this video; you will be able to describe the normalization guidelines for relational databases and define the third normal form (3NF).
-
Ordering Result Sets
After watching this video; you will be able to use the ORDER By clause to order result sets returned from a SELECT statement.
-
Overview of Database Backup and Restore
After watching this video; you will be able to list the options available in SQL Server for database backups and restores.
-
Overview of Database Security
After watching this video; you will be able to describe the main considerations for relational database security.
-
Restoring Databases with SSMS
After watching this video; you will be able to use SQL Server to restore databases.
-
SQL; DDL; and DML
After watching this video; you will be able to describe the purpose of SQL; DDL; and DML statements in the context of SQL Server.
-
Table and Column Properties
After watching this video; you will be able to define the table and column properties such as collation; data type; size; and field properties in the context of SQL Server examples.
-
Table Design
After watching this video; you will be able to define the standards used in tables for data storage such as removing duplicates; breaking down fields; and the use of primary keys in the context of SQL Server examples.
-
Transactions
After watching this video; you will be able to use transactions with SQL server to ensure data and referential integrity.
-
Truncating Tables
After watching this video; you will be able to compare TRUNCATE to DELETE and use the TRUNCATE command to remove data from a SQL Server table.
-
Using Aggregate Functions
After watching this video; you will be able to use SQL Server aggregate functions; COUNT; AVG; MIN; MAX to return specific result sets.
-
Using Cross Joins
After watching this video; you will be able to use CROSS JOINS to retrieve data from multiple SQL Server tables.
-
Using DML Statements
After watching this video; you will be able to use DML statements to query; update; and delete data in a SQL Server database.
-
Using SELECT statements
After watching this video; you will be able to use SELECT statements to query tables and columns.
-
Overview of Normalization
After watching this video; you will be able to describe the purpose of normalizing relational databases.
-
Creating Tables
After watching this video; you will be able to using SMSS and DDL; create SQL Server tables and define their properties.
-
Updating Data
After watching this video; you will be able to describe how data is updated to a SQL Server database and use appropriate UPDATE statements.
-
Deleting Data
After watching this video; you will be able to use DELETE to delete data from single or multiple SQL Server tables.