Sql Development For Beginners

BEGINNING OF PART I Preview 00:32

PART I begins here.

Installing Oracle 12c in Windows 10 Preview 12:11

How to download Oracle 12c software from Oracle's Website and install it in you Windows PC or a Windows Laptop.

Self Test - Oracle Installation

Questions about Oracle Installation

Using SQL Developer Preview 02:11

This lecture explains about how to connect to a Oracle Database using SQL Developer. Oracle SQL Developer is a tool provided for Oracle, to interact with Oracle Databases. Oracle SQL Developer tool can be used to develop programs for Oracle Database.

Troubleshooting Connection Issues Preview 03:26

If you are not able to connect a Oracle Database using Oracle SQL Developer tool, then use this lecture for troubleshooting. 

Client Server Architecture Preview 02:22

The lecture explains about Client Server Architecture. Client Server architecture is a two system architecture where one system serves as a Server or a provider while the other acts as the client or consumer.

Different types of Clients Preview 04:02

This lecture explains about the various types of clients used to access Oracle Database along with the type of database driver needed such as, ODBC, JDBC, OCI etc.

Quick Overview of Oracle RDBMS Architecture Preview 05:18

Gives a simplified, high level overview of Oracle RDBMS System

Connecting to an Oracle Database Preview 02:25

This lecture explains about connecting to an Oracle Database.

Demo - Connecting as SYSDBA Preview 02:06

Hands-on lab: Connect as SYSDBA

LAB - Connecting as SYSDBA Preview 00:07

LAB - Hands on with connecting as SYSDBA

DEMO - Stopping an Oracle Database Preview 01:20

This hands-on lecture explains about Stopping an Oracle Database.

LAB - Stopping an Oracle Database Preview 00:14

LAB - Hands on with Stopping an Oracle Database

DEMO - Starting an Oracle Database Preview 03:18

Explains about starting an Oracle Database.

LAB - Starting an Oracle Database Preview 00:26

Hands on with Starting an Oracle Database

What is a Table? Preview 02:00

This lecture explains about a Table.

Data Types Preview 02:01

This lecture explains about Data Types

Basics of a SELECT Statement Preview 02:38

The lecture explains the basics of a SELECT statement

DESCRIBE Command - DESC Preview 01:43

Explains about DESCRIBE command which is used to get the Column level information of a Table.

LAB - DESCRIBE or DESC Command Preview 00:01

LAB work on DESCRIBE Command

SELECT COUNT - Find the total number of Rows Preview 00:46

This lecture explains about how to find the total row count of a Table.

LAB - SELECT COUNT Preview 00:04

LAB for SELECT COUNT syntax

DBA_TABLESPACES Preview 01:01

Explains about DBA_TABLESPACES

LAB - DBA_TABLESPACES Preview 00:09

SELECT and understand the data from DBA_TABLESPACES

Selecting Particular Columns Preview 01:46

Learn about Selecting the columns that we want instead of all the columns from a Table.

LAB - Selecting Particular Columns Preview 00:16

Lab about selecting a set of columns that we want instead of all the columns from a Table.

WHERE Clause - Basics Preview 02:22

Explains the basics of a WHERE clause.

LAB - WHERE Clause Preview 00:04

Hands on with WHERE Clause

Oracle Database User Architecture Preview 05:58

Gain knowledge about how Oracle Users and Schemas work.

Schema Vs User Preview 00:45

Compares Oracle Schema and Oracle User

How objects are stored? Preview 01:03

Explains the fundamental principles of how objects are stored within a database.

Accessing the Objects Preview 00:54

Explains the fundamental principles of accessing objects within a database.

Classification of SQL Commands Preview 02:54

Provides information about SQL Classifications as well as the Commands included in each classification

DML - Data Manipulation Language Preview 01:11

DDL - Data Definition Language Preview 01:13

DCL - Data Control Language Preview 00:28

Explains about Data Control Language

TCL - Transaction Control Language Preview 00:19

Explains about Transaction Control Language

Create a User Preview 02:30

The students will learn about how to create a user.

LAB - Create a User Preview 00:10

LAB Work: Hands-on with creating a user

Create a Table Preview 01:22

Explains about how to create a Table.

LAB - Create a Table Preview 00:17

Lab: Hands-on with CREATE TABLE statement

Basics of DML Preview 01:35

Explains the basics of DML statements

DML - SELECT STATEMENT Preview 00:36

Explains about SELECT statement

DML - INSERT STATEMENT Preview 01:39

Explains about the structure of an INSERT statement.

LAB - DML - INSERT Fails. Why? Preview 00:18

The INSERT has failed. Why?

DBA Info - METADATA Preview 01:11

What is METADATA? - This course explains about it.

DBA Info - DATA DICTIONARY Preview 00:34

Explains about Oracle Database's DATA DICTIONARY

DBA Info - DEFAULT PERMANENT TABLESPACE Preview 03:12

DML - Fixing the Failed INSERT Preview 00:28

The course explains about fixing the INSERT statement that failed earlier.

Demonstration of the commands to fix the INSERT Preview 03:31

Demonstrating the fix commands for the failed INSERT statement.

LAB - Demonstration of the commands to fix the INSERT Preview 00:32

LAB - Hands on with the commands to fix the INSERT

DML - UPDATE STATEMENT Preview 02:08

Explains about UPDATE statement

Demo of an UPDATE STATEMENT Preview 01:27

Demonstrating the UPDATE statement

LAB - DML - UPDATE Preview 00:09

LAB - Hands on with UPDATE statements

DML - DELETE STATEMENT Preview 01:08

Explains about DELETE statements

Demo - DELETE STATEMENT Preview 01:09

Demonstrating a DELETE statement

LAB - DML - DELETE Preview 00:08

LAB - Hands on with a DELETE statement

DML - MERGE STATEMENT Preview 00:13

We will take a look at MERGE statement later

TCL - Basics Preview 01:17

Basics of Transaction Control Language which is commonly referred as TCL.

Definition of a Transaction Preview 00:24

This lecture narrates the definition of a Transaction.

What is a Transaction? Preview 03:56

This lecture narrates an example scenario about Transactions.

Demo of a Transaction Preview 02:06

This lesson show demo of three individual transactions. Two are single DML transactions and one transaction involves two DMLs.

LAB - TCL - Transactions Preview 00:12

Lab: Hands-on with Transactions

DBA Info - Internal handling of Transaction through REDO Preview 03:41

Part 1 of 2: How does Oracle handle a transaction? This lesson explains about REDO Concept.

DBA Info - Internal handling of Transaction through UNDO Preview 03:07

Part 2 of 2: How a transaction is being handled? This lesson explains about the use of UNDO.

TCL - COMMIT STATEMENT Preview 01:56

Explains about COMMIT and some of its options as suitable for this beginners course

TCL - COMMIT Demo Preview 02:54

Demonstration of COMMIT commands

LAB - TCL - COMMIT STATEMENT Preview 00:18

LAB: Hands-on for COMMIT related commands

TCL - ROLLBACK STATEMENT Preview 01:38

Explains the ROLLBACK statement

LAB - ROLLBACK STATEMENT Preview 00:08

LAB - Hands on for ROLLBACK statements

TCL - SAVEPOINT STATEMENT Preview 01:59

This lesson explains about SAVEPOINTS. SAVEPOINTS are used saving part of your changes by doing partial rollback instead of full rollback.

TCL - SAVEPOINT Demo Preview 02:14

Demonstration of SAVEPOINTS.

LAB - TCL - SAVEPOINT Preview 00:17

LAB - Hands on with SAVEPOINT's usage scenario.

DCL - GRANT STATEMENT Preview 00:38

Explains about GRANT statement

DCL - SYSTEM PRIVILEGES Preview 00:29

Explains about SYSTEM PRIVILEGES

DCL - OBJECT PRIVILEGES Preview 00:35

Explains about Object Privileges

DCL - ROLE PRIVILEGES Preview 00:55

Explains about ROLE PRIVILEGES

DCL - REVOKE STATEMENT Preview 00:22

Explains about REVOKE statements

DCL - GRANT and REVOKE - FULL DEMO Preview 05:40

Full demonstration of GRANT and REVOKE statements.

LAB - GRANT and REVOKE - FULL DEMO Preview 00:32

LAB: Hands on with GRANT and REVOKE statements

DBA Info - Find the DBAs Preview 01:09

By the way, who are my DBAs?

LAB - Find the DBAs Preview 00:06

Lab: Hands-on about finding the users who have been granted the DBA privilege. As well as list the system privileges granted to the DBA role.

DDL - CREATE STATEMENT Preview 00:41

Let us take a quick look at CREATE Statements

DDL - ALTER STATEMENT Preview 00:21

Explains about ALTER Statements

DDL - DROP STATEMENT Preview 00:24

Explores the DROP statement

DDL - RENAME STATEMENT Preview 00:25

Let us explore the RENAME statement.

DDL - TRUNCATE STATEMENT Preview 00:14

Let us explore TRUNCATE statement

DDL - TRUNCATE vs DELETE Preview 00:30

Let us compare TRUNCATE and DELETE statements.

DDL - COMMENT STATEMENT Preview 00:27

Let us explore COMMENT statement

ALL THE DDL STATEMENTS - FULL DEMO Preview 08:24

Full demonstration of all the DDL Statements

LAB - DDL STATEMENTS Preview 01:24

LAB: Hands-on with all the DDL Statements

Addressing the Objects Preview 01:19

Explains about addressing the objects.

OLTP - Online Transaction Processing System Preview 00:56

Brief look at Online Transaction Processing Systems

DSS - Decision Support System Preview 00:48

A brief look at Decision Support System Databases

DATA MODELING - ENTITY RELATIONSHIP MODEL or ER MODEL Preview 01:01

Introducing Data Modeling, which is planning the structure of the objects and the data in an RDBMS

ER MODEL - CREATION & NORMALIZATION Preview 10:31

Let's create a Data Model from scratch and Normalize it.

ER MODEL - CONCEPTUAL MODEL Preview 00:54

Explains about Conceptual Modeling, which is the first part in an ER Model.

ER MODEL - LOGICAL MODEL Preview 00:56

Explains about Logical Modeling aspects, which is the second stage of an ER Model.

ER MODEL - PHYSICAL MODEL Preview 00:41

Explains about Physical Model, which is the final stage of an ER Model.

ER MODEL vs ER DIAGRAM Preview 00:30

Compares ER MODEL with ER DIAGRAM, often referred as ERD.

ENTITY, ATTRIBUTE, TUPLE & RELATIONSHIPS Preview 01:51

Explains how an ENTITY, ATTRIBUTE, TUPLE and RELATIONSHIP from a Data Model are actually transformed during the actual implementation.

ENTITY becomes a TABLE; ATTRIBUTE becomes a COLUMN; TUPLE is a ROW; RELATIONSHIPS are implemented by PRIMARY KEY and FOREIGN KEY constraints.

Beginning of Part II Preview 00:06

PART II begins here.

Data for this Section Preview 00:41

Run the commands in the TST user to create the data for this section.

SELECT EVERYTHING Preview 00:55

Let us SELECT all the data from a TABLE.

SELECT PARTICULAR COLUMNS Preview 00:36

Selecting all the data from particular columns of a Table.

Filtering Data using WHERE Clause Preview 00:44

How to use the WHERE clause?

JOIN Two Tables Preview 02:03

A Simple JOIN of Two Tables.

LAB - JOIN Two Tables Preview 00:08

LAB: Hands-on for Joining Two Tables.

PROJECTION, SELECTION & JOINING Preview 01:19

Explains about Relational Theory in Mathematics which is the basis of any RDBMS system. A SELECT statement is based on three Relational Theory concepts called, PROJECTION, SELECTION and JOINING.

Mandatory and Optional Clauses of a SELECT Statement Preview 00:39

Explains about the Mandatory and Optional Clauses of a SELECT Statement in Oracle.

ORACLE RESERVED WORDS Preview 00:56

Explains about certain words that are reserved for Oracle's internal use.

LOWER and UPPER CASE in SQL Statements Preview 02:57

Explains about how lower and upper cases in SQL Statements are handled by Oracle.

LAB - LOWER and UPPER CASE in SQL Statements Preview 00:09

LAB: Hands-on with lower and upper case SQL Statements.

SQL STATEMENT TERMINATORS Preview 01:45

Explains about SQL Statement Terminators and how to use them.

STRUCTURE OF A TABLE - DESCRIBE COMMAND Preview 01:29

How to find the structure of a Table? Let's explore using DESCRIBE or DESC Command.

SELECT EVERYTHING - SELECT * Preview 01:20

Let us select every rows of a table using SELECT * Syntax.

FIND THE TOTAL NUMBER OF ROWS - COUNT (*) Preview 00:51

Use SELECT COUNT(*) to find the total number of rows of a table.

LAB - For this Entire Section Preview 00:10

LAB: Hands-on for this entire section.

To Quote or Not to Quote..! Preview 02:29

Explains about using single quotes to select literals, even the ones that aren't there in the table we are selecting from.

DUAL has a DUMMY with an X – Wait, What? Preview 01:40

Explains about the structure and purpose of the DUAL table.

Excuse me, Who am I and What is today's date please? - SYSDATE Preview 00:57

Explains about some frequently used scenarios with regard to DUAL table.

LAB - For this Section Preview 00:12

Additions and Subtractions ( + and - ) Preview 01:19

How to do Addition and Subtractions in a SQL Statement.

Multiplication and Division ( * and / ) Preview 01:08

How to do Multiplication and Division using SQL Statements.

Order of Precedence between Multiple Operators Preview 02:58

In an expression containing multiple arithmetic operations, which Operation gets solved first.

Changing the Order of Precedence using Parenthesis Preview 01:26

How to change the Order of Precedence using Parenthesis.

Arithmetic Operations on Tables Preview 01:19

Performing Arithmetic Operations on Tables

LAB - For this Section Preview 00:17

LAB: Hands on for this section.

Alias for Columns Preview 02:43

How to create alias for columns in the result-sets.

CONCATENATION - Creating Sentences from the Data Preview 02:19

Let us make sentences out of the data.

Exception for Inner Single Quotes Preview 01:36

What if the inner string already has a single quote? It will interfere with the encompassing single quotes. So how can we address it?

Replacing the Quote Delimiters Preview 02:58

I use large sentences with lots of single quotes and adding extra single quotes is confusing. Is there a easy way? Yes. We can replace the single quote operators if needed.

LAB - For this Section Preview 00:28

LAB: Hands on for this Section

DISTINCT - Avoiding Duplicates in the Results Preview 01:34

Let us avoid duplicates in the results using DISTINCT keyword

LAB - For DISTINCT Preview 00:06

LAB - DISTINCT is so distinct, so that I decided to keep a distinct section for it

Unlocking the HR Schema and Connecting Preview 02:43

Let us unlock the HR schema, which is one of the sample schemas provided by Oracle and log in as it.

Explore a Schema using SQL Developer Preview 02:05

Let us explore a schema using SQL Developer

LAB - For this Section Preview 00:12

Lab: Hands on for this section

NULL Values Preview 02:47

Explains about NULL concept. NULL means NO DATA.

Retrieving NULL Values - IS NULL Preview 01:44

How to SELECT rows with NULL values? By using the 'IS' operator.

Retrieving NON-NULL Values - IS NOT NULL Preview 01:06

Explains about retrieving non-null values.

Arithmetic Operations on NULL Values Preview 01:59

Explains about performing arithmetic operations on NULL values.

Concatenation on NULL Values Preview 02:36

Explains about how CONCATENATION works with NULL Values.

Substituting NULL Values in the Results Preview 02:28

Explains about how to substitute NULL values, just in the results.

LAB - For this Section Preview 00:33

LAB - Hands on for this Section

Use the ORDER BY clause to sort SQL query results Preview 02:24

Using the ORDER BY clause to sort the results in Ascending, Descending orders.

Sorting NULL Values and Expressions Preview 02:12

1. Sorting NULL values using NULLS FIRST & NULLS LAST keywords.
2. Sorting the results based on Expressions in the SQL

Positional and Composite Sorting Preview 02:44

Explains about sorting the SQL Results using the position of the columns in the SELECT clause as well as sorting using multiple columns, which is called as Composite Sorting.

Limiting the Rows with a WHERE clause Preview 03:08

Explains about limiting the rows with a WHERE clause.

Column based and Date based Conditions in WHERE clause Preview 03:41

Explains about limiting rows using column and date comparisons. Also explains about the date format, DD-MON-RR.

LAB - For this Section Preview 01:14

Lab: Hands-on for ORDER BY Clause statements that we saw in the previous few lessons.

INEQUALITY OPERATORS - GREATER THAN & LESS THAN Preview 02:39

Explains about GREATER THAN and LESSER THAN operators in a WHERE clause

COMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO Preview 02:09

Explains about Composite Inequality Operators which comprises of more than one symbols.

COMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO Preview 01:57

Explains about NOT EQUAL TO operations

INEQUALITY OPERATORS ON DATE VALUES Preview 01:53

Explains about using inequality operators on Date values

RANGE COMPARISON - BETWEEN OPERATOR Preview 02:24

Explains about BETWEEN operator.

SET COMPARISON - IN OPERATOR Preview 02:18

Explores about SET comparison operator, IN.

LAB - For this Section Preview 00:43

LAB - Hands on for this section

LIKE OPERATOR - WITH WILDCARDS % AND _ (UNDERSCORE) Preview 03:32

This lesson explores very comprehensively about the wildcards % and _ in Pattern Matching. It also takes a look at how these wildcards behave in various scenarios.

LIKE OPERATOR - HANDS ON Preview 05:15

This lesson demonstrates all the scenarios that were explored in the previous lesson.

PATTERN COMPARISON - ESCAPE CHARACTER Preview 03:26

What if the actual data contains wildcard characters? How can we retrieve data when the data itself has some wildcard characters?

LAB - For this Section Preview 00:33

LAB - Hands on for this section

BOOLEAN or LOGICAL OPERATORS - CONCEPTS Preview 02:44

The concept behind Boolean Operators

BOOLEAN OPERATOR - OR Preview 05:05

Explains about the Boolean Operator - OR

BOOLEAN OPERATOR - AND Preview 02:46

Explains about the AND operator

BOOLEAN OPERATOR - NOT Preview 02:17

Explores NOT operator in the Boolean Context, where two conditions are compared. This context is not the same as the comparator operators in the context of  NOT EQUAL TO, IS NOT NULL etc.

BOOLEAN OPERATORS - HANDS ON DEMO Preview 04:41

Demonstration of all the Boolean Operators explained in this section.

LAB - BOOLEAN OPERATORS Preview 00:21

LAB - Hands on with Boolean Operators

SUBSTITUTIONS - USING AMPERSANDS, DEFINING AND UNDEFINING THE VARIABLES Preview 02:32

Explores about using Ampersands to construct SQLs dynamically. Also explains about how to DEFINE and UNDEFINE variables.

SUBSTITUTIONS - DOUBLE AMPERSANDS Preview 04:37

Explores about using Double Ampersands, SET VERIFY ON, SET VERIFY OFF etc

LAB - For this Section Preview 01:43

LAB - Hands on for this Section.

FUNCTIONS - INTRODUCTION Preview 03:44

Introducing Functions. This lesson explains about Functions in Oracle. This also explains about how Functions have been classified into Single Row Functions and  Group Functions.

NUMERICAL SINGLE ROW FUNCTIONS Preview 06:01

Examples of Single Row Numerical Functions.

CHARACTER BASED SINGLE ROW FUNCTIONS Preview 05:14

Explores character based single rows functions such as CHR, CONCAT, UPPER, LOWER, INITCAP, LPAD, RPAD, LTRIM, RTRIM, REPLACE, SUBSTR etc

LAB I - For this Section Preview 00:39

LAB - Hands on for this section

CHARACTER FUNCTIONS WITH NUMERICAL RESULTS Preview 02:29

Explores Character based functions that return numerical values such as ASCII, INSTR, REGEXP_COUNT, LENGTH and LENGTHB

DATETIME FUNCTIONS INTRODUCTION Preview 05:41

Let us explore how the Date and Time values are handled within an Oracle Database.

DATE AND TIME FUNCTIONS - MORE FUNCTIONS Preview 07:49

Exploring more Date and Time functions such as

• TO_CHAR
• ADD_MONTHS
• EXTRACT
• LAST_DAY
• CURRENT_TIMESTAMP
• LOCALTIMESTAMP
• MONTHS_BETWEEN
• ROUND
• TRUNC
• NEW_TIME
• NEXT_DAY
• SYSTIMESTAMP
• SYS_EXTRACT_UTC
• TO_TIMESTAMP
• TO_TIMESTAMP_TZ
• CAST

DATE AND TIME FUNCTIONS - TO_DATE Preview 03:17

TO_DATE is a very important conversion function. It is used to convert a character string into a date value.

COMPARISON FUNCTIONS - GREATEST AND LEAST Preview 01:37

Explores about comparison functions, GREATEST and LEAST.

LAB II - For this Section Preview 00:54

LAB II - Hands for this section

AGGREGATE FUNCTIONS - GROUPS and SUBGROUPS Preview 04:18

Explores about Aggregate Functions which are also knows as Group Functions. This lesson also explores about GROUP BY clause and the need for it.

AGGREGATE FUNCTIONS - EXAMPLES Preview 05:54

Explores various aggregate functions such as

• COUNT(*)
• COUNT(COLUMN_NAME)
• DISTINCT
• GROUP BY clause
• APPROX_COUNT_DISTINCT
• AVG
• MIN
• MAX
• SUM

FILTERING AGGREGATE FUNCTIONS - HAVING CLAUSE Preview 02:40

Explores about filtering the result set of an aggregate function using the HAVING clause.

LAB - For this Section Preview 00:40

LAB - Hands on for this section

CONDITIONAL FUNCTIONS - NVL, NVL2 and NULLIF Preview 03:16

Explores conditional functions such as

• NVL
• NVL2
• NULLIF

CONDITIONAL FUNCTIONS - DECODE and CASE Preview 03:50

Learn about DECODE and CASE function, which serve as IF THEN ELSE functions.

LAB - For this Section Preview 00:26

LAB: Hands on for this Section

BASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN Preview 06:15

Explains about the basics of how two tables are joined. And it starts with a Cartesian Product which also known as CROSS JOIN.

BASICS OF A JOIN - AMBIGUOUS COLUMN NAMES Preview 02:21

Explores about identifying the columns with same names, precisely with a table name qualifier in front of those, to avoid ambiguous column name error in a JOIN.

DEMO - CARTESIAN PRODUCT OR CROSS JOIN Preview 01:57

Demonstration of a Cartesian Product, also known as CROSS JOIN.

DEMO - AMBIGUOUS COLUMN NAMES Preview 02:27

Demonstration of preventing AMBIGUOUS COLUMN NAMES by qualifying columns with Table Names in front of them. Also using aliases to keep the SQLs simple and readable.

EQUIJOIN - OLD METHOD Preview 02:47

Introduces EquiJoins and explains about the old traditional method implemented till Oracle 9i for a JOIN. Old methods used to perform joins in the WHERE clause.

EQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE Preview 02:15

Exploring the EQUIJOIN using one of the ANSI standards which uses JOIN ON clause.

EQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE Preview 04:18

Explores about JOIN USING clause in joining

EQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE Preview 02:09

Explores about NATURAL JOINS

NON-EQUIJOINS Preview 02:09

Explores about Non-equijoins.

OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS Preview 02:36

Explores about OUTER JOINS. Also explains about the various types of OUTER JOINS which are LEFT OUTER JOIN, RIGHT OUTER JOIN and FULL OUTER JOIN.

DEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS Preview 01:52

Demonstrating the OUTER JOINS. This includes the demonstration of LEFT OUTER JOIN, RIGHT OUTER JOIN and FULL OUTER JOIN.

LAB - For this Section Preview 02:10

LAB: Hands on for this entire section

SUBQUERIES - DEFINITION AND SUBQUERY IN THE SELECT CLAUSE Preview 03:09

Explains about Subqueries and their use. Also gives an example of subquery being used in the SELECT clause

SUBQUERY - IN THE WHERE CLAUSE Preview 03:35

Example of a SUBQUERY in the WHERE clause

SUBQUERY - IN THE FROM CLAUSE Preview 02:07

Using Subqueries in the FROM clause.

SUBQUERY - IN DMLs - IN INSERT UPDATE DELETE Preview 03:14

Example of using subqueries in the DML statements such as INSERT, UPDATE and DELETE statements.

LAB - For this Section Preview 00:43

LAB: Hands on for this section

UNION - COMBINING ROWS FROM TWO QUERIES WITHOUT DUPLICATES Preview 04:51

The SET operator UNION, combines the rows from two or multiple queries, sorts the results and removes the duplicates.

UNION ALL - COMBINING ROWS FROM TWO QUERIES WITH DUPLICATES Preview 02:55

UNION ALL combines the results from multiple queries without removing the duplicates. It also doesn't sort the output. So generally an UNION ALL operator is faster than UNION operator.

INTERSECT - FETCHING THE COMMON ROWS FROM THE RESULTS Preview 02:05

An INTERSECT operator fetches the rows that are common in the results of the queries. This also sorts the results as well as removes the duplicates.

MINUS - FIRST RESULT SET MINUS SECOND RESULT SET Preview 03:51

A MINUS operator, takes the first result set, then removes the rows that are common between the first result set and the second result set, and produces the remaining rows of the first result set after removing the duplicates and sorting.

LAB - For this Section Preview 01:00

LAB: Hands on for this section.

INSERT - VARIOUS METHODS OF INSERTING DATA Preview 04:49

Explores about various methods of inserting data.

UPDATE - VARIOUS METHODS OF UPDATING DATA Preview 03:34

Explores about various methods of updating data using UPDATE statements.

DELETE - VARIOUS METHODS OF DELETING DATA Preview 02:02

Explores about various methods of deleting data from a table using DELETE statements.

LAB - For this Section Preview 00:51

LAB: Hands on for this section.

NULL - DEFAULT Preview 01:55

NULL - Allowing NULL values is one of the default properties of a Column in a Table.

NOT NULL CONSTRAINT Preview 02:04

Let us explore about NOT NULL constraint on a Column of a Table.

UNIQUE CONSTRAINT Preview 03:58

Explores about UNIQUE constraints.

PRIMARY KEY CONSTRAINT Preview 02:50

Explores about PRIMARY KEY Constraints. It can be thought of as a combination of UNIQUE and NOT-NULL constraints.

FOREIGN KEY CONSTRAINTS Preview 05:30

Explores about FOREIGN KEY constraints. There are situations where the data at one table must be a subset of data at another table. A FOREIGN KEY can be used for that purpose. It can refer to a PRIMARY KEY. Referencing within a table is also possible.

LAB - For this Section Preview 01:00

LAB: Hands on for this section.

INDEXES Preview 02:24

Introduces Indexes.

CONCLUSION - THANK YOU Preview 00:27

Just a finishing note about what is next.