Sql and relational theory

Xem 1-5 trên 5 kết quả Sql and relational theory
  • SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL. This second edition includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating.

    pdf446p hoa_can 26-01-2013 25 6   Download

  • Views are virtual tables. That means they should be updatable, just as "real" orare. In fact, view updatability isn’t just desirable, it’s crucial, for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the relational model first appeared, there has been widespread skepticism as to whether (in general) view updating is even possible.

    pdf262p hoa_can 26-01-2013 22 2   Download

  • Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data....

    pdf767p titatu_123 01-03-2013 69 33   Download

  • This book is a companion to my An Introduction to Relational Database Theory (reference [7]) and is intended to be read in parallel with that text, hereinafter referred to as “the theory book”. As I noted in the preface of that book, a university course on relational databases is typically divided into a theory component and an “industrial” component requiring the student to learn the basics of SQL. In that preface I also mention that in my own teaching I encourage students to “compare and contrast SQL with what they have learned in the theory part”.

    pdf172p tuanloc_do 03-12-2012 23 1   Download

  • This book teaches you the fundamentals of databases, including relational database theory, logical and physical database design, and the SQL language. Advanced topics include using functions, stored procedures and XML.

    pdf282p emvaolop1 24-01-2015 14 6   Download


Đồng bộ tài khoản