Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1PzGVjjsR2lSlr5EXFzmbIpVN4RMGBkjwU_De6FQyxVI/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1x7-BCc_2Z83vSGjcFZiWGGdtVoRm1AJLRnxp-lXtchU/edit?usp=sharing 1. Таблица DUAL 2. Конструкция WITH. Рекурсивные запросы с конструкцией WITH 3. Иерархические запросы (self joins): START WITH, CONNECT BY, PRIOR, NOCYCLE, ORDER SIBLINGS BY, LEVEL, CONNECT_BY_ISCYCLE, CONNECT_BY_ISLEAF, SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT 4. Псевдостолбцы (pseudocomlumns). 4.1 ORA_ROWSCN (SCN_TO_TIMESTAMP, TIMESTAMP_TO_SCN) 4.2 ROWID (DBMS_ROWID) 4.3 ROWNUM 5. Конструкция SAMPLE 6. Конструкция PIVOT 7. Конструкция UNPIVOT 8. Оператор INSERT INTO SINGLE TABLE 9. Оператор INSERT INTO MULTITABLE: INSERT ALL, INSERT FIRST 10. Оператор UPDATE 11. Оператор DELETE 12. Оператор MERGE 13. Обновляемая VIEW (KEY-PRESERVED TABLE) 14. SQL FUNCTIONS: SYSDATE, EXTRACT, ADD_MONTH, MONTH_BETWEEN, UPPER/LOWER, LENGTH, SUBSTR, INSTR, REPLACE, LTRIM/RTRIM/TRIM, LPAD/RPAD, TO_CHAR, TO_NUMBER, TO_DATE, POWER, ABS, ROUND, CEIL/FLOOR, USER, TRUNC, GREATEST/LEAST Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Views: 5366 Moscow Development Team
In the previous video we talked about adding constraints at the column-level. We made it nice and simple by only requiring a few keywords, but the problem we were having is that we could not assign a name to the constraint, which many people like to do so we can reference easily if we need to at a later time. To do this, it requires a little bit more typing, but it will give us extra flexibility and many consider it to be the higher quality approach to adding constraints. Let's go though a simple example. Let's say we have a users table with a user_id column that we want to make a primary key. We will create the table like this: CREATE TABLE( user_ id NUMBER PRIMARY KEY ) Instead of adding the PRIMARY KEY keywords after the data type, we add: CONSTRAINT user_pk PRIMARY KEY Now, we have assigned the name user_pk to this constraint. You can do the same with other constraints, such as UNIQUE. The syntax would be CONSTRAINT username_un UNIQUE. The other way to create constraints requires to put all of our constraints at the bottom of our table creation rather than inline with the column. This type of constraint is known as a table-level constraints. To make a column a primary key using table-level constraints, we add it to the CREATE TABLE command as if it is another row and use the CONSTRAINT keyword to tell Oracle that what is coming is a constraint, not a column in our table. CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR), CONSTRAINT username_un UNIQUE (username), CONSTRAINT users_pk PRIMARY KEY (user_id) ) The primary differences here is that you have to put the column you are talking about in parenthesis after the PRIMARY KEY keyword. That's because it's at the end of the table and you need a way to tell it what column you are talking about. The option of putting it at the end of the table has the added benefit in this situation because if we needed to have a primary key that is the combination of multiple columns, we can do that by just adding the other column in the PRIMARY KEY parenthesis right after a comma. In summary, there are three ways to make constraints. The first is at the column level, unnamed. The second is at the column level, named. The third is at the table level, also named. In the next video we are going to create a named constraint in Oracle SQL Developer, so stay tuned and be sure to subscribe! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 17983 Caleb Curry
Candidate key definition and understanding with the help of examples. Happy Learning and Keep rising.
Views: 90531 Edu Therapy
In this demonstration, the Multi-Table Protect Job Wizard is used to define a rule for data in multiple Oracle tables. The rule locates columns that share the same type of data so that a protection rule for personally identifiable information (PII) can be applied to that data in multiple tables at the same time.
Views: 581 IRI TheCoSortCo
In this video tutorial, Tahir Hussain Babar (Bob) explains how to implement the History Preserving Transform (which is used when trying to implement a History Preserving Architecture in a Data Warehouse) when using Flowgraphs to perform ETL (Extract, Transform and Load) tasks with SAP Web IDE for SAP HANA in SAP HANA 2.0 SPS00. You can get the scripts from here ; https://github.com/saphanaacademy/SDI/blob/master/HANA2.0_SPS00.txt Thank you for watching. Video by the SAP HANA Academy.
Views: 1127 SAP HANA Academy
Oracle tutorial : Global Temporary Table In Oracle PL SQL create temp table sql This video will explain to you how to create Temporary Tables in Oracle Oracle tutorial : Global Temporary Table In Oracle 1)The data in such a table is stored only as long as the session or transaction lasts and is private for each session. 2)The definition is visible to all sessions. 3)After commit or disconnection, the data is lost but the definition of the table remains. 4)Indexes created on a temporary. 5)Scope of TRUNCATE command is a single database session. There is no effect of TRUNCATE on other sessions. 6)Foreign key constraints are not applicable in case of Temporary tables 7)Temporary tables cannot contain column of persistent collection type Syntax : CREATE GLOBAL TEMPORARY TABLE table_name ( column_name column_data_type … … ) ON COMMIT DELETE ROWS; CREATE GLOBAL TEMPORARY TABLE Emp ( id number(5) NOT NULL, name varchar2(50) NOT NULL, city varchar2(50) NOT NULL ) ON COMMIT DELETE ROWS INSERT INTO Emp VALUES (1, ‘Test1’, ‘city1’); INSERT INTO Emp VALUES (2, ‘Test2’, ‘city2’); INSERT INTO Emp VALUES (3, ‘Test3’, ‘city3’); SELECT COUNT(*) FROM emp; Result = 3 rows COMMIT; SELECT COUNT(*) FROM emp; Result = 0 rows For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle temporary table create temporary table sql temp table
Views: 4240 Tech Query Pond
The concept of Super Key Candidate Key and Primary Key and the conceptual difference. To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-super-key-candidate-key-and-primary-key IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 315665 Techtud
Informatica mdm online Training | Day14 Preserve source system keys in base object table . How to preserve source system keys in informatica mdm . load job in informatica mdm , base object table in informatica mdm , XREF table in informatica mdm . http://tutors99.com/en/online_training_content/course_content/2/Informatica-MDM-Online-Training Please contact us if you need any clarification regarding informatica online training . INIDA : +91-9015376513 USA : +1-3106681444 Email : [email protected] Email : [email protected] Informatica MDM Training informatica mdm Interview Questions And Answers #InformaticaMdmTraining , #InformaticaMdmOnlineTraining ,#InformaticaTraining, #MDMTraining ,#InformaticaMDMCertification,#InformaticaCertification , #InformaticaMdmInterviewQuestions ------------------------------------------ Best Informatica MDM 10.1 Online Training best Informatica MDM 10.1 training etl Informatica MDM 10.1 training free Informatica MDM 10.1 training free Informatica MDM 10.1 training material free Informatica MDM 10.1 training online free online Informatica MDM 10.1 training Informatica MDM 9.7 e learning Informatica MDM 9.7 training course Informatica MDM 9.1 tutorials Informatica MDM 9 course Informatica MDM 9 e learning Informatica MDM 9 free training Informatica MDM 9 online training Informatica MDM administrator training Informatica MDM classes Informatica MDM complete videos Informatica MDM corporate training Informatica MDM course Informatica MDM course in bangalore Informatica MDM course in hyderabad Informatica MDM data quality online training Informatica MDM data transformation e learning Informatica MDM data transformation training Informatica MDM data transformation training course Informatica MDM data transformation tutorials Informatica MDM demo classes Informatica MDM demo session Informatica MDM developer training Informatica MDM etl training Informatica MDM it training Informatica MDM learning material Informatica MDM live demo Informatica MDM live training Informatica MDM live videos Informatica MDM materials Informatica MDM mdm training Informatica MDM online course Informatica MDM online training hyderabad Informatica MDM online training in hyderabad Informatica MDM online training india Informatica MDM Online Training Part1 Informatica MDM online training usa Informatica MDM online training videos Informatica MDM online tutorial Informatica MDM power center training Informatica MDM power exchange training Informatica MDM powercenter course Informatica MDM powercenter e learning Informatica MDM powercenter online training Informatica MDM powercenter training Informatica MDM powercenter training course Informatica MDM powercenter training materials Informatica MDM powercenter training videos Informatica MDM powercenter tutorials Informatica MDM project training Informatica MDM training bangalore Informatica MDM training chennai Informatica MDM training course Informatica MDM training courses Informatica MDM training dallas Informatica MDM training for beginners Informatica MDM training in ameerpet Informatica MDM training in bangalore Informatica MDM training in chicago Informatica MDM training in hyderabad Informatica MDM training in india Informatica MDM training in nj Informatica MDM training in toronto Informatica MDM training in USA Informatica MDM training india Informatica MDM training institute Informatica MDM training materials Informatica MDM training tutorials Informatica MDM training videos Informatica MDM tutorial for beginners Informatica MDM tutorial videosa Informatica MDM Tutorials Informatica MDM tutorials online Informatica MDM video training Informatica MDM video tutorial Informatica MDM video Tutorials Informatica MDM videos Informatica MDM workflow manager Informatica MDM xml transformation learn Informatica MDM 8.6 learn Informatica MDM 9 learn Informatica MDM data transfomation learn Informatica MDM online learn Informatica MDM online free learn Informatica MDM powercenter learning Informatica MDM online Data warehouse ETL training Online Informatica MDM training online training for Informatica MDM online training Informatica MDM power center Informatica MDM tutorial informatica mdm master data management mdm solutions mdm server data management what is mdm master data what is informatica
Views: 218 Informatica MDM Online Training
Lecture By: Mr. Varun Singla Facebook page link : https://www.facebook.com/gatesmashers/ GATE 2005 question for practice The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with on-delete cascade. A C ----- 2 4 3 4 4 3 5 2 7 2 9 5 6 4 The set of all tuples that must be additionally deleted to preserve referential integrity when the tuple (2,4) is deleted is: A (3,4) and (6,4) B (5,2) and (7,2) C (5,2), (7,2) and (9,5) D (3,4), (4,3) and (6,4)
Views: 24621 Gate Smashers
For Complete Video Series visit http://www.studyyaar.com/index.php/module/14-sql More Learning Resources and Full videos are only available at www.studyyaar.com This video clip is part of module available at http://www.studyyaar.com/index.php/learning-program/2-database-management-system-part-1
Views: 2006 StudyYaar.com
Function And Java Class You Can get from Below Link... https://github.com/arulxaviers/Oracle_PLSQL_SHA_256_512_Encryption A Complete Brief Video about How to use Oracle Database Encryption By Using SHA 256 Bit & 512 Bit Algorithms? How to use Oracle SHA 256 Bit & 512 Bit Data Encryption Algorithms? Oracle Data Encryption Database Encryption dbms_crypto.hash example 11g dbms_crypto.hash sha256 dbms_crypto.hash invalid identifier dbms_crypto.hash 12c dbms_crypto.encrypt example encryption and decryption in oracle 11g sys.dbms_crypto.hash example SHA 256 Bit SHA 512 Bit Encryption
Views: 1676 Oracle PL/SQL World
In this video tutorial, Tahir Hussain Babar introduces the concepts of Replication when using Smart Data Integration. In this basic introduction to the concept, we look at using Remote Sources to connect to a SAP ECC system in DB2. We import the KNA1 table, which holds Customer Master Data, and then we look at simply updating some data in SAP GUI, using transaction code XD02 to update some data using the SAP GUI. We check to see that the data is updated in the Virtual table in the Remote Data Source. Next, we look at how data is replicated into SAP HANA by using a .hdbflowgraph to build a simple replication task which extracts data from the Virtual Table, and loads it into the table in SAP HANA, via a "Real-Time" task. Lastly, we look at launching the Realtime Task by executing a Stored Procedure, and demonstrating that the real-time task works. Scripts; https://github.com/saphanaacademy/SDI/blob/master/SPS09.txt Video by the SAP HANA Academy.
Views: 23585 SAP HANA Academy
You use a join to return related rows from two or more database tables. In this episode, Chris gives a quick rundown of the following types of join: - Inner join - Outer join - Full outer join - Cross join For more details on joins, read the Oracle Database SQL Language reference: http://docs.oracle.com/database/122/SQLRF/Joins.htm#SQLRF52355 Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2015 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: 6822 The Magic of SQL
In this tutorial you learn how to build a dashboard prompt, and a dashboard with multiple pages. You also learn how to embed analytics content in dashboard pages. The example in this video is from HCM but applies to all applications that use OTBi and OTBI Enterprise including Oracle Financials Cloud, Oracle Project Portfolio Management Cloud, and Oracle Procurement Cloud. Please note that all of the techniques and concepts in this tutorial also apply to OTBI Enterprise although the available subject areas will be different.
Views: 10398 Oracle EPM Tutorials
Below is link for Useful Pl/SQL Books http://goo.gl/XMy0tt ---------------------------------------------------------- Difference Between Delete and Truncate in Detail On bigger picture they serve the same purpose but there are many Differences listed with examples Point Delete Truncate 1. Data Recovery Delete: Come under the DML Category, we need to commit or Rollback explicitly to make the changes permanent, so we can recover the data by Rollback command fully with in a session or up to a point if Save Points are used Fall In DDL Category (DDL Command issue the Auto commit implicitly) so no chances of Recovery even not using the Flashback table method. But Truncate operations are also logged , they didn’t generate redo SQL but they are logged , view for truncated data info V$LOGMNR_CONTENTS 2. Data Removal Delete Can remove all or selected data using the Where Clause predicates. Or we can say delete any subset of rows We can Truncate complete table or a partition or sub partition of a table. 3. Speed Delete is Slower because oracle maintain the redo logs for Read Consistency (so that every session connected can see a consistent data at a given point of time ) Delete is very time consuming activity especially when table have numerous indexes and Triggers associated with table Faster as no data logs are maintained no associated trigger firing. 4. DML Triggers Firing DML (Delete) triggers associated with table will fire. DML Trigger will not fire in case of truncate method. 5. Flashback Technology Data can be recovered even after commit operation using Flashback Table options Flashback_transaction_query table will give what to recover and up to which point. Data cannot be recovered in truncate method by Flashback table option. 6. Referential Integrity Constraint Behavior if we don’t have related data in child table then we can delete the data from the parent table or we have variants like On Delete Cascade & on Delete set Null. We can’t truncate a table with enable Referential Integrity Constraint, even there is no data in the child table, we have to disable or drop the constraint if we want to truncate the table. Exception: Truncate is possible if the FK is self-referential means primary key and foreign key are on the same table. 7. Space De allocation or Space Utilization No extent reset with delete when deleting rows from a table, extents are not de allocated, So if there were 50 extents in the table before the deletion, there will still be 50 after the deletion. Truncate: When a table is truncated it will free the space allocated except in case of reuse storage clause. This space can subsequently be used only by new data in the table or cluster resulting from insert or update operations .All extents are de allocated leaving only the extents specified when the table was originally created .Example So if the table was originally created with min extents 3, there will be 3 extents remaining when the tables is truncated. When you truncate a table, NEXT is automatically reset to the last extent deleted. 8. High Water Mark Delete will not reset the high water mark Truncate will reset the High Water mark which is very important for performance point of view as in case of full table scan and full index scan oracle will read all the block under high water mark this makes a lot of difference in terms of performance. 9. Cluster No as such restriction with delete. You cannot individually truncate a table that is part of a cluster. You must truncate the cluster, Delete all rows from the table, or drop and re-create the table. 10. Information Capturing Delete : we can capture the row information what we have deleted using Delete Method, f you are deleting multiple records then use composite data types (collections & records) Truncate Don’t have this feature of capturing the deleted records. 11. Function Based Index Impact DELETE You cannot delete rows from a table if a function-based index on the table has become invalid. You must first validate the function-based index. Truncate: No as such restriction 12. UNUSABLE Indexes Delete no as such feature. Truncate if table is not empty then truncate make all unusable indexes to useable. 13. Complex views You cannot delete data from a Complex view except through INSTEAD OF triggers. But we can delete data from simple Views and MV. We cannot truncate a view simple or complex but you can truncate MV with special Features like Preserve MV Logs and Purge MV Logs. 14. Privileges Delete You need to provide delete table privilege on object. Truncate you must have drop table privilege there is no truncate table privilege exists. 15. Domain Index No as such restriction You cannot truncate the object having domain index in invalid or In progress state
Views: 13994 Ram Gupta
To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-normalization IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 511987 Techtud
In this tutorial you learn how to add pivot tables and action links to an analysis in that shows absence data by business unit. The example in this video is from HCM but applies to all applications that use OTBi and OTBI Enterprise including Oracle Financials Cloud, Oracle Project Portfolio Management Cloud, and Oracle Procurement Cloud. Please note that all of the techniques and concepts in this tutorial also apply to OTBI Enterprise although the available subject areas will be different.
Views: 7390 Oracle EPM Tutorials
Held on September 20 2018 Watch Joel Kallman, Senior Director of Software Development, along with a number of experts from the global APEX Community, to discuss Oracle Forms Modernization. Learn about the positive aspects, together with the challenges, of using Oracle APEX to modernize your Oracle Forms applications. Real-world success stories, challenges, and tips are presented. Session Chats: https://apex.oracle.com/pls/apex/f?p=20051:4:1757390683715::NO::P4_ASKTOM_OFFICE_HOUR_ID:157276294837434079139335725983223048710 Key Video Timestamps: Panel Introduction [9:15] Question 1 [11:55] - Can you please give a brief overview of one of your completed projects (or something which is underway)? Question 2 [20:50] - What would you say is your approach in modernization with APEX? Rewrite? Partial migration? Create new apps adjacent to the existing Oracle Forms apps? Question 3 [29:40] - What were some of the biggest challenges you faced in this type of project? Question 4 [36:15] - What was the biggest benefit to the customer? Has the customer been satisfied with the result? Question 5 [41:50] - We always talk about preserving your investment in the back-end business logic, in SQL and PL/SQL. Is this a fallacy? How much of the back-end code had to be modified to work in the new world with APEX? Question 6 [46:30] - Can you describe the process you follow to assess if something is appropriate to be modernized with APEX? Can you give an example of something you would not use APEX to modernize a Forms app? Question 7 [50:55] - How do you go about educating someone to use APEX, who comes from a Forms background? It is Web, and Web is different. Question 8 [1:01:45] - How long does it take for the existing Forms developers to become competent in APEX and Web development? Were they able to carry on with further development on their own? Question 9 [1:04:35] - Can customers do this migration on their own? This Office Hours forum is comprised of our many partners, and if I were watching this, I might think “wow, I need outside help to get this done”. What would you say? Question 10 [1:08:40] - For anyone watching this, who is contemplating modernizing some fo their Forms apps with APEX, do you have any specific advice? 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
Views: 2771 Oracle Developers
The Trace File Analyzer (TFA) Collector Tool is a utility for collecting first failure diagnostics when creating Service Requests with Oracle Support. Using TFA Collector to make diagnostic collections removes questions about what files to collect and upload. TFA knows about all the well known Oracle and operating system diagnostic locations and collects only files that have been modified proximate to problem time specified from any of those well known locations. Larger files are also pruned proximate to problem time specified to reduce the size of the upload. If the system is a clustered environment TFA collects relevant diagnostics from the remote nodes as well. All of this can be accomplished with one simple command. Key features of TFA Collector include: RAC and single instance non-RAC support Time-based collection of relevant files OS Clusterware ASM DB OSW and CHMOS etc Large file pruning Cluster-wide time-relevant collections Analytics for key files DB alert logs Clusterware alert logs ASM alert logs system messages OSWatcher top and slabinfo data Flexible command-line interface Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Views: 5562 Oracle Learning Library
Using MySQL to demonstrate basic design, entity integrity (primary key), attribute constraints (not null, unique) and referential integrity (foreign keys). The series uses a graphical designer, but switches to writing SQL to implement the design in the diagram. There series ends with some insertions and a simple joining of tables.
Views: 399 kgosafomaafo
In this video tutorial, Tahir Hussain Babar introduces the concepts of Data Sources and Data Sinks (Templates Tables) when using Smart Data Quality. He first starts with creating .hdbflowgraphs in order to create Smart Data Quality tasks, which can be used to perform ETL routines. After that, a simple extract and load routine is created which although simple, focuses on explaining the end-to-end steps of creating an ETL task in order to move data from one data source to another. Next, the different objects in the "General" and "Data Provisioning" tabs are investigated and finally we look at how to execute a task. Scripts; https://github.com/saphanaacademy/SDI/blob/master/SPS09.txt Video by the SAP HANA Academy.
Views: 10186 SAP HANA Academy
Hash partitioning Use hash partitioning if your data does not easily lend itself to range partitioning, but you would like to partition for performance and manageability reasons. Hash partitioning provides a method of evenly distributing data across a specified number of partitions. Rows are mapped into partitions based on a hash value of the partitioning key The following example shows how to create a hash partition table. The following example creates a hash-partitioned table. The partitioning column is partno, four partitions are created and assigned system generated names, and they are placed in four named tablespaces (tab1,tab2, ...). CREATE TABLE products (partno NUMBER, description VARCHAR2 (60)) PARTITION BY HASH (partno) PARTITIONS 4 STORE IN (tab1, tab2, tab3, tab4);
Views: 814 Md Arshad
For demo code and more go to https://johnsterrett.com/presentations/table-partitioning-secret-weapon-for-big-data-problems/ Big Data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks. Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.
Views: 433 Procure SQL LLC
by Peter Geoghegan Counterintuitive lessons learned from the implementation effort Talk that examines implementation process on the INSERT...ON DUPLICATE KEY LOCK FOR UPDATE feature proposed for PostgreSQL. "UPSERT" can loosely be described as a DBMS feature that allows a DML statement's author to atomically either insert a row, or on the basis of the row already existing, update that existing row instead, while safely giving little to no further thought to concurrency. One of those two outcomes must be guaranteed, regardless of concurrent activity, which is the essential property of UPSERT. Examples include MySQL's INSERT...ON DUPLICATE KEY UPDATE, or the SQL standard's MERGE statement (as implemented in a number of proprietary systems). The absence of this feature from Postgres has been a long-standing complaint from Postgres users, and an effort to implement an extension to the Postgres INSERT statement, that implements something broadly in line with user expectations in this area was undertaken in 2013. This talk considers the experience of working on that implementation, and examines how the proposed INSERT...ON DUPLICATE KEY LOCK FOR UPDATE feature deals with concurrency issues, visibility issues, the interplay of value locking and row locking, and the general avoidance of unprincipled deadlocking. In order to come up with an implementation that satisfied user expectations, while still preserving and respecting long standing abstractions and conceptual precepts, some interesting and counterintuitive choices were made to resolve the fundamental tension in tying value locking (as always required on a limited scale for unique index enforcement) to row locking (to LOCK FOR UPDATE). Finally, the talk examines the strategic significance of UPSERT, and further use-cases enabled by the feature in the area of multi-master replication conflict resolution.
Views: 562 Andrea Ross
A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. Database Management System or DBMS in short refers to the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.
Views: 471 Rumuni Education
Veteran DBA, developer, and designer Rob Lockard returns for his third 2 Minute Tech Tip with advice on using Oracle Transparent Data Encryption. Want a deeper dive? Rob is presenting a webinar on Oracle Transparent Data Encryption Baseline Practices on August 27, 2015. for more information please see: http://oraclewizard.com/Oraclewizard/2015/07/16/oracle-transparent-data-encryption-baseline-practices-webinar/
Views: 459 ArchBeat Archive
First part of 3 videos - in this episode we download PostgreSQL and set up the tables which we are going to need in future. I also run through each column and explain code. The SQL code is below, replace table_schema with your schema name and table_name with your table's name: http://postgresql.org/ Query 1: delete from table_schema.table_name; copy table_schema.table_name from 'Your Sales Path Here\Accounting_Khadgar_sales.csv' delimiter ',' csv header; commit; Query 2: drop table if exists temp_table; create local temp table temp_table on commit preserve rows as select "itemName", "stackSize", "quantity" as "totalQuantity", round(price/10000::decimal(10,2),2) as "stackSell(g)", to_timestamp(time)::date as date, to_char(to_timestamp(time)::date, 'yyyy-mm') as month, source from query1_table_schema.query1_table_name order by date desc, "stackSell(g)" desc; drop table if exists table_schema.table_name; create table table_schema.table_name as select "itemName", "stackSize", "totalQuantity", "stackSell(g)", ("totalQuantity" / "stackSize") * "stackSell(g)" as total_money, date, month, source from temp_table order by date desc, "stackSell(g)" desc; commit; drop table if exists temp_table; SELECT * FROM table_schema.table_name;
Views: 544 Mythirion
When building dimensional models it is crucial to decide on how changes in source data will be represented in dimension tables. This phenomena is called slowly changing dimensions. When it is not necessary to preserve the history, a Type 1 Slowly Changing Dimension can be used. This technique is commonly used in situations when the changed is implemented to correct an error. This tutorial provides a practical , follow-along, demonstration of how to manage Type 1 Slowly changing dimensions using T-SQL I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 3833 Steve Fox
• Counselling Guruji is our latest product & a well-structured program that answers all your queries related to Career/GATE/NET/PSU’s/Private Sector etc. You can register for the program at: https://goo.gl/forms/ZmLB2XwoCIKppDh92 You can check out the brochure at: https://www.google.com/url?q=http://www.knowledgegate.in/guruji/counselling_guruji_brochure.pdf&sa=D&ust=1553069285684000&usg=AFQjCNFaTk4Pnid0XYyZoDTlAtDPUGcxNA • Link for the complete playlist of DBMS is: https://www.youtube.com/playlist?list=PLmXKhU9FNesR1rSES7oLdJaNFgmuj0SYV • Links for the books that we recommend for DBMS are: 1.Database System Concepts (Writer: Avi Silberschatz · Henry F.Korth · S. Sudarshan) (Publisher: McGraw Hill Education) https://amzn.to/2HoR6ta 2.Fundamentals of database systems (Writer:Ramez Elmsari,Shamkant B.Navathe) https://amzn.to/2EYEUh2 3.Database Management Systems (Writer: Raghu Ramkrishnan, JohannesGehrke) https://amzn.to/2EZGYph 4.Introduction to Database Management (Writer: Mark L. Gillenson, Paulraj Ponniah, Alex Kriegel, Boris M. Trukhnov, Allen G. Taylor, and Gavin Powell with Frank Miller.(Publisher: Wiley Pathways) https://amzn.to/2F0e20w • Check out our website http://www.knowledgegate.in/ • Please spare some time and fill this form so that we can know about you and what you think about us: https://goo.gl/forms/b5ffxRyEAsaoUatx2 • Your review/recommendation and some words can help validating our quality of content and work so Please do the following: - 1) Give us a 5-star review with comment on Google https://goo.gl/maps/sLgzMX5oUZ82 2) Follow our Facebook page and give us a 5-star review with comments https://www.facebook.com/pg/knowledgegate.in/reviews 3) Follow us on Instagram https://www.instagram.com/mail.knowledgegate/ 4) Follow us on Quora https://www.quora.com/profile/Sanchit-Jain-307 • Links for Hindi playlists of other Subjects are: TOC: https://www.youtube.com/playlist?list=PLmXKhU9FNesSdCsn6YQqu9DmXRMsYdZ2T OS: https://www.youtube.com/playlist?list=PLmXKhU9FNesSFvj6gASuWmQd23Ul5omtD Digital Electronics: https://www.youtube.com/playlist?list=PLmXKhU9FNesSfX1PVt4VGm-wbIKfemUWK Discrete Mathematics: Relations:https://www.youtube.com/playlist?list=PLmXKhU9FNesTpQNP_OpXN7WaPwGx7NWsq Graph Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesS7GpOddHDX3ZCl86_cwcIn Group Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesQrSgLxm6zx3XxH_M_8n3LA Proposition:https://www.youtube.com/playlist?list=PLmXKhU9FNesQxcibunbD82NTQMBKVUO1S Set Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesTSqP8hWDncxpCj8a4uzmu7 Data Structure: https://www.youtube.com/playlist?list=PLmXKhU9FNesRRy20Hjr2GuQ7Y6wevfsc5 Computer Networks: https://www.youtube.com/playlist?list=PLmXKhU9FNesSjFbXSZGF8JF_4LVwwofCd Algorithm: https://www.youtube.com/playlist?list=PLmXKhU9FNesQJ3rpOAFE6RTm-2u2diwKn • About this video: This video discusses about the complete process of normalizing a relation table with the help of example. Techniques and shortcut tricks for normalizing a table fast, how to decompose a table from 1NF to BCNF is explained. Steps: 1. Identify the candidate keys with the given functional dependencies. 2. Identify the normal form of the relation. (Trick: Start checking from BCNF and not from 2NF) 3. If the table is in 3NF but not in BCNF, decompose to 3NF i)Remove the attribute which is not the super key and is functionally deriving any prime attribute from the original table. ii)Create a new relation with the removed attribute. iii) Make one of the attributes the key that is common in both tables according to functional dependency. 4. If the table is in 2NF but not in 3NF, decompose to 3 NF and then to BCNF i)Identify any dependencies between non-key attributes in each table. ii)Remove them to form a new table iii)Make one of the attributes to be the key of the new table iv)This becomes the foreign key in the original table. 5. If the table is in 1NF but not in 2NF, decompose to 2NF, then 3NF and then to BCNF. i)Check every functional dependency for any prime attribute in its LHS. ii)If the prime attribute functionally derives any non-prime attribute, it is partial dependency. iii)Remove the prime attribute and the dependent non-prime attribute from original relation and make a new entity. Normalization questions tutorials in hindi, Normalization practice problems for gate , Identify in normal forms in shortest possible time, shortcut trick to identify and decompose a relation in a normal form,Fast identification of normal form, Method to decompose relation into BCNF, Step by step explanation of decomposing tables in the BCNF normal form, DBMS blueprint, DataBase Management system,database,DBMS, RDBMS, Relations, Table, Query, Normalization, Normal forms,Database design,Relational Model,Instance,Schema,Data Definition Language, SQL queries, ER Diagrams, Entity Relationship Model,Constraints,Entity,Attributes,Weak entity, Types of entity,
Views: 155982 KNOWLEDGE GATE
This video contains the information about database key such as primary key, candidate key, super key etc. Database Keys & Types of keys in hindi (Simple Explain) SUPER key | CANDIDATE KEY | PRIMARY key | DBMS | keys in dbms | types of keys | Part 3.10 Key in DBMS in HINDI with examples | SUPER KEY CANDIDATE KEY PRIMARY KEY IN DBMS IN HINDI DBMS - Keys Super, Candidate, Primary, Alternate Types of Keys in a Relation with Example - DBMS Tutorial Super Key Candidate Key Primary Key in DBMS in HINDI Types of keys in dbms in hindi
Views: 70 The Knowledge Adda
To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-illustration/lecture-division IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 22681 Techtud
Concept of Division Operation. To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-division IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 48793 Techtud
Relational Model Data is stored in the form of Tables also called as Relation. Rows are called Tuples. Columns are called Attributes. Degree of the table =No of attributes Primary Key is used to uniquely identify the data in the table. Values in primary key can never have duplicate values or a null value. Foreign Key is used to link two tables. Foreign key refers to the primary key of the other table. Super key is the combination of more than one key which can uniquely identify the data. Alternate Key are the candidate keys which not primary key currently. Integrity Constraints 1. Entity Integrity 2. Referential Integrity 3.Domain Constraints 4. Semantic Constraints
Views: 174 NETCracker CBSE NET/ GATE Computer Sc.
In SQL you can base queries on the results of other queries. This video explains the various types of subquery and their uses, covering: - Inline views - IN & EXISTS - Common table expressions/subquery factoring/with clause - Scalar subqueries Take the course; Databases for Developers: Next Level https://blogs.oracle.com/academy/take-your-sql-skills-to-the-next-level-with-this-free-online-10-part-tutorial Further reading: About Queries and Subqueries: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/About-Queries-and-Subqueries.html Using Subqueries: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Using-Subqueries.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2015 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: 2003 The Magic of SQL
This lecture explains about Null Values in attributes. To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-21 IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE(for 'All India Test Series for GATE-2016'): http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate/ Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about our regularly uploaded new videos.
Views: 18608 Techtud