Learning SQL on SQL Server 2005

Nonfiction, Computers, Programming, Programming Languages, SQL, Database Management, Data Processing
Cover of the book Learning SQL on SQL Server 2005 by Sikha Saha Bagui, Richard Walsh Earp, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Sikha Saha Bagui, Richard Walsh Earp ISBN: 9781449390891
Publisher: O'Reilly Media Publication: March 5, 2010
Imprint: O'Reilly Media Language: English
Author: Sikha Saha Bagui, Richard Walsh Earp
ISBN: 9781449390891
Publisher: O'Reilly Media
Publication: March 5, 2010
Imprint: O'Reilly Media
Language: English

Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.

Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:

  • Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables
  • How to customize SQL Server 2005's settings and about SQL Server 2005's functions
  • About joins, a common database mechanism for combining tables
  • Query development, the use of views and other derived structures, and simple set operations
  • Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005

Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.

Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:

Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.

More books from O'Reilly Media

Cover of the book Kindle Fire: Out of the Box by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book The Culture of Big Data by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book sendmail Cookbook by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book EPUB 3 Best Practices by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Application Security for the Android Platform by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Design and Prototyping for Drupal by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Wikipedia: The Missing Manual by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Refactoring SQL Applications by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Google Wave: Up and Running by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Writing and Querying MapReduce Views in CouchDB by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Learning from jQuery by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Calm Technology by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book MySQL Pocket Reference by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Bash kurz & gut by Sikha Saha Bagui, Richard Walsh Earp
Cover of the book Java 8 Lambdas by Sikha Saha Bagui, Richard Walsh Earp
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy