Sikha Saha Bagui's Books

Learning SQL on SQL Server 2005

By: Sikha Saha Bagui,Richard Walsh Earp

Write a review Read reviews Take a Quiz Solve Book Puzzle

Learning SQL on SQL Server 2005

By: Sikha Saha Bagui,Richard Walsh Earp

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.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

344

Publisher

"O'Reilly Media, Inc."

Published Date

ISBN 10

1449390897

ISBN 13

9781449390891

Database Design Using Entity-Relationship Diagrams

By: Sikha Saha Bagui,Richard Walsh Earp

Write a review Read reviews Take a Quiz Solve Book Puzzle

Database Design Using Entity-Relationship Diagrams

By: Sikha Saha Bagui,Richard Walsh Earp

Essential to database design, entity-relationship (ER) diagrams are known for their usefulness in data modeling and mapping out clear database designs. They are also well-known for being difficult to master. With Database Design Using Entity-Relationship Diagrams, Third Edition, database designers, developers, and students preparing to enter the field can quickly learn the ins and outs of data modeling through ER diagramming. Building on the success of the bestselling first and second editions, this accessible text includes a new chapter on the relational model and functional dependencies. It also includes expanded chapters on Enhanced Entity-Relationship (EER) diagrams and reverse mapping. It uses cutting-edge case studies and examples to help readers master database development basics and defines ER and EER diagramming in terms of requirements (end user requests) and specifications (designer feedback to those requests), facilitating agile database development. This book Describes a step-by-step approach for producing an ER diagram and developing a relational database from it Contains exercises, examples, case studies, bibliographies, and summaries in each chapter Details the rules for mapping ER diagrams to relational databases Explains how to reverse engineer a relational database back to an entity-relationship model Includes grammar for the ER diagrams that can be presented back to the user, facilitating agile database development The updated exercises and chapter summaries provide the real-world understanding needed to develop ER and EER diagrams, map them to relational databases, and test the resulting relational database. Complete with a wealth of additional exercises and examples throughout, this edition should be a basic component of any database course. Its comprehensive nature and easy-to-navigate structure make it a resource that students and professionals will turn to throughout their careers.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

347

Publisher

CRC Press

Published Date

ISBN 10

1000642704

ISBN 13

9781000642704

Essential SQL on SQL Server 2008

By: Dr. Sikha Bagui,Dr. Richard Earp

Write a review Read reviews Take a Quiz Solve Book Puzzle

Essential SQL on SQL Server 2008

By: Dr. Sikha Bagui,Dr. Richard Earp

This book provides readers with a very systematic approach to learning SQL using SQL Server.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

407

Publisher

Jones & Bartlett Publishers

Published Date

ISBN 10

0763792071

ISBN 13

9780763792077

Practical Guide to Using SQL in Oracle

By: Dr. Richard Earp,Earp,Dr. Sikha Bagui

Write a review Read reviews Take a Quiz Solve Book Puzzle

Practical Guide to Using SQL in Oracle

By: Dr. Richard Earp,Earp,Dr. Sikha Bagui

Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic increase in the popularity of relational databases, coupled with Oracle’s having the largest market share, has created a demand for programmers who can write SQL code correctly and efficiently. This book provides a systematic approach to learning SQL in Oracle. Each chapter is written in a step-by-step manner and includes examples that can be run using Oracle. Using the sample tables and data provided, readers will be able to perform the examples to gain hands-on experience with Oracle programming. Gain an understanding of basic SQL principles. Learn to generate, store, and edit SQL queries in Oracle. Develop joins, subqueries, and correlated subqueries. Work with XML and Oracle databases. Test your SQL knowledge with the exercises at the end of each chapter!

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

506

Publisher

Jones & Bartlett Publishers

Published Date

ISBN 10

1449613039

ISBN 13

9781449613037

Database Design Using Entity-Relationship Diagrams

By: Sikha Bagui,Richard Earp

Write a review Read reviews Take a Quiz Solve Book Puzzle

Database Design Using Entity-Relationship Diagrams

By: Sikha Bagui,Richard Earp

Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications. The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers. introbul>Features

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

268

Publisher

Auerbach Publications

Published Date

ISBN 10

0849315484

ISBN 13

9780849315480

Book's by Sikha Saha Bagui

Learning SQL on SQL Server 2005

Learning SQL on SQL Server 2005

Database Design Using Entity-Relationship Diagrams

Database Design Using Entity-Relationship Diagrams

Essential SQL on SQL Server 2008

Essential SQL on SQL Server 2008

Practical Guide to Using SQL in Oracle

Practical Guide to Using SQL in Oracle

Database Design Using Entity-Relationship Diagrams

Database Design Using Entity-Relationship Diagrams

Username

Password

Username

Password

Password again

Birthday

Email