Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.
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.
Crafted for hands-on learning and tested in classrooms worldwide, this book illuminates in-depth every Oracle SQL technique you’ll need. From the simplest query fundamentals to regular expressions and with newly added coverage of Oracle’s powerful new SQL Developer tool, you will focus on the tasks that matter most. Hundreds of step-by-step, guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you’ll acquire a powerful arsenal of useful skills–and an extraordinary library of solutions for your real-world challenges with Oracle SQL.
100% focused on Oracle SQL for Oracle 11g, today’s #1 database platform–not “generic” SQL! Master all core SQL techniques including every type of join such as equijoins, self joins, and outer joins Understand Oracle functions in depth, especially character, number, date, timestamp, interval, conversion, aggregate, regular expressions, analytical, and more Practice all types of subqueries, such as correlated and scalar subqueries, and learn about set operators and hierarchical queries Build effective queries and learn fundamental Oracle SQL Developer and SQL*Plus skills Make the most of the Data Dictionary and create tables, views, indexes, and sequences Secure databases using Oracle privileges, roles, and synonyms Explore Oracle 11g’s advanced data warehousing features Learn many practical tips about performance optimization, security, and architectural solutions Avoid common pitfalls and understand and solve common mistakes For every database developer, administrator, designer, or architect, regardless of experience!
If you have an aptitude for mathematics and some programming skills, author Joel Grus will help you get comfortable with the math and statistics at the core of data science, and with hacking skills you need to get started as a data scientist. Today’s messy glut of data holds answers to questions no one’s even thought to ask. This book provides you with the know-how to dig those answers out.Get a crash course in PythonLearn the basics of linear algebra, statistics, and probability—and understand how and when they're used in data scienceCollect, explore, clean, munge, and manipulate dataDive into the fundamentals of machine learningImplement models such as k-nearest Neighbors, Naive Bayes, linear and logistic regression, decision trees, neural networks, and clusteringExplore recommender systems, natural language processing, network analysis, MapReduce, and databases
In Prosperity in the Age of Decline, Brian and AlanBeaulieu—the CEO and President of the Institute for TrendResearch® (ITR)—offer an informed,meticulously-researched look at the future and the coming GreatDepression. Drawing on ITR's 94.7% forecast accuracy rate, the bookoutlines specific, actionable strategies for capitalizing oncyclical opportunities and dodging economic danger. In thisimportant resource, the authors reveal what it will take forindividual investors and business leaders to prosper as the economyheats up prior to the predicted downturn, preserve wealth in theupcoming Great Depression, and profit on the way out of thedepression. The imbalances and maladjustments have a while to playout and the authors pinpoint the investment opportunities to be hadin the countdown period.
The Beaulieu's examine the major economic trends at play, suchas low interest rates, burgeoning government debt, and an agingpopulation. They discuss which trends will last and what investorsshould do with this knowledge in order to thrive. The book alsoreviews the group of leading economic indicators that mostconsistently achieve reliable results for predicting where theeconomy is headed. Designed as a useful tool for investors, thebook includes a working list of key trends, describes the upsidepotential of each trend, and explains the potential threat stemmingfrom a particular trend. Understanding how to capitalize on thesetrends and knowing how to avoid the common pitfalls are the keys tocreating a solid economic future for individual investors andbusiness leaders.Contains the strategies for capitalizing on cyclicalopportunities and avoiding economic dangersOffers an examination of major economic trendsIncludes information on the leading economic indicators thatmost reliably achieve resultsShows how to preserve wealth and avoid the most commoninvesting pitfalls
This comprehensive resource offers guidelines for avertingcyclical downturns and building on rising industry trends.