بسم الله الرحمن الرحيم
ملحوظة: يمكن نقل الموضوع
SQL: A Beginner’s Guide 3rd Edition
الناشر: McGraw-Hill Osborne
عدد الصفحات: 534 صفحة
حجم الملف: 3.80 MB
Essential Skills–Made Easy!
Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner’s Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g.
Designed for Easy Learning:
* Key Skills & Concepts–Lists of specific skills covered in the chapter
* Ask the Experts–Q&A sections filled with bonus information and helpful tips
* Try This–Hands-on exercises that show how to apply your skills
* Notes–Extra information related to the topic being covered
* Self-Tests–Chapter-ending quizzes to test your knowledge
* Annotated Syntax–Example code with commentary that describes the programming techniques being illustrated
SQL for Dummies, 5th Edition
الناشر: For Dummies
عدد الصفحات: 432 صفحة
حجم الملف: 5.9 MB
Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them.
Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities – the domain of database gurus who possess enlightenment beyond that of ordinary mortals. Well, SQL For Dummies, 5th Edition, sweeps away the database mystique.
Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. But you don’t have to be a database newbie to find value in SQL For Dummies, 5th Edition; even if you have some experience designing and creating databases, you may discover a few things you didn’t know about
عدد الصفحات: 831 صفحة
حجم الملف: 5.5 Mb
* Covers the latest version of the ISO SQL standard (SQL-99) and gives readers information they need to know about the differences in vendor-specific SQL implementations including Oracle, Microsoft SQL Server, and IBM DB2
* Knowledge of this ubiquitous database programming language is becoming more critical as IT departments move toward more integrated heterogeneous platforms
* Covers growing use of SQL with Web services and XML
* CD-ROM includes a complete sample database and trial versions of major relational database management software
SQL All-in-One Desk Reference For Dummies
الناشر: For Dummies
عدد الصفحات: 720 صفحة
حجم الملف: 7.8 Mb
SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.
Beginning SQL Queries: From Novice to Professional
عدد الصفحات: 528 صفحة
حجم الملف: 8.94 MB
* Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times
* Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix
* Paul Wilton is a successful Wrox “Beginning” book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product
* SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others
The Art of SQL
عدد الصفحات: 367 صفحة
حجم الملف: 1.63 MB
For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any “bad SQL” later.
In “The Art of SQL,” author and SQL expert Stephane Faroult argues that this “safe approach” only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.
“The Art of SQL” offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult’s approach takes a page from Sun Tzu’s classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can’t be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.
Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the numberof users doubles? What if you want to keep several years of data online? Faroult’s way of looking at SQL performance may be unconventional and unique, but he’s deadly serious about writing good SQL and using SQL well. “The Art of SQL” is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions.
Sams Teach Yourself SQL in 24 Hours, 3rd Edition
عدد الصفحات: 504 صفحة
حجم الملف: 2.17 MB
Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.
Programmer's Guide to SQL
عدد الصفحات: 400 صفحة
حجم الملف: 3.37 MB
The Programmer’s Guide to SQL provides an in-depth yet concise tutorial on the use of Structured Query Language (SQL). Once you’ve mastered the fundamentals, the book serves as a handy desktop reference on SQL usage, covering all of the major SQL statements that you’ll need when programming databases. It also comes complete with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access.
In each case, the book demonstrates how the SQL standard is implemented (and and often extended) by each database system vendor. Specific topics include:
* Querying, modifying, and summarizing data using SQL functions
* Using complex nested queries and joins
* Programming database stored procedures, triggers, and views
* Creating tables, indexes, and other database objects
* Writing transaction-safe SQL
* Implementing basic database security
The book also includes two complete case studies that show how to create and query the underlying database for a fully featured website, as well as how to implement role-based security in your applications. This book is ideal for any programmer, analyst, or database administrator in search of a SQL reference that also demonstrates how to use SQL to solve real business problems.
SQL Fundamentals (3rd Edition)
الناشر: Prentice Hall PTR
عدد الصفحات: 832 صفحة
حجم الملف: 5.8 MB
SQL for the Real World.
Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.
SQL Fundamentals,Third Edition, teaches you how to
*Build simple statements to retrieve, store, or modify data
*Craft complex queries that draw information from multiple tables
*Sort and summarize your data just the way you want it
*Create and edit your own tables
*Protect the integrity of your data
*Create more efficient, high-performance queries
*Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
*Use the Oracle Data Dictionary
Teach Yourself SQL in 21 Days, Second Edition
عدد الصفحات: 864 صفحة
حجم الملف: 1.87 MB
Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle’s database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker’s rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.
Professional SQL Server 2005 Programming
عدد الصفحات: 912 صفحة
حجم الملف: 17.7 Mb
Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server. The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the ?meat? of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples.
- قم بالضغط هنا
لمعرفة المزيد عن كيفية التحميل من موقع hotfile.com
- قم بالضغط هنا
لتنزيل المزيد من الكتب المتعلقة ب SQL
يوجد المزيد من المزيد من الكتب في مختلف مجالات الحاسب في المدونة التالية:
أو يمكن الوصول مباشرة للكتب المتعلقة باحد فروع الحاسب من خلال احد الاقسام التالية:
/ For Dummies
/ Harry Potter Novels
/ Microsoft Office Books
/ Photoshop CS2
/ Photoshop CS3
/ Photoshop CS4
/ Visual Basic .Net
/ Star Wars Audio Books
/ Star Wars Comics
/ Star Wars Novels
/ The New York Times Bestsellers Books
/ Windows 7
/ Windows Vista
/ Windows XP
أرجو الفائدة للجميع