Home
Search results “Oracle alter add partition list”
Table Partitioning in Oracle Sql|Hash Partitioning|Range Partitioning|List Partitioning|Partitioning
 
09:04
Table Partitioning in Oracle Sql | Hash Partitioning | Range Partitioning | List Partitioning | Partitioning --------------------------------------------------------------------------------------------------------- hash partitioning,range partitioning,oracle hash partitioned index example,partition by range interval,when to use range partitioning,what is table partitioning,list partitioning,how to query partition table in oracle,partition, sql server, sql, partitioning in oracle, hash, performance, oracle, partitioning, list, range, interval partition, reference partition, composite partition, index partition, partition pruning, table partitioning, sql server table partition, table partition, hash partitioning, composite partitioning, sql server partitioning, sql server table partitioning, partition table, types of partitions, what is partition, advantages of partition, partition index, sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner, Please Subscribe My Channel
How to Convert a Non-Partitioned Table to Partitioned using Oracle Database 12c R2
 
05:02
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.
Views: 3574 SkillBuilders
SQL 12c Tutorial 23 : SQL Creating PARTITION on  Existing Table SQL 12c new feature
 
06:20
SQL 12c Tutorial 23 : SQL Creating PARTITION on Existing Table SQL 12c new feature SQL 12c New Features SQL 12c Tutorial for beginners Oracle SQL Tutorial for beginners Creating Partition on existing table
Views: 1471 TechLake
part 10 modify partition add list values
 
01:30
alter table modify partition,add list values, list partition, data warehousing
part 16 default value add list partition
 
03:21
default value using list partition, alter table, data warehousing
part 9 - list partition
 
02:21
list partition, data warehousing, alter table
Oracle SQL Tutorial 22 - Why Primary Keys Shouldn't Change
 
07:14
In the last video I mentioned that with our database design it is important to make sure that nobody tries to update a user's username. What happens if they do? Nothing horrible, Oracle will just throw an error. That's not such a big deal, but if you are hoping to make some kind of application that allows someone to change their username, this is not the best set up. Why? If you look at the projects table, we have a foreign key that references the username. Let's assume for a moment that Oracle allows you to do anything with your data. That means that if a user updates their username, there will be projects created by users that don't exist. Or a user could change their name to the previous owner. To fix this problem, we would need something such as an ON UPDATE CASCADE command for our foreign key. That would mean that if the user updated their username, the columns that reference that username would also update to the new value. This exists in some database management systems, but this does not exist in Oracle at the time of this video. How do we get around this problem? I'm sure we could conjure up something to allow us to update the username, but the easiest solution is to reference the user_id instead of the username. That way, when the username is updated, nothing changes inside of the foreign key. As a general rule, primary keys should never change. Foreign keys CAN change, but they should not change because a primary key changed. So, if we did happen to use a username as a column, it would be frowned upon if the username had to change because the column it references changes. However, it would be acceptable to change the foreign key if we needed to point to a new entity in the users table. Even if a username is never intended to change, these complications bother a lot of people. You can mitigate these problems by only referencing surrogate keys in foreign keys. This has the downside though that when you retrieve the data, you are going to have to do more work to make the data readable. For example, we had a table that was called project_users. It is essentially a table that says what users are part of what projects. We could have the foreign keys reference the project's name and the user's username. Then when you could say SELECT * FROM project_users. The data would be completely readable without doing anything. If you switch to only referencing surrogate primary keys, you will have a bunch of random numbers that don't mean anything and will have to be joined with other tables…which is really super frustrating when later you have to join a thousand tables to read anything. Which side do you prefer? Pick a side. Choose wisely. I'll see you all in the next video ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 6409 Caleb Curry
Dynamic sql table name variable
 
11:59
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable_20.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 SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB 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 pass table name dynamically for stored procedure in sql server. This is one of the sql questions that is very commonly asked. I have a web page with a textbox. When I enter a table name in the textbox and when I click "Load Data" button, we want to retrieve data from that respective table and display it on the page. Copy the SQL Script to create the tables from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Create the following stored procedure. Notice we are passing table name as a parameter to the stored prcoedure. In the body of the stored procedure we are concatenating strings to build our dynamic sql statement. In our previous videos we discussed that this open doors for SQL injection. Create procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + @TableName Execute sp_executesql @sql End So the obvious question that comes to our mind is, why are we not creating parameterised sql statement instead. The answers is we can't. SQL Server does not allow table names and column names to be passed as parameters. Notice in the example below, we are creating a parameterised query with @TabName as a parameter. When we execute the following code, the procedure gets created successfully. Create procedure spDynamicTableName1 @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from @TabName' Execute sp_executesql @sql, N'@TabName nvarchar(100)', @TabName = @TableName End But when we try to execute it we get an error - Must declare the table variable "@TabName" Execute spDynamicTableName1 N'Countries' Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicTableName.aspx". Copy and paste the HTML from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Copy and paste the code from my blog in the code-behind page http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html At this point, run the application and type the following text in the "Table Name" textbox and click "Load Data" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. Employees; Drop database SalesDB One way to prevent SQL injection in this case is by using SQL Server built-in function - QUOTENAME(). We will discuss QUOTENAME() function in detail in our next video. For now understand that by default, this function wraps that string that is passed to it in a pair of brackets. SELECT QUOTENAME('Employees') returns [Employees] Modify the stored procedure to use QUOTENAME() function as shown below. Alter procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + QUOTENAME(@TableName) Execute sp_executesql @sql End At this point, type the following text in the "Table Name" textbox and click "Load Data" button. Notice you will see a message - Invalid object name 'Employees; Drop database SalesDB'. Also "SalesDB" database is not dropped. Employees; Drop database SalesDB The entire text in "Table Name" textbox is wrapped in a pair of brackets by the QUOTENAME function and is treated as table name. Since we do have a table with the specified name, we get the error - Invalid object name.
Views: 28231 kudvenkat
Table Partitioning in Oracle Sql | Oracle Sql Partitioning | Oracle Sql Partitioning Step by Step
 
03:17
Table Partitioning in Oracle Sql | Oracle Sql Partitioning | Oracle Sql Partitioning Step by Step --------------------------------------------------------------------------------------------------------- oracle, partition, partitioning, sql, partitioning in oracle, hash, list, range, interval partition, reference partition, composite partition, index partition, performance, partition pruning, partition wise join, sql server, partition table, sql server table partitioning, table partitioning, sql server partitioning, sql server table partition, table partition, what is partition, partitioned table, advantages of partition, types of partitions, ,table partitioning in sql server 2012 step by step,table partitioning in sql server 2014 step by step,table partitioning in sql server 2016 step by step,partition table sql server 2012 example,sql server partition existing table,sql server partition table by month,table partitioning in sql server 2008 r2 step by step,sql server partitioning best practices,horizontal partitioning in sql server, sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner, Please Subscribe My Channel Composite Range-Range Partitioning Composite range-range partitioning enables logical range partitioning along two dimensions; for example, partition by order_date and range subpartition by shipping_date. Composite Range-Hash Partitioning Composite range-hash partitioning partitions data using the range method, and within each partition, subpartitions it using the hash method. Composite range-hash partitioning provides the improved manageability of range partitioning and the data placement, striping, and parallelism advantages of hash partitioning. Composite Range-List Partitioning Composite range-list partitioning partitions data using the range method, and within each partition, subpartitions it using the list method. Composite range-list partitioning provides the manageability of range partitioning and the explicit control of list partitioning for the subpartitions. Composite List-Range Partitioning Composite list-range partitioning enables logical range subpartitioning within a given list partitioning strategy; for example, list partition by country_id and range subpartition by order_date. Composite List-Hash Partitioning Composite list-hash partitioning enables hash subpartitioning of a list-partitioned object; for example, to enable partition-wise joins. Composite List-List Partitioning Composite list-list partitioning enables logical list partitioning along two dimensions; for example, list partition by country_id and list subpartition by sales_channel. Composite Hash-Hash Partitioning Composite hash-hash partitioning enables hash partitioning along two dimensions. This technique is beneficial to enable partition-wise joins along two dimensions. Composite Hash-List Partitioning Composite hash-list partitioning enables hash partitioning along two dimensions. Composite Hash-Range Partitioning Composite hash-range partitioning enables hash partitioning along two dimensions.
What is the RANGE PARTITION in Oracle ?
 
14:10
Hi guys in my today scenario I'm going to explain with you What is the RANGE PARTITION in Oracle, Oracle database #RANGEPARTITIONUnbeatable,Unbreakable Platform..
Views: 7328 Oracle World
14. Pseudo Columns
 
14:02
In this video you will learn about Pseudo columns used in Oracle engine. This is one of confusing topic for beginners, if you are one you should quickly watch it. You will remember it always after watching. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 41043 ITORIAN
SQL with Oracle 10g XE - Using GROUP BY to Group Results of a Query
 
04:52
In this video I use the GROUP BY clause to organize the results of a function by groups or categories. If you are looking to run a function on a column and have those results grouped together then you will need to use the GROUP BY clause to run the query. This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 5762 Lecture Snippets
How to view table structure in oracle database .
 
00:28
How to view table structure in oracle database .
Views: 477 latest ITChannel
Oracle Database 12c: Partitioning Improvements with Tom Kyte
 
08:08
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information: "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14107 "Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14100 "ALTER INDEX COALESCE Clause" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF52782 "DBMS_PART.CLEANUP_GIDX Procedure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ARPLS74409
Views: 13931 OracleDBVision
part 17 split partition
 
01:56
split partition, data warehousing, alter table
List all tables in a sql server database using a query  Part 65
 
05:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/part-65-list-all-tables-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-65-list-all-tables-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 In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question. Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use. 1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008 2. SYS.TABLES - Supported in SQL Server version 2005 & 2008 3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008 -- Gets the list of tables only Select * from SYSOBJECTS where XTYPE='U' -- Gets the list of tables only Select * from SYS.TABLES -- Gets the list of tables and views select * from INFORMATION_SCHEMA.TABLES To get the list of different object types (XTYPE) in a database Select Distinct XTYPE from SYSOBJECTS Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS IT - Internal table P - Stored procedure PK - PRIMARY KEY constraint S - System table SQ - Service queue U - User table V - View Please check the following MSDN link for all possible XTYPE column values and what they represent. http://msdn.microsoft.com/en-us/library/ms177596.aspx
Views: 93635 kudvenkat
part 12 truncate partition
 
01:55
Truncate partition, alter table, data warehousing
part 11  modify parition drop values
 
02:15
alter table modify partition, drop values,
How to drop tablespace in Oracle 10g or 11g
 
01:34
This is how to drop tablespace in oracle 10g or oracle 11g, you can delete tablespace in oracle if you want. Delete or drop tablesapce in oracle cascade
Views: 294 Tanya Kenapa?
part 4 date range partition
 
02:33
date range paritition data warehousing range partition
part 19 compare truncate,drop,coalsec
 
02:35
compare truncate, drop, drop list values, coalesc partition, data warehousing alter table
Oracle PL SQL interview question difference between VARRAY NESTED TABLE ASSOCIATIVE ARRAY
 
06:29
Oracle PL SQL interview question difference between VARRAY NESTED TABLE ASSOCIATIVE ARRAY Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 860 Siva Academy
Tutorial#73 How to Rename Multiple Columns in Single Query in Oracle SQL Database
 
02:11
Explaining how to alter/Rename columns in Single Query of oracle database, this can be the interview question for Oracle SQL 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 #Oracle #equalConnectCoach #rakeshmalviya
Views: 76 EqualConnect Coach
Creating range partition in Oracle 12c - Part 1
 
11:32
Partition makes a table access faster in case of very large table. In this tutorial we have tried to demonstrate the range partition on date.
Views: 199 Subhroneel Ganguly
Oracle 12c Release 2 - How to move a heap table online
 
01:43
Need to reorganize a table ? Want to do it whenever you want without impacting any users ? Easy in 12.2 ========================================­­­­============== Copyright © 2017 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.
Views: 465 Connor McDonald
Part 4   Delete duplicate rows in sql
 
03:26
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/05/part-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 356634 kudvenkat
How to Create Partition table in SQL Server
 
08:08
how to create partition table in sql server lite
Views: 1224 SOKREY HOUSAN
10. SELECT command with WHERE condition
 
10:15
In this video you will learn how to execute SELECT commands with WHERE condition. I will show you by executing these command and you will understand it easily. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 58810 ITORIAN
Oracle DBA Justin - How to execute sql and Sqlplus commands from an external script
 
09:33
How to execute sql and Sqlplus commands from an external script
Views: 87569 jbleistein11
6. Базы данных. Оптимизация запросов. Оптимизация структуры данных | Технострим
 
02:10:16
Слайды лекции: https://bozaro.github.io/tech-db-lectures/06/ ► Другие лекции курса: https://www.youtube.com/playlist?list=PLrCZzMib1e9oOFQbuOgjKYbRUoA8zGKnj Подробнее о курсе: https://park.mail.ru/curriculum/program/discipline/218/ Лекция читается в рамках образовательного проекта "Технопарк Mail.ru Group" при МГТУ им.Баумана. КРАТКОЕ СОДЕРЖАНИЕ: Лекция посвящена производительности (оптимизации работы с БД). Рассматриваются следующие темы: — Нормализация и денормализация данных; — Оптимизация запросов конкретных типов; — Разница между актуальными и историческими данными; — Секционирование; — Оптимизация на уровне приложения; — Примеры эффективного массового изменения данных. Хронометраж: 00:00:03 О теме лекции 00:00:54 Нормализация и денормализация данных (на примере тестовой БД из прошлой лекции) 00:02:43 Вопрос залу: о приоритете применения того или метода построения запроса 00:04:10 Повторение пройденного материала: о покрывающем индексе 00:04:45 Повторение пройденного материала: про подзапросы (SUBQUERIES) 00:07:47 Повторение пройденного материала: краткий итог 00:11:01 Вопрос залу: в каком случае не нужны индексы для внешних ключей (FOREIGN KEY)? 00:12:44 Продолжение рассмотрения примера из тестовой БД: Заменим 'Zombie%' на 'Comedy%' 00:13:12 Оптимизируйте доступ к данным (Модификация запросов) 00:17:45 Нормализация (плюсы нормализации данных) 00:18:56 Денормализация (методы денормализации данных) 00:22:04 Нормализация/денормализация: пример 00:25:18 Оптимизация запросов конкретных типов 00:25:33 Оптимизация DELETE: очистка таблицы 00:28:07 Оптимизация COUNT(*): получение кол-ва записей в таблице 00:31:28 Оптимизация COUNT(*): получение кол-ва записей после выполнения запроса 00:33:20 Оптимизация LIMIT со смещением 00:40:46 Оптимизация: случай из практики 00:44:21 Исторические и актуальные данные (Настоящее vs Прошлое) 00:46:44 Актуальные данные (особенности и проблемы) 00:49:12 Исторические данные (особенности и проблемы) 00:57:47 Вопрос из зала по пройденному материалу 00:58:17 Ответ и уточняющие вопросы 01:00:36 Исторические данные (особенности и проблемы) - продолжение 01:02:03 Цитата о "биг дата" 01:02:49 Секционирование (англ. partitioning) 01:06:48 Секционирование: наследование 01:16:13 Секционирование: наследование (плюсы и минусы) 01:19:46 Секционирование: pg_pathman (плюсы и минусы) 01:22:11 Секционирование: PostgreSQL 10 (плюсы и минусы) 01:23:45 Оптимизация на уровне приложения (Уменьшение времени блокировок) 01:26:56 Разбиение запроса на более мелкие 01:31:09 Модификация схемы 01:39:50 Группировка UPDATE 01:45:54 Массовая вставка данных 01:53:08 Загрузка данных через COPY 01:55:11 Блокировки (Пессимистичная / Оптимистичная) 01:59:54 Ограничение времени ожидания (Долгий / Ждущий / Срочный запрос) 02:04:42 CREATE INDEX (Блокирующее / Неблокирующее создание индекса) 02:05:36 ALTER TABLE (Классический / Сокращенный вариант) О КАНАЛЕ: Официальный канал образовательных проектов Mail.Ru Group ► Нажмите здесь для подписки ‣ http://www.youtube.com/TPMGTU?sub_confirmation=1 Актуальные лекции и мастер-классы о программировании от лучших IT-специалистов. Если вы увлечены мобильной и веб-разработкой, присоединяйтесь! Наши проекты: Технопарк при МГТУ им. Баумана ‣ https://park.mail.ru Техносфера при МГУ им. Ломоносова ‣ https://sphere.mail.ru Технотрек при МФТИ ‣ https://track.mail.ru Техноатом при МИФИ - https://atom.mail.ru Технополис при СПбПУ - https://polis.mail.ru ------------------------ МЫ В СЕТИ: Технопарк в ВК | http://vk.com/tpmailru Техносфера в ВК | https://vk.com/tsmailru Технотрек в ВК | https://vk.com/trackmailru Техноатом в ВК | https://vk.com/technoatom Технополис в ОК: https://www.ok.ru/technopolis Технополис в ВК: https://vk.com/technopolis_ok Блог на Хабре | http://habrahabr.ru/company/mailru
PART 6 RANAME PARTITION
 
01:15
rename partition, data warehousing, alter table
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 186247 Manish Sharma
Microsoft SQL Server Table Partitioning
 
01:53
Denny Cherry talks about SQL Server Table Partitioning features which can improve query performance and reduce downtime when loading and pruning data. Denny is an independent consultant with over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny's specialties include system architecture, performance tuning, replication, and troubleshooting. He is a Microsoft Certified Master as well a Microsoft MVP, and is the principal consultant at Denny Cherry & Associates. "At SQL Saturday Silicon Valley I was talking about table partitioning and how to implement it and why do you want to implement it. It is technology that a lot of people aren't familiar with because it is an enterprise only feature so they really do not get exposed to it until they actually land at that big shop that really needs it and even once they get in to those larger shops they may not necessarily really know when to apply it and when isn't a good time to apply it and what some of the best practices are around implementing it so it is one of the things that is used for really, really large datasets so doing it wrong is really expensive because fixing it is even more expensive because we are usually talking about moving 100s of billions of [rows] may be trillions of [rows] and I mean it just takes forever to move that amount of information so having a good foundation to start on when you are doing your research is really important so that is kind of what I covered in this session today and I did some quick demos on how to actually do it, how to move data, how to truncate data quickly in a partition table and stuff like that. There is a lot of really good information on Google that you can use to learn about table partitioning. One of the nice things about partitioning is because so many few people are using it there is not a lot of bad information out there. There are a lot of videos available from PASS and from Vconference.com and various other websites that are going to give you a lot of really good information and of course you get a lot of SQL Saturday where you will find somebody talking about table partitioning in some way so you can get some good information from them as well."
Views: 1303 DesignMind
How to Replace a Failed Disk - Svm Root Mirror Primary Disk  Replacement
 
17:32
This Video is part of our Solaris Courses http://unixadminschool.com/member/product/solaris-associate-membership/
Views: 2485 unixadminschool com
SQL1 - using select; choosing your columns; distinct rows.
 
07:23
The basics of SQL with Oracle Apex; starting the SQL language with the idea of relational database tables, and simple ways to obtain data from them.
Views: 604 Charles Boisvert
part 18 drop tablespace
 
02:38
tablespace, data warehousing,segment
Distinct operator in oracle in hindi ,english
 
06:16
Description. The Oracle DISTINCT clause is used to remove duplicates from the result set. ... Syntax. The syntax for the DISTINCT clause in Oracle/PLSQL is: SELECT DISTINCT expressions FROM tables [WHERE conditions]; ... Note. ... Example - With Single Expression. ... Example - With Multiple Expressions. distinct on multiple columns in sql oracle distinct count oracle select distinct on one column where distinct sql sql distinct group by how to select unique records in oracle without using distinct select distinct count SQL Tutorial in Oracle - 4 NULL, LIKE, DISTINCT, ORDER BY SQL SELECT statement is used to fetch the data from a database table which returns data in the form of result table. These result ... Oracle Database11g tutorials 8 || SQL DISTINCT with multiple columns |SQL Distinct with Two columns will show how to use SQL DISTINCT keyword with SQL Select ... SQL Tutorial - 27: The DISTINCT Keyword The Bad Tutorials In this tutorial we'll see how we can pull out unique data from tables using the DISTINCT Clause in our Queries. 55. SELECT DISTINCT in SQL (Hindi) • Please Subscribe Channel Like, Share and Comment Visit : DISTINCT Clause in Oracle | Oracle SQL Tutorial Videos | • DISTINCT Clause in Oracle. Oracle Database11g tutorials 7 | |SQL DISTINCT keyword || SQL tutorials This SQL tutorial and Oracle database 11g tutorial for beginners will show how to use SQL DISTINCT keyword with SQL Select ... 06- Oracle SQL-Arabic Course Concatenation Operator-Quote q Operator-DISTINCT-DESCRIBEاوراكل ديفلوبر • أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح SQL فى درس اليوم نتحدث عن Concatenation Operator & Quote q Operator & ... SQL with Oracle 10g XE - Using the DISTINCT Function Lecture Snippets In this video I use the DISTINCT function to list the values of a column from a query and remove the duplicate listings. When using ... SQL Distinct and Multiple Columns • Jamie King of Neumont University showing how SQL DISTINCT varies when multiple columns are present in the result set. Learn Oracle | Alias Names, Concatenation, Distinct Keyword Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following ... 8:54 Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7 How To install Oracle Database 11g enterprise edition On windows 64 bit. Full installation in Single video. Enjoy SQL and ... Related
Views: 28 Muo sigma classes
How to Install Oracle! !! Database Training
 
01:50
For Complete Database Training Details Visit: http://www.qaonlinetraining.com http://infotek-solutions.com/ Delivery Method: Instructor led classroom and Online Training supported by world class Learning management system which automate all flow of lectures, videos, assignments, forums, quizzes and interview process. Class Schedule: Week-ends and Weekdays Contact Us: 571-437-0652, Mail Us: [email protected] Training Locations at : Ashburn / Fairfax / Maryland Office Address: 12801 Worldgate Dr #500, Herndon, VA 20170 Overview of Oracle DBA Training Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem Using SQL*Plus for DBA management Connecting and executing SQL Using the “as sysdba” syntax Overview of SQL*Plus DBA commands (startup, etc.) Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins Using sort_area_size, hash_area_size and pga_aggregate_target Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links Oracle tables, views and materialized views Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) Oracle Views Oracle materialized views Oracle indexes Types of Oracle indexes (b-tree, bitmap, bitmap join index) Creating B*-Tree, bitmap and function-based Indexes Function-based indexes Finding indexing opportunities Index maintenance Oracle constraints Costs & benefits of constraints Types of Oracle indexes constraints (check, not null, unique, PK, FK) Cascading constraints Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). Monitoring Chained rows (fetch continued rows) Monitoring Insert and Update performance (pctused, APPEND) Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) Oracle DBA Utilities Data pump (Imp and exp utilities) SQL*Loader LogMiner Flashback DataGuard Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
How to Easily Identifying Oracle Locks
 
02:10
How to Easily Identifying Oracle Locks. For more information, please go to: http://www.embarcadero.com/products/dbartisan-xe
Views: 2096 DBPowerStudio
Truncate statement in SQL Server - Part 19 Tamil
 
10:56
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX TRUNCATE statement is used to Remove all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.
Views: 243 IT Port
How to delete duplicate rows in SQL
 
02:57
How to delete duplicate rows in SQL
Views: 2048 X Admin
DDL Triggers in sql server
 
12:31
ddl trigger example ddl trigger example in sql server ddl triggers can be used to In this video we will discuss DDL Triggers in sql server. In SQL Server there are 4 types of triggers 1. DML Triggers - Data Manipulation Language. Discussed in Parts 43 to 47 of SQL Server Tutorial. 2. DDL Triggers - Data Definition Language 3. CLR triggers - Common Language Runtime 4. Logon triggers What are DDL triggers DDL triggers fire in response to DDL events - CREATE, ALTER, and DROP (Table, Function, Index, Stored Procedure etc...). For the list of all DDL events please visit https://msdn.microsoft.com/en-us/library/bb522542.aspx Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. Example - sp_rename system stored procedure What is the use of DDL triggers If you want to execute some code in response to a specific DDL event To prevent certain changes to your database schema Audit the changes that the users are making to the database structure Syntax for creating DDL trigger CREATE TRIGGER [Trigger_Name] ON [Scope (Server|Database)] FOR [EventType1, EventType2, EventType3, ...], AS BEGIN -- Trigger Body END DDL triggers scope : DDL triggers can be created in a specific database or at the server level. The following trigger will fire in response to CREATE_TABLE DDL event. Use SampleDB Go CREATE TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE AS BEGIN Print 'New table created' END To check if the trigger has been created 1. In the Object Explorer window, expand the SampleDB database by clicking on the plus symbol. 2. Expand Programmability folder 3. Expand Database Triggers folder Please note : If you can't find the trigger that you just created, make sure to refresh the Database Triggers folder. When you execute the following code to create the table, the trigger will automatically fire and will print the message - New table created Create Table Test (Id int) The above trigger will be fired only for one DDL event CREATE_TABLE. If you want this trigger to be fired for multiple events, for example when you alter or drop a table, then separate the events using a comma as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Print 'A table has just been created, modified or deleted' END Now if you create, alter or drop a table, the trigger will fire automatically and you will get the message - A table has just been created, modified or deleted. The 2 DDL triggers above execute some code in response to DDL events (CREATE_TABLE, ALTER_TABLE, DROP_TABLE). Now let us look at an example of how to prevent users from creating, altering or dropping tables. To do this modify the trigger as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Rollback Print 'You cannot create, alter or drop a table' END To be able to create, alter or drop a table, you either have to disable or delete the trigger. To disable trigger 1. Right click on the trigger in object explorer and select "Disable" from the context menu 2. You can also disable the trigger using the following T-SQL command DISABLE TRIGGER trMyFirstTrigger ON DATABASE To enable trigger 1. Right click on the trigger in object explorer and select "Enable" from the context menu 2. You can also enable the trigger using the following T-SQL command ENABLE TRIGGER trMyFirstTrigger ON DATABASE To drop trigger 1. Right click on the trigger in object explorer and select "Delete" from the context menu 2. You can also drop the trigger using the following T-SQL command DROP TRIGGER trMyFirstTrigger ON DATABASE Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. The following trigger will be fired when ever you rename a database object using sp_rename system stored procedure. CREATE TRIGGER trRenameTable ON DATABASE FOR RENAME AS BEGIN Print 'You just renamed something' END The following code changes the name of the TestTable to NewTestTable. When this code is executed, it will fire the trigger trRenameTable sp_rename 'TestTable', 'NewTestTable' The following code changes the name of the Id column in NewTestTable to NewId. When this code is executed, it will fire the trigger trRenameTable sp_rename 'NewTestTable.Id' , 'NewId', 'column' Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server_9.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: 63548 kudvenkat
Tutorial#53  Count and Sum  Aggregate Function in Oracle SQL Database| Group by Function in SQL
 
09:01
Explaining How to get Count and Sum Value in Oracle Database in others words what is the aggregate function in Oracle or what are the types of aggregate function in SQL An Aggregate function is a function where the values of multiple rows are grouped together to form a single value of more significant meaning or measurements such as a set, a bag or a list or Aggregate Function in Oracle SQL Database or Aggregate Function in SQL or How to use Count and sum Aggregate Function in Oracle or Types of Aggregate function in SQL Assignment: Assignment link will be available soon: 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: 41 EqualConnect Coach
HOW TO INCREASE THE SIZE OF A DATABASE COLUMN in Oracle Forms via Data Flow Analysis
 
03:07
Learn how you can easily increase the size of a database column using PITSS.CONs Data Flow Analysis. In this video you learn how you can increase the size of a database column and how you identify all dependent objects within your entire application using PITSS.CONs Data Flow Analysis. ▼▼▼▼▼▼▼▼▼▼ MORE DETAILS BELOW ▼▼▼▼▼▼▼▼▼▼▼ In this Video you learn: - How to increase the size of a database column - How to identify all dependent objects within your entire application - How PITSS.CON will help you to do that quickly and easily _______________ LEARN MORE ABOUT ORACLE PITSS.CON ANALYSIS_______________ PITSS US/CANADA/UK: ►Development Analysis: https://pitss.com/solutions/analysis-services/development-analysis/ PITSS D/A/CH: ►Entwicklungsanalyse: https://pitss.com/de/entwicklungsanalyse/ ____________________________ HOW TO FIND US______________________________ PITSS US/Canada/UK: https://pitss.com/ PITSS D/A/CH: https://pitss.com/de/ _______________________CONNECT & STAY UP TO DATE ________________________ Subscribe on Youtube: https://www.youtube.com/user/pitssam Twitter: https://twitter.com/PITSS_GmbH Google+: https://plus.google.com/116912679338809155946/posts LinkedIn US: https://www.linkedin.com/company/pitss-america-llc LinkedIn De: https://www.linkedin.com/company/pitss-gmbh
Views: 84 PITSS
Row Number function in SQL Server
 
07:24
sql server row_number example sql server row number by partition sql server row_number over partition by order by In this video we will discuss Row_Number function in SQL Server. This is continuation to Part 108. Please watch Part 108 from SQL Server tutorial before proceeding. Row_Number function Introduced in SQL Server 2005 Returns the sequential number of a row starting at 1 ORDER BY clause is required PARTITION BY clause is optional When the data is partitioned, row number is reset to 1 when the partition changes Syntax : ROW_NUMBER() OVER (ORDER BY Col1, Col2) Row_Number function without PARTITION BY : In this example, data is not partitioned, so ROW_NUMBER will provide a consecutive numbering for all the rows in the table based on the order of rows imposed by the ORDER BY clause. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (ORDER BY Gender) AS RowNumber FROM Employees Please note : If ORDER BY clause is not specified you will get the following error The function 'ROW_NUMBER' must have an OVER clause with ORDER BY Row_Number function with PARTITION BY : In this example, data is partitioned by Gender, so ROW_NUMBER will provide a consecutive numbering only for the rows with in a parttion. When the partition changes the row number is reset to 1. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (PARTITION BY Gender ORDER BY Gender) AS RowNumber FROM Employees Use case for Row_Number function : Deleting all duplicate rows except one from a sql server table. Discussed in detail in Part 4 of SQL Server Interview Questions and Answers video series. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server_30.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: 87663 kudvenkat
Part 12   Can we join two tables without primary foreign key relation
 
10:38
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/09/part-12-can-we-join-two-tables-without.html Can we join two tables without primary foreign key relation Yes, we can join two tables without primary foreign key relation as long as the column values involved in the join can be converted to one type. ID column in Departments table is not the primary Key and DepartmentId column in Employees table is not the foreign key. But we can still join these tables using ID column from Departments table and DepartmentId column from Employees table, as both the columns involved in the join have same data type i.e int. Select Employees.Name as EmployeeName, Departments.Name as DepartmentName from Employees join Departments on Departments.ID = Employees.DepartmentId The obious next question is, if primary foreign key relation is not mandatory for 2 tables to be joined then what is the use of these keys? Primary key enforces uniqueness of values over one or more columns. Since ID is not a primary key in Departments table, 2 or more departments may end up having same ID value, which makes it impossible to distinguish between them based on the ID column value. Foreign key enforces referential integrity. Without foreign key constraint on DepartmentId column in Employees table, it is possible to insert a row into Employees table with a value for DepartmentId column that does not exist in Departments table. The following insert statement, successfully inserts a new Employee into Employees table whose DepartmentId is 100. But we don't have a department with ID = 100 in Departments table. This means this employee row is an orphan row, and the referential integrity is lost as result Insert into Employees values (8, 'Mary', 'Female', 80000, 100) If we have had a foreign key constraint on DepartmentId column in Employees table, the following insert statement would have failed with the following error. Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted with the FOREIGN KEY constraint. The conflict occurred in database "Sample", table "dbo.Departments", column 'ID'.
Views: 122904 kudvenkat
Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training
 
26:14
Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training Subscribe to OPTGHAR Online IT Training and Placements at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA?sub_confirmation=1 Watch more demo videos at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA Apply for Oracle 11g DBA online training at: http://www.optghar.com/it-training-courses/oracle-11g-online-training-placement-opt-cpt-students/43/20 For more information contact OPTGHAR.com at: 844-678-4427 (844-OPTGHAR) | [email protected] | http://www.optghar.com Oracle 11g – SQL & PL/SQL The Oracle database environment 1.Reviewing basic architecture concepts 2.Oracle 10g Architecture 3.Main features of 9i and 10g Basic SQL*PLUS commands 1.Using script files, START, @, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL Basic SELECT Statement 1.Writing the statement in sql plus, Running the SELECT statement Ordering the output 1.Single Column, Descending order, multiple column sorts Conditional retrieval of data 1.Working with complex conditions, AND OR NOT LIKE BETWEEN Working with variables 1.Creating and using variables, Command substitution Pseudo columns and functions 1.Pseudo Columns, Row num, Sys date, User & UID, the Dual Table 2.Working with character functions 3.UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(), 4.TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE 5.Working with date functions 6.TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY() Using non-character function 1.ROUND (), TRUNC (), SIGN (), Working with multiple tables, Different type of Joins, Writing Outer Joins Using the SET operators 1.Union, Intersect, minus Aggregating data using group functions 1.GROUP BY, HAVING Creating Sub queries 1.Single Row sub queries, Multiple row Sub queries Enhancing groups function 1.ROLLUP, CUBE Transaction Control Language 1.Rollback, Commit, save point Processing hierarchies 1.creating the Tree structure, LEVEL, CONNECT BY Data Manipulation Language 1.INSERT, UPDATE, DELETE Data Definition Language 1.CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE Using Declarative Constraints 1.Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS, USER_IND_COLUMNS, USER_UPDATEABLE_COLUMNS, Materialized Views, Other Data dictionary views Database Security 1.Object Privileges, Granting access to objects Improving query performance 1.Planning and managing the tuning process, Employing tuning tools, Running EXPLAIN PLAN and auto trace, SQL Trace and TKPROF output, Optimizer concepts, Fundamentals of access paths, Gathering object and system statistics with DBMS_STATS, Utilizing hints and optimizer mode, Specifying first-rows optimization, Determining the driving table Other Concepts 1.The Relational Database Model, The system Development Lifecycle, Overview of normalization PL/SQL Blocks 1.Structure, Writing Anonymous Blocks Variables 1.Oracle Data types, TYPE and ROWTYPE declarations, Value assignments Control structures 1.IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, 2.LOOP END , LOOP statement, WHILE condition, FOR condition Cursors 1.Implicit and Explicit Cursors, Cursor Manipulation statements, 2.OPEN FETCH CLOSE EXIT WHEN Printing Values to Screen Procedures 1.Creating and Calling Procedures Functions 1.Creating and Calling Functions Packages 1.Package Header, Package Body Design Tips and Techniques 1.Format of standard packages in an application, Spec and Body, NOCOPY hint Triggers 1.Database triggers, calling procedures from triggers Dynamic SQL 1.EXECUTE IMMEDIATE, DBMS_SQL package Oracle Supplied packages 1.DBMS_OUTPUT, UTL_FILE Collection data types 1.Associative Arrays, Nested tables, VARRAYs Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training Subscribe to OPTGHAR Online IT Training and Placements at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA?sub_confirmation=1 Watch more demo videos at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA Apply for Oracle 11g DBA online training at: http://www.optghar.com/it-training-courses/oracle-11g-online-training-placement-opt-cpt-students/43/20 For more information contact OPTGHAR.com at: 844-678-4427 (844-OPTGHAR) | [email protected] | http://www.optghar.com
Increasing paging space in AIX ( chps -s)
 
02:41
Task:- Add 32MB size to existing paging space paging00 chps -s 2 paging00 -s increase the size of paging space in noof logical partation
introduction to sql - Creating and Managing Tables
 
02:47
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
Views: 127 EasyShiksha TV

Ocean isle north carolina
Milwaukee bucks stadium seating chart
Pediatric ophthalmologist orlando
Victorville youth soccer
Sprinkler world colorado springs