Home
Search results “Oracle subquery two columns”
SQL Tutorial 12 Advanced Subqueries returning multiple columns
 
14:22
SQL Tutorial on Advanced Subqueries returning multiple columns Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 56896 Telusko
093-Oracle SQL 12c: Multiple Column Subquery / لقد وقعنا في الفخ
 
10:16
تعلم اوراكل حتى الاحتراف EXAM 1Z0-061 EXAM 1Z0-071
Views: 1093 khaled alkhudari
GROUP BY with Multiple Columns (Introduction to Oracle SQL)
 
04:03
Learn how to group with multiple columns using GROUP BY in SQL. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 978 Database Star
SQL Distinct and Multiple Columns
 
02:52
Jamie King of Neumont University showing how SQL DISTINCT varies when multiple columns are present in the result set.
Views: 18813 Jamie King
SQL ORDER BY With Multiple Columns
 
03:50
Jamie King of Neumont University demonstrating ORDER BY in regards to multiple columns.
Views: 7306 Jamie King
Multi Row Subqueries (Introduction to Oracle SQL)
 
03:55
Explains what a multi row subquery is and what it can be used for. This is a subquery that returns multiple rows, and it needs to be treated differently. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 588 Database Star
Querying Multiple Tables with SQL
 
10:40
Demonstration of how to query two or more tables with SQL Server.
Views: 32434 Larry Domine
Subqueries in sql   Part 59
 
14:34
In this video we will discuss about subqueries in sql server. Let us understand subqueris with an example. Please create the required tables and insert sample data using the script below. Create Table tblProducts ( [Id] int identity primary key, [Name] nvarchar(50), [Description] nvarchar(250) ) Create Table tblProductSales ( Id int primary key identity, ProductId int foreign key references tblProducts(Id), UnitPrice int, QuantitySold int ) Insert into tblProducts values ('TV', '52 inch black color LCD TV') Insert into tblProducts values ('Laptop', 'Very thin black color acer laptop') Insert into tblProducts values ('Desktop', 'HP high performance desktop') Insert into tblProductSales values(3, 450, 5) Insert into tblProductSales values(2, 250, 7) Insert into tblProductSales values(3, 450, 4) Insert into tblProductSales values(3, 450, 9) Write a query to retrieve products that are not at all sold? This can be very easily achieved using subquery as shown below. Select [Id], [Name], [Description] from tblProducts where Id not in (Select Distinct ProductId from tblProductSales) Most of the times subqueries can be very easily replaced with joins. The above query is rewritten using joins and produces the same results. Select tblProducts.[Id], [Name], [Description] from tblProducts left join tblProductSales on tblProducts.Id = tblProductSales.ProductId where tblProductSales.ProductId IS NULL In this example, we have seen how to use a subquery in the where clause. Let us now discuss about using a sub query in the SELECT clause. Write a query to retrieve the NAME and TOTALQUANTITY sold, using a subquery. Select [Name], (Select SUM(QuantitySold) from tblProductSales where ProductId = tblProducts.Id) as TotalQuantity from tblProducts order by Name Query with an equivalent join that produces the same result. Select [Name], SUM(QuantitySold) as TotalQuantity from tblProducts left join tblProductSales on tblProducts.Id = tblProductSales.ProductId group by [Name] order by Name From these examples, it should be very clear that, a subquery is simply a select statement, that returns a single value and can be nested inside a SELECT, UPDATE, INSERT, or DELETE statement. It is also possible to nest a subquery inside another subquery. According to MSDN, subqueries can be nested upto 32 levels. Subqueries are always encolsed in paranthesis and are also called as inner queries, and the query containing the subquery is called as outer query. The columns from a table that is present only inside a subquery, cannot be used in the SELECT list of the outer query. Next Video: What to choose for performance? Queries that involve a subquery or a join Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/subqueries-in-sql-part-59.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-59-subqueries-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 203564 kudvenkat
Oracle Sql :  Lecture 40: GROUP BY with multiple columns
 
05:01
Oracle Sql: GROUP BY with multiple columns https://www.youtube.com/channel/UCnBpiBIOtRgMsk4G7Ri1jbQ
Views: 2064 Oracle SQL
SQL 12c Tutorial :  SQL Sub Queries  IN , ANY, ALL
 
13:04
SQL 12c Tutorial : SQL Sub Queries IN , ANY, ALL SQL 12c Tutorial for beginners Oracle SQL Tutorial for beginners SQL Single Row Sub Queries SQL Multi Row Sub Queries SQL Correlated Sub Queries SQL Inline View
Views: 1745 TechLake
MULTIPLE COLUMS FROM A SUBQUERY - DUNIA CODING
 
09:13
How can I select multiple columns from a subquery (in SQL Server) that should have one record (select top 1) for each record in the main query?
Views: 148 Al-Hawari Channel
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH NULL / NOT IN / NOT EXISTS OR OUTER JOIN
 
08:36
This video demonstrates the oracle sql interview question where one need to use either not in, not exists or an outer join to get the desired result. For example if one is asked to fetch records from department table where department_id is not present in employee table
Views: 1959 Kishan Mashru
MERGING DATA IN MULTIPLE COLUMNS INTO SINGLE COLUMN IN ORACLE
 
03:59
LET US CONSIDER THAT I HAVE DATA IN 2 OR 3 COLUMNS AND I WANT TO MERGE THE DATA INTO SINGLE "COLUMN"..THIS VIDEO TEACHES CLEARLY HOW WE CAN DO THAT IN "ORACLE"..
Views: 1488 P-Square Technologies
Tutorial#33 How to Join  two Columns using concatenation function in Oracle SQL Database
 
06:51
How to concatenate/join/combine two or more columns, string, Number using Concatenation Function or How to Concatenate String and Integer Values in SQL Server or Concatenate String and column by using Concatenation function in Oracle SQL Or How to use Concatenation Function in Oracle database Assignment link: https://drive.google.com/open?id=1u-2Mj-27KxM5FZwRTVXNv7dwXQsAtzkn In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 54 EqualConnect Coach
Find Duplicate Rows in SQL - Select Statement Tutorial
 
02:06
Find duplicate row values in a field or multiple fields in SQL Server table with this tutorial. Do this for one column, or multiple columns. Uses SQL Server Management Studio for the demonstration.
Views: 42832 Edward Kench
SQL Aggregation queries using Group By, Sum, Count and Having
 
10:01
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 169323 Joes2Pros SQL Trainings
How to delete duplicate records from a table in oracle
 
02:01
Let c how to remove duplicates from a table..I have one table here 'student' It has two duplicate records. 3 joe 4 robert These two records has duplicates. So I have to remove them. I can remove them using rowid functionality using one subquery. You can give different column names in GROUP BY clause. to identify the duplicate record. You can give just primary key values also. Duplicate rows are deleted now... Query used in video: delete from student where rowid not in (select min(rowid) from student group by sno,sname); Thanks for watching...:)
Views: 15092 WingsOfTechnology
How to Create Check Constraint on Multiple Columns in SQL Server- SQL Server / TSQL Tutorial Part 84
 
08:53
SQL Server / TSQL Tutorial Scenario: You are working as SQL Server developer, you need to create dbo.Customer table that should have First Name, Age and Age Type columns. You can add CustomerId as Identity. You need to create Check Constraint on Age and Age Type Columns with below logic. Link to scripts used in SQL Server / TSQL Tutorial Video http://www.techbrothersit.com/2016/05/how-to-create-check-constraint-on_2.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 1019 TechBrothersIT
PIVOT Tutorial - generating dynamic column with PIVOT Interview Question SQL
 
14:14
In this lecture you will learn about PIVOT operator and using it to generate dynamic columns.PIVOT is very use full operator to convert values into columns. PIVOT: •Convert your output from (values)vertical order to horizontal(making columns) one Topic to cover: •PIVOT example •PIVOT syntax •Interview Question •PIVOT on northwind •Dynamic PIVOT query http://www.techsapphire.in/index/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/0-158
Views: 28844 techsapphire
SQL Correlated Subqueries
 
07:14
Demonstrates SQL correlated subqueries.
Views: 28967 Jamie King
SQL 11g Tutorial in Bangla # 66 Writing a multiple column subquery
 
25:59
Oracle Database 11g SQL series tutorial in Bangla
Views: 42 Leen's Tech
Getting Started with PL/SQL Table Functions 2. Returning Multiple Columns
 
07:56
In this second module in the series, Steven Feuerstein explores the code you need to write when you want your table function to return an array with multiple columns. Best taken as part of the Oracle Dev Gym PL/SQL Table Functions class: https://devgym.oracle.com/pls/apex/dg/class/pl-sql-table-functions.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2018 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
SQL Tutorial - 21: The UPDATE Query
 
06:12
In this tutorial we'll check out the UPDATE Query which is used to update/change records in a table.
Views: 86093 The Bad Tutorials
How to Join 3 tables in 1 SQL query
 
04:59
Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit http://www.joes2pros.com Offer expires July 1, 2015 From the newly released 2 Disc DVD set (SQL Queries Joes 2 Pros Vol2) this video shows how to join 3 tables in 1 query.
Views: 251558 Joes2Pros SQL Trainings
Part 6   Transform rows into columns in sql server
 
08:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 189005 kudvenkat
Oracle sql Interview Question : How to change rows to column
 
09:18
This video tutorial talks about the frequently asked oracle sql interview question of changing rows to the column. Based on the given scenario, we are asked to change the presentation of data in a table with 3 rows and 2 column to 3 columns and 2 rows. Decode Function in oracle https://youtu.be/YUAjPMjqMws Pivot and unpivot in oracle https://youtu.be/6s0DI1YcWIM
Views: 14354 Kishan Mashru
Group By using Multiple Columns in SQL
 
06:25
This video explains how to use group by clause in select statement to retrieve data using groups. It also explains how to use multiple columns in group by clause.
Views: 1833 suleman sauadagar
How to Join two tables in a update statement
 
07:18
This video is to understand how we can update a column of a table, based on the data present on the other table, and both the tables having a common column. Its a complicated update statement that can be used to update with different conditions.
Views: 8512 Kishan Mashru
SQL Tutorial 11 Subqueries with aggregate functions
 
08:06
Subqueries with aggregate functions Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 11147 Telusko
Oracle | SubQueries Part - 2 by Dinesh
 
21:36
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo............
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 247158 The Bad Tutorials
Transpose Rows into Columns in Oracle Database
 
11:36
Transpose rows to columns in Oracle , rows into columns in Oracle
Views: 99 Adam Tech
What to choose for performance   SubQuery or Joins   Part 62
 
12:26
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/what-to-choose-for-performance.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-62-what-to-choose-for-performance.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists What to choose for performance - SubQuery or Joins According to MSDN, in sql server, in most cases, there is usually no performance difference between queries that uses sub-queries and equivalent queries using joins. For example, on my machine I have 400,000 records in tblProducts table 600,000 records in tblProductSales tables The following query, returns, the list of products that we have sold atleast once. This query is formed using sub-queries. When I execute this query I get 306,199 rows in 6 seconds Select Id, Name, Description from tblProducts where ID IN ( Select ProductId from tblProductSales ) At this stage please clean the query and execution plan cache using the following T-SQL command. CHECKPOINT; GO DBCC DROPCLEANBUFFERS; Go DBCC FREEPROCCACHE; GO Now, run the query that is formed using joins. Notice that I get the exact same 306,199 rows in 6 seconds. Select distinct tblProducts.Id, Name, Description from tblProducts inner join tblProductSales on tblProducts.Id = tblProductSales.ProductId Please Note: I have used automated sql script to insert huge amounts of this random data. Please watch Part 61 of SQL Server tutorial, in which we have discussed about this automated script. According to MSDN, in some cases where existence must be checked, a join produces better performance. Otherwise, the nested query must be processed for each result of the outer query. In such cases, a join approach would yield better results. The following query returns the products that we have not sold atleast once. This query is formed using sub-queries. When I execute this query I get 93,801 rows in 3 seconds Select Id, Name, [Description] from tblProducts where Not Exists(Select * from tblProductSales where ProductId = tblProducts.Id) When I execute the below equivalent query, that uses joins, I get the exact same 93,801 rows in 3 seconds. Select tblProducts.Id, Name, [Description] from tblProducts left join tblProductSales on tblProducts.Id = tblProductSales.ProductId where tblProductSales.ProductId IS NULL In general joins work faster than sub-queries, but in reality it all depends on the execution plan that is generated by SQL Server. It does not matter how we have written the query, SQL Server will always transform it on an execution plan. If sql server generates the same plan from both queries, we will get the same result. I would say, rather than going by theory, turn on client statistics and execution plan to see the performance of each option, and then make a decision. In a later video session we will discuss about client statistics and execution plans in detail.
Views: 86742 kudvenkat
Alias Names  In Oracle | Oracle Tutorials for Beginners
 
07:30
Alias Names In Oracle | Oracle Tutorials for Beginners Column Level Alias Names in Oracle Table Level Alias names in Oracle Oracle Tutorials for Beginners Oracle pl/sql Tutorials for Beginners Oracle Tutorials for Beginners Oracle Tutorials for Beginners Oracle Tutorials for Beginners Oracle Tutorials for Beginners PlayList Oracle Tutorials for Beginners Playlist Oracle Tutorials for Beginners oracle alias column name with space oracle sql column alias in where clause oracle sql alias subquery oracle join alias oracle database alias alias sql sql alias join oracle as keyword sql query column name with space how to find space in a column in oracle select column name with space in teradata sql column name with space in where clause oracle sql alias subquery teradata column alias with space oracle column names with special characters oracle sql column alias with spaces sql alias join sql alias without as sql alias in where clause changing column names in sql query results how to join two tables with alias sql server alias aliases are very handy when table names are long sql as
Views: 640 Oracle PL/SQL World
Correlated subquery in sql   Part 60
 
07:59
In this video we will discuss about Corelated Subqueries In Part 59, we discussed about 2 examples that uses subqueries. Please watch Part 59, before proceeding with this video. We will be using the same tables and queries from Part 59. In the example below, sub query is executed first and only once. The sub query resutls are then used by the outer query. In a non-corelated subquery, the subquery can be executed independently of the outer query. Select [Id], [Name], [Description] from tblProducts where Id not in (Select Distinct ProductId from tblProductSales) If the subquery depends on the outer query for its values, then that sub query is called as a correlated subquery. In the where clause of the subquery below, "ProductId" column get it's value from tblProducts table that is present in the outer query. So, here the subquery is dependent on the outer query for it's value, hence this subquery is a correlated subquery. Correlated subqueries get executed, once for every row that is selected by the outer query. corelated subquery, cannot be executed independently of the outer query. Select [Name], (Select SUM(QuantitySold) from tblProductSales where ProductId = tblProducts.Id) as TotalQuantity from tblProducts order by Name Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/correlated-subquery-in-sql-part-60.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-60-co-related-subqueries.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 126529 kudvenkat
DISTINCT Clause & UNIQUE Keyword in Oracle | Oracle Tutorials for Beginners
 
06:59
DISTINCT & UNIQUE Keyword in Oracle | Oracle Tutorials for Beginners DISTINCT Keyword in Oracle DISTINCT Clause in Oracle UNIQUE Keyword in Oracle UNIQUE Clause in Oracle Oracle Tutorials for Beginners Oracle Tutorials for Beginners select distinct * sql distinct multiple columns sql distinct count select distinct on one column with multiple columns returned select distinct mysql sql count distinct multiple columns oracle distinct count sql distinct group by sql count distinct two columns select distinct on one column with multiple columns returned select distinct on one column with multiple columns returned oracle sql select unique values from multiple columns select distinct multiple columns mysql select distinct all columns sql count distinct multiple columns group by sql select distinct multiple columns group by select distinct oracle select distinct rows sql select distinct multiple columns select distinct on one column select count distinct select unique mysql how to select unique records in oracle without using distinct sql select distinct values and count of each Oracle Tutorials for Beginners Oracle Tutorials for Beginners Oracle Tutorials for Beginners Oracle Tutorials for Beginners
Views: 531 Oracle PL/SQL World
SQL : Introduction to Sub Query
 
04:50
In this tutorial, you'll learn what is a sub query and how to use it. SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Views: 7099 radhikaravikumar
SQL Inner Join Multiple Tables with SUM Tutorial - SQL 2008/2012/2016/2017
 
18:03
Use inner joins with multiple tables to create reports. Uses aliases, and the SUM aggregate function to demonstrate the flexibility of the join statement. Get the SQL script to create the database and run the exercies in the video here: https://www.qewbi.com/sql/scripts/qewbijoins.zip
Views: 136279 Edward Kench
SQL Dynamic Pivot Example Adventure Works
 
05:16
TSQL Dynamic Pivot example in adventure works. Pivot Example: https://www.youtube.com/watch?v=HmXv76kh78M Concatenate all product ids: https://www.youtube.com/watch?v=1kfp0s-lc3M
Views: 1378 Blake B
SQL Tutorial 10 Subqueries  with Group By and Having clause
 
09:22
Subqueries with Group By and Having clause Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 16029 Telusko
Nested Queries | SQL | Tutorial 18
 
10:23
Giraffe Academy is rebranding! I've decided to re-focus the brand of this channel to highlight myself as a developer and teacher! The newly minted Mike Dane channel will have all the same content, with more to come in the future! Source Code - http://www.mikedane.com/databases/sql. This video is one in a series of videos where we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. If you’re enjoying Giraffe Academy and want to invest in our future, consider leaving a contribution http://www.mikedane.com/contribute Links: Website - http://www.mikedane.com/ Facebook - https://www.facebook.com/giraffeacademy/ Twitter - https://twitter.com/GiraffeAcademy
Views: 5064 Mike Dane
Oracle Tutorial - How to add virtual column in oracle 11g
 
07:41
Hello friends in this video i'm going to demonstrate you how to add virtual column in ORACLE 11g step by step. Oracle 11g supports virtual columns which are derived from the other columns in the table. You can use the virtual columns in your queries, you can index them, you can collect the statistics, etc. There are few restrictions on the virtual columns. You cannot write/insert the data into virtual columns. There is no support for index_organized, external, object, cluster, temporary tables.
Views: 1351 OCP Technology
Running total in SQL
 
04:21
Using a correlated subquery to produce a running total (or running balance) column.
Views: 10613 Barry Brown
SQL DISTINCT Within a SELECT - Retrieving Unique Values
 
03:41
Jamie King of Neumont University demonstrating use of DISTINCT within a SQL SELECT command.
Views: 22421 Jamie King