Learning SQL on SQL Server 2005
(eBook)
Author
Contributors
Published
[Sebastopol, Calif.] : O'Reilly, [2006].
Format
eBook
ISBN
9780596102159, 0596102151, 9781449390891, 1449390897
Physical Desc
1 online resource (342 pages)
Status
Description
Loading Description...
Also in this Series
Checking series information...
Subjects
Bisac Subjects
More Details
Language
English
Notes
Description
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.
Local note
O'Reilly,O'Reilly Online Learning: Academic/Public Library Edition
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Bagui, S., & Earp, R. (2006). Learning SQL on SQL Server 2005 . O'Reilly.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Bagui, Sikha, 1964- and Richard Earp. 2006. Learning SQL On SQL Server 2005. O'Reilly.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Bagui, Sikha, 1964- and Richard Earp. Learning SQL On SQL Server 2005 O'Reilly, 2006.
MLA Citation, 9th Edition (style guide)Bagui, Sikha, and Richard Earp. Learning SQL On SQL Server 2005 O'Reilly, 2006.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
269640e0-c83d-64f3-31c5-caa80daaa316-eng
Grouping Information
| Grouped Work ID | 269640e0-c83d-64f3-31c5-caa80daaa316-eng |
|---|---|
| Full title | learning sql on sql server 2005 |
| Author | bagui sikha |
| Grouping Category | book |
| Last Update | 2024-04-16 12:23:35PM |
| Last Indexed | 2024-04-17 02:25:00AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Nov 18, 2022 |
| Last Used | Mar 15, 2024 |
Marc Record
| First Detected | Nov 09, 2022 03:37:26 PM |
|---|---|
| Last File Modification Time | Apr 16, 2024 12:24:17 PM |
MARC Record
| LEADER | 05576cam a2200757 a 4500 | ||
|---|---|---|---|
| 001 | ocm68941023 | ||
| 003 | OCoLC | ||
| 005 | 20240405112445.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 060517s2006 cau o 001 0 eng d | ||
| 010 | |a 2006284877 | ||
| 019 | |a 326774512|a 968008992|a 969039553|a 1103276352|a 1129374382|a 1202568467|a 1240521711|a 1412662904 | ||
| 020 | |a 9780596102159 | ||
| 020 | |a 0596102151 | ||
| 020 | |a 9781449390891 | ||
| 020 | |a 1449390897 | ||
| 020 | |z 0596102151 | ||
| 024 | 3 | |z 9780596102159 | |
| 029 | 1 | |a DEBSZ|b 355371588 | |
| 029 | 1 | |a GBVCP|b 617236399 | |
| 029 | 1 | |a HEBIS|b 291444474 | |
| 029 | 1 | |a NZ1|b 11777249 | |
| 029 | 1 | |a AU@|b 000070668321 | |
| 035 | |a (OCoLC)68941023|z (OCoLC)326774512|z (OCoLC)968008992|z (OCoLC)969039553|z (OCoLC)1103276352|z (OCoLC)1129374382|z (OCoLC)1202568467|z (OCoLC)1240521711|z (OCoLC)1412662904 | ||
| 040 | |a MKN|b eng|e pn|c MKN|d OCLCA|d TXJ|d CEF|d OCLCQ|d DEBSZ|d OCLCQ|d C6I|d OCLCF|d OCLCQ|d EBLCP|d YDXCP|d OCLCQ|d FEM|d OCLCQ|d MOQ|d CUSER|d WYU|d UKAHL|d VT2|d OCLCQ|d OCLCO|d INARC|d OCLCL|d OCLCQ|d OCLCL | ||
| 049 | |a TKLA | ||
| 050 | 4 | |a QA76.73.S67|b B34 2006 | |
| 082 | 0 | 4 | |a 005.75/85|2 22 |
| 100 | 1 | |a Bagui, Sikha,|d 1964-|1 https://id.oclc.org/worldcat/entity/E39PCjthh6DFC4Vkc8MhVQf3pK|0 http://id.loc.gov/authorities/names/n2002010519 | |
| 245 | 1 | 0 | |a Learning SQL on SQL Server 2005 /|c by Sikha Saha Bagui, Richard Walsh Earp. |
| 260 | |a [Sebastopol, Calif.] :|b O'Reilly,|c [2006] | ||
| 300 | |a 1 online resource (342 pages) | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 347 | |a text file|2 rda | ||
| 520 | |a 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. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a SQL server.|0 http://id.loc.gov/authorities/names/n90684343 |
| 630 | 0 | 7 | |a SQL server.|2 blmlsh |
| 630 | 0 | 7 | |a SQL server.|2 fast|0 (OCoLC)fst01376937 |
| 650 | 0 | |a SQL (Computer program language)|0 http://id.loc.gov/authorities/subjects/sh86006628 | |
| 650 | 0 | |a Database design.|0 http://id.loc.gov/authorities/subjects/sh88004472 | |
| 650 | 0 | |a Database management.|0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données|x Conception. | |
| 650 | 6 | |a Bases de données|x Gestion. | |
| 650 | 1 | 7 | |a SQL (Computer program language)|2 bisacsh |
| 650 | 7 | |a SQL (Computer program language)|2 blmlsh | |
| 650 | 7 | |a Database design.|2 blmlsh | |
| 650 | 7 | |a Database management.|2 blmlsh | |
| 650 | 7 | |a Database design.|2 fast|0 (OCoLC)fst00888032 | |
| 650 | 7 | |a Database management.|2 fast|0 (OCoLC)fst00888037 | |
| 650 | 7 | |a SQL (Computer program language)|2 fast|0 (OCoLC)fst01102869 | |
| 655 | 4 | |a Programming Languages. | |
| 700 | 1 | |a Earp, Richard,|d 1940-|1 https://id.oclc.org/worldcat/entity/E39PCjwTvDKTM6xkMtrDk79rG3|0 http://id.loc.gov/authorities/names/n2002010518 | |
| 758 | |i has work:|a Learning SQL on SQL Server 2005 (Text)|1 https://id.oclc.org/worldcat/entity/E39PCGdbWrM9dhvjmMmMHXrCkP|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 1 | |c Original|z 0596102151|w (OCoLC)69387844 | |
| 856 | 4 | 0 | |u https://ezproxy.knoxlib.org/login?url=https://learning.oreilly.com/library/view/~/0596102151/?ar |
| 938 | |a Askews and Holts Library Services|b ASKH|n AH26833626 | ||
| 938 | |a ProQuest Ebook Central|b EBLB|n EBL536667 | ||
| 938 | |a YBP Library Services|b YANK|n 12707326 | ||
| 938 | |a Internet Archive|b INAR|n learningsqlonsql0000bagu | ||
| 994 | |a 92|b TKL | ||