Reference Guide: NoSQL Databases
NoSQL is an alternative to relational databases that is optimized to work with non-structured data and large data volume, while maintaining high availability and performance. In this guide you will find more informations about NoSQL databases.
Working with Triggers in PostgreSQL
In this article we will learn in practice the use of triggers in PostgreSQL 9.4 database, and learn how to use the rules.
Using Functions in PostgreSQL
In this article we will see how to create a custom audio player for the web environment using only jQuery and audio plugins.
NoSQL vs NewSQL: BigData in Details
In this article we will see a complete discussion regarding these two new BigData methodologies: NoSQL and NewSQL, their main features and principles.
Saving Geolocation data with Google Maps API and MongoDB
See in this article how to develop an application based on geographic data using Google Maps API and MongoDB. The application consists of a page on which we will enter the location of taxi passengers and another where we will see a map.
SQL Server: How to Perform Data Encryption
This article, through contextualization and simple examples, discusses best practices regarding encryption for sensitive data protection inside and outside the organization.
Dates and Times in SQL Server
In this video, We will talk about dates and times in SQL Server. The purpose of this video is to get you familiar with the dates and times (and their functions), so you can get the data that you need (and only the data that you need).
Database Links - Oracle PL SQL Course - Lesson 40
This video discuss the details demanded to setup the environment to establish a remote connect to a database server, which can be another Oracle instance or any other database that has an ODBC driver.
The SQL*Loader - Oracle PL SQL Course - Lesson 39
Importing files with textual data in CSV format into the Oracle is performed by utility called SQL*Loader. This video shows how to work with these files using the import control files of SQL*Loader by using examples.
Importing and exporting data - Oracle PL SQL Course - Lesson 38
Oracle has many tools and utilities to perform the import and export data into and from a database. This video shows how to use the IMP and EXP command line utilities to import and export, respectively, data to and from Oracle tables.
Managing dependencies - Oracle PL SQL Course - Lesson 35
This video explain the scenarios and situations where object dependency is an issue in Oracle and provide some examples that show how an object can be invalid because of a broken chain on dependency.
Table Statistics - Oracle PL SQL Course - Lesson 31
This video explain how are statistics and histograms and how why they are important. The examples show how to gather the statistics using the ANALYZE command and check the blocks size allocation in the DBA_TABLES and the DBA_INDEXES views.
Triggers - Oracle PL SQL Course - Lesson 28
This video explain the trigger concept and show the details of timming, event, type, when clause, firing sequence, :NEW and :OLD qualifiers, and the internal DELETING, INSERTING and UPDATING variables.
Creating Functions - Oracle PL SQL Course - Lesson 24
This video will discuss the details about the creation of functions in Oracle: the differences from procedures, the type of return values, what can and cannot be inside a function, the parameters types and how to execute the functions.
Creating procedures - Oracle PL SQL Course - Lesson 23
This video discuss about the following advantages of procedures in Oracle: modularity, reusability, extensibility, maintainability, data security, integrity, improved performance and code clarity.