On TV.com: THE GIRLS NEXT DOOR photos
1 Resources for

sql basics

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

SQL basics: Deleting from child tables
This SQL basics article responds to Builder.com members' questions about deleting rows from one table and using another table as a data reference.I’ve received several requests for a description of how to delete rows from tables that are dependent on criteria from other tables. The solution lies in a clever,...
Tags: Programming languages, Databases, Shelley Doll, SQL Basics, SQL, subselect
Technical articles 2002-10-15

Additional Resources

SQL Server Survival Guide for Network Administrators
Microsoft's SQL Server can be a scary place, especially if you don't have much database experience. So we put together this resource to help guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon...
Tags: Microsoft SQL Server Transact-SQL, TechRepublic Inc., Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management
Download resources 2005-01-05
SQL Server Survival Guide for Net Admins PDF
This resource will guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon to perform; Transact-SQL Reference introduces the fundamentals of T-SQL code and query building to help you find information in your database....
Tags: Microsoft SQL Server Transact-SQL, Administrator, Adobe PDF, Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management
Download resources 2004-10-07
SQL Profiler
Have you ever had to diagnose SQL Server performance issues or troubleshoot an application? If so, check out my article on working with SQL Profiler. It will run you through the basics and get you up to speed quicky.
Tags: SQL Profiler, SQL
Blog posts 2005-12-06
Microsoft SQL Server I/O Basics Chapter 2: SQL Server 2004 SP4 and SQL Server 2005
Microsoft SQL Server 2005 continues to innovate and extend I/O performance and reliability. With new innovations come new terms, designs, and algorithms. The administrator of a SQL Server 2005 installation will find that visibility into the SQL Server I/O subsystem has been significantly increased. A primary focus of the SQL...
Tags: Microsoft SQL Server, I/O, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
White papers 2006-06-01
QuickStart: Microsoft SQL Server
If you need to get up to speed fast on Microsoft SQL Server, we've got the answer. Download our QuickStart: Microsoft SQL Server to learn the basics of this powerful database system.
Tags: Microsoft SQL Server, Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management
Software downloads 2004-06-28
SQL Server 2000 QuickStart Guide
Getting a good start in any new technology or programming language often depends on finding the best available information. Besides explaining the basics, the TechRepublic.com SQL Server QuickStart Tool shows you common tasks, exposes strengths and weaknesses, demonstrates some of the best uses of the technology, and lists a variety...
Tags: Microsoft SQL Server, Microsoft SQL Server 2000
Blog posts 2006-06-17
Where to go .....
I am currently in a reporter DBO position. I mainly use MS Access. I am trying to get a game plan together so I can strive for MCDBA. I use SQL loosely. I use it but only the basics I haven't really used SQL in several years. I got...
Tags: Programming languages, Databases, SQL
Discussion threads 2005-07-14
TechRepublic SQL Server QuickStart
Getting a good start in any new technology or programming language often depends on finding the best available information. Besides explaining the basics, the TechRepublic.com SQL Server QuickStart Tool shows you common tasks, exposes strengths and weaknesses, demonstrates some of the best uses of the technology, and lists a variety...
Tags: TechRepublic Inc., Productivity, Programming Languages, Development Tools, Strategy, Software Development, Software/Web Development, Management
Download resources 2004-06-07
Administer SQL Server 2005 Express Edition
SQL Server Express is a free, easy-to-use, simple-to-manage database without many of the features of the full-blown SQL Server, but powerful and flexible enough to meet the needs of low-end server users such as small businesses, non-professional developers building Web applications, and hobbyists building client applications. Master the...
Tags: Coverage, Microsoft SQL Server, Sybex, Server, Microsoft SQL Server 2005, SQL Server Express, Databases, Enterprise Software, Software, Data Management
Book chapters 2006-12-06
Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server
DTSAbout Sql Server 2000 DTS
Tags: DTS, jayapragadeesh@..., Microsoft Corp., Microsoft SQL Server, networking, server, Step-by-Step
Discussion threads 2004-12-20
MSDN Webcast: SQL Master Class: Reporting Services Basics (Level 200)
Microsoft SQL Server Reporting Services was released in 2004 to provide developers with an easy way to extract and share information captured in a relational database. This webcast explores how to create basic reports, link them to together, and provide end users with a way to get the information they...
Tags: Microsoft Developer Network, Webcast, SQL, Microsoft Corp., Digital Media, Databases, Consumer Electronics, Personal Technology, Enterprise Software, Software, Data Management
Webcasts
Website Security
I use php and mysql databases and am looking for some good resources dealing with security issues. I am hoping to start a business eventually with my brother and would like to learn about the basics of keeping your website secure. ThanksEdit/Delete MessageSQL Injection AttacksLearn as much as you can...
Tags: database, educational resource, marcato15, PHP, programming, security, Web site, Website Security
Discussion threads 2005-11-10
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...
Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management
White papers 2001-07-19
SQL PathFinder for Oracle (msi)
SQL Pathfinder is for Oracle SQL programmers who live in an environment where multiple versions of SQL scripts and multiple SQL execution environments exist. Pathfinder determines the SQL path that SQL Plus will use, and traces and displays all of the script dependencies for your SQL script. The dependencies are...
Tags: Oracle Corp., SQL, SQL PathFinder, Pathfinder, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2006-11-21
Cache Monitor (zip)
Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like advanced SQL Query Editor with foreign key join suggestion, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, Graphical SQL execution plan. Version 0.34 is...
Tags: Monitor, SQL, Cache Monitor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2007-05-11
What is the difference between Oracle, SQL and PL/SQL?
Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...
Tags: Oracle Corp., PL/SQL, SQL
Blog posts 2006-05-30
Microsoft PowerPoint Basics
This Microsoft PowerPoint Basics presentation provides a preformatted solution for teaching end users Microsoft PowerPoint fundamentals. The presentation also proves helpful in reviewing PowerPoint basics. The accompanying handout provides a single document for employees to keep at their desks as a handy quick reference guide. This download is an exclusive...
Tags: microsoft powerpoint, microsoft corp., microsoft office, office suites, software
Download resources 2006-08-14
Some resources on SQL Server 2005
Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center  SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner
Blog posts 2005-11-11
Transferring SQL Server logins between servers or instances
I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. [poll=11] I...
Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren
Blog posts 2007-09-25
  • << Previous
  • page 1 of 1
  • Next >>


Windows XP vs. Mac OS X
This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...
Buy Now
Disaster Prevention and Recovery in Windows Server 2003
The Windows Server 2003 Volume Shadow Copy Service offers even small IT shops a unique opportunity to back up just like the big guys. Our Windows Serv ...
Buy Now

IP Networking