demographics survey 
|
BizAssist Reader Survey
BizAssist.co.za is currently running a reader / visitor survey so that we may gain further insight into our website visitors and their areas of interest. We have some fantastic prizes up for grabs in our monthly draws so please assist by telling us a bit about yourself. Complete the reader survey and you could be a winner! |
bizassist on facebook
|
Are you on Facebook?
Join the BizAssist - Entrepreneurs & SME's Facebook Group. |
|
join the sahba
|
S.A.H.B.A
Become a member of the South African Home Business Association for only R200 per year. |
|
|
|
New Business Trends  Internet Business
Intersoft SQL Bible
Annotations
Helps readers to learn SQL for Oracle 11g, IBM DB2, and Microsoft SQL Server 2008. In this work the chapters highlight how the SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. It is intended for SQL users, from beginners to experienced developers.
Description
This work helps readers harness SQL for Oracle 11g, IBM DB2, and Microsoft SQL Server 2008. Combining theory with everyday practicality, this definitive volume is packed with up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. This book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.This work helps readers to: learn the basics of SQL and relational databases; explore tables, views, sequences, and other database objects; examine transactions and locking in multiuser environments; review functions mandated by the SQL standard and the three major vendors; access metadata information and implement database security; and, go beyond SQL to XML integration, OLAP business intelligence, and more. In the companion Web Site find downloadable code examples, a full book description, and more.
Table of Contents
Acknowledgements.
Introduction.
Part I SQL Basic Concepts and Principles.
Chapter 1: SQL and Relational Database Management Systems.
Chapter 2: Fundamental SQL Concepts and Principles.
Chapter 3: SQL Data Types.Part II Creating and Modifying Database Objects.
Chapter 4: Creating RDBMS Objects.
Chapter 5: Altering and Destroying RDBMS Objects.Part III Data Manipulation and Transaction Control.
Chapter 6: Data Manipulation Language (DML).
Chapter 7: Sessions, Transactions, and Locks.Part IV Retrieving and Transferring Data.
Chapter 8: Understanding the SELECT Statement.
Chapter 9: Multitable Queries.
Chapter 10: SQL Functions.
Chapter 11: SQL Operators.Part V Implementing Security Using the System Catalog.
Chapter 12: SQL and RDBMS Security.
Chapter 13: The System Catalog and INFORMATION SCHEMA.Part VI Beyond SQL: Procedural Programming and Database Access Mechanisms.
Chapter 14: Stored Procedures, Triggers, and User-Defined Functions.
Chapter 15: SQL and XML.
Chapter 16: SQL and Procedural Programming.
Chapter 17: The Future of SQL.
Appendix A: Accompanying Website.
Appendix B: The ACME Sample Database.
Appendix C: Basics of Relational Database Design.
Appendix D: Installing RDBMS Software.
Appendix E: Accessing RDBMS.
Appendix F: Installing the ACME Database.
Appendix G: SQL Functions.
Appendix H: SQL Syntax Reference.
Appendix I: SQL-Reserved Keywords.
Appendix J: The Other RDBMSs.
Appendix K: A Brief Introduction to Number Systems, Boolean Algebra, and Set Theory.
Index.
Author Biography
Alex Kriegel, PMP, MCSD/MCTS, works as a Systems Architect for the State of Oregon; prior to this he worked for Pope and Talbot, Inc., Psion Teklogix International, Inc., and for Belorussian Academy of Sciences. He received his MSc. in Physics of Metals from Belarus State Polytechnic Institute in 1988, discovered PC programming and relational databases in 1992, and has never looked back since. Alex is certified as a Project Management Professional (PMP) by the Project Management Institute, and also holds various Microsoft certifications. He is also the author of Microsoft SQL Server 2000 Weekend Crash Course (Wiley, 2001), SQL Functions (Wrox, 2005), and co-author of Introduction to Database Management (Wiley, 2007), and the first edition of this book. Boris M. Trukhnov, OCP, has been working as Senior Technical Analyst/Oracle DBA for Pope & Talbot, Inc., in Portland, Oregon, since 1998. His previous job titles include Senior Programmer Analyst, Senior Software Developer, and Senior Operations Analyst. He has been working with SQL and relational databases since 1994. Boris holds a B.S. in Computer Science from the University of Minnesota. He is a co-author of Introduction to Database Management (Wiley, 2007).
new business trends internet business trends |
31 Articles:
|
| |
new business trends internet business marketing |
4 Articles:
|
|
new business trends internet business technology |
12 Articles:
|
| |
new business trends internet business entrepreneurs |
3 Articles:
|
| |
new business trends internet business features |
5 Articles:
|
| |
|
|
|
|
subscribe to our newsletters
|
Please click the button below if you would like to subscribe to our SME Newsletters, BizSmarts and BizOps New Business Opportunities.
|
|
|
