Lecture 1.1 - Introduction to Microsoft SQL Server

Lecture 1.2 - Introduction to Microsoft SQL Server

Lecture 1.3 - Introduction to Microsoft SQL Server

Lecture 2.1 - Select and Where

Lecture 2.2 - Select and Where

Lecture 2.3 - Select and Where

Lecture 3.1 - SQL Sub Languages - Order By Clauses

Lecture 3.2 - SQL Sub Languages - Order By Clauses

Lecture 4.1 - Any - All - Select Into - Insert Into - Case

Lecture 4.2 - Any - All - Select Into - Insert Into - Case

Lecture 5.1 - Delete - Top - Aggregate Functions - Wild Cards

Lecture 5.2 - Delete - Top - Aggregate Functions - Wild Cards

Lecture 6.1 - Insert - Update - Is Null Commands

Lecture 6.2 - Insert - Update - Is Null Commands

Lecture 6.3 - Insert - Update - Is Null Commands

Lecture 7.1 - In - Between - Table Alias

Lecture 7.2 - In - Between - Table Alias

Lecture 8.1 - SQL Comments - SQL Operators

Lecture 8.2 - SQL Comments - SQL Operators

Lecture 9.1 - Joins

Lecture 9.2 - Joins

Lecture 10.1 - Union All - Union - Group By - Having - Exists - Not Exists

Lecture 10.2 - Union All - Union - Group By - Having - Exists - Not Exists

Lecture 11.1 - Null Functions - Transact SQL

Lecture 11.2 - Null Functions - Transact SQL

Lecture 12.1 - Examples - If - Conditional Statements

Lecture 12.2 - Examples - If - Conditional Statements

Lecture 13.1 - Goto Statement - Looping Construct

Lecture 13.2 - Goto Statement - Looping Construct

Lecture 14.1 - Sub Programs - Stored Procedures

Lecture 14.2 - Sub Programs - Stored Procedures

Lecture 15.1 - Stored Procedure Examples

Lecture 15.2 - Stored Procedure Examples

Lecture 16.1 - Modifying and Dropping a Stored Procedure

Lecture 16.2 - Modifying and Dropping a Stored Procedure

Lecture 17.1 - Dynamic Queries - Procedure Returning Values - Functions

Lecture 17.2 - Dynamic Queries - Procedure Returning Values - Functions

Lecture 18.1 - Break - Continue - Exception Handling

Lecture 18.2 - Break - Continue - Exception Handling

Lecture 19.1 - Structured Exception Handling

Lecture 19.2 - Structured Exception Handling

Lecture 20.1 - Multiple and Nested Try Catch Blocks

Lecture 20.2 - Multiple and Nested Try Catch Blocks

Lecture 21.1 - Using Anonymous Block - Table Valued Functions

Lecture 21.2 - Using Anonymous Block - Table Valued Functions

Lecture 22.1 - Backup DB - Differential Example - DDL Statements

Lecture 22.2 - Backup DB - Differential Example - DDL Statements

Lecture 23.1 - User Defined DB - Creating DB with GUI - Query - Commands

Lecture 23.2 - User Defined DB - Creating DB with GUI - Query - Commands

Lecture 24.1 - Database Constraints and Domain Integrity Constraints

Lecture 24.2 - Database Constraints and Domain Integrity Constraints

Lecture 25.1 - Primary Key and Composite Key

Lecture 25.2 - Primary Key and Composite Key

Lecture 26.1 - Creating 1-to-1 Relationship - Indexes

Lecture 26.2 - Creating 1-to-1 Relationship - Indexes

Lecture 27.1 - Views and Types of Views

Lecture 27.2 - Views and Types of Views

Lecture 28.1 - Auto Increment - SQL Date Operations

Lecture 28.2 - Auto Increment - SQL Date Operations

Lecture 29 - Hosting

Topics covered in this video: a) Replication, b) Replication Set Members, c) Replication Data Availability .......... Objectives of this video: a) Introduction to Replication? b) How to check the data availability for replica set members?

Topics covered in this video: a) Replication Set Deployment, b) Member Configuration Deployment, c) Export and Import Files .......... Objectives of this video: a) How to deploy the replication in local environment? b) How to configure the replica members? c) How to export and import json or csv file to mongo?

Topics covered in this video: a) Sharding .......... Objectives of this video: a) What is Sharding? b) Explain the usage of Sharding in brief.

Topics covered in this video: a) MongoDB Administration, b) MongoDB Back Methods .......... Objectives of this video: a) What is Administration in MongoDB and how it is done? b) How to set Profiling in mongo?

This video comprehends the terms Oracle Database which is an object-relational database management system developed and marketed by Oracle Corporation. Oracle Database is commonly referred to as Oracle RDBMS or simply Oracle.

This topic will cover, DBCA which can create Standby Databases directly, but with some restrictions, like only for Single Instance Databases and only non-container Databases.

In this tutorial, you will learn how to use the Oracle create user statement to create a new user in the Oracle database. The create user statement allows you to create a new database user which you can use to log in to the Oracle database.

In this video you will learn about the an Oracle database which is made up of physical and logical structures. Physical structures can be seen and operated on from the operating system, such as the physical files that store data on a disk.

In this tutorial you will know about the Oracle Database creates and manages information that is used to roll back, or undo, changes to the database. Such information consists of records of the actions of transactions, primarily before they are committed. These records are collectively referred to as undo.

In this video you will learn about the Oracle Flashback Technology which is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

In this tutorial you will learn about the installing Oracle Database, which is a fully functional database with a client/server network environment that has been minimally configured. This chapter helps you configure your server network.

In this tutorial we will learn about the Locking which protect table when several users are accessing the same table. Locking is a concurrency control technique in oracle. It helps in data integrity while allowing maximum concurrency access to data. Oracle offers automatic locking whenever situation requires.

In this video tutorial you will learn about the Auditing which is the monitoring and recording of configured database actions, from both database users and non-data base users.

In this session you will learn about the Oracle Data Pump technology which enables very high-speed movement of data and metadata from one database to another.

This tutorial teaches you about the Backup and recovery procedures which protect your database against data loss and reconstruct the data, should loss occur. The reconstructing of data is achieved through media recovery, which refers to the various operations involved in restoring, rolling forward, and rolling back a backup of database files.

In this video you will learn about the backup recovery scheme which you devise for an Oracle database, operating system backups of the database's datafiles and control files are absolutely necessary as part of the strategy to safeguard against potential media failures that can damage these files.

This tutorial teaches you the Recovery processes which are dependent on the type of failure that occurred, the structures affected, and the type of recovery that you perform. If no files are lost or damaged, recovery may amount to no more than restarting an instance. If data has been lost, recovery requires additional steps.

This session teaches you the Recovery Manager (RMAN which is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering database files.

In this video you will learn about the Oracle offers which is a wide range of migration services to help you optimize your usage of Oracle technology. Through the use of tools, resources, and proven best practices, Oracle can provide support for migrating from legacy or non-Oracle technologies to Oracle.

In this video get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus, explore T-SQL scripts, database queries, and data types

In this video learn basic of SQL Programming and overview the SQL basic commands and how we use these commands in SQL Programming. This SQL tutorial will teach you basics on how to use SQL in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

In this video we talk about DDL (DATA DEFINATION LANGUAGE) and also cover all the basic techniques of DDL.In this video we will learn about the SQL commands – DDL, DML, DCL; SQL Constraints – Keys, Not Null, Check , Default, and also MYSQL Hands-on and basic Querying

In this video session we learn SQL commands and how to use these commands like select command, insert command, delete command etc. In this video we will learn about hands-on experience on the terminal, creating database, Tables and manipulating data.

In this video we learn about SQL Basic and Aggregate Functions and also cover different functions of SQL. This tutorial teaches us about clauses and the update command. We will also cover making records, updating and modifying rows.

In this session we talk about SQL Regular Expression and we also cover all techniques of SQL Regular Expression.This tutorial teaches us about clauses and the update command. We will also cover making records, updating and modifying rows and EML commands.

In this video we learn about SQL Comparison Clauses and how we use Comparison Clauses in SQL. This tutorial covers Comparison Operators by relating values by a mathematical symbol which is used to compare two values. Learn about comparison operators result - TRUE, FALSE, or UNKNOWN

In this session we learn about SQL String and also cover all types of string in SQL and how we can use SQL Strings. In this video we will learn about the basic string functions such as concat_ws, file format, and insert function, L-case, u case, and lower case. We will also learn about basic functions such as upper functions.

In this session we cover advance level string function and also cover all different commands we use in SQL String Function. This video is a sequel for string functions tutorial. In this tutorial we will learn few most useful string functions such as spaces and null issue as well, L-Pad command.

In this SQL String function part 3 we learn select Repeat function and Select Replace function and also cover different between Select Repeat function and Select Replace function. This tutorial is another sequel to string functions, however, these functions are used less and not used that frequently. We will further learn here about the repeat function, absolute function, ceiling, and floor and down functions.

In this session we learn about SQL Numeric Functions and how we use Numeric functions in SQL. In this video, we will be covering numerical functions. Learn about the basic date functions and also about truncate functions.

In this video session we learn about SQL Numeric Function and also cover the basic functionality of SQL Numeric Function. SQL Data Functions. In this video we will learn about few more Date functions. We will further look into the day function option as well. This tutorial covers basic querying over a single table.

: In this video we talk about SQL Joins Introduction and Demonstration and basic join’s function and how to make table using joins. In this tutorial learn about joints in SQL. This tutorial teaches us how to connect two different tables with joints. We will also cover the topic of querying two or more tables and about subquery .

In this lecture last session we talk about MySQL Workbench and procedures and Views and MySQL Workbench functionality. In this tutorial learn about SQL in automating things. This tutorial covers stroll procedure, functions and views which are helpful for automation purposes in SQL.