• Querying Microsoft SQL Server 2012

    Querying Microsoft SQL Server 2012

    Querying Microsoft SQL Server 2012
    Audio: aac, 44100 Hz, stereo | Video: h264, yuv420p, 1280x720, 29.97 fps
    5h 35m | Beginner Mar 31, 2014 | Exercise Files | 858 MB

    Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft's proprietary extension for SQL), and improving query performance.
    Continue Reading
  • Pluralsight - Indexing, Querying and Analyzing Text with SQL Server 2012-2014 (2014)

    Pluralsight - Indexing, Querying and Analyzing Text with SQL Server 2012-2014 (2014)

    Pluralsight - Indexing, Querying and Analyzing Text with SQL Server 2012-2014 (2014)
    MP4 | AVC 325kbps | English | 1024x768 | 15fps | 2h 48mins | AAC stereo 125kbps | 565 MB
    Genre: Video Training

    It is hard to imagine searching for something on the Web without modern search engines like Bing or Google. However, most contemporary applications still limit users to exact searches only. For end users, even the standard SQL LIKE operator is not powerful enough for approximate searches. In addition, many documents are stored in modern databases; end users would probably like to get powerful search inside document contents as well. Text mining is also becoming more and more popular.
    Continue Reading
  • Querying Moving Objects Detected by Sensor Networks

    Querying Moving Objects Detected by Sensor Networks

    Markus Bestehorn, "Querying Moving Objects Detected by Sensor Networks"
    2013 | ISBN-10: 146144926X | 80 pages | PDF | 3,2 MB
    Continue Reading
  • Best Internet Links

    45 Anonymous 12.02.2014
  • TrainSignal - SQL Server 2012 Querying (70-461)



    TrainSignal - SQL Server 2012 Querying (70-461)
    English | wmv | WMV3 800x600 | WMA 1 ch 48 kbps | 8 hrs 55 min | 403 MB
    eLearning, Video training

    This course is designed to teach students how to query and work with a SQL Server 2012 database. Skills gained will include querying a database using joins and data aggregations and query optimization. This course includes basic management of database objects and using XML SQL Server.
    Continue Reading
  • VTC.com - Querying Microsoft SQL Server 2012 Exam 70-461 Course DVD-iNKiSO



    VTC.com - Querying Microsoft SQL Server 2012 Exam 70-461 Course DVD-iNKiSO
    Released: 13/01/13 | Author: Mark Long | Duration: 8.5 hrs / 110 tutorials | Size: 1.16 GB
    Genre(s): Training | Tutorial

    The 2012 Microsoft MCSA Certification track includes Exam 70-461 Querying Microsoft SQL Server 2012. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill.
    Continue Reading
  • Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012



    Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 by Itzik Ben-Gan, Dejan Sarka and Ron Talmage
    752 pages | English | 2012 | ISBN: 0735666059 | PDF, EPUB + CD content | 56 MB

    Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.
    Continue Reading
  • Writing and Querying MapReduce Views in CouchDB



    O'Reilly (3-2011) | PDF | 76 pages | 1449303129 | 1.5Mb

    Writing and Querying MapReduce Views in CouchDB /by Bradley Holt. If you want to use CouchDB to support real-world applications, you'll need to create MapReduce views that let you query this document-oriented database for meaningful data. With this short and concise ebook, you'll learn how to create a variety of MapReduce views to help you query and aggregate data in CouchDB’s large, distributed datasets.
    Continue Reading
  • Inside Microsoft® SQL Server™ 2005 T-SQL Querying (Solid Quality Learning) ( CHM version )


    Inside Microsoft® SQL Server™ 2005 T-SQL Querying (Solid Quality Learning)
    640 pages | Microsoft Press 1st Edition (March 29, 2006) | ISBN-10 : 0735623139 | CHM | 8.18 Mb


    This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL
    Continue Reading
  • Inside Microsoft SQL Server 2008 T-SQL Querying


    Microsoft Press (3-2009) | PDF | 832 pages | 0735626030 | 3.70Mb

    Inside Microsoft SQL Server 2008 T-SQL Querying /by Itzik Ben-Gan (Author), Lubor Kollar(Author), Dejan Sarka(Author), Steve Kass (Author) .Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance.
    Continue Reading
  • AppDev SQL Server 2008 Installing Querying Security DVD


    AppDev SQL Server 2008 Installing Querying Security DVD | 1.2 GB

    In this course, you'll learn about the components that make up the comprehensive SQL Server 2008 product and the various editions that Microsoft makes available, so that you can select the right one. You'll learn about installation and upgrade issues, about some of the many configuration choices available to customize it to your needs and environment, as well as how to tweak it after installation. Then you'll learn how to work with database objects and data, using Management Studio and other tools, as well as Transact SQL (T-SQL), the programming language of SQL server. You'll learn about the features in T-SQL for querying, inserting, updating, and deleting data, as well as the rich support in T-SQL for various data-based operations. The course finishes up with a comprehensive look at security, both to help you secure your server and data from unauthorized use as well as to avoid security hurdles as you administer and develop applications that use the server and its data.
    Continue Reading