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
Tags » SQL
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
English
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
CREATE DATABASE
Postgres=# create database databasenane;
CREATE BOLE
Postgres=# create user testuser with password ‘password’ ;
ALTEB ROLE/CHANGE PASSWORD
11 more wordsPostgres=# alter user testuser with password ‘newpassword’ ;
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
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
（转）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
