SQL in a Nutshell, 4th Edition
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts-all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards; Fundamental concepts necessary for understanding relational databases and SQL commands; An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard; The implementation of each comma ...
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts-all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards; Fundamental concepts necessary for understanding relational databases and SQL commands; An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard; The implementation of each comma ...
Up and Running with DAX for Power BI
Take a concise approach to learning how DAX, the function language of Power BI and PowerPivot, works. This book focuses on explaining the core concepts of DAX so that ordinary folks can gain the skills required to tackle complex data analysis problems. But make no mistake, this is in no way an introductory book on DAX. A number of the topics you will learn, such as the concepts of context transition and table expansion, are considered advanced and challenging areas of DAX. While there are numerous resources on DAX, most are written with developers in mind, making learning DAX appear an overwhelming challenge, especially for those who are coming from an Excel background or with limited coding experience. The reality is, to hit the ground running with DAX, it's not necessary to wade through copious pages on rarified DAX functions and the technical aspects of the language. There are just a few mandatory concepts that must be fully understood before DAX can be mastered. Knowledge of eve ...
Take a concise approach to learning how DAX, the function language of Power BI and PowerPivot, works. This book focuses on explaining the core concepts of DAX so that ordinary folks can gain the skills required to tackle complex data analysis problems. But make no mistake, this is in no way an introductory book on DAX. A number of the topics you will learn, such as the concepts of context transition and table expansion, are considered advanced and challenging areas of DAX. While there are numerous resources on DAX, most are written with developers in mind, making learning DAX appear an overwhelming challenge, especially for those who are coming from an Excel background or with limited coding experience. The reality is, to hit the ground running with DAX, it's not necessary to wade through copious pages on rarified DAX functions and the technical aspects of the language. There are just a few mandatory concepts that must be fully understood before DAX can be mastered. Knowledge of eve ...
A Complete Guide to Docker for Operations and Development
Harness the power of Docker by containerizing your code with all its libraries and file systems to consistently run anywhere. This book is your source for learning all about Docker operations and development. It's divided into two units and focuses on the topics that the Docker Certified Associate exam covers. Unit 1 covers the Docker fundamentals, such as Docker Enterprise for Operations, Docker Enterprise for Developers, Swarm, and an introduction to Kubernetes. You will learn how to install Docker Community Edition, Docker Enterprise Edition with Kubernetes and CLI. Also, you will learn the Docker cycle, container lifecycle, develop applications in any language, wrap, build, ship, and deploy them for production. Finally, you will learn how to create a Swarm cluster, deploy an app to it, and manage it with the best practices according to the current technologies. Unit 2 provides quizzes to help you prepare for the certification test. The DCA exam format and the question style h ...
Harness the power of Docker by containerizing your code with all its libraries and file systems to consistently run anywhere. This book is your source for learning all about Docker operations and development. It's divided into two units and focuses on the topics that the Docker Certified Associate exam covers. Unit 1 covers the Docker fundamentals, such as Docker Enterprise for Operations, Docker Enterprise for Developers, Swarm, and an introduction to Kubernetes. You will learn how to install Docker Community Edition, Docker Enterprise Edition with Kubernetes and CLI. Also, you will learn the Docker cycle, container lifecycle, develop applications in any language, wrap, build, ship, and deploy them for production. Finally, you will learn how to create a Swarm cluster, deploy an app to it, and manage it with the best practices according to the current technologies. Unit 2 provides quizzes to help you prepare for the certification test. The DCA exam format and the question style h ...
The Conversion Code, 2nd Edition
In this revision, The Conversion Code: A Step-by-Step Guide to Marketing and Sales that Will Grow Your Business Faster, 2nd Edition, digital marketing and lead conversion expert Chris Smith delivers the ultimate exploration of the marketing and advertising tactics that are successfully generating higher quality leads that are easier for salespeople to convert. Smith researches and tests the latest and most popular platforms, including TikTok, YouTube and Instagram, while also studying the most effective sales techniques, tools, and scripts. In this book, you'll learn to: Increase your lead conversion rate, reduce your cost per lead and improve your overall ROI from marketing and sales; Generate an endless supply of high-quality leads from social media that are easy to convert into closed sales; Stop chasing leads and start attracting clients with amazing marketing and clever ads; Adapt to the consumer privacy changes that have made targeting ads and getting leads to answer the phone ...
In this revision, The Conversion Code: A Step-by-Step Guide to Marketing and Sales that Will Grow Your Business Faster, 2nd Edition, digital marketing and lead conversion expert Chris Smith delivers the ultimate exploration of the marketing and advertising tactics that are successfully generating higher quality leads that are easier for salespeople to convert. Smith researches and tests the latest and most popular platforms, including TikTok, YouTube and Instagram, while also studying the most effective sales techniques, tools, and scripts. In this book, you'll learn to: Increase your lead conversion rate, reduce your cost per lead and improve your overall ROI from marketing and sales; Generate an endless supply of high-quality leads from social media that are easy to convert into closed sales; Stop chasing leads and start attracting clients with amazing marketing and clever ads; Adapt to the consumer privacy changes that have made targeting ads and getting leads to answer the phone ...
The Professional Agile Leader
To leverage the immense opportunities associated with accelerating change, organizations need teams capable of trying new ideas quickly, learning from their experiences, and adapting based on that learning. Helping these teams to grow and thrive requires agile leaders who support, inspire, and encourage, and who can leave behind the management skills of directing, monitoring, and rewarding or punishing. The Professional Agile Leader is a realistic, practical guide, written by experienced agile leaders who share their collective experiences in helping agile leaders to grow responsive and adaptive teams. They structure powerful lessons around a case study based on decades of experience helping agile leaders achieve and sustain agile transformation. Best of all, they never settle for high-level hand-waving-they show you how it's really done. Reignite once-successful organizations that have lost their way; Form cross-functional teams and empower them with purpose; Learn to let go, as ...
To leverage the immense opportunities associated with accelerating change, organizations need teams capable of trying new ideas quickly, learning from their experiences, and adapting based on that learning. Helping these teams to grow and thrive requires agile leaders who support, inspire, and encourage, and who can leave behind the management skills of directing, monitoring, and rewarding or punishing. The Professional Agile Leader is a realistic, practical guide, written by experienced agile leaders who share their collective experiences in helping agile leaders to grow responsive and adaptive teams. They structure powerful lessons around a case study based on decades of experience helping agile leaders achieve and sustain agile transformation. Best of all, they never settle for high-level hand-waving-they show you how it's really done. Reignite once-successful organizations that have lost their way; Form cross-functional teams and empower them with purpose; Learn to let go, as ...
A Network Architect's Guide to 5G
As 5G transforms mobile usage and services, network professionals will need to significantly evolve their transport network architectures towards greater sophistication and stronger integration with radio networks, and facilitate transition towards cloud-native 5G mobile core. Until now, however, most 5G guides have foregrounded RF/radio and mobile core innovations, not its implications for data networks. A Network Architects Guide to 5G fills the gap, giving network architects, designers, and engineers essential knowledge for designing and planning their own 5G networks. Drawing on decades of experience with global service providers and enterprise networks, the authors illuminate new and evolving network technologies necessary for building 5G-capable networks, such as segment routing, network slicing, timing and synchronization, edge computing, distributed data centers, integration with public cloud, and more. They explain how 5G blurs boundaries between mobile core, radio access, ...
As 5G transforms mobile usage and services, network professionals will need to significantly evolve their transport network architectures towards greater sophistication and stronger integration with radio networks, and facilitate transition towards cloud-native 5G mobile core. Until now, however, most 5G guides have foregrounded RF/radio and mobile core innovations, not its implications for data networks. A Network Architects Guide to 5G fills the gap, giving network architects, designers, and engineers essential knowledge for designing and planning their own 5G networks. Drawing on decades of experience with global service providers and enterprise networks, the authors illuminate new and evolving network technologies necessary for building 5G-capable networks, such as segment routing, network slicing, timing and synchronization, edge computing, distributed data centers, integration with public cloud, and more. They explain how 5G blurs boundaries between mobile core, radio access, ...
Rust Web Development with Rocket
Looking for a fast, powerful, and intuitive framework to build web applications? This Rust book will help you kickstart your web development journey and take your Rust programming skills to the next level as you uncover the power of Rocket - a fast, flexible, and fun framework powered by Rust. Rust Web Development with Rocket wastes no time in getting you up to speed with what Rust is and how to use it. You'll discover what makes it so productive and reliable, eventually mastering all of the concepts you need to play with the Rocket framework while developing a wide set of web development skills. Throughout this book, you'll be able to walk through a hands-on project, covering everything that goes into making advanced web applications, and get to grips with the ins and outs of Rocket development, including error handling, Rust vectors, and wrappers. You'll also learn how to use synchronous and asynchronous programming to improve application performance and make processing user conte ...
Looking for a fast, powerful, and intuitive framework to build web applications? This Rust book will help you kickstart your web development journey and take your Rust programming skills to the next level as you uncover the power of Rocket - a fast, flexible, and fun framework powered by Rust. Rust Web Development with Rocket wastes no time in getting you up to speed with what Rust is and how to use it. You'll discover what makes it so productive and reliable, eventually mastering all of the concepts you need to play with the Rocket framework while developing a wide set of web development skills. Throughout this book, you'll be able to walk through a hands-on project, covering everything that goes into making advanced web applications, and get to grips with the ins and outs of Rocket development, including error handling, Rust vectors, and wrappers. You'll also learn how to use synchronous and asynchronous programming to improve application performance and make processing user conte ...
Solidity Programming Essentials, 2nd Edition
Solidity is a high-level language for writing smart contracts, and the syntax has large similarities with JavaScript, thereby making it easier for developers to learn, design, compile, and deploy smart contracts on large blockchain ecosystems including Ethereum and Polygon among others. This book guides you in understanding Solidity programming from scratch. The book starts with step-by-step instructions for the installation of multiple tools and private blockchain, along with foundational concepts such as variables, data types, and programming constructs. You'll then explore contracts based on an object-oriented paradigm, including the usage of constructors, interfaces, libraries, and abstract contracts. The following chapters help you get to grips with testing and debugging smart contracts. As you advance, you'll learn about advanced concepts like assembly programming, advanced interfaces, usage of recovery, and error handling using try-catch blocks. You'll also explore multiple d ...
Solidity is a high-level language for writing smart contracts, and the syntax has large similarities with JavaScript, thereby making it easier for developers to learn, design, compile, and deploy smart contracts on large blockchain ecosystems including Ethereum and Polygon among others. This book guides you in understanding Solidity programming from scratch. The book starts with step-by-step instructions for the installation of multiple tools and private blockchain, along with foundational concepts such as variables, data types, and programming constructs. You'll then explore contracts based on an object-oriented paradigm, including the usage of constructors, interfaces, libraries, and abstract contracts. The following chapters help you get to grips with testing and debugging smart contracts. As you advance, you'll learn about advanced concepts like assembly programming, advanced interfaces, usage of recovery, and error handling using try-catch blocks. You'll also explore multiple d ...
Django 4 for the Impatient
Learning Django can be a tricky and time-consuming activity. There are hundreds of tutorials, loads of documentation, and many explanations that are hard to digest. However, this book enables you to use and learn Django in just a couple of days. In this book, you'll go on a fun, hands-on, and pragmatic journey to learn Django full stack development. You'll start building your first Django app within minutes. You'll be provided with short explanations and a practical approach that cover some of the most important Django features, such as Django Apps' structure, URLs, views, templates, models, CSS inclusion, image storage, authentication and authorization, Django admin panel, and many more. You'll also use Django to develop a movies review app and deploy it to the internet. By the end of this book, you'll be able to build and deploy your own Django web applications. ...
Learning Django can be a tricky and time-consuming activity. There are hundreds of tutorials, loads of documentation, and many explanations that are hard to digest. However, this book enables you to use and learn Django in just a couple of days. In this book, you'll go on a fun, hands-on, and pragmatic journey to learn Django full stack development. You'll start building your first Django app within minutes. You'll be provided with short explanations and a practical approach that cover some of the most important Django features, such as Django Apps' structure, URLs, views, templates, models, CSS inclusion, image storage, authentication and authorization, Django admin panel, and many more. You'll also use Django to develop a movies review app and deploy it to the internet. By the end of this book, you'll be able to build and deploy your own Django web applications. ...
JavaScript from Frontend to Backend
JavaScript, the most widely used programming language in the world, has numerous libraries and modules and a dizzying array of need-to-know topics. Picking a starting point can be difficult. Enter JavaScript from Frontend to Backend. This concise, practical guide will get you up to speed in next to no time. This book begins with the basics of variables and objects in JavaScript and then moves quickly on to building components on the client-side with Vue.js and a simple list management application. After that, the focus shifts to the server-side and Node.js, where you'll examine the MVC model and explore the Express module. Once you've got to grips with the server-side and the client-side, the only thing that remains is the database. You'll discover MongoDB and the Mongoose module. In the final chapter of this fast-paced guide, you'll combine all these pieces to integrate a Vue.js application into a Node.js server, using Express to structure the server code and MongoDB to store the i ...
JavaScript, the most widely used programming language in the world, has numerous libraries and modules and a dizzying array of need-to-know topics. Picking a starting point can be difficult. Enter JavaScript from Frontend to Backend. This concise, practical guide will get you up to speed in next to no time. This book begins with the basics of variables and objects in JavaScript and then moves quickly on to building components on the client-side with Vue.js and a simple list management application. After that, the focus shifts to the server-side and Node.js, where you'll examine the MVC model and explore the Express module. Once you've got to grips with the server-side and the client-side, the only thing that remains is the database. You'll discover MongoDB and the Mongoose module. In the final chapter of this fast-paced guide, you'll combine all these pieces to integrate a Vue.js application into a Node.js server, using Express to structure the server code and MongoDB to store the i ...