Apply powerful window functions in T-SQL—and increase the performance and speed of your queries Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.
Tips, tricks, and workarounds for effectively administering SQL Server
This comprehensive guide teaches you the skills needed to successfully administer SQL Server 2012. You'll learn how to handle the most difficult admin issues including change management, security, performance tuning, monitoring, and backups. And you'll also discover how to master the latest features of the 2012 release, including client connectivity enhancements, cloud computing, data replication, and business intelligence. This detailed instruction by leading experts will help you improve the efficiency, scalability, and performance of your SQL Server environment so you can do more in much less time.
Professional Microsoft SQL Server 2012 Administration:
Examines settings and configuration items that improve SQL Server performance
Shows how to implement strategies for effective indexing for your database
Takes you through the setup, configuration, and testing of a cluster
Outlines the options in SQL Server for backups and recoveries, and provides recommendations to make the most of these features
Covers what you need to know about how SharePoint® 2010 integrates with SQL Server
Introduces SQL Server Azure and gets you up and running on this exciting new cloud platform
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Курс охватывает следующие основные возможности SQL Server 2005 по разрешению проблем и оптимизации серверов баз данных:
Использование профайлера и системного монитора для контроля за производительностью баз данных и серверов Оптимизация выполнения запросов Применение SQLdiag Tool для анализа данных Применение Database Tuning Advisor для поиска проблем с выполнением запросов Использование постраничного восстановления данных для восстановления целостности данных Разрешение поблем с конкуренцией SQL Server
Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.
For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain. During such difficult periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly.
For as long as there has been something to communicate between two persons there has been data. Today, vast volumes of it are gathered about almost every individual and business. It is the information that we provide when we sign up for an account at our favorite website, fill out a job application, or apply for a mortgage.
Данный видеокурс познакомит слушателей с базовыми знаниями SQL, позволяющими разработчику писать запросы к одной или нескольким таблицам, модифицировать данные таблиц и создавать объекты базы данных. Основным инструментом разработки, используемым в курсе, является Oracle SQL Developer; в качестве дополнительного используется SQL Plus.
Учебное пособие подготовлено по материалам лекционных курсов, посвященных основам теории баз данных, языку SQL, хранимым процедурам и триггерам, которые читались автором в последние десять лет. В пособии также рассмотрены вопросы взаимодействия технологии баз данных с Web-технологиями.
