Home
Search results “List oracle table indexes”
Collections in Oracle PLSQL
 
13:29
Complete Oracle PL/SQL Tutorial for Beginners Playlist here https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi ************************************************** Composite DataType - Collections in Oracle PL SQL 1. Difference Between Records and Collections 2. Types of Collections in Oracle 3. VARRAYS 4. Nested Table 3. Associative Arrays / Index BY Tables 4. Multi Dimensional Arrays Using Collections and Records
Views: 22997 yrrhelp
Oracle Interview Question - oracle index related questions - BTREE index in oracle
 
23:14
Oracle Interview Question - oracle index related questions 1. What is Index? How to create index? 2. What are the types of index? 3. How to find the list of indexes for a given table? 4. Explain B-tree index 5. Explain Bitmap index 6. Explain "Function based" index 7. Explain "Reverse Key" index 8. When to choose what type of index? 9. How to know index is being used? 10. How to monitor index usage? 11. What are the advantages/drawbacks of indes? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 2478 Siva Academy
A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1
 
08:43
"Why isn't Oracle using my index?!" is a common question people have when tuning SQL queries. In this episode Chris compares two methods for finding all the red candies from party bags he's prepared. He shows how these are like a full table scan and an index range scan. He goes on to compare the performance of these two approaches. He shows when a full table scan becomes more efficient than an index range scan and vice versa. ============================ 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: 9068 The Magic of SQL
Local Vs Global Partitioned Index in Oracle 11g
 
17:30
The Video Explains the difference between Local Partitioned Indexes(Prefixed vs Non Prefixed Indexes). and Global Partitioned Index along with the challenges in maintaining Global partitioned Indexes when the underlying tables partitioned is dropped/truncated/Merged/Moved. Local Partitioned Index Shares the same boundaries as the table and are in the same number as table partitions they are widely used in DSS and DWH systems. While Global Partitioned Index are predominantly used in OLTP systems
Views: 9542 Tech Coach
How Many Indexes Are Too Many?: Finding All The Red Sweets Part 5
 
10:58
Every index you add to a table increases its storage requirements and DML overheads. So it's a good idea to create as few as possible. When you have two or more indexes using the same columns, you may be able to get away with just one. But how do you decide which to keep? This video discusses how to analyze your queries so you can cut the number of indexes you create. ============================ 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: 2523 The Magic of SQL
Which Order Should Columns Go in an Index?: Finding All the Red Sweets Part 4
 
06:19
When you create an index on multiple columns there's an important question you need to answer: In which order should you list the columns? This video looks at some of the factors you should consider to help answer this question. ============================ 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: 4736 The Magic of SQL
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners
 
07:09
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners DESCRIBE Keyword in Oracle DESC Keyword in Oracle DESCRIBE Keyword in Oracle SQL DESC Keyword in Oracle SQL DESCRIBE Keyword in SQL DESC Keyword in SQL Oracle Tutorials for Beginners Oracle SQL for Beginners Oracle Database for Beginners Oracle SQL Tutorials for Biners Oracle Database tutorials for Beginners oracle describe table structure desc table in sql server descending order in oracle how to see table structure in oracle sql developer desc command in mysql pl sql describe table desc command in sql example describe table in sql query how to see table structure in oracle sql developer desc table in sql server sql query to view table structure in oracle oracle describe table invalid sql statement describe table in sql query oracle desc table order by column name describe not working in oracle oracle show tables how to see table structure in oracle sql developer how to get table structure in oracle 11g sql query to list all tables in a database describe table in oracle sql developer sql query to view table structure in sql server oracle get list of tables in schema oracle show tables describe table structure in sql server
Views: 877 Oracle PL/SQL World
SQL Index |¦| Indexes in SQL |¦| Database Index
 
09:57
Indexes in SQL are used to speed up SQL queries. A database index works much like an index in a book. For example, if you have a database table with a list of people, a common query would be to lookup someone by name. Creating an index means the database will not have to scan the entire table looking for matches. Instead, it will restrict its search to a small portion of the rows. In this video we use a table with 100 million rows to illustrate how much an index can change the speed of a query. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
Views: 40284 Socratica
What is the LIST PARTITION in Oracle ?
 
07:56
Hi guys in my today scenario I'm going to explain with you What is the LIST PARTITION in Oracle, #LISTPARTITIONinOracle Oracle database Unbeatable,Unbreakable Platform..
Views: 3732 Oracle World
SCPT 46:Oracle Storage Termininology:  High Water Mark and Free Lists
 
15:31
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 18692 Oresoft LWC
What is RANGE-LIST SUBPARTITIONS in Oracle via OEM ?
 
14:04
Hi friends today in my videos I'm going to explain with you What is RANGE-LIST SUB-PARTITIONS in Oracle via OEM Oracle database Unbeatable,Unbreakable Platform.. # RANGE-LISTSUBPARTITIONS #OEM
Views: 1480 Oracle World
SQL Get list of all tables in a table
 
02:21
SQL Server: How to get tables name from database.
Views: 101 Pramadha just fun
Why Is My Query Slow? More Reasons Storing Dates as Numbers Is Bad
 
05:25
Storing dates as numbers can cause unexpected problems. In this video Chris looks at one possible issue: inconsistent query performance. He then shows methods you can use to improve performance, including function-based indexes and histograms. ============================ 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: 7798 The Magic of SQL
Partitioning in Oracle Explained with Real project Examples : Introduction
 
22:43
This Video series will explain partitioning and its use cases referencing real project examples from different domain. It will explain what when and why of partitioning in a simple but elaborate manner. This is the 1st video which explains why partitioning is required and what are the advantages we gain from it. The following videos will explain when should we do it and how. Part 1 : Partitioning in Oracle : https://www.youtube.com/watch?v=m3q4lrE671Y&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=1 Part 2 : Partitioning in Oracle - Performance Basics :https://www.youtube.com/watch?v=OQ8LXbxLI5g&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=2 Part 3 : List Partitioning in Oracle : https://www.youtube.com/watch?v=w6kB-90pFa4&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=3 Part 4 : Range partitioning in Oracle : https://www.youtube.com/watch?v=VBkpI4Ki49Q&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=4 Part 5 : Hash Partitioning in Oracle : https://www.youtube.com/watch?v=2YxOF_sJMLI&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=5 Part 6 : Composite Partitioning in Oracle :https://www.youtube.com/watch?v=q_e9IkNtSWc&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=6 Part 7 : Reference Partitioning in Oracle :https://www.youtube.com/watch?v=p8gNwr6Rtdo&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=7 Part 8 : Local Vs Global Partitioned Index in Oracle 11g : https://www.youtube.com/watch?v=t77fyUt8XPw&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=8 Part 9 : Partitioning enhancement in 12 c :https://www.youtube.com/watch?v=o_WjapdXiQg&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=9
Views: 35208 Tech Coach
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: 1994 Siva Academy
Indexes in sql server   Part 35
 
11:14
In this video we will learn about What are indexes Why do we use indexes Advantages of indexes These concepts are applicable to sql server 2000, 2005 and 2008 Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/indexes-in-sql-server-part-35.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-35-indexes.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: 424321 kudvenkat
PART 5.3 Indexing in dbms in hindi basics of indexing in dbms primary secondary clustered
 
20:31
• 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 the concept of Indexing in database in Hindi. Important topic of database Indexing like need of indexing in database management indexing, Why we do indexing in files in database, How we do indexing in dbms, Types of indexing, Methods of Indexing, Advantages of Indexing, How to access a file fast in database, Single level Indexing in database file, Multilevel indexing in database file structure in dbms, Dense indexing in database, Sparse Indexing in database, Index file in dbms, Advantages of using Index file in database are discussed. What is Indexing: Additional auxiliary access structure is called indexes, a data technique to efficiently retrieve records from the database files based on some attributes on which the indexing has been done. Dense Index: 1)In dense index, there is an entry in the index file for every search key value in the main file. This makes searching faster but requires more space to store index records itself. 2)Note that it is not for every record, it is for every search key value. Sometime number of records in the main file is greater than = number of search keys in the main file, for example if search key is repeated. Sparse Index: 1)If an index entry is created only for some records of the main file, then it is called sparse index. 2)No. of index entries in the index file is less than No. of records in the main file. Indexing in dbms, Indexing in dbms tutorial in hindi,about indexing in dbms,indexing and hashing in dbms, terminologies in indexing in database,indexing in dbms example,indexing in dbms tutorial,disadvantages of indexing in dbms,indexing in dbms for gate, sparse indexing example, dense indexing in dbms example, 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,DataBase design, database architecture, Degree of relation,Cardinality ratio,One to many relationship,
Views: 199326 KNOWLEDGE GATE
ORADCReport(Oracle Database Configuration Report)
 
01:35
ORADCReport (Oracle Database Configuration Report) Version 1 -Providing Database information -Providing Segments Status information -Providing Session information. -Finding the Top SQL List -Finding the Invalid Objects -Table/Index summary -Tablespace size/usage statistics Supported os : windows Supported JRE : Java Runtime Environment 1.8.x on more Installation Windows : Extract the Archive using zip utility.
Views: 33 optimistic lab
mysql tutorial for beginners (6/8) : Indexes
 
05:48
mysql tutorial for beginners (6/8) : Indexes As things stand, the table students works and can be searched without problem by MySQL—until it grows to more than a couple of hundred rows, At that point, database accesses will get slower and slower with every new row added, because MySQL has to search through every row whenever a query is issued. This is like searching through every book in a library whenever you need to look something up. Of course, you don’t have to search libraries that way, because they have either a card index system or, most likely, a database of their own. The way to achieve fast searches is to add an index, either when creating a table or at any time afterward. But the decision is not so simple. For example, there are different index types such as a regular INDEX, PRIMARY KEY, and FULLTEXT. Also, you must decide which columns require an index, a judgment that requires you to predict whether you will be searching any of the data in that column. And even when you’ve decided that, you still have the option of reducing index size by limiting the amount of each column to be indexed. If we imagine the searches that may be made on the students table, it becomes apparent that all of the columns may need to be searched. Anyway, go ahead and add an index to each of the columns, using the commands: ALTER TABLE students ADD INDEX(name(3)); An alternative to using ALTER TABLE to add an index is to use the CREATE INDEX command. They are equivalent, except that CREATE INDEX cannot be used for creating a PRIMARY KEY CREATE INDEX surname ON students (surname(5)); DESCRIBE students; These commands create indexes on both the name and surname columns, limiting name index to only the first 3 characters, and surname index to the first 5 characters. For instance, when MySQL indexes the following name: SAFAA It will actually store in the index only the first 3 characters: SAF This is done to minimize the size of the index, and to optimize database access speed. DESCRIBE command shows the key MUL for each column. This key means that multiple occurrences of a value may occur within that column, which is exactly what we want, as name or surname may appear many times. You don’t have to wait, until after creating a table to add indexes. In fact, doing so can be time-consuming, as adding an index to a large table can take a very long time. Therefore, let’s look at a command that creates the table students with indexes already in place. CREATE TABLE students ( Id_studnet SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(10) NOT NULL, surname VARCHAR(20) NOT NULL, email VARCHAR(30) NOT NULL, INDEX(name(3)), INDEX(surname(5)), ,PRIMARY KEY(id_studnet),UNIQUE(email)); Another important index, PK, its single unique key for each student to enable instant accessing of a row. The importance of having a key with a unique value for each row will come up when we start to combine data from different tables. You can add PK, while you create the table at the first time, or later by issuing the following command: ALTER TABLE students ADD PRIMARY KEY(id_student); The last important index, FULLTEXT index Unlike a regular index, MySQL’s FULLTEXT allows super-fast searches of entire columns of text. It stores every word in every data string in a special index that you can search using “natural language,” in a similar manner to using a search engine. It’s not strictly true that MySQL stores all the words in a FULLTEXT index, because it has a built-in list of more than 500 words that it chooses to ignore because they are so common that they aren’t very helpful for searching anyway. This list, called stopwords, includes the, as, is, of, and so on. The list helps MySQL run much more quickly when performing a FULLTEXT search and keeps database sizes down. FULLTEXT indexes can be created for CHAR, VARCHAR, and TEXT columns only. A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE (or CREATE INDEX). Adding a FULLTEXT index to the table students for the columns name and surname ALTER TABLE classics ADD FULLTEXT(name,surname); this index is in addition to the ones already created and does not affect them You can now perform FULLTEXT searches across this pair of columns. If you find that MySQL is running slower than you think it should be when accessing your database, the problem is usually related to your indexes. Either you don’t have an index where you need one, or the indexes are not optimally designed. Tweaking a table’s indexes will often solve such a problem. In the next tutorial, we will learn about, using FOREIGN KEY Constraints and how to join tables together. Subscribe for more: ---------------------------------------------------------------------------- https://www.youtube.com/subscription_center?add_user=saf3al2a SWE.Safaa Al-Hayali - saf3al2a
Views: 31838 Safaa Al-Hayali
List Partitioning in Oracle
 
03:47
Understanding and creating list partition
Views: 65 Koenig Solutions
SDU Tools   18   List Table and Index Sizes in a SQL Server Database
 
02:11
SDU Tools are a free set of T-SQL tools (Registration is required) to help developers and database administrators (DBAs) working with SQL Server. This video shows how to use procedures from the tools to find the size of tables or the size of both tables and indexes. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 173 SQL Down Under
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
Finding Database Columns By Name in Oracle SQL Developer
 
05:11
How to find all columns in your Oracle Database by searching on the name.
Views: 7696 Jeff Smith
SQL indexing in 9 minutes and a half
 
09:38
CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. Proper indexing is one of the keys to database performance - yet a disturbingly high number of people have it more or less wrong. This presentation is based on material from a seminar.
Views: 62231 roughsealtd
14.300 Motivation for Index Structures, Selectivities, Scan vs. Index Access on Disk and Main Memory
 
16:39
Video for my inverted classroom "Database Systems". The complete list of videos and additional material is (will be) available at http://datenbankenlernen.de Computer Science, Saarland University: Bachelor (in German): http://www.cs.uni-saarland.de/index.php?id=52&L=1 Master (in English): http://www.cs.uni-saarland.de/index.php?id=132&L=1 Ph.D./Grad School: http://gradschool.cs.uni-saarland.de/
Partitioning in Oracle - Performance Basics
 
28:35
This is the 2nd video from " Partitioning in Oracle " series, It explains how oracle stores and manages data. What is single Block IO and Multi Block IO ? Why full table scan is better than index access in few cases. The video is very elaborate, I have tried my level best to keep it as simple as possible
Views: 13844 Tech Coach
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: 96695 kudvenkat
how to create and drop table in oracle sql || oracle sql tutorial 11
 
12:49
in this video i will show you how to create table in oracle sql for more detail join our facebook group ,https://www.facebook.com/groups/242999206136244/ Oracle - SQL Table Basics Create Table The mechanics of creating a table are relatively straight forward. Being able to design a well thought out database that will scale to meet the needs of a large scale enterprise is a very challenging undertaking. In these examples we will be working through development of a fairly simple three table database. In doing so we will get to cover a good deal of the development basics for creating tables and indexes. It is possible, though not advised to create a table without a primary key. I will discuss primary keys on a different page yet to be created. It is also possible to set initial default values for a column though none of the columns in our tables were suitable candidates to do this. There are many good primers on creating tables and databases. The purpose of this page is just to show the basic Oracle syntax by example for creating a table. Also, taking the create table for an existing table and using it as a model is also a very good practice and means of learning. .----------------------------------------------------------------------------------------------------------. video courses- list of playlist : tips and trics link► https://www.youtube.com/playlist?list=PLOfLYVXrwqXrI5jvwUEi6N13QR4xCj2k2 command prompt commands: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXobXGUdGk6JhzyQ216dNiQL oracle sql: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXqoUWCoh4cARGDW13SofDO- c programming: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXrZ_Ub8EXeLY7YP1YxhoJzf .-----------------------------------------------------------------------------------------------------------. watch more videos: learn oracle sql online overview tutorail : https://www.youtube.com/watch?v=Dfesgj4w8QA&t=8s how to fix or repair a corrupted usb flash drive or cd card using command prompt: https://www.youtube.com/edit?video_id... how to copy a folder using cmd: https://www.youtube.com/watch?v=Lblhb... how to move a folder using cmd: https://www.youtube.com/watch?v=YFfHZ... how to dell files in cmd: https://www.youtube.com/watch?v=3-lqg... how to make and remove directory: https://www.youtube.com/edit?video_id... how to change color and title in cmd: https://www.youtube.com/edit?video_id... how to change directory in command prompt: https://www.youtube.com/watch?v=SmLYx... .-----------------------------------------------------------------------------------------------------------. social media links: join our group: ► https://www.facebook.com/groups/24299... ► Follow on Google+: http://[email protected] ► Follow on Twitter: https://twitter.com/@rananavi4766669 :
Views: 10 The Learning Tree
List all objects in SQL Server database
 
04:20
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Get List Of All Tables, Views, Indexes, Constraints and Triggers in a SQL Server database
Views: 33 IT Port
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: 14301 OracleDBVision
AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)
 
59:56
This session is for those who already have some familiarity with DynamoDB. The patterns and data models discussed in this session summarize a collection of implementations and best practices leveraged by Amazon.com to deliver highly scalable solutions for a wide variety of business problems. The session also covers strategies for global secondary index sharding and index overloading, scalable graph processing with materialized queries, relational modeling with composite keys, and executing transactional workflows on DynamoDB.
Views: 80005 Amazon Web Services
part 9 - list partition
 
02:21
list partition, data warehousing, alter table
SQL Indexes - Part 11
 
15:28
SQL Indexes for ORACLE DBA. http://oracledbatech.com
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: 3867 SkillBuilders
oracle plsql records and collections NESTED Table
 
13:08
oracle plsql records and collections NESTED Table 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: 806 Siva Academy
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: 192310 Manish Sharma
Oracle Tutorial || Oracle|Sql Diff Type of Tables Part-2 by basha
 
35:55
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle 11g DBA Bangla Tutorial |Ch9_3-Managing Schema Objects | Database Management System |Training
 
28:03
See the Description for required source code and links Oracle DBA Tutorial Source Code of Oracle Database Training: https://drive.google.com/open?id=0Bz0MNaVyRm3lOFBQdE9EOWJFSnc Chapter-9 : Managing Schema Objects. In this chapter, you will know about oracle data types, types of constraints, create and modify table, create and modify index, temporary tables, customer database schema and schema object. The constraint, index and customer database schema is a important in oracle. Oracle DBA training including database design is special computer training designed online courses on Database Management System. It is fully bangla tutorial of Oracle 11g database administration. It will be much helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database Administration PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3la2dYR1A1SlRiVlk All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3ldTUwaTd4cjVka0k Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Oracle - SQL Tutorial link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lTWNhMURIbFV1MjA FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ N.B: In the video tutorial, I have tried to describe steps to create index, customer database schema, schema object, constraint, tables in oracle database. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DBA]
Views: 267 MD. SHARIFUL ALAM
How to Learn Oracle Step by Step: 1
 
38:11
Description Prepare for the Oracle Certified Associate Oracle Database 12c Installation and Administration exam with this exclusive exam practice test. EXAM DETAILS: Duration: 120 min No of questions: 67 Passing score: 64% Exam price: US$ 245 Exam Topics: Exploring the Oracle Database Architecture List the architectural components of Oracle Database Explain the memory structures Describe the background processes Oracle Database Management Tools Use database management tools Oracle Database Instance Understand initialization parameter files Start up and shut down an Oracle database instance View the alert log and access dynamic performance views Configuring the Oracle Network Environment Configure Oracle Net Services Use tools for configuring and managing the Oracle network Configure client-side network Configure communication between databases Administering User Security Create and manage database user accounts Grant and revoke privileges Create and manage roles Create and manage profiles Managing Database Storage Structures Describe the storage of table row data in blocks Create and manage tablespaces Create and manage tablespaces Explain how Oracle database server automatically manages space Save space by using compression Use the Segment Advisor Reclaim wasted space from tables and indexes by using the segment shrink functionality Managing Undo Data Explain DML and undo data generation Monitor and administer undo data Describe the difference between undo data and redo data Configure undo retention Managing Data Concurrency Describe the locking mechanism and how Oracle manages data concurrency Monitor and resolve locking conflicts Implementing Oracle Database Auditing Enable standard database auditing and unified auditing Backup and Recovery Concepts Identify the importance of checkpoints, redo log files, and archive log files Backup and Recovery Configuration Configure the fast recovery area Configure ARCHIVELOG mode Performing Database Backups Create consistent database backups Back up your database without shutting it down Create incremental backups Automate database backups Manage backups Performing Database Recovery Determine the need for performing recovery Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file Moving Data Describe ways to move data Use SQL*Loader to load data from a non-Oracle database Use external tables to move data via platform-independent files Explain the general architecture of Oracle Data Pump Use Data Pump Export and Import to move data between Oracle databases Performing Database Maintenance Use server-generated alerts Managing Performance: SQL Tuning Use the SQL Tuning advisor Automating Tasks by Using Oracle Scheduler Use Oracle Scheduler to simplify management tasks Use job chains to perform a series of related tasks Use Scheduler jobs on remote systems Use advanced Scheduler features to prioritize jobs Creating an Oracle Database Using DBCA Generate database creation scripts by using DBCA Manage database design templates by using DBCA Upgrading Oracle Database Software Describe data migration methods Describe the upgrade process Introduction to DBAAS Recognize the difference between a DBaaS Instance and a Database Instance Navigate with My Services Dashboard User authentication and roles Generate a Secure Shell (SSH) Public/Private Key Pair Who this course is for: Database Administrators who wants to attain Oracle 12c OCA certification System Administrator or Administrator Any DBA who wants to clear 1Z0-062 in next 15 days
Views: 27 america new york
Table valued parameters in SQL Server
 
06:46
table valued parameters example send table variable to stored procedure pass table variable as parameter to stored procedure pass table variable to sql stored procedure In this video we will discuss table valued parameters in SQL Server. Table Valued Parameter is a new feature introduced in SQL SERVER 2008. Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure from T-SQL code or from an application. Prior to SQL SERVER 2008, it is not possible to pass a table variable as a parameter to a stored procedure. Let us understand how to pass multiple rows to a stored procedure using Table Valued Parameter with an example. We want to insert multiple rows into the following Employees table. SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10) ) Go Step 1 : Create User-defined Table Type CREATE TYPE EmpTableType AS TABLE ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) Go Step 2 : Use the User-defined Table Type as a parameter in the stored procedure. Table valued parameters must be passed as read-only to stored procedures, functions etc. This means you cannot perform DML operations like INSERT, UPDATE or DELETE on a table-valued parameter in the body of a function, stored procedure etc. CREATE PROCEDURE spInsertEmployees @EmpTableType EmpTableType READONLY AS BEGIN INSERT INTO Employees SELECT * FROM @EmpTableType END Step 3 : Declare a table variable, insert the data and then pass the table variable as a parameter to the stored procedure. DECLARE @EmployeeTableType EmpTableType INSERT INTO @EmployeeTableType VALUES (1, 'Mark', 'Male') INSERT INTO @EmployeeTableType VALUES (2, 'Mary', 'Female') INSERT INTO @EmployeeTableType VALUES (3, 'John', 'Male') INSERT INTO @EmployeeTableType VALUES (4, 'Sara', 'Female') INSERT INTO @EmployeeTableType VALUES (5, 'Rob', 'Male') EXECUTE spInsertEmployees @EmployeeTableType That's it. Now select the data from Employees table and notice that all the rows of the table variable are inserted into the Employees table. In our next video, we will discuss how to pass table as a parameter to the stored procedure from an ADO.NET application Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server_17.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: 71560 kudvenkat
KISS series on Partitioning: 05 How to create a list partitioned table
 
04:33
Welcome to the KISS video series on Partitioning, where we take a more developer-centric look at how partitioning can make our applications more successful. In this session, we look at hash partitioning Scripts: https://livesql.oracle.com/apex/livesql/file/content_EXS3Y4LQGPTUGO223O3PGK2K9.html blog: https://connor-mcdonald.com ========================================­­============== 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: 560 Connor McDonald
ORADPReport(Oracle Database Performance Report)
 
01:54
ORADPReport (Oracle Database Performance Report) Version 1 -Providing Top SQL information -Providing RAC Status information -Providing File I/O information. -Finding the Top SQL List -Table/Index I/O summary Supported os : windows Supported JRE : Java Runtime Environment 1.8.x on more Installation Windows : Extract the Archive using zip utility.
Views: 15 optimistic lab
Part 5   SQL query to find employees hired in last n months
 
04:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-5-sql-query-to-find-employees.html This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer. -- Replace N with number of months Select * FROM Employees Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 191431 kudvenkat
Database Design 22 - Look up Table
 
16:53
Donate!: http://bit.ly/DonateCTVM2. A look up table is a table with a list of all possible values for a column in a different table. These values are then accessed through a foreign key. This is often used for one to many relationships where the many has only so many possibilities. More content: http://CalebCurry.com Courses for Download: http://www.udemy.com/u/calebcurry/ Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Subscribe (it's free!): http://bit.ly/PqPyvH Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 40657 Caleb Curry
Oracle 11g DBA Bangla Tutorial |Ch9_2-Managing Schema Objects | Database Management System |Training
 
37:46
See the Description for required source code and links Oracle DBA Tutorial Source Code of Oracle Database Training: https://drive.google.com/open?id=0Bz0MNaVyRm3lOFBQdE9EOWJFSnc Chapter-9 : Managing Schema Objects. In this chapter, you will know about oracle data types, types of constraints, create and modify table, create and modify index, temporary tables, customer database schema and schema object. The constraint, index and customer database schema is a important in oracle. Oracle DBA training including database design is special computer training designed online courses on Database Management System. It is fully bangla tutorial of Oracle 11g database administration. It will be much helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database Administration PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3la2dYR1A1SlRiVlk All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3ldTUwaTd4cjVka0k Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Oracle - SQL Tutorial link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lTWNhMURIbFV1MjA FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ N.B: In the video tutorial, I have tried to describe steps to create index, customer database schema, schema object, constraint, tables in oracle database. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DBA]
Views: 302 MD. SHARIFUL ALAM
Oracle 11g DBA Bangla Tutorial |Ch9_4-Managing Schema Objects | Database Management System |Training
 
41:24
See the Description for required source code and links Oracle DBA Tutorial Source Code of Oracle Database Training: https://drive.google.com/open?id=0Bz0MNaVyRm3lOFBQdE9EOWJFSnc Chapter-9 : Managing Schema Objects. In this chapter, you will know about oracle data types, types of constraints, create and modify table, create and modify index, temporary tables, customer database schema and schema object. The constraint, index and customer database schema is a important in oracle. Oracle DBA training including database design is special computer training designed online courses on Database Management System. It is fully bangla tutorial of Oracle 11g database administration. It will be much helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database Administration PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3la2dYR1A1SlRiVlk All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3ldTUwaTd4cjVka0k Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Oracle - SQL Tutorial link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lTWNhMURIbFV1MjA FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ N.B: In the video tutorial, I have tried to describe steps to create index, customer database schema, schema object, constraint, tables in oracle database. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DBA]
Views: 258 MD. SHARIFUL ALAM
What is a HashTable Data Structure - Introduction to Hash Tables , Part 0
 
07:37
This tutorial is an introduction to hash tables. A hash table is a data structure that is used to implement an associative array. This video explains some of the basic concepts regarding hash tables, and also discusses one method (chaining) that can be used to avoid collisions. Wan't to learn C++? I highly recommend this book http://amzn.to/1PftaSt Donate http://bit.ly/17vCDFx STILL NEED MORE HELP? Connect one-on-one with a Programming Tutor. Click the link below: https://trk.justanswer.com/aff_c?offer_id=2&aff_id=8012&url_id=238 :)
Views: 826056 Paul Programming
Oracle Database 11g - SQL Bangla Tutorial |Ch12_2- How to create View, Synonyms, Sequence, Index
 
38:48
See the Description for required source code and links SQL Tutorial Source Code of Oracle Database 11g Training: https://drive.google.com/open?id=0Bz0MNaVyRm3ldDZkT3ZfWFlOVDQ Chapter-12: Creating Other Schema Objects. In this video tutorial, you will know how to create, alter, drop schema objects such as View, Synonyms, Sequence, Index. The View, Synonyms, Sequence, Index are important object for database management. This is special computer training designing online courses on Database Management System. It is fully bangla tutorial. It will be helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lUWpGbXMyX3lRUTg All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3lMjFVcXhzMjNvWDA All SQL & PL SQL Tutorials are found in the link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lWDB0V1JOOE93eUE FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ In the tutorial, I have tried to describe about how to create and manage View, Synonyms, Sequence, Index in oracle database. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DATABASE]
Views: 408 MD. SHARIFUL ALAM
Part 2   SQL query to get organization hierarchy
 
10:14
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-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 311714 kudvenkat
Oracle SQL 10 Altering a table using SQL commands Hands On
 
21:01
USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions." sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic, PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure ,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan, PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL