Tags » SQL

SQL CheatSheet

I’ve just worked through Imtiaz Ahmad’s Master SQL for Data Science on Udemy and it was a thoroughly enjoyable, morale-boosting experience! He build on each concept so you never feel left behind or perplexed at how he arrived at a solution, and as promised there are a gazillion exercises so by the time you’re done you feel like you can actually create queries! 124 more words

How To

Advanced SQL : SQL Expert Certification Preparation Course free

Advanced SQL : SQL Expert Certification Preparation Course

Created by Omer Dagasan, Omer Faruk Ince

Last updated 10/2017


Created by Omer Dagasan, Omer Faruk Ince… 457 more words

Identifying the top segments

Hello readers! My name is Bruno Kremer, this is my first post from a series, and I will be talking about how we can identify the top segments of the database. 334 more words

postgres cmd commands for windows


Postgres=#  create database databasenane;


Postgres=#  create user testuser with password ‘password’ ;


Postgres=#  alter user testuser with password ‘newpassword’ ;

11 more words

DBA Ramblings from 2013

DBA In training
My IT career started when I joined a small IT firm that developed web based applications. The applications were written like most other applications in at the turn of the year 2000 in good old asp, VB scripting and SQL server. 7,421 more words

SQL Server

Unified Monitoring – Overview and design.

We need to get a standard toolset in order to view the state of our SQL servers. The intention is to have a common framework that is easy enough for various new bit to be added. 1,798 more words

SQL Server

(转)Understanding the WITH Clause

Recently I researched recursive SQL queries for an Oracle Technology Network (OTN) article on Oracle’s CONNECT BY syntax. (By the way, that article is scheduled to appear on OTN sometime in July) While researching that article, someone at Oracle pointed me to the SELECT statement’s WITH clause. 2,853 more words