Learn MongoDB Beginner to Advanced 7 Video course Training DVD

Course 01 
Introduction to MongoDB
Duration 2h 27m 

Course 02
Introduction to Mongoose for Node.js and MongoDB
Duration 1h 41m

Course 03
MongoDB Administration
Duration 7h 20m

Course 04
Big Data & Reporting with MongoDB
Duration 2h 26m

Course 05
Using MongoDB with ASP.NET MVC
Duration 3h 12m

Bonus Course  06
Learning MongoDB
Duration: 7 hours 22 minutes

Bonus Course  07
Learning MongoDB
Duration: 3 hours and 26 minutes

Buy This Course DVD Now @

​

     

Querying Data with Transact-SQL - Certification Exam 70-761 Video Training Course DVD

Querying Data with Transact-SQL - Exam 70-761 Certification Training Course

Prepare to take the Microsoft 70-761 exam and work towards your MCSA: SQL 2016 Database Development Certification

Duration: 6 hours 47 minutes

Chapter: Introduction
 Welcome To The Course 
Course Overview 
Understanding Transact-SQL 
SQL Server 2016 Certifications 
Examples And Code 

Chapter: Understanding Databases
What Is A Database? 08m 7s
Database Structure And Purpose
Database Terminology
Understanding Data Types
Statement Types

Chapter: Getting And Installing SQL Server 2016
 SQL Server 2016 Editions
Getting SQL Server 2016
Installing SQL Server 2016
Installing SQL Server Management Studio
Attaching The Sample Database

Chapter: Basic Select Statements
 Basic Select Structure
Using The Where Clause
Column Aliasing
Using Distinct
Ordering Results
T-SQL Concatenation
Multipart Naming

Chapter: Advanced Select Statements
Like And In
Union
Intersect And Except
Paging Results
Understanding Case Expressions Part - 1
Understanding Case Expressions Part - 2
Using Pivot Part - 1
Using Pivot Part - 2

Chapter: Querying Multiple Tables
 Database Structure
Table Relationships
Using The Join Statement
Table Aliasing
Join Types
Join Types Examples

Chapter: Grouping Data
 Using Built-In Functions
Understanding Group By
Understanding Having
Understanding Grouping Sets
Using The Graphical Query Tool

Chapter: Modifying Data
 Inserting Data
Insert Demo
Insert Select
Select Into
Updating Data
Update Demo
Deleting Data
Delete Demo

Chapter: Programming Objects With T-SQL
 Understanding Stored Procs
Stored Procedure Demo
Using Input Parameters
Using Output Parameters
Understanding Table Variables
Understanding CTEs Part - 1
Understanding CTEs Part - 2
Understanding Masking
Masking Demo

Chapter: User-Defined Functions
 Function Basics
Understanding Scalar Functions
Table-Valued Functions

Chapter: Understanding Subqueries
 Subquery Basics
Scalar Subqueries
Multi-Valued Subqueries
Correlated Subqueries
Chapter: Conclusion

Wrap Up

Buy This Course DVD Now @

​

 

Developing SQL Databases MCSA Certification Exam 70-762 Video Training Course DVD

Developing SQL Databases - Exam 70-762 Certification

Prepare to Take the Microsoft 70-762 Exam and Work Towards Your MCSA: SQL 2016 Database Development Certification

Duration: 8 hours 39 minutes

Chapter: Introduction
Welcome To The Course
Course Overview
Microsoft's SQL Server
SQL Server 2016 Certifications
Examples And Code

Chapter: SQL Server Basics
SQL Server Platform
SQL Server Editions
Understanding Databases
Database Structures
Transact-SQL

Chapter: Getting And Installing SQL Server 2016
 Getting SQL Server 2016
Installing SQL Server 2016
Installing SQL Server Management Studio
Attaching The Sample Database
Verifying The Installation

Chapter: Table Design And Implementation
 Creating The Database
Database Options
Understanding Tables
SQL Server Data Types
Choosing A Data Type
What Is Normalization?
Understanding Relationships
Schemas
Table Design Basics
Creating Tables Using T-SQL
Creating Tables Graphically
Using Identity Columns Part - 1
Using Identity Columns Part - 2
Altering Tables Part - 1
Altering Tables Part - 2

Chapter: Advanced Table Design
 Understanding Data Integrity
Constraints
Primary And Foreign Keys
Adding Constraints Part - 1
Adding Constraints Part - 2
Understanding Filegroups
Table Partitions
Temporal Tables
Working With Temporal Tables Part - 1
Working With Temporal Tables Part - 2
In-Memory Tables Part - 1
In-Memory Tables Part - 2
Generating Scripts

Chapter: Indexes
 Index Basics
Clustered Or Nonclustered Part - 1
Clustered Or Nonclustered Part - 2
Covered Indexes
Creating Indexes
Columnstore Indexes
Managing Indexes
Rebuilding And Reorganizing

Chapter: Views
View Basics
Creating A View
Updateable Views
Indexed Views

Chapter: Transactions
 Understanding Transactions Part - 1
Understanding Transactions Part - 2
Transaction Log
Using Explicit Transactions
Savepoints Part - 1
Savepoints Part - 2

Chapter: Stored Procedures
Stored Procedure Basics
Creating Stored Procedures
Using Input Parameters
Using Output Parameters
Table-Valued Parameters Part - 1
Table-Valued Parameters Part - 2
Return Status Part - 1
Return Status Part - 2
Natively Compiled Stored Procs

Chapter: Triggers
 Understanding Triggers
Instead Of Triggers
After Triggers
Inserted And Deleted Tables

Chapter: User-Defined Functions
Understanding Functions
Scalar Functions
Table-Valued Functions

Chapter: Conclusion
 Wrap Up

Buy This Course DVD Now @

​