background preloader

SQLZOO

https://sqlzoo.net/

SQL Trace This article lists the commands required to trace SQL statements executed by a user, an application or the entire database. [edit] Tracing a SQL session [edit] Start session trace How to share data between stored procedures An SQL text by Erland Sommarskog, SQL Server MVP. Most recent update 2013-11-02. Introduction This article tackles two related questions: .NET Tutorial: Learn .NET and C# interactively Welcome to my .NET Tutorial! This is an interactive .NET tutorial. To access it, please install Microsoft Silverlight. This .NET Tutorial is 100% free. Not just some modules or sections of it, but the entire tutorial. Research - Turning Ideas into Reality Microsoft Azure and cloud computing Predicting ocean chemistry using Microsoft Azure Introducing LiveOcean: A cloud-based predictive system from the University of Washington and Microsoft Research of ocean acidification properties that may help the shellfish industry survive changing conditions by providing forecasts about ocean water. Open source AI

3 Data Pump Import This chapter describes the Oracle Data Pump Import utility. The following topics are discussed: This section provides descriptions of the parameters available in the command-line mode of Data Pump Import. Many of the descriptions include an example of how to use the parameter. Using Partitions in a Microsoft SQL Server 2000 Data Warehouse - Waterfox Author: Joy Mundy Contributors: Stuart Ozer, Lubor Kollar, Len Wyatt Microsoft Corporation February 2001 Summary: This article describes how to use partitions to improve the manageability, query performance, and load speed of data warehouses in SQL Server 2000 Enterprise Edition. Horizontal partitioning of dimensional schema, both in the relational database and in Analysis Services cubes, is addressed. Contents How Do I Find Tutorials (Database Engine) Microsoft SQL Server includes a complete set of graphical tools and command line utilities that allow users, programmers, and administrators to increase their productivity. The step-by-step tutorials listed below, help you learn to get the most out of SQL Server tools so you can work efficiently, right from the start. The following table describes the topics in this section.

A case for ANSI SQL Intro Hi there! This is my first post on the blog. I will cover Oracle SQL and PL/SQL topics. For lack of inspiration, I dubbed it "The Oracle Experience" (like The Jimi Hendrix Experience) because Oracle databases rock, of course. Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server - Waterfox Published: February 17, 2005 Authors: Gandhi Swaminathan Contributors: Hao Chen, Rakesh Gujjula, Gang He

One of the very useful site to learn Oracle SQL interactively as you can execute queries online in your browser which proves to be very useful and along with providing decent examples to solve complex queries. by raghu Apr 7

Related:  SQL Base de donnĂ©es