Category: Education

Feed: Microsoft Press blog. Author: Kim Spilker. In Skill 1.2 from Exam Ref 70-761 Querying Data with Transact-SQL, learn how to query multiple tables by using join statements based on provided tables, data, and requirements. Skill 1.2: Query multiple tables by using joins Often, data that you need to query is spread across multiple tables. The tables are usually related through keys, such as a foreign key in one side and a primary key in the other. Then you can use joins to query the data from the different tables and match the rows that need to be related. This ... Read More

Feed: SQL Server Customer Advisory Team. Author: Arvind Shyamsundar. Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Rajesh Setlem, Joe Sack, Dimitri Furman, Denzil Ribeiro (Microsoft) This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions. SQLCAT has been working with them in their process of adopting SQL Server 2017. During a recent lab engagement, we found a set of seemingly innocuous query (anti-)patterns which were actually having a significant impact on overall performance. In ... Read More

Feed: Kamran Agayev's Oracle Blog. Posted by Kamran Agayev A. on October 13th, 2017 Dear friends Hope most of you already got my book and started preparing for the OCM exam. Every month I get an email from my readers as well as from those who used my book and passed OCM exam successfully! If you haven’t subscribed to the OCM Newsletter and want to read the previous articles, use the following link:http://www.ocmguide.com/category/ocm-tips-and-tricks/ If you want to get free trial copy of the book in pdf format, use the following address:http://www.ocmguide.com/ If you also want to successfully pass the exam, ... Read More

Feed: Microsoft Press blog. Author: Kim Spilker. We’re pleased to announce that we have a new video available for purchase! Programming the Microsoft Bot Framework, with Microsoft MVP Joe Mayo, offers more than five hours of instruction. SPECIAL OFFER: Through October 31, 2017, save 50% on the purchase of this video when you pre-order the related ebook, Programming the Microsoft Bot Framework: A Multiplatform Approach to Building Chatbots, at the same time. Find details and discount code here. This video is also available on Safari. Reflecting the next radical revolution in human-computer interaction, this Programming the Microsoft Bot Framework video will help you leverage ... Read More

Feed: Microsoft Press blog. Author: Kim Spilker. In this sample chapter from MOS 2016 Study Guide for Microsoft Excel, learn about exam objectives related to presenting data in charts and enhancing worksheets through images, business diagrams, and text boxes. The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2016 relate to creating charts and objects. Specifically, the following objectives are associated with this set of skills: 5.1 Create charts 5.2 Format charts 5.3 Insert and format objects You can store a large amount of data in an Excel workbook. When you want to present ... Read More

Feed: O'Reilly Media, Inc. Upcoming Titles. Author: O'Reilly Media, Inc.. Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper ... Read More

Feed: O'Reilly Media, Inc. Upcoming Titles. Author: O'Reilly Media, Inc.. Get up and running quickly with the new Jumpstarting ebook series from Make:. The Arduino 101 is a low-power board that includes not only Bluetooth LE capabilities but an on-board 6-axis accelerometer/gyroscope for exciting real-world-connected projects ... Read More

Feed: O'Reilly Media, Inc. Upcoming Titles. Author: O'Reilly Media, Inc.. Classroom-tested by tens of thousands of students, this new edition of the bestselling intro to programming book is for anyone who wants to understand computer science. Learn about design, algorithms, testing, and debugging. Discover the fundamentals of programming with Python 3.6--a language that's used in millions of devices. Write programs to solve real-world problems, and come away with everything you need to produce quality code. This edition has been updated to use the new language features in Python 3.6.No programming experience required! Incremental examples show you the steps and missteps ... Read More

Feed: SQL Server Customer Advisory Team. Author: Kun Cheng (SQLCAT). Reviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajesh Setlem Most people familiar with Azure SQL DB (aka SQL Database) are aware of the firewall setting requirements of SQL DB, which are very important to lock down connections to SQL DB on Azure. Details are documented here. The firewall setting helps restrict inbound connections to clients with specific IP addresses. Note that this refers to the firewall on the Azure SQL DB side. But when the SQL client is running on-premises behind internet gateway/proxy server, the firewall of the gateway/proxy ... Read More

Feed: SQL Server Customer Advisory Team. Author: Denzil Ribeiro. SQL 2017 bits are generally available to customers today. One of the most notable milestones in the 2017 release is SQL Server on Linux. Setup has been relatively simple for SQL Server on Linux, but often there are questions around unattended install. For SQL Server on Linux, there are several capabilities that are useful in unattended install scenarios: You can specify environment variables prior to the install that are picked up by the install process, to enable customization of SQL Server settings such as TCP port, Data/Log directories, etc. You can ... Read More