Databases--tutorial.jcwcn.com

Home / Databases /

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

New

Hot