Home
Search results “Oracle json query” for the 2017
CodeTalk Series: JSON in the Oracle Database
 
01:01:21
Steven Feuerstein, Oracle Corporation Darryl Hurley, Implestrat.com Did you know that Oracle Database 12c makes it easy for you to store, manipulate, and serve up JSON documents? You certainly do NOT need to install a document store database side-by-side with Oracle Database when your UI developers start demanding JSON! Join Steven Feuerstein for an interview with and demonstrations by Darryl Hurley of Implestrat.com. Darryl, an active database developer and DBA for many years, has lately been diving into the JSON features of 12.1 and 12.2. Make sure you are positioned to have a smart conversation with the JavaScript developers in your company about how you can help meet their JSON needs.
Views: 495 ODTUG
Model JSON Data in Oracle NoSQL Database
 
04:36
In this video, you learn how to model JSON data in Oracle NoSQL Database. Modeling JSON data includes storing, retrieving, querying, and indexing JSON data. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.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.
One SQL Cheat Code For Amazingly Fast JSON Queries - SQL JSON Index performance
 
10:41
How non-persisted computed column indexes make your JSON queries high performance. Did you know that non-persisted columns actually get saved to the index pages? This makes JSON querying incredibly fast in SQL Server. Please like and subscribe if you enjoyed this video! Blog post: https://bertwagner.com/2017/05/09/one-sql-cheat-code-for-amazingly-fast-json-queries/ Want to receive the latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/ Elsewhere on the internet: https://bertwagner.com https://twitter.com/bertwagner
Views: 1958 Bert Wagner
Top 10 Tips for JSON Processing in Database
 
44:46
Beda Hammerschmidt presents the Top 10 Do's and Don'ts for JSON Processing in the database.
Views: 1210 Oracle Developers
ORDS and the New SQL/JSON Database Functions - Part 1
 
15:10
Shows how to use the new SQL/JSON functions available in Oracle Database 12c to insert the data in nested JSON objects into multiple tables in the Oracle database as one transaction using REST and Oracle REST Data Services (ORDS). For more detail also see blog post https://blogs.oracle.com/newgendbaccess/entry/inserting_nested_json_objects_into
REST Enabling the Oracle Database
 
01:04:42
Presenter: Colm Divilly, Oracle Corporation This session will demonstrate how quickly one can install and configure Oracle REST Data Services (ORDS) to provide/serve REST endpoints on both RESTful Services and Database Objects themselves. A brief overview of REST concepts will be followed by a demo of ORDS being installed in less than 5 minutes. Then a series of demos showing how easy it is to REST enable a table and use GET/POST/DELETE to provide a full CRUD API to your data, including complex scenarios involving complex data types like SDO_GEOMETRY and rich web applications that can take advantage of JSON. REST is the new development paradigm and the Oracle Database is 100% ready with the addition of ORDS.
Views: 257 ODTUG
Oracle Database 12c as a JSON document store
 
00:29
Morpho Database Architect, Aris Prassinos discusses using Oracle Database 12c as a JSON document store.
Query JSON Object SQL SERVER 2016
 
03:33
Query JSON Object in SQL SERVER 2016
Views: 150 Modern Pathshala
An Introduction to REST and JSON
 
04:32
Learn about Representational State Transfer REST) and JavaScript Object Notation. This videos forms part of the Oracle Cloud Primer Series. For more details visit the Cloud Primer Playlist at: http://bit.ly/cloud_primers ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll 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.
From SQL to N1QL: structured querying for JSON – Connect NY 2017
 
41:07
Speakers: Keshav Murthy, Director, Query Development, Couchbase Kevin Holder, VP, WW Technical Field Operations JSON is the lingua franca of flexible data management, used to define complex, variably structured data objects. SQL is the universally known structured query language, used for well defined, uniformly structured data. Can SQL be used to query JSON? Yes, it can when you use N1QL – Couchbase’s SQL query language for JSON. In this session, we’ll explore how N1QL extends SQL to leverage the universality of SQL as a query language, while also leveraging the flexibility and agility inherent in JSON. See extensive examples of using SQL to directly query complex JSON objects that include arrays, sets, and nested objects. Learn about the powerful query expressiveness of N1QL, including the latest features that have been added to the language. Get practical examples of using N1QL to solve real-world application challenges, based on queries used by Couchbase customers. Slideshare: https://www.slideshare.net/Couchbase/from-sql-to-n1ql-structured-querying-for-json-couchbase-connect-new-york-2017/1 Visit our website for more information: https://www.couchbase.com/
Views: 591 Couchbase
json to table
 
08:57
Download code: http://codewithmark.com/convert-your-api-json-data-to-html-table Awesome Functions: http://awesomefunctions.com Please watch: "Learn how to create secure Rest API calls - Code With Mark" https://www.youtube.com/watch?v=VQlOZdbNQ0Q
Views: 21628 Code With Mark
Oracle REST Data Services Development with Oracle SQL Developer
 
16:00
Version 4.2 of Oracle SQL Developer makes it very easy to develop and deploy your Oracle REST Data Services for your Oracle Database.
Views: 10434 Jeff Smith
Python With Oracle Database
 
11:51
Import CSV data into oracle table using python Reference : http://guideme360.in/2017/08/25/python-oracle-database/ Channel : https://www.youtube.com/c/GuideMe
Views: 10882 The Programming Guy
Oracle Retrieve data from XML Document using XMLTable
 
17:49
Oracle retrieve data from xml document using xmltable
Views: 5526 Sridhar Raghavan
Make the RDBMS Relevant Again with RESTful Web Services and JSON
 
45:55
Timothy Hall, DBA, Developer, Author, Trainer, oracle-base.com The rise of JavaScript has made JSON support an essential part of most systems. This session describes ways to add JSON support to your existing applications, using a variety of tools, including Oracle REST Data Services, the APEX_JSON and APEX_WEB_SERVICE packages, and the JSON support built into Oracle Database 12c.
Views: 406 Oracle Developers
SQL Database Fundamentals: 13 Introduction to JSON
 
04:10
Would you like to learn the basics of relational databases? Join us for this look at SQL Database fundamentals, along with those of database management systems and database components. Get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus, explore T-SQL scripts, database queries, and data types. Start with a look at creating tables, inserting data, and querying data in tables. Then, learn about data manipulation, optimize database performance, and work with non-relational data. Get practical help on basic database administration, including installation and configuration, backup and restore, security, monitoring, and maintenance. Take this SQL Database tutorial to prepare for additional online courses for database administrators (DBAs), developers, data scientists, and big data specialists. Check it out! 1 | Introduction to Databases View a course introduction, and get started with databases. 2 | Getting Started with Tables Get an introduction to concepts and techniques for creating tables, inserting data, and querying data in tables. 3 | Working with Data in Tables Learn about data manipulation using Transact-SQL (T-SQL), including INSERT, UPDATE, and DELETE. Explore wrapper objects, such as views and stored procedures. 4 | Optimizing Database Performance Get an introduction to terminology and concepts for optimizing database performance by using indexes. 5 | Working with Non-Relational Data Explore additional types of data that can be used in modern databases, including XML and JSON. 6 | Basic Database Administration Learn about terminology and concepts for basic database administration, including installation and configuration, backup and restore, security, monitoring, and maintenance.
Parse JSON from open RESTful API and save to Oracle database without programming
 
00:28
Try Withdata JsonToOracle, Save RESTful API JSON data to Oracle database, no need to program, just a few mouse clicks! https://www.withdata.com/jsontooracle/ .
Views: 61 Shiji Pan
How to Decode XML In Oracle Database?
 
05:49
Sample Code Link: https://github.com/arulxaviers/Decode_XML_In_Oracle Thi video Will Teach you How to Decode XML In Oracle Database? how to read xml file in oracle pl sql extract value from xml oracle dbms_xmlgen.convert ampersand oracle xmltable example oracle xml query examples how to parse xml in oracle pl sql xml parsing in oracle 11g oracle xmltype extract example XMLTYPE XMLREAD Decode XML in Oracle
Views: 1734 Oracle PL/SQL World
Learning PYTHON for PLSQL Developers
 
53:27
Arup Nanda, Oracle ACE Director, Principle of Proligence Consulting This Session presents PYTHON concepts from the PL/SQL perspective, allowing Database Developers to rapidly learn to develop and implement PYTHON applications. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.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.
Spring Boot Oracle Example
 
12:47
Want to learn Spring Framework 5? Check out Spring Framework 5: Beginner to Guru here! http://bit.ly/2HkHprW In this video, I show you how to setup a simple Spring Boot web application which uses a Oracle database for persistence. Spring Data JPA is used with Hibernate 5 to persist objects to the database.
Views: 8491 Spring Framework Guru
DevLive: Oracle 12.2 as a JSON Database
 
02:35
Christoph Bussler recaps his Oracle Code NYC session "Scaling JSON Documents and Relational Data in Distributed Sharded Databases" and talks about some of the questions he got during the session.
Views: 82 Oracle Developers
Oracle Retrieve data from XML Document using XMLQuery
 
14:48
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2395 Sridhar Raghavan
How to Hack Into Your Oracle Database via Node js Using SQL Injection
 
58:06
https://developer.oracle.com/code/online | Dan McGhan, Chris Saxon: Hackers are constantly searching for personal data they can use to exploit people. And they’re often successful. Each week brings new stories of large-scale data breaches. A common attack vector is SQL injection. If your application is vulnerable to this, hackers can get whatever they want from your database. This session shows you how easy it is to access private data with SQL injection and how to change your code to stop it. It ends with a discussion of further recommendations for writing secure code. This is a must-attend session for all developers who write database access code.
Views: 723 Oracle Developers
ORDS and the New SQL/JSON  Database Functions - Part 2
 
15:54
This is the second part of the "ORDS and the New SQL/JSON Database Functions" series which covers storing JSON in columns within your relational schema and in the new Oracle Database 12c JSON Document Store using Simple Oracle Document Access or SODA.
Creating Jasper report from Oracle data source.
 
14:07
Creating a jasper report using Oracle database source. A basic tutorial to learn to create data adapter, using data adapter in jasper report. Designing jasper report using source table writing custom queries.
Views: 3622 Subhroneel Ganguly
Introduction to the JSON Usecase
 
02:15
This video introduces you to the usecase scenario that will provide a context on how to model JSON data in Oracle NoSQL Database. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.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.
oracle in select
 
13:49
oracle in select
Views: 441 IT Know
Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements
 
01:04:02
Presenter: Maria Colgan, Oracle Corporation The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task, even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.
Views: 2852 ODTUG
JSON in Oracle Database 12c Release 2 (part 2)
 
02:47
Eine relationale View aus JSON Code generieren oder wie kann man JSON aus relationalen Daten geniereren?
Views: 46 OraTech
How to read JSON data in Spring Boot and write to a database
 
23:36
Enroll in my Spring Boot Course http://bit.ly/2pQuyFq In this tutorial, we are going to look at how to read JSON data in a Spring Boot application and write it to a database. Source Code: https://github.com/cfaddict/spring-boot-jsontodb Please Subscribe to this channel and leave a comment below. Blog: http://therealdanvega.com/blog Facebook: http://www.facebook.com/therealdanvega Twitter: http://www.twitter.com/therealdanvega
Views: 10308 Dan Vega
Oracle REST Data Services Product Walk-through and Demonstration
 
59:52
A quick overview of REST, then an introduction of Oracle REST Data Services (ORDS) and how it brings a RESTful access to your Oracle Database.
Views: 4790 Jeff Smith
Building REST API with SQL Server using JSON functions
 
01:01:00
SQL Server 2016 and Azure SQL Database provide built-in functions that enable you to easily transform JSON documents into relational format and vice versa. Exchanging JSON documents between client applications and SQL Database is now easier than ever. In this session you will see how to create REST API using built-in JSON functionalities in SQL Server 2016 and Azure SQL Database.
Views: 11547 PASS AppDev
JSON in Oracle Database (part 1)
 
03:28
Wie kann ich auf JSON in der Datenbank zugreifen? Wie sieht der zugriff über External Table aus? Wie lege ich eine Tabelle in der Datenbank dazu an? Und wie greife ich mit einfachen SELECT Statements darauf zu? Das Slideset dazu gibt es unter https://www.slideshare.net/uschwinn/json-in-der-oracle-datenbank-12c-release-2
Views: 106 OraTech
How to Import JSON File Into SQL Server Database Using T-SQL (T-SQL References)
 
13:13
Buy Me a Coffee? https://www.paypal.me/jiejenn/5 Your donation will help me to make more tutorial videos! How to Import JSON File Into SQL Server Database Using T-SQL. These are the MS SQL Server books I personally recommended For beginner MS SQL Server users ► T-SQL Fundamentals: http://amzn.to/2uzxNqf ► Microsoft SQL Server 2016: A Beginner's Guide: http://amzn.to/2uztNGv For experience MS SQL Server users ► Murach's SQL Server 2016 for Developers: http://amzn.to/2h4Azz5 My equipment when using spreadsheet, email, and programming ► Logitech MX Master 2S Wireless Mouse with FLOW Cross-Computer Control and File Sharing for PC and Mac: http://amzn.to/2urglTm ► Logitech Wireless Illuminated Keyboard K800: http://amzn.to/2eGz8Gw Equipment I use for recording ► Blue Yeti USB Microphone: http://amzn.to/2vxs6H3 ► Camtasia 9: http://amzn.to/2tlBNvz If you found this video helpful, please give me a like to my video and subscribe to my channel. Thanks! For any question, please email me at [email protected]
Views: 6459 Jie Jenn
Solr Indexing Sample Docs to solr core and searching with various filter query options
 
06:12
This tutorial will help in indexing sample Solr Docs using Post Utility. Indexing into specific core. Searching queries to fetch data based on Filter query and other options. let assume file as dummy.xml under example/exampledocs directory. Go to exampledocs directory using command prompt & execute - java -jar post.jar dummy.xml For multiple XML files use - java -jar post.jar dummy.xml dummy1.xml For all XML files present in working directory use- java -jar post.jar *.xml SimplePostTool version 1.5 Posting files to base url http://localhost:8983/solr/update using content-type application/xml.. POSTing file dummy.xml 1 files indexed. COMMITting Solr index changes to http://localhost:8983/solr/update.. Time spent: 0:00:00.547
Views: 11446 Learn Technology
MuleSoft Anypoint Oracle Database Connector Dynamic value
 
03:05
passing real time value
Views: 196 Monoar
Null: Databases for Developers #10
 
07:42
The null value represents missing or unknown information. But using it brings complications to your SQL. In this video Chris discusses how to work with null to ensure you get the correct results. Further reading: Oracle Database SQL Reference on Nulls: http://docs.oracle.com/database/122/SQLRF/Nulls.htm#SQLRF30037 Null related functions: http://docs.oracle.com/database/122/SQLRF/Single-Row-Functions.htm#SQLRF51187 Is null condition: http://docs.oracle.com/database/122/SQLRF/Null-Conditions.htm#SQLRF52152 Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2228 The Magic of SQL
Reading JSON R Programming
 
05:42
Read in Javascript Object Notation (JSON) from git API using the R Programming Language. Git API: https://api.github.com/users/randerson112358/repos Get the code: https://github.com/randerson112358/R-Programs/blob/master/readJSON.R Please Subscribe ! ►Websites: http://everythingcomputerscience.com/ ►C-Programming Tutorial: https://www.udemy.com/c-programming-for-complete-beginners/learn/v4/overview ►Become a Patreot: https://www.patreon.com/randerson112358 ►PROGRAMMING BOOKS C-Programming - https://www.amazon.com/gp/product/0131103628/ref=as_li_tl?ie=UTF8&tag=everythingc06-20&camp=1789&creative=9325&linkCode=as2&creativeASIN=0131103628&linkId=764c7627ffb13944091b2ad15fb5de90 Head First Java - https://www.amazon.com/gp/product/0596009208/ref=as_li_tl?ie=UTF8&tag=everythingc06-20&camp=1789&creative=9325&linkCode=as2&creativeASIN=0596009208&linkId=58082f233879197beb1aeb73b03c1ed8 ►DISCRETE STRUCTURES/MATHEMATICS BOOKS Discrete Mathematics Workbook- https://www.amazon.com/gp/product/0130463272/ref=as_li_tl?ie=UTF8&tag=everythingc06-20&camp=1789&creative=9325&linkCode=as2&creativeASIN=0130463272&linkId=83220d3b9eb58fb0566fa51c0e5b5571 Practice Problems in Discrete Mathematics -https://www.amazon.com/gp/product/0130458031/ref=as_li_tl?ie=UTF8&tag=everythingc06-20&camp=1789&creative=9325&linkCode=as2&creativeASIN=0130458031&linkId=e6c98555ea0342d902afda0221a1a8fb ►ALGORITHMS BOOKS Algorithm Analysis - https://www.amazon.com/gp/product/0262033844/ref=as_li_tl?ie=UTF8&tag=everythingc06-20&camp=1789&creative=9325&linkCode=as2&creativeASIN=0262033844&linkId=ba3b1d4075fbd043bb4596a0df9402e9
Views: 1790 Computer Science
Create a RESTful web service in Oracle Database Cloud Service
 
04:09
This video shows you how to create a RESTful web service in Oracle Database Cloud Service. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.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.
Connecting to Snowflake with Oracle SQL Developer Data Modeler (SDDM)
 
06:17
In this video, Kent Graziano, The Data Warrior, will show you how to connect Oracle SQL Developer Data Modeler to your Snowflake account. Once done you can quickly create a data model for the designs you have already deployed in Snowflake. For additional details, see his post here: https://kentgraziano.com/2015/11/20/tech-tip-connect-to-snowflake-db-using-sqldevmodeler/
Views: 691 Snowflake Computing
Redis Crash Course Tutorial
 
39:35
In this crash course we will discuss and demonstrate the fundamentals of Redis including... What Redis Is Installation Redis-cli Data Types - Strings, Lists, Sets, Sorted Sets, Hashes Data Persistence FULL REDIS COURSE: Please Use This Link https://www.eduonix.com/affiliates/id/16-10420 SUPPORT: We spend massive amounts of time creating these free videos, please donate to show your support: http://www.paypal.me/traversymedia http://www.patreon.com/traversymedia FOLLOW TRAVERSY MEDIA: http://www.facebook.com/traversymedia http://www.twitter.com/traversymedia http://www.linkedin.com/bradtraversy
Views: 100974 Traversy Media
AskTOM TV - SQL Plan Directives from DBMS_XPLAN
 
06:15
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at how to identify which SQL Plan Directivees are being used for a given query 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: 840 Connor McDonald
Manual Oracle Database Creation 11g with Proper Steps
 
07:13
Using the CREATE DATBASE SQL statement is a more manual approach to creating a database. If you use the CREATE DATABASE statement, you must complete additional actions before you have an operational database. These actions include building views on the data dictionary tables and installing standard PL/SQL packages. You perform these actions by running prepared scripts. If you have existing scripts for creating your database, consider editing those scripts to take advantage of new Oracle Database features. The instructions in this section apply to single-instance installations only. Refer to the Oracle Real Application Clusters (Oracle RAC) installation guide for your platform for instructions for creating an Oracle RAC database. Single-instance does not mean that only one Oracle instance can reside on a single host computer. In fact, multiple Oracle instances (and their associated databases) can run on a single host computer. A single-instance database is a database that is accessed by only one Oracle instance, as opposed to an Oracle RAC database, which is accessed concurrently by multiple Oracle instances on multiple nodes.
Views: 292 Saurabh Joshi
Oracle 12c Release 2 - How to move a heap table online
 
01:43
Need to reorganize a table ? Want to do it whenever you want without impacting any users ? Easy in 12.2 ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 398 Connor McDonald
Why Postgres Should Be Your Document Database
 
01:11:16
Did you know PostgreSQL excels at storing JSON documents? Known mostly for its mature SQL and data-at-scale infrastructure, the PostgreSQL project added a "JSONB" column type in its 9.4 release, then refined it over the next two releases. While using it is straightforward, combining it in hybrid structured/unstructured applications along with other facilities in the database can require skill. In this webinar, Python and database consultant Jim Fulton shows us how to use JSONB and related machinery for pure and hybrid Python document-oriented applications. We also briefly discuss his long history back to the start of Python, and finish with his unique NewtDB library for native Python objects coupled to JSONB queries. Jim uses PyCharm Professional during the webinar. PyCharm Professional bundles the database tools from JetBrains DataGrip, our database IDE. However, the webinar itself is focused on the concepts of JSONB. Find the code here: https://github.com/jimfulton/pycharm-170320 1:10 - Document databases vs Relational databases 10:24 - Two-tiered Kanban demo 31:05 - Document oriented version of two-tiered Kanban demo 39:17 - Newt DB version 46:16 - Querying JSONB 54:16 - Optimizing JSONB queries with an index
Views: 19006 JetBrainsTV
B-Tree Indexes
 
04:33
In this video, I'd like to take a look at B-tree indexes and show how knowing them can help design better database tables and queries.
Learn about the Oracle NoSQL Database and its Features
 
28:24
Oracle NoSQL Database is an advanced key-value database that is designed to be highly scalable with predictable low latency. In this video, learn how to download and install Oracle NoSQL Database, and watch how Oracle NoSQL Database can be used in solving challenges in a Pizza delivery business. Learn more about Oracle NoSQL Database from Oracle Help Center: http://docs.oracle.com/cd/NOSQL/html/index.html 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.