Subscribe: DevX: Latest Database Content
http://services.devx.com/outgoing/databasefeed.xml
Preview: DevX: Latest Database Content

DevX: Latest Database Content



www.DevX.com



Published: Wed, 29 Mar 2017 23:42:01 -0700

Last Build Date: Wed, 29 Mar 2017 23:42:01 -0700

 



Add Months to a Date in Oracle SQL

Wed, 29 Mar 2017 06:41:00 -0700

Language: SQL, Expertise: Beginner — Learn to easily add a number of months to a date in Oracle SQL with the ADD_MONTHS function.



Remove a Constraint from a Table in Oracle SQL

Wed, 22 Mar 2017 06:37:00 -0700

Language: SQL, Expertise: Beginner — Learn how to remove constraints that have been set up to enforce business rules on a database.



Built-in JSON Functions in SQL

Fri, 17 Mar 2017 06:22:00 -0700

Language: SQL, Expertise: Intermediate — Did you know that SQL has some very handy built-in JSON functions?



Find the Source Code of a Function or Procedure in Oracle SQL

Tue, 14 Mar 2017 06:36:00 -0700

Language: SQL, Expertise: Beginner — If you need to find the source code for a function or procedure in the database, it's easy to do in Oracle.



Optional Parameters in SQL

Thu, 09 Mar 2017 11:20:00 -0800

Language: SQL, Expertise: Beginner — Learn to implement an optional parameter in SQL by declaring a parameter in your stored procedure with a default value of NULL



Add Multiple Columns to a Table in a Single Statement in Oracle SQL

Mon, 06 Mar 2017 07:40:00 -0800

Language: SQL, Expertise: Beginner



Turn on Line Numbers in SQL Developer

Thu, 23 Feb 2017 06:40:00 -0800

Language: SQL||Expertise: Beginner



Using the SQL LCASE Function

Wed, 22 Feb 2017 02:36:00 -0800

Language: SQL||Expertise: Beginner



Get a List of all Tables In Oracle SQL

Mon, 20 Feb 2017 02:35:00 -0800




How to Undo Dropping a Table in Oracle SQL

Tue, 07 Feb 2017 07:42:00 -0800

Language: SQL||Expertise: Beginner



Cloud Platform Overview

Mon, 06 Feb 2017 09:41:00 -0800

Gain a solid understanding of the current state of Cloud platforms, how to integrate the Cloud into your systems and how to manage the risks.



Change the Output Format of a Date with TO_DATE

Tue, 31 Jan 2017 02:20:00 -0800

Language: SQL||Expertise: Beginner



MySQL vs. MariaDB

Fri, 27 Jan 2017 12:18:00 -0800

Many developers have used MySQL, while many have only heard of MariaDB. Explore the differences between these two database management systems.



Limiting the Amount of Characters Output in a Column Using the SQL TEXTSIZE Command

Tue, 24 Jan 2017 02:35:00 -0800

Language: SQL||Expertise: Beginner



Using Python for Big Data Analysis

Wed, 18 Jan 2017 12:29:00 -0800

There are numerous tools to aid in big data analysis, but one of the most popular is Python.



Using DATEFROMPARTS SQL Function

Tue, 17 Jan 2017 05:26:00 -0800

Language: SQL||Expertise: Beginner



The Future of Tech Careers

Thu, 12 Jan 2017 05:12:00 -0800

Learn how to future-proof your career by combine innovations from multiple areas to achieve synergies.



Using REPLICATE for SQL Strings

Thu, 05 Jan 2017 05:27:00 -0800

Language: SQL||Expertise: Beginner



Top 10 Security Best Practices

Fri, 30 Dec 2016 13:37:00 -0800

Security is hard. It takes dedicated attention, knowledge and meticulous execution. It is also an ongoing process. It's important to educate stakeholders and clarify the state of security, the risks and mitigations. You need to be vigilant and on your toes.



The sp_MSforeachdb Stored Procedure

Thu, 22 Dec 2016 01:49:00 -0800

Language: SQL||Expertise: Intermediate



Check if a Temporary Table Exists

Thu, 15 Dec 2016 11:47:00 -0800

Language: SQL||Expertise: Intermediate



Using FOR XML PATH and STUFF SQL String Concatenation

Tue, 06 Dec 2016 02:23:00 -0800

Language: SQL||Expertise: Intermediate



Convert Oracle Queries into Microsoft SQL Format

Fri, 02 Dec 2016 02:52:00 -0800

Language: SQL||Expertise: Intermediate



Container Orchestration with Docker Swarm

Fri, 25 Nov 2016 11:10:00 -0800

The power of containers shines brightest when you build large systems made up of many machines running lots of interacting containers. That's were Docker Swarm comes -- arguably the simplest orchestration solution for Docker containers and it is built into the Docker engine itself.



Renaming an SQL Server Database

Tue, 22 Nov 2016 02:22:00 -0800