Tags » SQL

Oracle SQL: A Beginner's Tutorial

Oracle SQL: A Beginner’s Tutorial PDF

This introduction to SQL for the Oracle database begins by discussing exactly how data is stored and maintained in a relational database, familiarizing readers with SQL INSERT, UPDATE, and DELETE statements. 58 more words


[SQL] - PIVOT,... (AdventureWorkdb)

  • Link Youtube: https://www.youtube.com/c/CarrY4U_VN
  • Link Facebook: https://www.facebook.com/carry4you69/


Lưu Ý: Trước khi bắt đầu các bạn cần add Database AdventureWork của Microsoft vào SQL của mình… 1,518 more words


Generate Table-Creation Script Using FOR XML Clause with PATH Mode

There are multiple ways to automate the generation of table-creation script based on existing tables in SQL server. The common way is to use the ‘generate script’ function to automate this process. 240 more words

Lean Code - Visual Tools

I’ve said it many times and it bears repeating:

Be careful who teaches you!

The following paragraph is cited from a book titled “Getting started with IntelliJ IDEA” by Hudson Orsine Assumpcao (October 2013), Chapter 3 “Working with Databases”.

356 more words

How to delete duplicate rows from a table

Scenario – A table storing registration codes is present and codes are loaded to this table on a daily basis and by mistake some duplicate entries have been loaded. 201 more words


SQL Server 2012 Best Security Practices

Security is a crucial part of any mission-critical application. This paper describes best practices for setting up and maintaining security in SQL Server 2012. 14,563 more words


Information Measurement with SQL Server, Part 2.2: The Rényi Entropy and Its Kin

By Steve Bolton

…………I kicked off this far-ranging series on using SQL Server to quantify information by discussing two of the earliest and most important measures, the Hartley function and Shannon’s Entropy. 1,719 more words

SQL Server