*******************************************************************************
Relational Database:
coursera-Stanford University-Introduction to Databases
*******************************************************************************
Relational Database:
:Schema - database structure, relation of different attributes.)
:Data type
:DDL - Data Definition Language (Create,)
: DML - Data Manipulation Language(Select,Insert,Update ,)
:Querying relational databases
Indexes:
Constraints & Triggers:
Transactions:
Views:
Authorization:
On-Line Analytical Processing (OLAP)
XML Data:
Querying XML:
JSON Data:
NoSQL Systems
Source Article : Hadoop-NoSQL Software and Services Market Forecast 2012-2017
*******************************************************************************
Treehouse: Learn Web Design, Web Development, and More
Learn HTML, CSS, iPhone apps & more.
Learn how to build websites & apps, write code or start a business.
Source Article: Facebook’s Profit Propelled by Mobile
...
Mobile devices accounted for nearly two-thirds of Facebook’s revenue, which at this point mostly comes from ads shown on the Facebook website and apps. However, the company is beginning to supplement that with ads on other sites.
...
*******************************************************************************
Business Intelligence for SQL Server 2012
Beginner SQL Tutorial
*******************************************************************************
Learn .NET in 60 days
Oracle Architecture in less than 10 minutes
*******************************************************************************
Queries:
SQL 2008 Retrieving parent-child hierarchy from query
SQL Server forums > Transact-SQL
;WITH EmpCTE(empid, empname, mgrid, lvl)
AS
(
SELECT empid, empname, mgrid, 0
FROM Employees
WHERE empid = 14 --input the leaf empid
UNION ALL
SELECT E.empid, E.empname, E.mgrid, M.lvl+1
FROM Employees AS E
JOIN EmpCTE AS M
ON E.empid = isnull(M.mgrid,0)-- search the mgrid according the mgrid on leaf empid
)
SELECT * FROM EmpCTE
--result
empid empname mgrid lvl
----------- ------------------------- ----------- -----------
14 James 11 0
11 David 7 1
7 Robert 3 2
3 Janet 1 3
1 Nancy NULL 4
----------------------
Departures from Origins and Arrivals at Destinations
*******************************************************************************
Unix Command Summary
Java Basic Syntax
*******************************************************************************
Erwin Data Modeler:
Erwin Data modeler
CA ERwin Data Modeler: Soup to Nuts Demo
ERwin Data Modeler WorkSpace
Metadata Integration from CA ERwin Data Modeler to Informatica PowerDesigner
Toad World:
ERWin models to Toad Data Modeler
Importing Erwin Data Model
Data Modelers - Alternatives to Erwin
What are the TOAD & ERWIN? What are the difference between them?
posted in BusinessObjects Reporting Tool (BO)
- TOAD is a software tool to connect to Oracle database (Oracle Client side tool)
- Erwin is a tool to do data modeling in logical and physical level
SWITCHING DATA MODELING TOOLS? OUCH!
*******************************************************************************
ETL Tools:
Datastage Tutorials-Datastage ETL Tool Datastage Frequently asked questions, Datastage Interv
*******************************************************************************
Programming Language:
The Python Tutorial
PL/SQL Tutorial
*******************************************************************************
No comments:
Post a Comment