Beginning SQL Joes 2 Pros

Beginning SQL Joes 2 Pros (English, Paperback, Morelan Rick A)

Share

Beginning SQL Joes 2 Pros  (English, Paperback, Morelan Rick A)

4.7
3 Ratings & 1 Reviews
₹793
899
11% off
i
Available offers
  • Bank Offer5% cashback on Flipkart Axis Bank Credit Card upto ₹4,000 per statement quarter
    T&C
  • Bank Offer5% cashback on Axis Bank Flipkart Debit Card up to ₹750
    T&C
  • Bank OfferFlat ₹10 Instant Cashback on Paytm UPI Trxns. Min Order Value ₹500. Valid once per Paytm account
    T&C
  • Delivery
    Check
    Enter pincode
      Delivery by7 Jul, Monday
      ?
      if ordered before 10:59 AM
    View Details
    Author
    Read More
    Highlights
    • Language: English
    • Binding: Paperback
    • Publisher: CreateSpace
    • Genre: Computers
    • ISBN: 9781439253175, 9781439253175
    • Pages: 254
    Services
    • Cash on Delivery available
      ?
    Seller
    SAMUDRAPVTLTD
    4
    • 7 Days Replacement Policy
      ?
  • See other sellers
  • Description

    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.

    Read More
    Specifications
    Book Details
    Imprint
    • CreateSpace
    Dimensions
    Width
    • 14 mm
    Height
    • 254 mm
    Length
    • 178 mm
    Weight
    • 449 gr
    Ratings & Reviews
    4.7
    3 Ratings &
    1 Reviews
    • 5
    • 4
    • 3
    • 2
    • 1
    • 2
    • 1
    • 0
    • 0
    • 0
    5

    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...
    READ MORE

    Vikas Ahlawat

    May, 2012

    1
    0
    Report Abuse
    Be the first to ask about this product
    Safe and Secure Payments.Easy returns.100% Authentic products.
    You might be interested in
    Medical And Nursing Books
    Min. 50% Off
    Shop Now
    Other Lifestyle Books
    Min. 50% Off
    Shop Now
    Language And Linguistic Books
    Min. 50% Off
    Shop Now
    General Fiction Books
    Min. 50% Off
    Shop Now
    Back to top