The fifth part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we compare the performance of conventions table functions with pipelined table functions. For more information see:
https://oracle-base.com/articles/misc/pipelined-table-functions
https://oracle-base.com/articles/misc/efficient-function-calls-from-sql
Website: https://oracle-base.com
Blog: https://oracle-base.com/blog
Twitter: https://twitter.com/oraclebase
Cameo by Mike Dietrich :
Blog: https://blogs.oracle.com/UPGRADE
Twitter: https://twitter.com/MikeDietrichDE
Cameo appearances are for fun, not an endorsement of the content of this video.

The video explains BITMAP and BITMAP JOIN INDEX IN ORACLE and when you should create them on a column.
BITMAP INDEXES should be dealt with carefully as they can lead to serious performance issues if the table is updated by multiple processes in parallel.
Indexing Basics :https://www.youtube.com/watch?v=0X9bbtwTnuE&t=1095s
Star and snowflake Schema :https://www.youtube.com/watch?v=Qq4yhhAk9fc&t=17s

https://developer.oracle.com/code/online | Kuassi Mensah: This session presents a Spark data source for joining big data with master data in an RDBMS. It describes how such an implementation: Allows parallel and direct access to the RDBMS database (with the option of controlling the number of concurrent connections). Introspects the RDBMS table, generates partitions of Spark JDBCRDDs based on the split pattern, and rewrites Spark SQL queries into the RDBMS SQL dialect. Uses hooks in the JDBC driver for faster type conversions. Pushes down predicates to the RDBMS, prunes partitions based on the where clause, and projects columns to the RDBMS to reduce the amount of data returned and processed on Spark. Writes back the result set to the RDBMS table for use by traditional BI tools

Data is always flow from source to target. Here source tables are created using SQL PLUS and target is staging table which is created using Table Operator from Compenent Palette
http://www.maheshbhagat.tk
http://www.fb.com/mymahesh11
https://twitter.com/mymahesh11

Held on August 7 2018
Collections are PL/SQL's version of arrays and there are three types: associative arrays, nested tables, varrays. They are used in many performance features of PL/SQL, such as bulk processing, as well as table functions. Steven Feuerstein uses them all the time and thinks you should, too. He kicked off this Office Hours with some of his favorite collections features/usages, and then he and Chris Saxon answered questions on measuring PGA, executing DML in parallel, and more.
2:30 Steven's favorite collection things
3:20 First a little quiz!
7:56 Banish row-by-row SQL processing
14:06 String-indexed collections
17:19 Nested collections
20:42 Table functions
26:18 Q&A
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
music: bensound.com

Oracle Flashback Technology 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.
Oracle Flashback Version Query
Use this feature to retrieve metadata and historical data for a specific time interval (for example, to view all the rows of a table that ever existed during a given time interval). Metadata for each row version includes start and end time, type of change operation, and identity of the transaction that created the row version. To create an Oracle Flashback Version Query, use the VERSIONS BETWEEN clause of the SELECT statement.
Oracle Flashback Table
Use this feature to restore a table to its state at a previous point in time. You can restore a table while the database is on line, undoing changes to only the specified table.

Oracle Database 12c Release 2 New Feature! Learn how to convert a non-partitioned table to a partitioned table - Online! This new method - using ALTER TABLE MODIFY - is much simpler than DBMS_REDEFINITION. In this free tutorial from SkillBuilders and Oracle Certified Master DBA John Watson you'll see a demonstration of converting the table and the impact on the underlying table and indexes. See all our free Oracle Database Tutorials at http://www.skillbuilders.com/free-oracle-tutorials.

Text Article
http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many.html
Slides
http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many_6.html
SQL Server Interview Questions and Answers text articles & slides
http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html
SQL Server Interview Questions and Answers playlist
https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR
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
In this video we will discuss how to insert data into a table that has many-to-many relationship
Create table Students
(
Id int primary key identity,
StudentName nvarchar(50)
)
Go
Create table Courses
(
Id int primary key identity,
CourseName nvarchar(50)
)
Go
Create table StudentCourses
(
StudentId int not null foreign key references Students(Id),
CourseId int not null foreign key references Courses(Id)
)
Go
Students - Id column is identity column
Courses - Id column is identity column
StudentCourses - StudentId and CourseId columns are foreign keys referencing Id column in Students and Courses tables
As you can see, StudentCourses is a bridge table that has many to many relationship with Students and Courses tables. This means a given student can be enrolled into many courses and a given course can have many students enrolled.
Below is the question asked in an interview for SQL Server Developer role.
Write a SQL script to insert data into StudentCourses table. Here are the rules that your script should follow.
1. There will be 2 inputs for the script
Student Name - The name of the student who wants to enroll into a course
Course Name - The name of the course the student wants to enroll into
2. If the student is already in the Students table, then use that existing Student Id. If the student is not already in the Students table, then a row for that student must be inserted into the Students table, and use that new student id.
3. Along the same lines, if the course is already in the Courses table, then use that existing Course Id. If the course is not already in the Courses table, then a row for that course must be inserted into the Courses table, and use that new course id.
4. There should be no duplicate student course enrollments, i.e a given student must not be enrolled in the same course twice. For example, Tom must not be enrolled in C# course twice.
Answer : To avoid duplicate student course enrollments create a composite primary key on StudentId and CourseId columns in StudentCourses table. With this composite primary key in place, if someone tries to enroll the same student in the same course again we get violation of primary key constraint error.
Alter table StudentCourses
Add Constraint PK_StudentCourses
Primary Key Clustered (CourseId, StudentId)
Here is the SQL script that inserts data into the 3 tables as expected
Declare @StudentName nvarchar(50) = 'Sam'
Declare @CourseName nvarchar(50) = 'SQL Server'
Declare @StudentId int
Declare @CourseId int
-- If the student already exists, use the existing student ID
Select @StudentId = Id from Students where StudentName = @StudentName
-- If the course already exists, use the existing course ID
Select @CourseId = Id from Courses where CourseName = @CourseName
-- If the student does not exist in the Students table
If (@StudentId is null)
Begin
-- Insert the student
Insert into Students values(@StudentName)
-- Get the Id of the student
Select @StudentId = SCOPE_IDENTITY()
End
-- If the course does not exist in the Courses table
If (@CourseId is null)
Begin
-- Insert the course
Insert into Courses values(@CourseName)
-- Get the Id of the course
Select @CourseId = SCOPE_IDENTITY()
End
-- Insert StudentId & CourseId in StudentCourses table
Insert into StudentCourses values(@StudentId, @CourseId)
If required, we can very easily convert this into a stored procedure as shown below.
Create procedure spInsertIntoStudentCourses
@StudentName nvarchar(50),
@CourseName nvarchar(50)
as
Begin
Declare @StudentId int
Declare @CourseId int
Select @StudentId = Id from Students where StudentName = @StudentName
Select @CourseId = Id from Courses where CourseName = @CourseName
If (@StudentId is null)
Begin
Insert into Students values(@StudentName)
Select @StudentId = SCOPE_IDENTITY()
End
If (@CourseId is null)
Begin
Insert into Courses values(@CourseName)
Select @CourseId = SCOPE_IDENTITY()
End
Insert into StudentCourses values(@StudentId, @CourseId)
End
Use the following statement to execute the stored procedure
Execute spInsertIntoStudentCourses 'Tom','C#'

In order to send SMS messages from your Oracle database you have to create a proper database table structure.
You can copy the CREATE TABLE statements from this page: http://www.ozeki.hu/index.php?owpn=5713
This documentation explains how you can connect Ozeki SMS Gateway with your Oracle database server.
First connect to your database and run the CREATE TABLE statements.
After you created the proper database table structure you can easily send SMS messages.
You only have to insert the SMS into the right table.
If you do not have an Oracle database installed, the previous video will explain the installation.
Send SMS from Oracle SQL - Installation
https://www.youtube.com/watch?v=TP-4--lw-YY
Learn how to configure a Database User in Ozeki SMS Gateway from the next video.
The Database User will read message records from the SQL table and send the SMS messages to mobile phones.
Send SMS from Oracle SQL - Configure Database User
https://www.youtube.com/watch?v=fGJL85tr9Mo
For more information please visit our site:
http://www.ozeki.hu

This video demonstrates,
1) What is partition and partition point.
2) How are they used together to sever the purpose of parallel processing of data, ensuring the data integrity.
3) How it helps in obtaining better performance.

interRel presents Look Smarter Than You Are with Oracle Essbase: What is Parallel Calculation?
Ever wonder what a parallel calculation is? Edward Roske, Oracle ACE Director and CEO of interRel gives you the scoop on what it is and how to leverage it to improve calculation performance!
To see more of our videos, go to http://epm.bi/videos

Oracle DB is big, and expensive, but it brings a lot to the "table" when compared with MySQL.
MySQL has limited ability to audit.
MySQL's security is unsophisticated. There are no groups or roles, no ability to deny a privilege (you can only grant privileges). A user who logs in with the same username and password from different network addresses may be treated as a completely separate user. There is no built-in encryption comparable to Oracle.
MySQL's Authentication is built-in. There is no LDAP, Active Directory, or other external authentication capability.
MySQL has no MPP (massively parallel processing ) support.
Unlike Oracle MySQL has no fractional-second storage type for times, dates, or intervals.
There is no RAC (Real Application Cluster) support in My SQL, and no failover or server promotion either. These are strong features in Oracle
MySQL's number of joins per query is limited to 61. Oracle's limit is much larger.
MySQL Replication is asynchronous and has many limitations and edge cases. For example, it is single-threaded, so a powerful slave can find it hard to replicate fast enough to keep up with a less powerful master.

RebellionRider.com presents a PL/SQL tutorial on how to use PL/SQL Bulk Collect with Fetch-Into statement of an explicit cursor in Oracle Database. Watch and learn how to enhance query performance with Bulk Collect in Oracle Database by Manish Sharma.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/bulk-collect-3
Previous Tutorial
► Introduction to Bulk Collect: https://youtu.be/HPVzFBluM_Q
► Explicit Cursor: https://youtu.be/3q7dW_d2KVc
► Simple Loop: https://youtu.be/AFx6QYcY1CU
► The script on GIT: https://github.com/RebellionRider/pl-sql-tut-74.git
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
For E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Parameter file is just a simple text file which is read and opened by expdp client unlike Dumpfiles and Logfiles which are created and written by the server.
SYNTAX
=========
[[email protected] ~]$ cat u1.par
tables=u1.t1
directory=DATA_PUMP_DIR
parallel=4
dumpfile=U1_%U.dmp
logfile=expdp_u1.log
===============================================
[[email protected] ~]$ expdp parfile=u1.par
Export: Release 11.2.0.1.0 - Production on Thu Aug 10 04:02:43 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Please like ,subscribe and ask me any queries if you have any doubt.
Email: [email protected]
=================================================
Hi Folks,
Greetings!!
I am professional part time oracle dba trainer and having good experience in oracle database administration.
This is the right place to enroll yourself for Oracle DBA real time course.
Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily.
Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge.
Mobile No : + 91 9960262955 (WhatsApp Number)
EmailID: [email protected]

Course Description – sql1
COURSE DESCRIPTION:
The Oracle server extends the data modeling capabilities to support an object relational database
model that brings object-oriented programming, complex data types, complex business objects, and
full compatibility with the relational world. It includes several features for improved performance and
functionality of online transactionprocessing (OLTP) applications, such as better sharing of run-time
data structures, larger buffer caches, and deferrable constraints. Data warehouse applications will
benefit from enhancements such as parallel execution of insert, update, and delete operations; partitioning;
and parallel-aware query optimization.
COURSE OBJECTIVES:
in this course
List the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Differentiate between SQL statements and iSQL*Plus commands
Limit the rows retrieved by a query
Sort the rows retrieved by a query
WHO SHOULD ATTEND?
COURSE OUTLINE:
In this lesson, you should have learned howtheOracleserverusesconstraints to prevent invalid data entry into tables. You also learned how to implement the constraints in DDL statements.
Writing Basic SQL SELECT Statements
Restricting and Sorting Data
Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Producing Readable Output with iSQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints

In this SQL Server Integration Services(SSIS) Interview question video, you will learn the answer of question "What is parallel execution in SSIS, and how many Data Flow Tasks can apackage run in parallel?"
I totally forgo to mention if Hypder-threading is enable then it will be number of logical processors +2 , those many executable can run in parallel.
Complete list of SSIS Interview Questions by Tech Brothers
http://sqlage.blogspot.com/search/label/SSIS%20INTERVIEW%20QUESTIONS

In this video I have explained what is range partitioning along with it's 2 real project use cases.
I have also explained interval Partitioning as an extension of Range partitioning
If you have not watched my Initial Videos on partitioning I will recommended watching them before watching this video
Apologies for the 10 second video glitch between 6 and 7 minutes :(

I and others have been working on bringing parallel query for PostgreSQL for several years now, but PostgreSQL 9.6 is the first release expected to include a user-visible feature. And it's pretty cool. In this talk, I'll give an overview of the development of this feature, where we are now, and what the future might hold. I will discuss the overall architecture of parallelism in PostgreSQL, give examples of queries that can be accelerated by the features expected to be in PostgreSQL 9.6, and talk about what's not done yet.
http://www.pgconf.us/2016/event/147/parallel-query-in-postgresql/

Course Description – sql1
COURSE DESCRIPTION:
The Oracle server extends the data modeling capabilities to support an object relational database
model that brings object-oriented programming, complex data types, complex business objects, and
full compatibility with the relational world. It includes several features for improved performance and
functionality of online transactionprocessing (OLTP) applications, such as better sharing of run-time
data structures, larger buffer caches, and deferrable constraints. Data warehouse applications will
benefit from enhancements such as parallel execution of insert, update, and delete operations; partitioning;
and parallel-aware query optimization.
COURSE OBJECTIVES:
in this course
List the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Differentiate between SQL statements and iSQL*Plus commands
Limit the rows retrieved by a query
Sort the rows retrieved by a query
WHO SHOULD ATTEND?
COURSE OUTLINE:
In this lesson, you should have learned howtheOracleserverusesconstraints to prevent invalid data entry into tables. You also learned how to implement the constraints in DDL statements.
Writing Basic SQL SELECT Statements
Restricting and Sorting Data
Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Producing Readable Output with iSQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints

The Genius Who Invented Economics Blogging Reveals How He Got Everything Right And Whats Coming Next.
Bill McBride, Calculated Risk The economics blogosphere was invented in early 2005 by a retired technology executive in Southern California named Bill McBride.
Thank God for that, because his blog, Calculated Risk, has been an invaluable and influential read for numerous reasons.
For one thing, its always been right. In its early days, when we all started reading it, it was way ahead of the curve in terms of warning about the housing bubble, horrible bank lending practices, and generally the economic collapse. From his perch in Newport Beach, CA he could see first hand the people taking out loans worth 10x their income, filling their Inland Empire garages with Harleys and Boats that they obviously couldnt afford.
But unlike many other bloggers who made a name during the crisis, he didnt stick with the doom and gloom message. He started making arguments for a GDP rebound in 2009.

Then in February of this year, he made his most important call: He announced: The Housing Bottom Is Here . McBride had officially come full circle from his days warning of housing collapse. Today, 8 months later, the housing bottom is becoming general consensus.
In addition to being correct on the economy, Calculated Risk has imparted the internet with other good practices, such as dutifully charting out the data, and examining data in an impartial, apolitical, non-hysterical manner.