Home
Search results “Postgresql like oracle”
Migrating Your Oracle Database to PostgreSQL - 2017 AWS Online Tech Talks
 
33:07
Learning Objectives: - Learn about the capabilities of the PostgreSQL database - Learn about PostgreSQL offerings on AWS - Learn how to migrate from Oracle to PostgreSQL with minimal disruption The PostgreSQL database has become very popular in recent years for its powerful functionality and high degree of compatibility with commercial databases. But migrating from Oracle or other databases to PostgreSQL has often been difficult and time-consuming. In this session, we’ll cover core capabilities and differences to be aware of, learn about PostgreSQL deployment options on Amazon Relational Database Service and Amazon Aurora, and see how to easily migrate your schemas and your data with minimal downtime.
Views: 6735 AWS Online Tech Talks
Differences Between Oracle And PostgreSQL Open Source Database [2015]
 
04:59
In this Video you will come to know the differences between Oracle And PostgreSQL Databases. In coming days I will do more videos based on this topic. This video help the developers to Migrate from Paid database to opensource database. 60% Oracle queries working properly in PostgreSQL, So its easy to migrate. PostgreSQL contains ACID property. Compare to Oracle, PostgreSQL retrieve data quickly (Refer my Blog: http://clearosapps.blogspot.in/2015/10/oracle-vs-postgresql-which-is-faster.html ). The queries which i used in this video are available in my blog - http://clearosapps.blogspot.in/ If you have any difficulties, any queries drop comments, like the video, Share it and subscribe the Channel for further updates. Background Music used: Gold Coast by Jens Kiilstofte https://machinimasound.com/music/gold-coast/ Licensed under Creative Commons Attribution 4.0 International (http://creativecommons.org/licenses/by/4.0/)
Views: 18139 8bitzs
Enterprise PostgreSQL and Oracle Compatibility with EnterpriseDB
 
06:02
Enterprise relational database solutions typically come with a hefty price tag, but PostgreSQL has proven to be an enterprise-capable open source alternative. EnterpriseDB is like the RedHat of the PostgreSQL, allowing you the flexibility of a free database solution with the service offerings of a expert team to assist at every step along the way. One unique feature of EnterpriseDB is the ability to import Oracle databases to migrate your data. EnterpriseDB also offers the flexibility of PostgreSQL in making it easy to work across multiple operating systems. Here Jake Ludington talks to Sean Doherty about EnterpriseDB and how it solves enterprise RDBMS challenges.
Views: 3357 Chris Pirillo
Migrating Oracle Databases to Cloud SQL PostgreSQL (Cloud Next '19)
 
49:43
Learn about the steps, procedures, best practices, and how to solve the challenges associated with migrating on-premises Oracle databases to Google Cloud SQL PostgreSQL. From source database migration assessment to schema conversion, data replication, and performance tuning, we will cover all of the basics required to get you started with your first Oracle to Cloud SQL migration project. Cloud SQL → https://bit.ly/2K3WYef Watch more: Next '19 Databases Sessions here → https://bit.ly/Next19Databases Next ‘19 All Sessions playlist → https://bit.ly/Next19AllSessions Subscribe to the GCP Channel → https://bit.ly/GCloudPlatform Speaker(s): David Yahalom, Kavitha Gopalakrishnan Session ID: DBS100 product:Cloud SQL,3rd Party and Partner Databases; fullname:Kavitha Gopalakrishnan;
Demo: Oracle Plugin for PostgreSQL | Blue Medora
 
12:51
Monitor hundreds of PostgreSQL databases metrics, identify common bottlenecks, manage alerts and get query-level visibility--all within Oracle Enterprise Manager using the Oracle Plugin for PostgreSQL. Learn more at www.bluemedora.com/OEM.
Views: 813 Blue Medora
Avinash Vallarapu: Migration of a 5 Node Oracle RAC to PostgreSQL -- PGCon 2018
 
54:08
In this proposal, I would like to talk about the methods and tools implemented to Migrate from a 5-Node Oracle RAC to PostgreSQL. It was an Oracle RAC with 5 Nodes designed to automatically load balance and scatter the transactions across multiple nodes for a complex business logic. There was a DR(Disaster Recovery Environment) which was a 5 Node RAC again with the ability to take a Read Traffic for ETL and Reporting. There are several built-in features with Enterprise Version of Oracle which are not claimed to be available for PostgreSQL and thus stopping majority of the users to migrate from Oracle RAC to PostgreSQL. I have overcome all such challenges and implemented a Design without using any external tools or Multi-Master solutions in the market. https://www.pgcon.org/2018/
Views: 136 PGCon
SQL: Sequence Generator
 
04:41
In this tutorial, you'll learn how to make use of sequence generator. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 9198 radhikaravikumar
The Elephants In The Room: Limitations of the PostgreSQL Core Technology
 
51:18
Check out http://www.pgconf.us/2015/event/85/ for the full talk details. The core architecture of PostgreSQL is significantly different from that of competing products like Oracle, SQL Server, or MySQL, which also differ from each other. Some of PostgreSQL's distinctive features, such as our highly extensible systems for adding new data types and new foreign data wrappers, have been tremendously successful in propelling PostgreSQL forward. Others, such as our storage format and limited replication capabilities, have significantly impeded the adoption of PostgreSQL. In this talk, I'll discuss some of the core architectural problems that I believe limit our success, based on my experiences working with EnterpriseDB customers, and will suggest some ways in which I believe the PostgreSQL architecture can evolve to meet those challenges. About the Speaker Robert has been involved in the PostgreSQL project since 2008, first as a patch reviewer and committer and a later as a major developer. Prior to that, he was a PostgreSQL application developer for nearly ten years. Features he has worked on include infrastructure for parallelism (for 9.4), the replacement of System V shared memory with anonymous shared memory (for 9.3), read and write scalability improvements (for 9.2), index-only scans (with Heikki Linnakangas and Ibrar Ahmed, for 9.2), unlogged tables (for 9.1), and left join removal (for 9.0). He works at EnterpriseDB as Chief Database Architect for the Database Server.
Views: 15603 Postgres Conference
Relational Databases - How to Choose  |¦|  SQL Tutorial  |¦|  SQL for Beginners
 
08:06
When learning SQL, you first need a database. In this video, we help you make your choice. There are many free, open-source options: MySQL, PostgreSQL, MariaDB, Sqlite, and many others. You can also choose an established commercial option like Oracle, SQL Server, or DB2. Better still, you can run the database on your own server or in the cloud! ——————————————— »» 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 Michael Harrison and Kimberly Hatch Harrison
Views: 18969 Socratica
SQL tutorial 74: SQL COALESCE Function In oracle Database Manish Sharma
 
04:44
Third tutorial in SQL Null Series. Coalesce Null function with example in oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-coalesce Previous Tutorial ► NVL https://youtu.be/aRoTR5Jn6K0 ► NVL2 https://youtu.be/SCwc0HcS1-U ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 28448 Manish Sharma
How to install a JDBC driver in Oracle SQL Developer
 
02:38
To connect to a third party database in SQL Developer, you will need to install a jdbc driver. The drivers are free downloads. Review the supported jdbc driver versions at http://www.oracle.com/technetwork/products/migration/jdbc-migration-1923524.html. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Views: 159277 Oracle Learning Library
SQL: Extract function
 
03:38
In this tutorial, you'll learn how to make use of extract function. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 4609 radhikaravikumar
PL/SQL: Object Type
 
08:31
In this tutorial, you'll learn what is a object type in sql/plsql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 14321 radhikaravikumar
Setup, create and manage a PostgreSQL Entreprise Geodatabase in ArcGIS
 
15:25
When you need a large, multiuser geodatabase that can be edited and used simultaneously by many users, the Enterprise geodatabase provides a good solution. It adds the ability to manage a shared, multiuser geodatabase as well as support for a number of critical version-based GIS workflows. The ability to leverage your organization's enterprise relational databases is a key advantage of the Enterprise geodatabase. In this tutorial you will learn how to install and create an Enterprise geodatabase in ArcGIS and PostgreSQL. To download required files and for more information : http://monde-geospatial.com/postgresql-entreprise-geodatabase-in-arcgis/ For more tutorials, visit our blog: : http://monde-geospatial.com Subscribe to our Channel : https://www.youtube.com/channel/UCNLNPBubG4enF16-QC5KzWA?sub_confirmation=1 Like our page on Facebook : http://www.facebook.com/MondeGeospatial Follow us on Twitter : http://twitter.com/MondeGeospatial
Views: 12059 Monde Geospatial
Connect Android with SQL Server, MySQL, Oracle, PostgreSQL, and Other RDBMS Servers
 
05:30
This video demonstrates how to synchronize Android devices through a relational database server with ITTIA DB Sync.
Views: 65913 ITTIA
PostgreSQL HA Database Clusters through Containment  QUAN HA LE mp4
 
44:47
The enormous amount of data flow has made Relation Database Management System the most important and popular tools for persistence of data. While open-source RDBMS systems are not as widely used as proprietary systems like Oracle databases, but over the years, systems like PostgreSQL have gained massive popularity. High-availability database clusters (also known as HA clusters or failover clusters) are groups of computers that support server applications that can be reliably utilized with a minimum of down-time. This presentation is an attempt to set a benchmark of PostgreSQL high-availability databases in comparing the performance of same-containment keepalived-repmgr clusters against cross-containment HAProxy-PgBouncer clusters. The result shows that our cross-containment HAProxy-PgBouncer is still a significantly better performer with load balancing, healthcheck and its throughputs are improved from 0.346% to 9.454% in compared to keepalived-repmgr. Also we would like to present I/O activities and CPU usage percentages between the two kinds of PostgreSQL HA clusters. http://www.pgconf.us/2016/event/199/postgresql-ha-database-clusters-through-containment/
Views: 331 Postgres Conference
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 114233 Manish Sharma
SQL vs NoSQL or MySQL vs MongoDB
 
21:30
SQL or NoSQL? MySQL vs MongoDB? Which database is better? Which one should you use? Limited Offer! Get the Full MongoDB Course at 90% off: https://www.udemy.com/mongodb-the-complete-developers-guide/?couponCode=ACAD_Y Exclusive Discount also available for our MEAN (Mongo, Express, Angular, Node) Course: https://www.udemy.com/angular-2-and-nodejs-the-practical-guide/?couponCode=ACAD_Y Don't miss the article on this video: https://academind.com/learn/web-dev/sql-vs-nosql/ Want to learn something totally different? Check out our other courses: https://academind.com/learn/our-courses ---------- More on SQL Horizontal Scaling: https://stackoverflow.com/questions/27157227/can-relational-database-scale-horizontally ---------- • You can follow Max on Twitter (@maxedapps). • And you should of course also follow @academind_real. • You can also find us on Facebook.(https://www.facebook.com/academindchannel/) • Or visit our Website (https://www.academind.com) and subscribe to our newsletter! See you in the videos! ---------- Academind is your source for online education in the areas of web development, frontend web development, backend web development, programming, coding and data science! No matter if you are looking for a tutorial, a course, a crash course, an introduction, an online tutorial or any related video, we try our best to offer you the content you are looking for. Our topics include Angular, React, Vue, Html, CSS, JavaScript, TypeScript, Redux, Nuxt.js, RxJs, Bootstrap, Laravel, Node.js, Progressive Web Apps (PWA), Ionic, React Native, Regular Expressions (RegEx), Stencil, Power BI, Amazon Web Services (AWS), Firebase or other topics, make sure to have a look at this channel or at academind.com to find the learning resource of your choice!
Views: 468476 Academind
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.
SQL: WITH Clause
 
06:11
In this tutorial, you'll learn will learn how to use with clause PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 16003 radhikaravikumar
Database Schema
 
06:20
How to draw a diagram representing the entities, relationships and fields of a relational database. If this video helped you, you may also benefit from these further examples of constructing database schema: http://youtu.be/0r43J3qkkT4 - identifying the tables in a given situation http://youtu.be/aWP2MLAYQfk - building the schema and determining the relationships I'm Mr. Woo and my channel is all about learning - I love doing it, and I love helping others to do it too. I guess that's why I became a teacher! I hope you get something out of these videos - I upload almost every weekday, so subscribe to find out when there's something new! For categorised playlists: http://www.misterwootube.com Main channel: http://youtube.com/misterwootube Discussion: http://facebook.com/misterwootube Worksheets and other resources: http://woo.jamesruse.nsw.edu.au
Views: 360779 Eddie Woo
SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join
 
18:04
Learn how to create SQL Joins. The first 10 minutes teach you the basics. Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join. The second 10 minutes show you are few techniques that will help you as you start building joins. READ THE ORIGINAL ARTICLE WITH THE TABLE SCRIPS http://www.sqltrainingonline.com/sql-joins-tutorial-for-beginners/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 213354 Joey Blue
Oracle vs SQL Server vs MySQL Contest!
 
04:42
As you study databases, there is a category of databases known as relational databases. These organize data in tables. The three most popular relational databases are MySQL, SQL Server, and Oracle. These database systems are top competitors. These are very similar and they are all very popular. Which one is best? They are very strong competitors. Of course certain ones are better for certain things, but they are all based off of the SQL standard. I am announcing that I am making videos over all three relational database systems. I am uploading them at the same time and turning it into a competition. The scoring systems works like this: 1 view = 1 point. 1 like = 10 points. The competition starts on video #23 and ends on video #150. After this I will add up the points and see which series wins. The winning series gets a bonus 50 videos. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 29279 Caleb Curry
PL/SQL: Stored Procedures Part-1
 
06:19
In this tutorial, you'll learn what are stored procedures PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 16969 radhikaravikumar
Modificar una Columna - ALTER COLUMN | PostgreSQL #13
 
07:53
Ayúdanos a crecer, comparte, dale like y suscribete al canal! ►[http://goo.gl/TZEYAO]◄ GRACIAS POR TU APOYO Y TU LIKE Continuamos viendo como modificar la estructura de una tabla, en este caso, de la columna. ▼Que es Tutoriales y más? ►Somos una comunidad que crece cada vez mas! Nuestro tema principal es la programación pero también nos interesa compartir sobre cualquier cosa que tenga que ver con tecnología e informatica! ►Cursos, tutoriales, reviews, gameplays y hasta algo de música es parte de lo que podrás encontrar si visitas nuestro canal! ► Ayúdanos a Subtitular este y otros videos para llegar a más personas: https://goo.gl/kEr6xW ▼Nuestros Cursos: ►SQL Server: https://goo.gl/7vMQnD ►C#: https://goo.gl/0NZeqM ►Java: https://goo.gl/VhFRR4 ►VB .Net: https://goo.gl/Gwh6O4 ►VBA: https://goo.gl/TxsZz3 ►Iniciándose en la programación: https://goo.gl/dHcmnM ►►Más cursos y vídeos en el canal!◄◄ ▼Encuentranos aquí: ►Facebook: https://goo.gl/iqIZMn ►Grupo de programadores en Facebook: https://goo.gl/sTvbFz ►Twiter: https://goo.gl/WJRoKR ►Blog: https://goo.gl/EOglPi ▼Tal vez te interese! ►Gana $$$ con tu canal [VISO]: http://bbtv.go2cloud.org/SHQK ►App del canal para tu navegador: https://goo.gl/Czkl9C ►Donativos: http://goo.gl/us1GDG ▼Código y más! ►Repositorio del Query del curso de SQL Server: https://goo.gl/LSig71
Views: 7722 Tecnología Binaria;
PL/SQL: Coalesce Function
 
04:36
In this tutorial, you'll learn how to make use of coalesce function in oracle SQL. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 3333 radhikaravikumar
CrateDB: Remedying the Challenges of Migrating Oracle/Postgres/SQL to MongoDB/NoSQL
 
01:04:33
Remedying the Challenges of Migrating Oracle/Postgres/SQL to MongoDB/NoSQL by Marios Trivyzas, Senior Core Engineer, Crate.io Hosted by Eric David Benari A Database Month event http://www.DBMonth.com/database/migration Funny pre-event tech-trivia: https://youtu.be/h3Fl4UscWsc This is the dark and terrible tale of a migration from an relational SQL database, an RDBMS like Oracle or Postgres, to NoSQL with MongoDB. The battles were fought by those unwilling or unable to learn Mongo's query language. The trials we faced feeding Mongo back through a SQL data warehouse. The tears shed. The lives lost (well, virtual-lives lost, lol.) In this session, we will look at how using a scalable SQL database with full text search would have solved all of the most-challenging aspects of SQL-to-NoSQL migration. Marios Trivyzas, Senior Core Engineer, Crate.io Marios is the Senior Core Engineer for Crate.io. He from Corfu, an island at the north-west of Greece with similar crazy weather to Berlin, and he was based in Berlin since February 2013. Marios has 15 years of experience working with C and Java focusing on low level Unix system programming and distributed systems. Since his academic years he has always been interested in data and has developed a specialty in databases, data stores and caching and helps CrateDB simplify and streamline working with machine data.
PL/SQL: Ref Cursors
 
09:28
In this tutorial, you'll learn what is ref cursors. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 28352 radhikaravikumar
MariaDB TX 3.0, the OSS Alternative to Closed Databases like Oracle, MSSQL & DB2
 
52:29
MariaDB TX 3.0, the OSS Alternative to Closed Databases like Oracle, MSSQL & DB2 by Rasmus Johansson, VP of Engineering, MariaDB • Funny pre-event tech-trivia: https://youtu.be/rgBpE9dwBjs We have a reason to celebrate! You finally have an open-source alternative to proprietary databases like Oracle, IBM DB2 and MS SQL Server! In the past, features like temporal tables and queries, purpose-built storage engines, data masking and obfuscation with instant, invisible or compressed columns required the use of a proprietary database, but now MariaDB TX 3.0 delivers these in an enterprise open source database. This presentation introduces the latest features available in MariaDB TX 3.0, why they were developed, how you can use them and what they mean for your business. You will learn about: • Oracle compatibility, including sequences and stored procedures • Temporal tables and queries, as well as deployment strategies • The use of different storage engines for different tables • Protecting personal data with masking and obfuscation • Adding columns without ever needing to rebuild tables As part of our celebration, we will be pouring Salmiakki Koskenkorva, a licorice-flavored black vodka that is a favorite of Finland! ••• Rasmus Johansson, VP of Engineering, MariaDB ••• Rasmus manages MariaDB Server development. He joined Monty Program Ab in 2010 where he served as the COO of the company. Monty Program became MariaDB Corporation after merging with SkySQL in 2013. Previously, Rasmus worked for Microsoft where he focused on SQL Server and before that he worked for CGI and Icon Medialab. He started his career as a developer and still enjoys being part of engineering. He is based in Helsinki, Finland. #MariaDB #NewSQL #OpenSource #MySQL #SQL
R tutorial: connecting to a database
 
03:38
Learn more about connecting to databases with R: https://www.datacamp.com/courses/importing-data-in-r-part-2 Welcome to part two of importing data in R! The previous course dealt with accessing data stored in flat files or excel files. In a professional setting, you'll also encounter data stored in relational databases. In this video, I'll briefly talk about what a relational database is and then I'll explain how you can connect to it. In the next video, I'll explain how you can import data from it! So, what's a relational database? There's no better way to show this than with an example. Take this database, called company. It contains three tables, employees, products and sales. Like a flat file, information is displayed in a table format. The employees table has 5 records and three fields, namely id, name and started_at. The id here serves as a unique key for each row or record. Next, the products table contains the details on four products. We're dealing with data from a telecom company that's selling both with and without a contract. Also here, each product has an identifier. Finally, there's the sales table. It lists what products were sold by who, when and for what price. Notice here that the ids in employee_id and product_id correspond to the ids that you can find in the employees and products table respectively. The third sale for example, was done by the employee with id 6, so Julie. She sold the product with id 9, so the Biz Unlimited contract. These relations make this database very powerful. You only store all necessary information once in nicely separated tables, but can connect the dots between different records to model what's happening. How the data in a relational database is stored and shuffled around when you make adaptations, depends on the so-called database management system, or DBMS you're using. Open-source implementations such as MySQL, postgreSQL and SQLite are very popular, but there are also proprietary implementations such as Oracle Database and Microsoft SQL server. Practically all of these implementations use SQL, or sequel, as the language for querying and maintaining the database. SQL stands for Structured Query Language. Depending on the type of database you want to connect to, you'll have to use different packages. Suppose the company database I introduced before is a MySQL database. This means you'll need the RMySQL package. For postgreSQL you'll need RpostgreSQL, for Oracle, you'll use ROracle and so on. How you interact with the database, so which R functions you use to access and manipulate the database, is specified in another R package called DBI. In more technical terms, DBI is an interface, and RMySQL is the implementation. Let's install the RMySQL package, which automatically installs the DBI package as well. Loading only the DBI package will be enough to get started. The first step is creating a connection to the remote MySQL database. You do this with dbConnect(), as follows. The first argument specifies the driver that you will use to connect to the MySQL database. It sure looks a bit strange, but the MySQL() function from the RMySQL package simply constructs a driver for us that dbConnect can use. Next, you have to specify the database name, where the database is hosted, through which port you want to connect, and finally the credentials to authenticate yourself. This is an actual database that we're hosting, so you can try these commands yourself! The result of the dbConnect call, con, is a DBI connection object. You'll need to pass this object to whatever function you're using to interact with the database. Before we do that, let's get familiar with this connection object in the exercises!
Views: 49926 DataCamp
SQL: Explain Plan for knowing the Query performance
 
05:17
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 101982 radhikaravikumar
SQL Databases and the Firebase Database - The Firebase Database For SQL Developers #1
 
06:50
Check out more information about the Firebase Database in the official documentation: https://goo.gl/audH62 Welcome to the first video in the Firebase Database for SQL Developers series! This lesson compares the fundamentals of SQL database to NoSQL databases like the Firebase Database. Watch more videos from this series: https://goo.gl/ZDcO0a Subscribe to the Firebase Channel: https://goo.gl/9giPHG
Views: 160359 Firebase
How to Choose the Right Database? - MongoDB, Cassandra, MySQL, HBase - Frank Kane
 
21:53
Explore the full course on Udemy (special discount included in the link): https://www.udemy.com/the-ultimate-hands-on-hadoop-tame-your-big-data/?couponCode=HADOOPUYT Choosing the right database for your application is no easy task. You have a wide variety of options relational databases such as MySQL, or distributed NoSQL solutions such as MongoDB, Cassandra, and HBase. NoSQL has come to mean not only SQL as many distributed database systems do in fact support SQL-style queries, as long as you are not doing complex join operations and this further blurs the lines between these systems. We will talk about how to analyze the requirements of your system in terms of consistency, availability, and partition-tolerance, and how to apply the CAP theorem to guide your choice after showing you where different database technologies fall on the sides of the CAP triangle. We will also talk about more practical considerations, such as your budget, need for professional support, and the ease of integration into the other systems already in place in your organization. Maybe you dont even need a distributed storage solution at all! Choosing the right technology for your data storage will save you a lot of pain as your application grows and evolves and making the wrong choice can lead to all sorts of maintenance problems and wasted work. Your instructor is Frank Kane of Sundog Education, bringing nine years of experience as a senior engineer and senior manager at Amazon.com and IMDb.com, where his job involved extracting meaning from their massive data sets, and processing that data in a highly distributed manner.
Views: 40596 Udemy Tech
Part 4   Delete duplicate rows in sql
 
03:26
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 364398 kudvenkat
Database Clustering Tutorial 1 - Intro to Database Clustering
 
09:20
Read the Blog: https://www.calebcurry.com/blogs/database-clustering/intro-to-database-clustering Get ClusterControl: http://bit.ly/ClusterControl In this video we are going to be discussing database clustering and how to manage database clusters with ClusterControl. Database clustering is when you have multiple computers working together that are all used to store your data. There are four primary reasons you should consider clustering. Data redundancy, Load balancing (scalability) High availability. Monitoring and Automation That is an intro to a few of the reasons having a cluster is a good idea. Obviously, not everyone needs a cluster. A cluster can be overkill. But the best way to know is to learn more about them, so I’ll see you in the next video! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 26323 Caleb Curry
Building your own PostgreSQL-as-a-Service on Kubernetes. - Alexander Kukushkin, Zalando SE
 
35:37
Building your own PostgreSQL-as-a-Service on Kubernetes. - Alexander Kukushkin, Zalando SE How many DBAs does it take to manage 500+ PostgreSQL HA clusters? Very close to zero, if you run them on Kubernetes with the help of postgres-operator. This talk is a story, how the team of Database Engineers at Zalando developed open-source components like Patroni and postgres-operator to run company-wide PostgreSQL-as-a-Service on Kubernetes. I will share how we automate all routine operations, providing developers with easy-to-use tools to create, manage and monitor their database, avoiding commercial solutions lock-in and saving costs. I will describe the benefits and pitfalls of running production databases on Kubernetes and, finally, show open-source tools we have built for application developers to deploy and manage PostgreSQL clusters by writing short manifests describing a few essential properties of the result. To Learn More: https://sched.co/GrU0 Join us for KubeCon + CloudNativeCon in Barcelona May 20 - 23, Shanghai June 24 - 26, and San Diego November 18 - 21! Learn more at https://kubecon.io. The conference features presentations from developers and end users of Kubernetes, Prometheus, Envoy and all of the other CNCF-hosted projects.
The Write-Ahead Log (WAL) in PostgreSQL - Seminar at New Horizons Bulgaria with Devrim Gündüz
 
01:10:51
The Write-Ahead Log (WAL) in PostgreSQL is a central feature of the database, and it’s relied upon to achieve critical functions, like backup, replication, and others. But how well does the average database administrator understand WAL? Learn all about WAL and what it includes; how to read it; the wal_level; and other topics like WAL and replication, backup, and point-in-time-recovery. We provide PostgreSQL trainings with EDB and we were very privileged to have Devrim Gündüz, a Principal Systems Engineer at EDB, deliver a world class PostgreSQL training for our clients here at New Horizons Bulgaria. Devrim has more than 18 years of experience in PostgreSQL and is an amazing lecturer. Learn more about PostgreSQL trainings here - https://bit.ly/2Nxlcuk .
SQL - Full course for beginners
 
04:20:39
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. 🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/ ⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw 🐦Follow Mike on Twitter: https://twitter.com/GiraffeAcademy 🔗The Giraffe Academy website: http://www.giraffeacademy.com/ -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://medium.freecodecamp.org And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Views: 1527380 freeCodeCamp.org
Move tables between databases PostgreSQL with a DBLINK
 
03:51
Move tables between databases PostgreSQL with a DBLINK do $$ declare r record ; begin for r in select * from dblink ('host=localhost user=postgres password=password dbname=source', 'select indexdef from pg_indexes where tablename = ''mytable''') as linktable ( indexdef text ) loop execute r.indexdef; end loop; end $$
Views: 5603 randomtutorial
How Modern SQL Databases Come up with Algorithms that You Wouldn't Dream Of
 
47:06
SQL is the only ever successful, mainstream, and general-purpose 4GL (Fourth Generation Programming Language) and it is awesome! With modern cost based optimisation, relational databases like Oracle, SQL Server, PostgreSQL finally keep up to the promise of a powerful declarative programming model by adapting to ever changing productive data without performance penalties. Thousand-line-long, complex SQL statements can be run in far below a millisecond against billion-row strong tables if database developers know their ways around the SQL language - and the best news is: It's not that hard! In this talk, I'll show how the SQL database will constantly outperform any hand written data retrieval algorithm - or in other words - how SQL, being a logic language, is the best language for business logic. Speakers: Lukas Eder Lukas Eder is the founder and CEO of Data Geekery GmbH. He is a Java Champion, located in Zurich, Switzerland. Data Geekery has been selling database products and services around Java and SQL since 2013. Ever since his Master’s studies at EPFL in 2006, he has been fascinated by the interaction of Java and SQL. He credits his work in the Swiss E-Banking field through various variants (JDBC, Hibernate, mostly with Oracle) for his experience. He is happy to share this knowledge at various conferences, JUGs, in-house presentations and on his blog.
Views: 1638 v JUG
#Geodatabase Talk - Episode 9 - SDE
 
10:56
Hussein's ArcGIS Books ⟶ https://www.husseinnasser.com/books The #geodatabase is a technology developed by #Esri that abstracts the underlying storage medium into another layer. By doing that you get interesting functionalities like domains, feature classes, tables, feature datasets across multiple databases from file based to enterprise RDBMS like Oracle, PostgreSQL, SQLServer DB2 etc. The communication between the client and the enterprise geodatabase is done through the spatial database engine. We explain that layer in this episode. Boost your GIS knowledge by grabbing my books ——————————————————————— - [x] Learning ArcGIS Geodatabase https://goo.gl/csQdCX - [x] Administering ArcGIS for Server https://goo.gl/zvYCRg - [x] ArcGIS By Example https://goo.gl/yJKSqB - [x] Building Web Applications with ArcGIS https://goo.gl/brgKUJ Watch my top GIS videos ———————————— - [x] Support IGeometry on paypal: https://goo.gl/wZ8hSh - [x] Full ArcGIS Javascript API Series Playlist http://bit.ly/2zf7G80 - [x] Full Multi-User Geodatabase Playlist https://goo.gl/nSgYnM - [x] Full ArcGIS Pro 2.x Playlist https://goo.gl/2j4NoZ - [x] Full ArcGIS By Example (C#) [Phonatech] Playlist https://goo.gl/FwdrHa - [x] Full ArcGIS Server Playlist https://goo.gl/nkfM6Q
Views: 96 IGeometry
How does PostgreSQL work with disks: a DBA’s checklist in detail
 
47:46
Check out http://www.pgconf.us/2015/event/82/ for the full talk details. PostgreSQL like any other classical database interacts with disks heavily and has dozens of disk-related settings. In order to keep an instance up and running under even moderate workloads, an average DBA needs to dig through PostgreSQL documentation, operating system documentation, hardware vendor manuals, a few books, plenty of blog posts, [HACKERS] and [PERFORM] mail lists archive and finally gain a couple years of experience. This talk will guide DBAs through a checklist, that allows to maximize the disk performance of a PostgreSQL installations. I will concisely summarize typical DBA tasks on four levels: choosing and setting up hardware, operating system configuration, file system mounting with proper options, and PostgreSQL tuning itself. The talk will include but is not limited to such important topics as monitoring I/O-related metrics, checkpoint tuning, autovacuum tuning. About the Speaker Ilya is a co-founder and DBA at PostgreSQL-Consulting.com. His previous experience encompasses such commercial databases as Oracle and DB2. Currently, Ilya works primarily with PostgreSQL with a focus on its performance and effective use in production. He sees the mission of PostgreSQL in substituting the commercial databases in high-performance mission-critical applications.
Views: 4603 Postgres Conference
SQL 020 SELECT WHERE LIKE or How can I match a pattern of wildcard characters?
 
04:50
Explains the SELECT WHERE LIKE clause. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 1103 cbtinc
PL/SQL tutorial 13: PL/SQL FOR Loop In Oracle Database by Manish Sharma RebellionRider.com
 
06:14
3rd and the last tutorial in Iterative/loop statement in Oracle PL/SQL series explaining concepts of FOR loop with examples by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/numeric-for-loop-in-pl-sql Previous Tutorial ► While Loop https://youtu.be/IIlc4Sr7kFE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 60470 Manish Sharma
Zero-downtime Postgres Upgrades
 
13:52
On the surface, the tech behind a payments API may look like any other startup’s. You'll probably find some Rails apps, a database, and a bunch of stuff off to the sides to glue it together. GoCardless found it's mostly not the tech that differs, but the approach. Using their high-availability Postgres cluster as a running example, they explore how reliability became so important to them, and dive into the most recent feature they built into the cluster: zero-downtime patch upgrades.
Views: 2401 Outlyer
Новые возможности полнотекстового поиска в PostgreSQL / Олег Бартунов (Postgres Professional)
 
55:43
Зал Москва, 8 ноября, 16:00 Презентация и тезисы: http://www.highload.ru/2016/abstracts/2352.html Я расскажу про новые возможности полнотекстового поиска, которые вошли в последний релиз PostgreSQL - поддержку фразового поиска и набор функций для манипулирования полнотекстовым типом данных (tsvector). Помимо этого, мы улучшили поддержку морфологических словарей, что привело к значительному увеличению числа поддерживаемых языков, оптимизировали работу со словарями, разработали новый индексный метод доступа RUM, который значительно ускорил выполнение ряда запросов с полнотекстовыми операторами. ...
Views: 3969 HighLoad Channel
SQL: Transaction Part-1
 
06:05
In this tutorial, you'll learn what are transaction and nature of transaction. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 3654 radhikaravikumar
#Geodatabase Talk - Episode 8 - Domains
 
11:12
Hussein's ArcGIS Books ⟶ https://www.husseinnasser.com/books The #geodatabase is a technology developed by #Esri that abstracts the underlying storage medium into another layer. By doing that you get interesting functionalities like domains, feature classes, tables, feature datasets across multiple databases from file based to enterprise RDBMS like Oracle, PostgreSQL, SQLServer DB2 etc. This episode I explain what geodatabase domains are, what are the different types and we also talk about the future of domains. Boost your GIS knowledge by grabbing my books ——————————————————————— - [x] Learning ArcGIS Geodatabase https://goo.gl/csQdCX - [x] Administering ArcGIS for Server https://goo.gl/zvYCRg - [x] ArcGIS By Example https://goo.gl/yJKSqB - [x] Building Web Applications with ArcGIS https://goo.gl/brgKUJ Watch my top GIS videos ———————————— - [x] Support IGeometry on paypal: https://goo.gl/wZ8hSh - [x] Full ArcGIS Javascript API Series Playlist http://bit.ly/2zf7G80 - [x] Full Multi-User Geodatabase Playlist https://goo.gl/nSgYnM - [x] Full ArcGIS Pro 2.x Playlist https://goo.gl/2j4NoZ - [x] Full ArcGIS By Example (C#) [Phonatech] Playlist https://goo.gl/FwdrHa - [x] Full ArcGIS Server Playlist https://goo.gl/nkfM6Q
Views: 100 IGeometry
Илья Космодемьянский: "Linux tuning to improve PostgreSQL performance"
 
51:43
Илья Космодемьянский / CEO и консультант / PostgreSQL-Consulting LLC / Германия. Саарбрюккен CEO и консультант в компании PostgreSQL-Consulting LLC, специалист по базам данных PostgreSQL, Oracle, DB2. ++++++++++++++++ Linux tuning to improve PostgreSQL performance Linux operating system has lots of tuning options which can change performance of your PostgreSQL installation drastically. For PostgreSQL, obviously, most important are storage-related options like vm.dirty*, IO elevators or filesystem mount options, but there are many more of them: CPU scheduler options, NUMA settings, or even power saving policy. The goal of this talk is to explain to DBAs and engineers how to use all this settings in order to match hardware configuration and PostgreSQL workload. ++++++++++++++++ Linux Piter 2015 http://it-events.com/events/4868 Конференция Linux Piter в социальных сетях: Вконтакте: https://vk.com/linuxpiter Facebook: https://www.facebook.com/pages/Linux-Piter/655735254527244 Twitter: https://twitter.com/LinuxPiter Хештег: #LinuxPiter ++++++++++++++++ Организаторы конференции: Айти-Событие: http://it-events.com IT-Доминанта: http://www.it-dominanta.ru ++++++++++++++++ Спонсор конференции: Корпорация EMC: http://russia.emc.com
Views: 2063 IT-Events
PL/SQL: Factorial
 
08:14
In this tutorial, you'll learn how to write factorial program in plsql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 5528 radhikaravikumar