Author : Alex Kriegel
Publisher : Wiley
Page : 414 pages
File Size : 16,71 MB
Release : 2001-10-15
Category : Computers
ISBN : 9780764548406
Microsoft SQL Server 2000 Weekend Crash Course includes 30 sessions on the key aspects of Microsoft SQL Server 2000. Each session is designed to take 30 minutes to complete, so the Crash Course is an intense 15-hour learning period. You can complete the Crash Course over a weekend -- but you can also easily adapt the Crash Course sessions to whatever schedule best suits your needs.
Author : Ben Forta
Publisher : Addison-Wesley Professional
Page : 635 pages
File Size : 40,7 MB
Release : 2023-11-02
Category : Computers
ISBN : 0138223165
MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. This book will teach you all you need to know to be immediately productive with the latest version of MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn How To Retrieve and Sort Data Filter Data Using Comparisons, Regular Expressions, Full Text Search, and Much More Join Relational Data Create and Alter Tables Insert, Update, and Delete Data Leverage the Power of Stored Procedures and Triggers Use Views and Cursors Manage Transactional Processing Create User Accounts and Manage Security via Access Control
Author : Allen G. Taylor
Publisher : Wiley
Page : 0 pages
File Size : 39,29 MB
Release : 2002-01-15
Category : Computers
ISBN : 9780764549014
Learn SQL fast! With SQL Weekend Crash Course, you can get up to speed on how to use SQL -- the standard international database language -- in a single weekend! This book consists of 30 sessions that teach the core concepts of ANSI SQL over a weekend (from Friday evening through Sunday afternoon). Naturally, you can adapt your learning to whatever schedule meets your needs. Coverage focuses on the following databases: Access, Oracle9i, SQL Server 2000, MySQL, and PostgreSQL. You'll pick up valuable skills such as: * Retrieving data * Adding, updating and deleting data * Using SQL within an application * Building database tables with SQL * Protecting the contents of a database * Dynamic SQL
Author : Ben Forta
Publisher : Addison-Wesley Professional
Page : 371 pages
File Size : 17,92 MB
Release : 2011-08-29
Category : Computers
ISBN : 0132842351
MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, and full text search Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and cursors Manage transactional processing Create user accounts and manage security via access control
Author : Steven M. Schafer
Publisher : John Wiley & Sons
Page : 478 pages
File Size : 12,13 MB
Release : 2003-11-24
Category : Computers
ISBN : 0764557351
Get up to speed on Apache, MySQL, and PHP - in a weekend! The big day is Monday. The day you get to show off what you know about Apache Web server, MySQL database, and PHP scripting. The problem is, you're not really up to speed. Maybe it's been a while since you installed all three of these technologies. Perhaps you've never used Apache, MySQL, and PHP together. Or maybe you just like a challenge. In any event, we've got a solution for you - Apache, MySQL, and PHP Weekend Crash Course. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to dive right in and begin building dynamic, data-driven sites on either Windows or Linux with all three integrated technologies. The Curriculum Friday Evening: 4 Sessions, 2 Hours * Installing Apache * Installing PHP * Installing MySQL * Apache Basics Saturday Morning: 6 Sessions, 3 Hours * Configuring Apache * Apache Security Concerns * The Basics of MySQL * MySQL Security * Working with Data * Queries Afternoon: 6 Sessions, 3 Hours * Troubleshooting MySQL Commands and Queries * Advanced MySQL Concepts * PHP Basics * Program Flow * PHP Functions Saturday, cont. Evening: 4 Sessions, 2 Hours * Working with Files * HTML Constructs * Working with Forms * Multiple-User Considerations in PHP Sunday Morning: 6 Sessions, 3 Hours * Good Coding Practices * Debugging and Troubleshooting PHP * MySQL Through PHP * Debugging and Troubleshooting MySQL in PHP * Odds and Ends * Project: Calendar I Afternoon: 4 Sessions, 2 Hours * Project: Calendar II * Project: Content Publishing I * Project: Content Publishing II * Project: Building an RSS Feed
Author : Bob Ward
Publisher : Apress
Page : 435 pages
File Size : 46,12 MB
Release : 2019-10-18
Category : Computers
ISBN : 1484254198
Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine learning (ML), big data analytics, Linux, containers, Kubernetes, Java, and data virtualization to Azure. This is not a book on traditional database administration for SQL Server. It focuses on all that is new for one of the most successful modernized data platforms in the industry. It is a book for data professionals who already know the fundamentals of SQL Server and want to up their game by building their skills in some of the hottest new areas in technology. SQL Server 2019 Revealed begins with a look at the project's team goal to integrate the world of big data with SQL Server into a major product release. The book then dives into the details of key new capabilities in SQL Server 2019 using a “learn by example” approach for Intelligent Performance, security, mission-critical availability, and features for the modern developer. Also covered are enhancements to SQL Server 2019 for Linux and gain a comprehensive look at SQL Server using containers and Kubernetes clusters. The book concludes by showing you how to virtualize your data access with Polybase to Oracle, MongoDB, Hadoop, and Azure, allowing you to reduce the need for expensive extract, transform, and load (ETL) applications. You will then learn how to take your knowledge of containers, Kubernetes, and Polybase to build a comprehensive solution called Big Data Clusters, which is a marquee feature of 2019. You will also learn how to gain access to Spark, SQL Server, and HDFS to build intelligence over your own data lake and deploy end-to-end machine learning applications. What You Will LearnImplement Big Data Clusters with SQL Server, Spark, and HDFS Create a Data Hub with connections to Oracle, Azure, Hadoop, and other sourcesCombine SQL and Spark to build a machine learning platform for AI applicationsBoost your performance with no application changes using Intelligent PerformanceIncrease security of your SQL Server through Secure Enclaves and Data ClassificationMaximize database uptime through online indexing and Accelerated Database RecoveryBuild new modern applications with Graph, ML Services, and T-SQL Extensibility with JavaImprove your ability to deploy SQL Server on Linux Gain in-depth knowledge to run SQL Server with containers and KubernetesKnow all the new database engine features for performance, usability, and diagnosticsUse the latest tools and methods to migrate your database to SQL Server 2019Apply your knowledge of SQL Server 2019 to Azure Who This Book Is For IT professionals and developers who understand the fundamentals of SQL Server and wish to focus on learning about the new, modern capabilities of SQL Server 2019. The book is for those who want to learn about SQL Server 2019 and the new Big Data Clusters and AI feature set, support for machine learning and Java, how to run SQL Server with containers and Kubernetes, and increased capabilities around Intelligent Performance, advanced security, and high availability.
Author : John L. Viescas
Publisher : Pearson Education
Page : 792 pages
File Size : 28,50 MB
Release : 2014
Category : Computers
ISBN : 0321992474
The #1 Easy, Common-Sense Guide to SQL Queries--Updated for Today's Databases, Standards, and Challenges SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You'll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think "outside the box" using unlinked tables. Coverage includes -- Getting started: understanding what relational databases are, and ensuring that your database structures are sound -- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE -- Summarizing and grouping data with GROUP BY and HAVING clauses -- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries -- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more Practice all you want with downloadable sample databases for today's versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you're a DBA, developer, user, or student, there's no better way to master SQL. informit.com/aw forMereMortals.com
Author : Alex Kriegel
Publisher : John Wiley & Sons
Page : 508 pages
File Size : 33,76 MB
Release : 2011-03-31
Category : Computers
ISBN : 1118092775
Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL. Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.
Author : Don Jones
Publisher : Wiley
Page : 304 pages
File Size : 14,19 MB
Release : 2002-12-01
Category : Computers
ISBN : 9780764549250
Focus: Book consists of 30 sessions that teach the core concepts of Windows .NET Server to Windows Administrators over a weekend. Covers the new features of the Windows .NET Server, including headless servers, Remote Desktop Services (RDS), and performance management. Learn how to implement Windows .NET Server as the base OS for the Microsoft .NET Framework and.NET Enterprise Servers, including SQL Server 2000 and Exchange 2000 Server. Covers Windows .NET Server's improvements to networking, Active Directory, usability, reliability, scalability, disaster recovery, management, and Internet integration as well as Windows basics and architecture; installing the Windows .NET Server; and managing server security. Running example: A running example of a fictitious major international bank is used to demonstrate key concepts. Windows interface tutorial on CD: For readers with no prior Windows experience at all, a Windows interface tutorial will be included as an appendix on the CD that accompanies the book. WCC series features: Each session takes 30 minutes to complete. Four time-to-go icons gauge the reader's progress through any given session. "Quiz Yourself" questions (at the end of each session) and "Part Review" questions allow the reader to review what they have just learned. Skill assessment software on the CD-ROM helps readers gauge their skill level before and after reading this book. ABOUT THE CD-ROM The CD-ROM has skills assessment software based on the sessions in the book and an appendix on the Windows interface.
Author : Don Jones
Publisher : Simon and Schuster
Page : 390 pages
File Size : 31,7 MB
Release : 2014-04-30
Category : Computers
ISBN : 1638353166
Summary Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performance monitoring. In about an hour a day over a month, you'll learn exactly what you can do, and what you shouldn't touch. Most importantly, you'll learn the day-to-day tasks and techniques you need to keep SQL Server humming along smoothly. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Book Microsoft SQL Server is used by millions of businesses, ranging in size from Fortune 500s to small shops worldwide. Whether you're just getting started as a DBA, supporting a SQL Server-driven application, or you've been drafted by your office as the SQL Server admin, you do not need a thousand-page book to get up and running. Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server. This concise, easy-to-read book skips academic introductions and teaches you day-to-day techniques for maintenance, backup and recovery, performance monitoring, and more. Each of the 21 short lessons gives you practical takeaways you'll use over and over. What's Inside Master the basics—indexes, logins, backup, recovery ... and more Learn what you can and cannot do when supporting a third-party application Monitor and improve performance Written by expert trainer and bestselling author Don Jones Accessible to readers of any level of experience, the book covers techniques for all versions of SQLServer 2005-2014. About the Author Don Jones is a Microsoft MVP, speaker, and trainer. He is the creator of the Month of Lunches series and author of over 50 books on PowerShell, IIS, Active Directory, SCCM, SQL Server, and more. Table of Contents Before you begin Server assessment and configuration T-SQL crash course Managing databases Backup and recovery Authentication: who are you? Authorization: what are you allowed to do? Accounting: what did you do? Analyzing indexes Maintaining indexes Tuning index designs Reading query execution plans Block and deadlock analysis Automating management with SQL Server Agent Multiserver management Windows PowerShell and SQL Server Using Extended Events Monitoring and analyzing performance Options for high availability Virtualizing SQL Server Moving, migrating, and upgrading databases SQL Server performance checklist Never the end
