Cart (0)
Digital Cart (0)

Add Another Item

Add Another Item

mvn

Add Another Item

Add Another Item

Compare
You can't compare with the above items. (Clear all items in the Compare list)

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide For Beginners (English)

(Paperback)
★★★★★ ★★★★★
3
Paperback
Author: Jessica Brown, Rick A. Morelan, Peter D. Kendall, Doug Fritz
Language: English
Length: 254 pages
Publisher: SQLAuthority
Rs. 481
Notify me when this product is in Stock:
:
Thank you, for your interest in Beginning SQL Joes 2 Pros: The SQL Hands-On Guide For Beginners (English) (Paperback). You will be Notified by Email when it becomes available.
Out of Stock!
This item is Out of Stock!

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide For Beginners (English) (Paperback) Price: Rs. 481

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide For Beginners is the first book in the five book series that focuses on the development of SQL and understanding how it is used to manage a database.

Summary Of The Book

SQL or Structured Query Language, is a programming language that has been designed to manage data pertaining to Relational DBMS. It is based on tuple relational calculus and relational algebra. The book intensively covers different topics related to Database Management, SQL queries, Relational Data, Data Definition Language, Data Manipulation Language, Bulk Copy Program, Stored Procedures, Transaction Control language and Data Control language.

The first chapter talks about Database management, the difference between Data and Information, how to create simple databases and Database Management Systems. The Second chapter deals with Basic Queries. It provides details on Query Syntax, Single Table Queries and Exact Matching. It also includes information on how to query about Special Characters, Pattern Matching and Querying ranges. It describes the basic structure of an SQL Query and Field Selection lists.

The third chapter Viewing Combined Information includes topics like Outer Joins-Left Outer Joins, Right Outer Joins and Full Outer Joins, and Filtering Multi-Table Queries. The chapter Query Strategies contains Table Aliasing, Cartesian Result Sets, Cross Joins, and Unmatched Records Queries. Another Chapter explains about How to Maintain tables: The Difference between Deleting and Dropping, How to alter Table Designs, Bulk Copy Program, Using BCP and, Importing and Exporting of data.

The penultimate chapter provides a useful insight into Data Control language. It provides an Introduction to Securities, Creation of SQL logins, Securables and Permissions, Dropping of SQL logins, Granting, Denying and Revoking of Permissions.
Beginning SQL Joes 2 Pros: The SQL Hands-On Guide For Beginners will help the reader gain more knowledge about SQL and learn more keywords as well as prepare the reader for the SQL certification test.

About The Authors

Rick A. Morelan began his career as a commercial fisherman and later went on to become an author, and a programmer. Another book by the author is SQL Backup and Recovery Joes 2 Pros . He is the creator of Joes2Pros series of books. He took computer classes at the Catapult Software Training Institute. He got his first breakthrough in the form of a job related to database management at Microsoft. He has worked for Microsoft for over 10 years has got about 30 technical certifications from Microsoft in areas like Networking, Applications, .NET Development and databases.

Doug Fritz is a researcher, programmer and author. Other books by him are SQL Architecture Basics Joes 2 Pros: Core Architecture Concepts and SQL Interpretability Joes 2 Pros: A Guide to Integrating SQL Server with SML, C# and Powershell. He works with Google as a creative programmer presently. He also has been a research assistant at the Massachusetts Institute Of Technology. At Yahoo he worked as a Creative Programmer and he did his internship at IBM.

Jessica Brown has also written SQL Architecture Basics Joes 2 Pros: Core Architecture Concepts, and SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008.

Another book by Peter D. Kendall is T SQL 2008 Joes 2 Pros: Core T SQl Coding Fundamentals for Microsoft SQL Server 2008.

Specifications of Beginning SQL Joes 2 Pros: The SQL Hands-On Guide For Beginners (English) (Paperback)

Book Details
Publisher SQLAuthority
ISBN-10 143925317X
Number of Pages 254 Pages
Publication Year 2009
Language English
ISBN-13 9781439253175
Binding Paperback
Dimensions
Weight 449 g
Height 0.54 inch
Width 7.00 inch
Contributors
Author Jessica Brown, Rick A. Morelan, Peter D. Kendall, Doug Fritz

Please Note: All products sold on Flipkart are brand new and 100% genuine

Reviews of Beginning SQL Joes 2 Pros: The SQL Hands-On Guide For Beginners (English) (Paperback)

4.7

Average Rating

Based on 3  ratings

Have you used this product?

Rate it now.

Write a Review

Recent top reviews

View all
★★★★★
★★★★★

Vikas Ahlawat

May 13, 2012

First to review

Thnx for providing such great collection of books.... Highly recommended

Thnx for providing such great collection of books........
Great books collections sir! Topics are explained very nicely..
Every topic containing Screen shots. And great apology in the starting of every chapter is one of the best thing of these book.
I am not adverting here. honestly.. …
(View complete review)

Top reviews

View all top reviews (1)

'Top Reviews' lists the most relevant product reviews only. Show ALL instead?

★★★★★
★★★★★

Vikas Ahlawat

May 13, 2012

First to review

Thnx for providing such great collection of books.... Highly recommended

Thnx for providing such great collection of books........
Great books collections sir! Topics are explained very nicely..
Every topic containing Screen shots. And great apology in the starting of every chapter is one of the best thing of these book.
I am not adverting here. honestly..
must buy..
Thanx Sir (Rick A Morelan & Pinal Dave)for providing such great books collections to sql community...
 

PAYMENT METHOD

POWERED BY

Hear ye, Shoppers! October 6th it is! Wherever you are, with whomsoever you are, pause for a minute and mark your calendar for the Big Billion Day, for the very first time ever on your favourite shopping site, Flipkart.
You must have seen the teasers by now and must be dying of curiosity and excitement. People from all walks of life, all over the country are gearing up for the biggest and craziest sale ever, so it is high time that you join in this extravaganza. With Diwali fast approaching, Flipkart has made shopping for your loved ones a lot easier, with the 6th October Big Billion Day. Let finance take a back seat as we prioritise sentiments over everything else.
To make the most of this awesome day, you need to follow a few quick and easy steps. First off, keep your Flipkart profile up-to-date to be a step ahead. Choose your favourites from a plethora of products and add them to your Wishlist as soon as possible. This will notify you from time-to-time about the various offers applicable on the chosen products.
Considering your busy schedule, we bring the convenience of Flipkart App to your mobiles! Wherever you are, just download this app from various stores like Google Play, App Store and Windows Store and you are all set to shop. With the help of this app, ready yourself for smart, quick and happy shopping.
With Flipkart, you can shop freely from within the comforts of your home or from anywhere else. Shopping on Flipkart is fun, easy and hassle-free. With convenient payment options such as cash on delivery, net banking and credit or debit card, you can be rest assured about the transactions. Flipkart also offers easy return and replacement policies, so that you can have a satisfying shopping experience. Share the joy and spread the love!

Loading ...
x