• home
  • forum
  • my
  • kt
  • download
  • this:1/2 25records  total:45    Start  Previous  Next  Last    goto:
    SQL Exercises
    ON: 2007-09-03 13:50:58
    Tutorial mainly uses syntax constructions of SQL-92 standard. It will help you to master in wide and varied possibilities for formulating queries of arbitrary complexity to relational databases. Each topic of the tutorial is followed by numbers of exercises, which may be solved online while the system controls the correctness of solutions. Some structures specific for MS SQL Server 2005 are also considered, in particular, the string and temporal functions.
    92 times | category: [Miscellaneous]
    SQL Select Statement
    ON: 2007-09-03 13:43:50
    Learn the fundamental commands of SQL: Select From
    38 times | category: [Miscellaneous]
    Beginning SQL Programming: Part 4
    ON: 2007-09-03 13:38:52
    This fourth installment covers data warehouse with multiple SQL requesters, the human roles in DBMS, when to use SQL, scaling, speed, price, universality, and analytic capabilities, among other areas. This book provides the reader with a firm grasp of SQL concepts.
    21 times | category: [Miscellaneous]
    Simple SQL, Part 1 : Introduction
    ON: 2007-09-03 13:34:28
    Your boss has given you a mission. It sounds simple enough - you just need to create a few custom reports on your intranet that connect to your company-wide database. Well, what if suddenly you discover the database is a legacy monstrosity filled with arcane language and structures? What if, heavens forbid, nobody can understand it? How will you keep your job?
    39 times | category: [Miscellaneous]
    Simple SQL, Part II : Getting Started With SQL
    ON: 2007-09-03 13:31:49
    Now that you've learned exactly what SQL is (in my previous column), and how to use the standard SELECT functions, it's time to move ahead to other features. In this section, I'll be covering special grouping, logical and mathematical functions. These functions build upon what you've hopefully already learned, and allow you to leverage that to use SQL in your work.
    34 times | category: [Miscellaneous]
    Simple SQL, Part III: SQL in Action
    ON: 2007-09-03 13:26:21
    In the previous two parts of this series, we looked at the underlying concepts of SQL and many of the basic SQL query components. In this, the third and final installment of the series, we'll look at why you'd want to use SQL, and an example of it in action, via the Microsoft Visual InterDev 6.0 programming environment.
    23 times | category: [Miscellaneous]
    Beginning SQL Programming
    ON: 2007-09-03 13:19:19
    This book will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques. This first excerpt covers the history of SQL, standards, terminology and the current state of SQL
    36 times | category: [Miscellaneous]
    Beginning SQL Programming: Part 2
    ON: 2007-09-03 13:11:08
    This second installment covers procedural versus declarative languages, SQL's place in the data center and obtaining SQL. This book will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques.
    19 times | category: [Miscellaneous]
    Beginning SQL Programming: Part 3
    ON: 2007-09-03 13:03:24
    This third installment covers configurations for using SQL, two and three tier architecture on a LAN, n-tier architecture on the Web, mainframe and terminals, and mainframe to mainframe. This book provides the reader with a firm grasp of SQL concepts
    17 times | category: [Miscellaneous]
    Oracle DBA FAQ - Loading and Exporting Data
    ON: 2007-09-03 12:56:09
    A collection of 27 FAQs on Oracle loading data and exporting data. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema and tables, creating external tables.
    1514 times | category: [Miscellaneous]
    Oracle DBA FAQ - Oracle Basic Concepts
    ON: 2007-09-03 12:50:00
    This is a collection of FAQ for Oracle DBA on fundamental concepts. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.
    99 times | category: [Miscellaneous]
    Oracle DBA FAQ - Understanding SQL SELECT Query Statements
    ON: 2007-09-03 12:46:28
    A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries.
    99 times | category: [Miscellaneous]
    Oracle DBA FAQ - Understanding SQL Transaction Management
    ON: 2007-09-03 12:42:04
    A collection of 22 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on starting and ending transactions, committing and rolling back transactions, transaction/statement-level read consistency, read committed isolation level, locks and dead locks.
    147 times | category: [Miscellaneous]
    Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
    ON: 2007-09-03 12:37:06
    A collection of 23 FAQs on Oracle user account, schema and privileges. Clear answers are provided with tutorial exercises on creating user accounts, granting privileges for session connections, granting privileges for creating tables and inserting rows.
    302 times | category: [Miscellaneous]
    Oracle DBA FAQ - Understanding SQL Basics
    ON: 2007-09-03 12:32:35
    A collection of 28 FAQs on Oracle SQL language basics. Clear answers are provided with tutorial exercises on data types, data literals, date and time values, data and time intervals, converting to dates and times, NULL values, pattern matches.
    105 times | category: [Miscellaneous]
    Oracle DBA FAQ - Understanding SQL DDL Statements
    ON: 2007-09-03 12:24:48
    A collection of 12 FAQs on Oracle SQL DDL statements. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views.
    71 times | category: [Miscellaneous]
    Oracle DBA FAQ - Understanding SQL DML Statements
    ON: 2007-09-03 12:23:39
    A collection of 15 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting, updating and deleting rows from database tables.
    93 times | category: [Miscellaneous]
    Oracle DBA FAQ - Managing Oracle Database Tables
    ON: 2007-09-03 12:19:45
    A collection of 17 FAQs on database tables for DBA and developers. Clear answers are provided together with tutorial exercises to help beginners on creating, altering and removing tables, adding, altering and removing columns, and working with recycle bin.
    80 times | category: [Miscellaneous]
    Oracle DBA FAQ - Understanding PL/SQL Language Basics
    ON: 2007-09-03 12:17:47
    A collection of 22 FAQs on PL/SQL language basics or DBA and developers. It can also be used as learning tutorials on defining variables, assigning values, using "loop" statements, setting "if" conditions, and working with null values
    86 times | category: [Miscellaneous]
    [MYSQL] functions/queries list
    ON: 2007-09-03 10:54:56
    A list of usefully mysql functions and queries with short description for each function and exmaples.
    17 times | category: [Miscellaneous]
    Connecting to MySQL database from PHP
    ON: 2007-09-03 10:53:29
    This tutorial will show you how to connect to MySQL database from PHP script.
    13 times | category: [Miscellaneous]
    Using MySQL Delete querys in PHP
    ON: 2007-09-03 10:51:12
    This tutorial will show you how to use MySQL querys to database in your PHP scripts.
    8 times | category: [Miscellaneous]
    MySQL SELECT query from PHP script help, examples, homework, photoshop tutorials, free tutorials, tu
    ON: 2007-09-03 10:49:09
    This tutorial will show you how to use MySQL querys to database in your PHP scripts.
    0 times | category: [Miscellaneous]
    MySQL FAQs - Command-Line End User Interface mysql
    ON: 2007-09-03 10:45:38
    A collection of 10 FAQs on MySQL command-line interface mysql. Clear answers are provided with tutorial exercises on mysql command option; running SQL and mysql commands; running mysql command files in batch mode; returning query output in HTML and XML formats.
    57 times | category: [Miscellaneous]
    Beginners Guide to MySQL
    ON: 2007-09-03 10:41:13
    Learn from the ground up, on how to use MySQL for your websites. Even if you are a complete beginner and know nothing, you will be able to understand this tutorial.
    28 times | category: [Miscellaneous]
    this:1/2 25records  total:45    Start  Previous  Next  Last    goto:

    Category

      DB Design (2)
      MS Access (10)
      MsSQL (8)
      MySQL (6)
      Oracle (10)
      SQL Basics (9)
      Sybase (0)