Practical SQL
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. Create databases and related tables using your own data; Define the right data types for your information; Aggregate, sort, and filter data to find patterns; Use basic math and advanced statistical functions; Identify errors in data and cle ...
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. Create databases and related tables using your own data; Define the right data types for your information; Aggregate, sort, and filter data to find patterns; Use basic math and advanced statistical functions; Identify errors in data and cle ...
Exam Ref 70-761 Querying Data with Transact-SQL
Prepare for Microsoft Exam 70-761 - and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Filter, sort, join, aggregate, and modify data; Use subqueries, table expressions, grouping sets, and pivoting; Query temporal and non-relational data, and output XML or JSON; Create views, user-defined functions, and stored procedures; Implement error handling, transactions, data types, and nulls. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer; Includes downloadable sample database and code for SQL Serve ...
Prepare for Microsoft Exam 70-761 - and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Filter, sort, join, aggregate, and modify data; Use subqueries, table expressions, grouping sets, and pivoting; Query temporal and non-relational data, and output XML or JSON; Create views, user-defined functions, and stored procedures; Implement error handling, transactions, data types, and nulls. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer; Includes downloadable sample database and code for SQL Serve ...
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Microsoft Excel; Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies; Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis. ...
Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Microsoft Excel; Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies; Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis. ...
Python Data Science Handbook
For many researchers, Python is a first-class tool mainly because of its libraries for storing, manipulating, and gaining insight from data. Several resources exist for individual pieces of this data science stack, but only with the Python Data Science Handbook do you get them all - IPython, NumPy, Pandas, Matplotlib, Scikit-Learn, and other related tools. Working scientists and data crunchers familiar with reading and writing Python code will find this comprehensive desk reference ideal for tackling day-to-day issues: manipulating, transforming, and cleaning data; visualizing different types of data; and using data to build statistical or machine learning models. Quite simply, this is the must-have reference for scientific computing in Python. IPython and Jupyter: provide computational environments for data scientists using Python; NumPy: includes the ndarray for efficient storage and manipulation of dense data arrays in Python; Pandas: features the DataFrame for efficient stora ...
For many researchers, Python is a first-class tool mainly because of its libraries for storing, manipulating, and gaining insight from data. Several resources exist for individual pieces of this data science stack, but only with the Python Data Science Handbook do you get them all - IPython, NumPy, Pandas, Matplotlib, Scikit-Learn, and other related tools. Working scientists and data crunchers familiar with reading and writing Python code will find this comprehensive desk reference ideal for tackling day-to-day issues: manipulating, transforming, and cleaning data; visualizing different types of data; and using data to build statistical or machine learning models. Quite simply, this is the must-have reference for scientific computing in Python. IPython and Jupyter: provide computational environments for data scientists using Python; NumPy: includes the ndarray for efficient storage and manipulation of dense data arrays in Python; Pandas: features the DataFrame for efficient stora ...
Learning PHP, MySQL & JavaScript, 5th Edition
Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you'll tackle dynamic web programming with the latest versions of today's core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries. Web designers will learn how to use these technologies together and pick up valuable web programming practices along the way—including how to optimize websites for mobile devices. At the end of the book, you'll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers. Explore MySQL, from database structure to complex queries; Use the MySQLi extension, PHP's improved MySQL interface; Create dynamic PHP web pages that tailor themselves to the user; Manage cookies and sessions and maintain a high level of security; Enhance the JavaScript language with jQuery and j ...
Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you'll tackle dynamic web programming with the latest versions of today's core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries. Web designers will learn how to use these technologies together and pick up valuable web programming practices along the way—including how to optimize websites for mobile devices. At the end of the book, you'll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers. Explore MySQL, from database structure to complex queries; Use the MySQLi extension, PHP's improved MySQL interface; Create dynamic PHP web pages that tailor themselves to the user; Manage cookies and sessions and maintain a high level of security; Enhance the JavaScript language with jQuery and j ...
Exam Ref 70-740 Installation, Storage and Compute with Windows Server 2016
Prepare for Microsoft Exam 70-740 - and help demonstrate your real-world mastery of Windows Server 2016 installation, storage, and compute features and capabilities. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Install Windows Servers in host and compute environments; Implement storage solutions; Implement Hyper-V; Implement Windows containers; Implement high availability; Maintain and monitor server environments. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience working with Windows Server in an enterprise environment; are familiar with core networking infrastructure, topologies, architectures, and protocols; and have experience with Windows clients and virtualization. ...
Prepare for Microsoft Exam 70-740 - and help demonstrate your real-world mastery of Windows Server 2016 installation, storage, and compute features and capabilities. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Install Windows Servers in host and compute environments; Implement storage solutions; Implement Hyper-V; Implement Windows containers; Implement high availability; Maintain and monitor server environments. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience working with Windows Server in an enterprise environment; are familiar with core networking infrastructure, topologies, architectures, and protocols; and have experience with Windows clients and virtualization. ...
Exam Ref 70-741 Networking with Windows Server 2016
Microsoft Exam 70-741 is for IT Pros interested in enhancing their skills for the latest version of Windows Server. This exam validates skills and knowledge for configuring advanced tasks required to deploy, manage, and maintain a Windows Server 2016 infrastructure, such as fault tolerance, certificate services, and identity federation. Passing this exam along with two other exams is required for MCSA and MCSE certifications. The Exam Ref is the official study guide for Microsoft certification exam 70-741. Featuring concise, objective-by-objective reviews and strategic case scenarios and Thought Experiments, exam candidates get professional-level preparation for the exam. The Exam Ref helps candidates maximize their performance on the exam and sharpen their job-role skills. It organizes material by the exam's objective domains Focus is on the skills measured on the exam: Implement Domain Name System (DNS); Implement DHCP; Implement IP Address Management (IPAM); Implement network ...
Microsoft Exam 70-741 is for IT Pros interested in enhancing their skills for the latest version of Windows Server. This exam validates skills and knowledge for configuring advanced tasks required to deploy, manage, and maintain a Windows Server 2016 infrastructure, such as fault tolerance, certificate services, and identity federation. Passing this exam along with two other exams is required for MCSA and MCSE certifications. The Exam Ref is the official study guide for Microsoft certification exam 70-741. Featuring concise, objective-by-objective reviews and strategic case scenarios and Thought Experiments, exam candidates get professional-level preparation for the exam. The Exam Ref helps candidates maximize their performance on the exam and sharpen their job-role skills. It organizes material by the exam's objective domains Focus is on the skills measured on the exam: Implement Domain Name System (DNS); Implement DHCP; Implement IP Address Management (IPAM); Implement network ...
Exam Ref 70-742 Identity with Windows Server 2016
Prepare for Microsoft Exam 70-742 - and help demonstrate your real-world mastery of Windows Server 2016 identity features and functionality. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Install and configure Active Directory Domain Services (AD DS); Manage and maintain AD DS; Create and manage Group Policy; Implement Active Directory Certificate Services (AD CS); Implement identity federation and access solutions. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience working with Windows Server, Windows clients, and virtualization; are familiar with core networking technologies, and are aware of basic security best practices. ...
Prepare for Microsoft Exam 70-742 - and help demonstrate your real-world mastery of Windows Server 2016 identity features and functionality. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Install and configure Active Directory Domain Services (AD DS); Manage and maintain AD DS; Create and manage Group Policy; Implement Active Directory Certificate Services (AD CS); Implement identity federation and access solutions. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience working with Windows Server, Windows clients, and virtualization; are familiar with core networking technologies, and are aware of basic security best practices. ...
Adaptive Code, 2nd Edition
By applying this book's principles, you can create code that accommodates new requirements and unforeseen scenarios without significant rewrites. Gary McLean Hall describes Agile best practices, principles, and patterns for designing and writing code that can evolve more quickly and easily, with fewer errors, because it doesn't impede change. Now revised, updated, and expanded, Adaptive Code, Second Edition adds indispensable practical insights on Kanban, dependency inversion, and creating reusable abstractions. Drawing on over a decade of Agile consulting and development experience, McLean Hall has updated his best-seller with deeper coverage of unit testing, refactoring, pure dependency injection, and more. Master powerful new ways to: Write code that enables and complements Scrum, Kanban, or any other Agile framework; Develop code that can survive major changes in requirements; Plan for adaptability by using dependencies, layering, interfaces, and design patterns; Perform unit ...
By applying this book's principles, you can create code that accommodates new requirements and unforeseen scenarios without significant rewrites. Gary McLean Hall describes Agile best practices, principles, and patterns for designing and writing code that can evolve more quickly and easily, with fewer errors, because it doesn't impede change. Now revised, updated, and expanded, Adaptive Code, Second Edition adds indispensable practical insights on Kanban, dependency inversion, and creating reusable abstractions. Drawing on over a decade of Agile consulting and development experience, McLean Hall has updated his best-seller with deeper coverage of unit testing, refactoring, pure dependency injection, and more. Master powerful new ways to: Write code that enables and complements Scrum, Kanban, or any other Agile framework; Develop code that can survive major changes in requirements; Plan for adaptability by using dependencies, layering, interfaces, and design patterns; Perform unit ...
Raspberry Pi 3 Cookbook for Python Programmers, 3rd Edition
Raspberry Pi 3 Cookbook for Python Programmers, 3rd Edition begins by guiding you through setting up Raspberry Pi 3, performing tasks using Python 3.6, and introducing the first steps to interface with electronics. As you work through each chapter, you will build your skills and apply them as you progress. You will learn how to build text classifiers, predict sentiments in words, develop applications using the popular Tkinter library, and create games by controlling graphics on your screen. You will harness the power of a built in graphics processor using Pi3D to generate your own high-quality 3D graphics and environments. You will understand how to connect Raspberry Pi's hardware pins directly to control electronics, from switching on LEDs and responding to push buttons to driving motors and servos. Get to grips with monitoring sensors to gather real-life data, using it to control other devices, and viewing the results over the internet. You will apply what you have learned by crea ...
Raspberry Pi 3 Cookbook for Python Programmers, 3rd Edition begins by guiding you through setting up Raspberry Pi 3, performing tasks using Python 3.6, and introducing the first steps to interface with electronics. As you work through each chapter, you will build your skills and apply them as you progress. You will learn how to build text classifiers, predict sentiments in words, develop applications using the popular Tkinter library, and create games by controlling graphics on your screen. You will harness the power of a built in graphics processor using Pi3D to generate your own high-quality 3D graphics and environments. You will understand how to connect Raspberry Pi's hardware pins directly to control electronics, from switching on LEDs and responding to push buttons to driving motors and servos. Get to grips with monitoring sensors to gather real-life data, using it to control other devices, and viewing the results over the internet. You will apply what you have learned by crea ...