Articles

SQL courses - Reference List

Bernard Nieuwoudt 2017-01-12 07:23:18

For further reading and reference, please see the books and articles below:

 

Leading Edge : All Courses:  https://www.leadingtraining.co.za/all_courses.php

 

 

 

General:

 WITH clause :

https://msdn.microsoft.com/en-za/library/ms175972.aspx

https://oracle-base.com/articles/misc/with-clause

http://www.dba-oracle.com/t_with_clause.htm

 

UNIONs , SELECT and SELECT INTO

https://msdn.microsoft.com/en-us/library/ms180026.aspx

 

COUNT() with NULL:

https://msdn.microsoft.com/en-za/library/ms175997.aspx

http://www.w3schools.com/sql/sql_func_count.asp

 

Non-EquiJoins

http://www.oracle-dba-online.com/sql/join_queries.htm

https://technet.microsoft.com/en-us/library/ms190014(v=sql.105).aspx

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/00d6e40e-1940-4995-aa56-35839fb90687/nonequi-joins?forum=transactsql

 

Normalise database to 5th Normal Form:

https://en.wikipedia.org/wiki/Fifth_normal_form

 

T-SQL

 

 Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins. Microsoft SQL Server 2012 Unleashed.

 <https://www.safaribooksonline.com/library/view/microsoft-sql-server/9780133408539/>

 

 

Shortcut keys for SQL Management Studio

https://msdn.microsoft.com/en-za/library/ms174205.aspx

 

T-SQL DML:

https://msdn.microsoft.com/en-us/library/ff848766.aspx>

 

T-SQL DDL:

https://msdn.microsoft.com/en-us/library/ff848799.aspx

 

Where to use column Aliases in T-SQL:

<http://stackoverflow.com/questions/3096301/sql-server-as-statement-aliased-column-within-where-statement

 

LTRIM with characters other than space:

<https://basitaalishan.com/2014/02/23/removing-part-of-string-before-and-after-specific-character-using-transact-sql-string-functions/

 

TOP (x) - How is it calculated in T-SQL:

<https://www.microsoftpressstore.com/articles/article.aspx?p=2314819

 

Import Excel data into a T-SQL database from an Excel data server:

https://support.microsoft.com/en-za/kb/321686

 

JOIN databases over Database Servers: 

<http://stackoverflow.com/questions/5145637/querying-data-by-joining-two-tables-in-two-database-on-different-servers>

<http://forums.asp.net/t/1254974.aspx?How+to+join+tables+from+different+databases+in+SQL+select+statement+>

 

JOIN databases on the same Database Server:

 <http://forums.asp.net/t/1254974.aspx?How+to+join+tables+from+different+databases+in+SQL+select+statement+>

 

Certification:

 

 

Oracle:

 

Use CAST with Oracle:

 https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions016.htm

 

Using Date Functions with Oracle

https://oracle-base.com/articles/misc/oracle-dates-timestamps-and-intervals

 

Manuals and Certification:

 

 

Telephone:
+27(0)11 656 4233
+27(0)72 597 0567
Address:
Woodmead Business Park
Ground Floor, Maple Place North
145 Western Service Road
Woodmead
Sandton 2196

View Map