What is Cardinality and High Cardinality and Low Cardinality in Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 904 TechLake
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 38578 itversity
In this free tutorial you will learn how to generate and read (interpret) an execution plan in Oracle Databases. See more FREE Oracle Tuning tutorials at http://skillbuilders.com/free-oracle-tutorials. Understanding what the Oracle Database does with your SQL is essential to tuning - and the execution plan is the key. Oracle Certified Master DBA John Watson will provide a brief introduction (4 minutes) - which includes John's tuning methodology, then demonstrate EXPLAIN PLAN, SQL*Plus AUTOTRACE and DBMS_XPLAN.DISPLAY_CURSOR. In the tutorial, John will teach you: - How to read an execution plan - Find the 1st step in the plan - Decipher the order of the steps in the plan - That EXPLAIN PLAN can be very misleading Prerequisites: To get the most from this tutorial, you should: 1 Know how to code SQL 2 Be familiar with SQL*Plus 3 Know - in very general terms - what an execution plan is. 4 Have a basic understanding of the Library Cache (this is where Oracle Database stores parsed SQL statements) 5 Have a basic understanding of the Cost Based Optimizer (this is the part of the database that parses your SQL, creates an execution plan. Hopefully the correct - most efficient - plan).
Views: 64355 SkillBuilders
When it comes to writing efficient queries there are a few key concepts that need to be understood. One of them is the Oracle Cost-Based Optimizer (CBO). Although it's called a cost-based optimizer it's actually not the cost we need to focus on primarily to understand why the optimizer makes certain decisions. In this webinar, you will learn the basics of the CBO, see why it is crucial that the optimizer's picture of the data fits reality, why cardinality and selectivity estimates matter so muc
Views: 58410 Redgate Videos
Cardinality feedback, introduced with Oracle Database 11g, has been significantly enhanced with 12c. Cardinality feedback allows the CBO to learn from a cardinality estimate mistake and re-optimize the execution plan. Learn more in this free SQL Tuning tutorial. See all free Oracle Database tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3087 SkillBuilders
This presentation describes the method to understand how oracle calculate cost during explain plan generation
Views: 705 debasis maity
The SQL Server query optimizer uses distribution statistics when creating a query plan. The statistics provide information about the distribution of column values across participating rows, helping the optimizer better estimate the number of rows, or cardinality, of the query results. Cardinality (SQL statements) In SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column (attribute) of a database table. The lower the cardinality, the more duplicated elements in a column
Views: 307 SqlIsEasy
In this video you will learn how the SQL Optimizer uses Density information to compute default cardinality estimations Twitter: http://www.twitter.com/SQLMaestros Twitter: http://www.twitter.com/A_Bansal http://www.SQLMaestros.com http://www.amitbansal.net
Views: 2917 SQLMaestros
Learn how and why equivalent SQL statements can have a dramatic effect on performance. Certified Master J Watson demonstrates...See all our free Oracle Database tutorials at http://skillbuilders.com/free-oracle-tutorials. The Oracle Database cost-based optimizer (CBO) should recognize equivalent SQL statements and re-write them into the most efficient form. Well, nothing is perfect - not even Oracle Database. Sometimes the way you write your SQL can have a dramatic effect on performance. Presented by John Watson, Oracle Certified Master DBA. Some experience with SQL tuning is expected.
Views: 1912 SkillBuilders
Oracle Database SQL Tuning tutorial. Learn what direct and indirect reads are and what impact they have on tuning SQL in Oracle Database. In this free tutorial from www.SkillBuilders.com, Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help. Perhaps most importantly, John will tell you what you can do about it. Intended Audience: Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience.
Views: 1640 SkillBuilders
Learn how to tune SQL - especially in Data Warehouse environments - with Constraints. Constraints provide critical information to the Cost Based Optimizer in the Oracle Database. Don't drop your constraints for query performance! In these 5 lessons, Oracle Certified Master DBA John Watson will demonstrate how constraints - unique, foreign key, not null - improve the execution plan and thus performance of SQL in an Oracle database. View all 5 lessons, free at http://www.skillbuilders.com/oracle-database-sql-tuning-with-constraints.
Views: 898 SkillBuilders
Oracle ACE Alfredo Krieg offers advice on tools for improving database performance in this 2 Minute Tech Tip recorded at the 2016 Great Lakes Oracle Conference in Cleveland, OH.
Views: 321 Oracle Developer Community ArchBeat
To tune a SQL statement, you need to understand the execution plan. Can you identify the 1st step in an execution plan? The 2nd? The 3rd? In this short tutorial, Oracle Certified Master DBA John Watson of SkillBuilders uses a MERGE JOIN to help you understand how to find the order of execution, essential for SQL tuning.
Views: 1179 SkillBuilders
Anju Garg is an Oracle Ace Associate with over 12 years of experience in IT Industry in various roles. Since 2010, she has been involved in teaching and has trained more than a hundred DBAs from across the world in various core DBA technologies like RAC, Data guard, Performance Tuning, SQL statement tuning, Database Administration etc. She is a regular speaker at Sangam and OTNYathra. She also writes articles for All Things Oracle. She is passionate about learning and has keen interest in RAC and Performance Tuning. She shares her knowledge via her technical blog at http://oracleinaction.com/ ABSTRACT--- To improve optimizer estimates in case of skewed data distribution , histograms can be created. Prior to 12c frequency and height balanced histograms could be created. if no. of buckets >= NDV, frequency histogram is created and the optimizer makes correct estimates. If no. of buckets < NDV, height balanced histogram is created and accuracy of optimizer estimates depends on whether a key value is an endpoint or not. The problem of optimizer misestimates in case of height balanced histograms is resolved to a large extent in Oracle Database 12c by introducing top-frequency and hybrid histograms which are created if no. of buckets < NDV. This webinar explores Pre as well post 12c histograms while highlighting the top-frequency and hybrid histograms introduced in Oracle Database 12c.
Views: 3789 AIOUG North India Chapter
Understanding Explain Plans is an excerpt from Oracle SQL Performance Tuning for Developers: http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027 6+ Hours of Video Instruction The focus of Oracle SQL Performance Tuning for Developers LiveLessons is to illustrate coding techniques that ensure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements. Description In this video training, Dan Hotka starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This course then goes in-depth on understanding and controlling the Explain Plan, which is how and in what order Oracle retrieves data. The discussion includes considerable detail, with SQL examples, on how the optimizers--both rule-based and cost-based, but mostly cost-based--make their decisions. Students will work with a variety of SQL statements, reviewing Explain Plans and making changes to make these SQL statements perform better. Lectures include index design, using hints and coding style to control the Explain Plans, and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL profiler. This LiveLessons course takes a close look at indexes: how Oracle selects them, why they are sometimes not used, and how to tell if indexes are being used. This course includes Oracle10g, Oracle11g, and Oracle12c SQL tuning topics. Skill Level Intermediate Learn How To Read and understand Explain Plan content Review an Explain Plan and tell quickly if this is a good plan Understand a good index column candidate from a not-so-good candidate Quickly tell the likelihood if your SQL will use an existing index Use coding and a variety of Hints (directives) that can produce better performing SQL Execute and interpret SQL trace output Who Should Take This Course Oracle programmers Oracle database administrators who need additional training on SQL tuning Course Requirements Working knowledge of the SQL query language http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027
Views: 3293 LiveLessons
If you want to tune queries, you have to look at query plans and you have to understand what they’re showing you. One thing people look for when tuning is “bad cardinality estimates”. If you’ve wondered what that means, and you want to understand how the optimizer uses statistics when creating a query plan, then join me for this session on statistics and query plans. We’ll set the stage with a review of what statistics are, then see how the optimizer uses them and where to find that “cardinality estimate” information in a plan. We’ll also cover the various ways statistics can be updated, explore what happens to plans when those updates occur, and ultimately you will see why understanding how it all works is critical when you’re troubleshooting performance issues. Expect lots of demos so you can truly understand what statistics are, how they're used, and why their management is so essential for good performance.
Views: 264 Saturday Night SQL VG
Hello friends in this video i'm just showing to you what is optimizer statistics into oracle,optimizer help to improve the performance of sql statements during execution period. #ORACLEWORLD #OptimizerStatistics Oracle database Unbeatable,Unbreakable Platform.
Views: 2309 Oracle World
You're up and running with autotrace, looking at the actual execution plan for a query. Now the real work begins! What is it you're actually looking for in the execution plan? This video shows what you need to investigate and how to use the HotSpot feature of SQL Developer 4.1 to highlight parts of the query you need to pay attention to. ============================ 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: 7929 The Magic of SQL
Held on May 1 2018 If you are running an Oracle Database proof of concept or benchmark focusing on performance, what optimizer settings should you use? What statistics do you need to gather and how should you gather them? In this session Nigel Bayliss shows how you can get consistent results and avoid burning time chasing problems. Covers Oracle Database 12c Release 1 onwards. 3:55 The Adaptive Optimizer (12.1) 8:44 The Mechanics of Adaption 12:03 Adaptive Optimizer Settings 16:18 Recommended Defaults 18:53 12.1 Proof of Concept Recommendations 21:26 12.2+ Proof of Concept Recommendations 34:35 Regathering Statistics 42:24 Dynamic Sampling and Parallel 44:55 More General Recommendations 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/ https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 194 Oracle Developers
Apache Spark 2.2 ships with a state-of-art cost-based optimization framework that collects and leverages a variety of per-column data statistics (e.g., cardinality, number of distinct values, NULL values, max/min, avg/max length, etc.) to improve the quality of query execution plans. Leveraging these reliable statistics helps Spark to make better decisions in picking the most optimal query plan. Examples of these optimizations include selecting the correct build side in a hash-join, choosing the right join type (broadcast hash-join vs. shuffled hash-join) or adjusting a multi-way join order, among others. In this talk, we'll take a deep dive into Spark's cost based optimizer and discuss how we collect/store these statistics, the query optimizations it enables, and its performance impact on TPC-DS benchmark queries. Talk contributors: Zhenhua Wang (Huawei Technologies) and Wenchen Fan (Databricks) Session hashtag: #SFdd2
Views: 693 Databricks
'עמי אהרונוביץ, מנהל תחום אורקל בג'ון ברייס מכללת הי-טק, יו"ר ארגון משתמשי אורקל בישראל. מייסד ומנכ"ל DBACES , מציג את הקורס לשיפור ביצועים בסיבת אורקל - SQL TUNING למפתחים ולמנהלי בסיס נתונים. לפרטים נוספים על הקורס הקליקו כאן:http://bit.ly/17kSIYj בואו להיות חברים שלנו בפיסבוק : http://on.fb.me/J6Ru6b
Views: 234 JohnBryceTraining
Oaktable World 2014 Jonathan Lewis on Calculating Selectivity
Views: 1038 kyle Hailey
Learn how to use Oracle Virtual Private Database (VPD) to secure your data. See all lessons at http://skillbuilders.com/12c-TSDP-Tutorial First, Virtual Private Database. What is it? Answer: It's a declarative technique for enforcing security. Typically, it's based on user application context. That was the first limitation of 8i. Backed with 8i context were session-specific. The context variables were sort in the PGA. That means you simply couldn't use this in a web environment. However, global context, with use of 9i, Virtual Private Database became usable for web applications with connection pooling. But whether you're using it to client server or on a three tier environment, it's declarative technique rather than a programmatic technique. I can go behind the back of the application as a DBA and generate predicates to get appended to all SQLs. Select, insert, update, delete the end users. Issue the SQL and I will generate a predicate that filters the access. It's impossible to bypass. All users will have predicates appended to all their code. It doesn't matter whether they're using SQL Plus, Discoverer, Business Objects, Crystal Reports, eBusiness Suites, whatever they're using, I as DBA can filter their access to roles. The end result, different users see different data sets while running the same code and accessing the same tables, hence, the name Virtual Private Database. Different users will think they're seeing a totally different set of tables, but in fact it's one column database, one set of tables hosting a single application shared by all the users. The mechanism - you can apply VPD to tables, to views, to synonyms, and a declarative technique. Once the technique you write a function that generates the predicate, you associate the function with the table. From then on whenever the user issue SQL against that table the Cost-Based Optimizer rewrites the code. The Cost-Based Optimizer rewrites the user SQL to call the function to generate the predicate. The predicate is then appended to the SQL and it's the modified SQL that is parsed and executed. Let's see how this actually works. I'm working here by the way. This is just a perfectly normal 12.1 database. But what I'm going to demonstrate at this point will in fact work on 11g as well. I'm not going to be using any of the 12c enhancements to VPD for this little demonstration. I'll work in the scott schema. What do we have to do? We write a function to generate the predicate string. Create function. And I'll my function vpdf. The function must conform to a fixed specification. It must take two varchar arguments. One of the arguments is intended to be the schema to which the function will be applied. The other argument is the object within the schema to which the function will be applied. And it must return a varchar2, which is the generated predicate. Let's begin. Within this function you can do just about anything. There are some limitations. It's impossible for the function to query or update the table against which the VPD calls here is going to be applied or we violate the rules of purity that we come across so often with PL/SQL. But apart from that, it can do just about anything - including a number of dreadful side effects can be introduced by writing VPD functions. I'm going to do a very simple one on this one. I'll shall simple return immediately a predicate. What predicate? Ename, which is the ename column from this scott.emp table. Ename should equal sys_context. I'll go to the local context, my user end context, and just extract session user. We can see that John has tested this earlier today and therefore the object already was suggesting and he's just dropping it now and cleaning up the recreate. I hope you realize these really are live demonstrations. I'm not just running scripts. I've created a function. What's that function going to do? It's going to return this value here. Test it. Always test it and see what it's actually going to do. I'll select vpdf. I have to give it a couple of arguments. This one will do for now.
Views: 4479 SkillBuilders
Lesson 1 in this tuning tutorial Oracle Certified Master DBA John Watson discusses when a SQL should be tuned and why. i.e. Don't waste your time tuning things that will not help.
Views: 768 SkillBuilders
In this tutorial you will learn how to do performance tuning on Oracle 10g, 11g, 12c databases.
Views: 2451 DBA Pro
Understanding the value of using Explain Plans in SAP HANA Studio to analyze and optimize SQL queries within the SAP HANA database. For more information, please go to http://academy.saphana.com/
Views: 21044 SAP Technology
See all 5 tutorials, free, at SkillBuilders.com/OracleTuningFullTableScans. In summary, serial full table scans were always indirect before 11.2, parallel scans always direct before 11.2. These are the two critical parameters. That hidden parameter _serial_direct_read, remember, defaults to auto so your application may start behaving very differently as you upgrade from 11.2.01 or 11.2.02. Parallel_degree_policy, that defaults to manual. But again, it becomes an option when you go to 11.2 to enable the automatic facility which allows not only automatic tuning to the degree of parallelism but also enables the ability to make indirect reads when doing a full table scan.
Views: 1586 SkillBuilders
Database Solutions. By Thomas Connolly, Carolyn Begg. Do you carry the world on your shoulders? Does every request for... http://www.thebookwoods.com/book01/0201674769.html Author of the book in this video: Thomas Connolly Carolyn Begg The book in this video is published by: Addison-Wesley Professional THE MAKER OF THIS VIDEO IS NOT AFFILIATED WITH OR ENDORSED BY THE PUBLISHING COMPANIES OR AUTHORS OF THE BOOK IN THIS VIDEO. ---- DISCLAIMER --- Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. All content in this video and written content are copyrighted to their respective owners. All book covers and art are copyrighted to their respective publishing companies and/or authors. We do not own, nor claim ownership of any images used in this video. All credit for the images or photography go to their rightful owners.
Views: 100 Johan L. Hagen
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials. In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced). You will also learn the importance of the auto sample size algorithm in 12c and the new "Hybrid" and "Top Frequency" type histograms.
Views: 3569 SkillBuilders
Feel free to contact Call : +91-8870903864 Or E-mail [email protected] ORACLE PERFORMANCE TUNNING 1 – 1: Introduction to Oracle tuning - The top-down approach to tuning - The history of Oracle tuning - A review of the Oracle architecture - The goals of Oracle tuning - Overview of SQL tuning - Oracle network bottlenecks - Oracle RAM usage and bottlenecks - Oracle CPU usage and bottlenecks - Oracle disk I/O overview - Monitoring server (sat, vmstat, top, glance) - Movement toward server consolidation 1 – 2: Oracle disk I/O tuning - History of DASD - Understanding disk I/O - Monitoring disk I/O (AWR, dba_hist_filestatxs) - Sorted hash cluster tables - Disk I/O waits - Oracle data buffer internals (db_cache_size) - Caching data blocks in the PGA (parallel full-table scans) - Blocksize and I/O performance 1 – 3: Oracle CPU Tuning - Finding your cpu_count - Measuring CPU usage with vmstat - Oracle CPU usage - Using processor affinity - _optimizer_cost_model=cpu - Parallel query and CPU 1 – 4: Oracle RAM tuning - all_rows and first_rows optimization and RAM - Multiple data buffers - Multiple blocksizes - Measuring RAM paging - Oracle SGA RAM - Oracle PGA RAM - Using the KEEP pool - Automatic Memory Management (AMM) 1 – 5: Oracle Instance Tuning - Global tuning techniques - Display possible unnecessary large-table full-table scans - Library cache tuning - Finding missing indexes - Tuning the database writer - instance parameter tuning 1 – 6: Oracle SQL Tuning Introduction - SQL tuning hierarchy - SQL tuning goals - optimizer modes - query re-write - cursor_sharing - viewing execution plans (autotrace) - verifying optimal join techniques - parallelizing SQL execution - dynamic statistics - Exercise – count times when a table is invoked - 12c new SQL features - function-based virtual column - adaptive execution plans - 12c new optimizer metadata collection features 2 – 1: AWR and ASH - AWR vs STATSPACK - Reading an AWR report - AWR report analyzer - Basics of predictive modeling for performance - Finding repeating signatures of data 2 - 2: Oracle RAC Tuning - RAC architecture tuning - Tuning disk I/O on RAC - Tuning the cache fusion layer on RAC 2 – 3: Oracle Tuning Pack - creating SQL Profiles - Recommending new indexes - “automatic” SQL Tuning - SQL Performance Advisor (SPA) - recommending object reorganization 2 – 5: Oracle Diagnostic pack - AWR and ASH - real time SQL monitoring - comparing performance periods - Oracle monitoring & alert notifications (setting thresholds) 2 – 6: Oracle Tracing - 10046 tracing - TKPROF tracing - Trace analyzer - Autotrace 3 – 1: Introduction to SQL tuning - Pre-SQL database communications - The evolution of SQL - Declarative languages 3 –2: Optimizing Oracle SQL - Parsing a SQL statement - Semantic parsing - Hard parse vs. soft parse - Decision tree generation - Making SQL reentrant 3 –3: Optimizer statistics - Types of metadata - Index metadata - Segment metadata - Server metadata - System stats 3 – 4: Exposing & Reading Execution Plans - autotrace - SQL*Trace - Determine the steps of an execution plan 3 – 5: altering execution plans - Changing CBO statistics - Changing init.ora SGA parameters - Changing optimizer parameters - Using hints - Using the opt_param hint 3 – 6: Oracle indexing - Overview of Oracle indexing - bitmap indexes - bitmap join indexes - guidelines for creating indexes - function-based indexes (FBI) - index usage monitoring - fishing in the library cache - optimizing indexes - The transient nature of indexing - database modality of workloads - SQL Workload analysis - Identifying EOW, EOM and EOY SQL. - Creating on-demand indexing - oracle text indexes Oracle Performance Tuning training online, Oracle Performance Tuning training material, IBM Websphere Application Server training cost, Oracle Performance Tuning training pdf, Websphere Application Server training in USA uae India, Oracle Performance Tuning training, online Corporate training malaysia Singapore, Oracle Performance Tuning software, Oracle Performance Tuning training in bangalore, Oracle Performance Tuning training institutes in hyderabad, Oracle Performance Tuning training in chennai, Oracle Performance Tuning training in hyderabad, Delhi, Mumbai, Pune, Oracle Performance Tuning, IBM Websphere ApplicationServer webinar, online training singapore, Oracle Performance Tuning eam, Oracle Performance Tuning as a service,Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training maximo scheduler, Oracle Performance Tuning (consumer product) Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training , Post Training Support
In this tutorial you will learn how to do performance tuning on Oracle 10g, 11g, 12c databases.
Views: 3609 DBA Pro
About Speaker Anju Garg is an Oracle Ace Associate with over 12 years of experience in IT Industry in various roles. Since 2010, she has been involved in teaching and has trained more than 100 DBAs from across the world in various core DBA technologies like RAC, Data guard, Performance Tuning, SQL statement tuning, Database Administration etc. SSince 2010, she has been involved in teaching and has trained more than 100 DBA's from across the world in various core DBA technologies like RAC, Data guard, Performance Tuning, SQL statement tuning, Database Administration etc. She is certified for - Oracle 12c OCP (DBA) - Oracle 11g R2 RAC OCE - Oracle 11g Performance Tuning OCE - Oracle 11g SQL statement Tuning OCE - Oracle 11g OCP (DBA) - Oracle 9i OCP (DBA) She presented papers on following papers during SANGAM 14 - Histograms Pre-12c and now - Adaptive Query Optimization Her white paper on " Histograms Pre-12c and now" was published in Issue7 of ORACLE CONNECT (AIOUG publication) published in Dec 2014. She is passionate about learning and has keen interest in RAC and Performance Tuning. She shares her knowledge via her technical blog at http://oracleinaction.com/ .
Views: 3302 AIOUG North India Chapter
Database and Its Applications Full Course | Introduction to Database Management System | Tutorial on SQL | E-R Model and Data Models Data Base Applications Unit Introduction: This unit introduces the term database, its types, and its advantages. It also focuses on basic structure and elements of database. At the end provide solid concept of entities. Unit No. 1 Database Foundation Introduction, Data and Information, Components, Advantages Data Association, Entities, Keys and Its Types, Attributes Data Associations, Data Structure Diagram Unit No. 2 E-R Model and Data Models Basic constructs (Symbols), Degree of Relationships, Cardinality, and Gerund Modeling Time Dependent Data, Super Types, Sub types Hierarchical, Network, Relational, Comparison of All Data Models Relations, Characteristics of relation, Converting E-R Model into Relation Unit. No. 3 Normalization (1NF, 2NF, 3NF) Unit No. 4 Data Base Design (Conceptual Design, Physical Design) Unit No. 5 SQL Introduction Introduction, Creating, Altering & Deleting Table Inserting, Updating, & Deleting Rows, Querying the Tables SQL Functions Arithmetic, Group (Average, Count, Max, Min, Sum) Date, Special Functions (In, Between, Like, Null) Unit No. 6 Introduction to Forms Form Components, Form Module, Blocks, Items, Objects, Object Navigator Properties Window, Layout Editor Unit No. 7 Basic Form Design Using Wizard for Form Design, Customizing a Form Defining Items Buttons, Check Boxes, Display items, List Items, Radio Groups, Text Items Creating LOV, Crating Master Detail Form Unit No. 8 Introduction to Reports Report Design Consideration Report Objects Basic Report Design Objectives Unit No. 1 Importance of Database Database Concepts Various Architectures of Database The Cost, Risk and Environment of Database Management System Difference between Data & Information The Concept of Entity, and Attributes Various Types of Attributes How Entities are recognized in an Entity Type How various types are associated with one another? Objectives of Unit No. 2 Architecture of entity relationship model Various types of relationship How the complexities of relationship are handled Effect of cardinality in relationship How multi value attributes are modeled How time dependent attributes are modeled Associative entity types are modeled Hierarchical data model Network data model Relational data model Why relational data model is in use? The basics of database design Recommended Books: Modern Data Base Management, by Jaffery A. Hoffer Oracle Developer 2000 by Michael Stowe Find us on Facebook: https://web.facebook.com/Computer-Education-for-All-1484033978567298 YouTube: https://www.youtube.com/channel/UCiV37YIYars6msmIQXopIeQ
Views: 30977 Computer Education For all
This is the second part of the video tutorial "Analysing Parallel Execution Skew". In this part I cover the concepts of Data Flow Operations (DFOs) and Data Flow Operation Trees (DFO Trees). Getting a grip at these concepts is important for understanding some of the effects that will be demonstrated in the later parts of this video tutorial. This tutorial also covers new parallel 12c features. See the initial part here: https://www.youtube.com/watch?v=4YKDns1EyTw If you're interested in reproducing the SQLs analysed here, you can find the scripts as part of the following blog post: http://oracle-randolf.blogspot.de/2014/04/analysing-parallel-execution-skew-data.html
Views: 952 Randolf Geist
Presented by Tom Kyte Thurs 21st June 2012 Summary SQL and PL/SQL are deceptively simple, user-friendly languages, which is great for productivity, but also makes it relatively easy to write bad, non-scalable code. Certain features, in particular, seem to sound an irresistible siren call into a world of Oracle applications that perform poorly and yield unpredictable results. In this webinar, Tom Kyte, a Senior Technical Architect at Oracle Corporation, and the man behind asktom.oracle.com, takes a look at a few of the worst offenders: Triggers - much trickery is possible via triggers, and much of it causes pain, confusion and unexpected side effects Indexes, NULLs and cardinality - misinformation abounds with regard to the effect of NULLs on cardinality estimates, and the impact of NULLs on index use Implicit conversions - strings to numbers, strings to dates, raw to string... probably #2 on the list of 'bugs I see time and time (and time) again' With Tom's typically example-driven approach, you'll see first-hand evidence of the damage caused when fundamental features are misused, misunderstood and implemented badly. A live Q+A session with Tom follows the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 587 Redgate Videos
http://www.dbvidya.com/course/sql-tuning-advanced/ [email protected] +91 991 2323 000 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-performance-tuning-videos/ Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-awr/ Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-tool/ ER Data Modeling Course : http://www.dbvidya.com/course/er-modeling/ Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensional-modeling/ Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 125 DbVidya
This talk, by one of the founders of the BigQuery team and a founder and current CTO of Looker, will make the case that BigQuery is not just another Enterprise Data Warehouse. It will show how BigQuery's unique properties follow from its technical architecture. The talk will announce new performance, security, cost, and manageability features. It will also show tricks and tips for getting more out of BigQuery. And finally it will show you how to push BigQuery to do things that you never thought were possible in a Data Warehouse. DA215 Event schedule → http://g.co/next18 Watch more Data Analytics sessions here → http://bit.ly/2KXMtcJ Next ‘18 All Sessions playlist → http://bit.ly/Allsessions Subscribe to the Google Cloud channel! → http://bit.ly/NextSub
Views: 4264 Google Cloud Platform
Lakshmi Mandyam, Director of Server Systems and Ecosystems, discussed the ARM architecture and its role in HP's Moonshot, as well as the impact of a battery-powered philosophy would have on technology trend at the Cube's coverage of HP's New York City hyperscale server launch. Mandyam discussed ARMs evolution since the end of 2011 with hosts Dave Vellante and John Furrier, debating whether or not Moonshot brings an end to the era of 'one size fits all' in the world of servers. 'It's a big step in that direction,' she agreed. Exploring the benefits of ARM architecture, Lakshmi Mandyam said that while it comes with standardization, it also allows for specialization. Partners take advantage of the standard ARM platform and then take it a step further, developing its own solutions, building on the current app convergence trend. "The new normal is going to be more integration," she added, pointing out that ARM is well positioned in that respect, due to its processor technology and multiple partners strategy. The company's server activity started about 4 years ago. It debuted with an OEM partner seeking their help for their issues -- running out of power and space. The company wanted to employ ARM technology, as it was batter powered. This battery-operated philosophy "leads to reducing power usage." The ecosystem is now driven by mobile and tablets, therefore there is quite a lot of interest in ARM architecture and a lot of companies are investing in the technology. The company shipped 1.6 billion chips last year alone. Open source and the changing server market . Speaking of software around the ARM architecture, Mandyam mentioned there was a lot of traction around open source. There is long term support for commercial Ubuntu, she added. She also mentions ARM's own investment in open source software -- its involvement in Linaro, which focuses on Linux innovation. Through this project, ARM and its partners are collaborating and sharing information, HP being part of this effort. HP's new Pathfinder ecosystem will allow them to get things done a lot faster, being able to further drive innovation. Speaking of its involvement in the server market, apart from HP's Moonshot, Mandyam said there are a number of servers soon to be announced that are based on ARM architecture, and even more partners will be basing their server releases on this architecture. Commenting on the importance of power consumption, Mandyam said that the total cost of ownership is more important than just energy. This includes saving on acquisition costs, increased reliability, and other such factors. Discussing the concept of software-defined technolgy, she stated that "the beauty of software-defined is that the end user is going to drive what software-defined really is." The hyperscale space is definitelly software defined, Dave Vellante pointed out, the general aim being to exclude the human component. .Hyperscale and ARM's competitive advantage . As far as the hyperscale world and the traditional enterprise environment coming together are concerned, the success of this convergence depends on circumstances."I actually think that, long-term, people can't ignore this trend. Most workloads in the future will be cloud-based." Therefore, enterprises will have to look at how they can deploy in the cloud, they will have to redefine how they do business. The current trend is to replicate the mobile experience everywhere and that experience today is on ARM, Lakshmi Mandyam added, and people want to duplicate that type of experience to reflect the fundamental shift of being always on, always connected. Regarding which trending metrics drive the industry, Mandyam said performance per watt, or per dollar options are gaining ground, and ARM can deliver for any of these new metrics. Asked to highlight ARM's competitive edge, Mandyam explained that the comapny's whole business model "is really about partnerships. When you think about ARM, it's really ARM and partners," the networks including about 1000 partners. The way the IP is developed, "we have a really long-term view." ARM discusses plans for 2016, and views success as its partners' success. "We scale from micro-controllers to processors that are going into servers. The ability to pick your optimization point, that is the difference we bring to the table." Generally, the reason companies turn to ARM is "because they see it as being a long-term strategic partner." Lakshmi Mandyam, ARM, at HP Moonshot 2013, with John Furrier and Dave Vellante
Views: 1708 SiliconANGLE theCUBE
Learn how your application can benefit from new capabilities in the Azure SQL Database and SQL Server platform, including graph data processing to model complex relationships between objects, and advanced self-tuning query processing to solve or avoid performance related problems. Create a Free Account (Azure): https://aka.ms/azft-sql
Views: 245 Microsoft Developer