About the author:
Rob Frye served in the NC Army National Guard for nearly two decades and is a combat veteran of Operation Iraqi Freedom. After retiring from military service, he completed his Bachelor's degree in Computer Science at Lenoir-Rhyne University, where he was the first honor graduate with a 4.0 overall GPA. Currently, Rob is the manager of ComeritLabs, in Huntersville, NC. ComeritLabs provides infrastructure, remote development, and training services for COMERIT, Inc. Rob is an experienced SAP BusinessObjects and SAP HANA developer and has delivered training on SAP HANA and the BusinessObjects toolset in the United States, Canada, Mexico, and South Africa.
Joe Darlak, Senior Director of SAP Analytics at COMERIT Inc., has successfully implemented SAP BW at clients since 1998, including several large-scale, full lifecycle global rollouts. He has significant experience increasing the capacity, reliability, and performance of SAP BI systems, defining and implementing processes and controls to stabilize service and mitigate risk, and improving the competency and skill sets of implementation and client service teams. Recently, he architected one of the largest SAP NetWeaver BW migrations to SAP HANA on record and has been instrumental in defining best practices for SAP HANA at Fortune 100 clients. He is the lead author of SAP BW: Administration and Performance Optimization, published in 2014. Over the past decade, he presented at multiple conferences on various SAP BW performance tuning topics. He is a former principal consultant in the iAnalytics practice at PricewaterhouseCoopers and holds a Master of Business Administration degree from the McCombs School of Business at The University of Texas at Austin.
Dr. Bjarne Berg is the senior director of BI at COMERIT, Inc., and one of the most respected and dedicated thought leaders in the BI market. Prior to joining COMERIT, he was a senior manager at PwC's global data warehouse group, the director of BI at VIP Consulting, and the VP of BI at COMERIT. In these positions, he managed multi-year BI and data warehouse projects for various clients . He is an internationally recognized expert in BI and analytics, a published author in international BI journals, and a frequent speaker at major BI and SAP conferences worldwide.
SQLite is a small, embeddable, SQL-based, relational database management system. It has been widely used in low- to medium-tier database applications, especially in embedded devices. This book provides a comprehensive description of SQLite database system. It describes design principles, engineering trade-offs, implementation issues, and operations of SQLite.
Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips.
Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more.Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence Begins with fundamental design recommendations and progresses through increasingly complex scenarios Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more
Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.