Part 5 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you. This course will teach you to track and report data more efficiently by walking you through the database design process, teaching you how to build tables and forms to enter data, and how to design queries and reports to retrieve and view data. No experience with Access or database design is necessary; however, experience with Microsoft Office applications and data entry is helpful.
In this single video, Rob Sullivan is tasked with perf-tuning an ASP.NET MVC 3 web application (using EF) so it can handle a StackOverflow data dump. Over 4 million rows of data in the Posts table alone! The application is one that any web developer might build - with holes in it that any developer might fall into. The site is timing out, we're down - we need some help from an amazing DBA!
SQL Server databases have a wide variety of configuration options and this demo-centric course shows the options available when creating a database, and how to modify a databases's configuration after it has been created, including adding and removing files and filegroups. This course is perfect for developers, DBAs, and anyone responsible for creating and configuring SQL Server databases, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward.
If you want or need to understand Oracle Database 12c, then you've come to the right place. In this course, we have three purposes. We want to (1) Get you up to speed with how Oracle Database works in general from the perspective of the database administrator (DBA); (2) Acquaint you with the new features and enhancements included in the latest 12c release of Oracle Database; and (3) Prepare you to pass the Oracle Certified Administrator (OCA) certification exam. To get the most benefit from this course, you should already have a basic understanding of relational database management systems, the relational model, and using SQL to query databases.
In this course we first look at what’s required to install Oracle under Windows and Linux. We then launch into an installation. We also cover the upgrade path. For instance, we learn what’s required to upgrade an Oracle 10g/11g database to 12c, and how we can verify successful upgrade.
This Oracle Database 12c Disaster Recovery and Data Movement course accomplishes two goals. Number one, you'll learn how to ensure that your Oracle-stored data is always safe, secure, and able to be recovered in the event of a media failure. Number two, you'll move closer to your goal of becoming an Oracle Certified Database Administrator because this course is closely tracked to the exam objectives.
It seems that most Oracle Database administrators enjoy twiddling and tweaking their production Oracle databases/instances to make them run as efficiently as possible. This course will teach you how to perform maintenance and manage performance. In addition, this course overlaps heavily with the OCP exam objectives.
Part 2 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality. In this course you'll learn, T-SQL, .NET/CLR development, data partitioning, and advanced query techniques. If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you'll benefit from this in-depth course.
Part 1 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality. In this course you'll learn, T-SQL, .NET/CLR development, data partitioning, and advanced query techniques. If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you'll benefit from this in-depth course.
Database corruption happens all the time, all over the world. When it happens in your environment, do you know what to do? Will you realize you have corruption? Written and presented by the person who wrote SQL Server's consistency checking and repair tools, this course will show you what you need to know to detect and recover from most cases of database corruption. The course starts by explaining why timely corruption detection is so important, and then investigates the various causes of database corruption. You'll learn how to configure SQL Server to automatically detect when I/O errors occur, what consistency checks are, the DBCC commands to use to perform consistency checks, and how to configure SQL Server to perform consistency checks regularly. The course then moves on to interpreting the output from consistency checks so you'll know when you have corruption in your environment, plus whether and how the corruption limits your recovery options or not. Finally, the course ends with modules that describe and demonstrate how to recover from corruption using simple restore techniques and simple repair techniques. Packed with a wealth of information and practical, easy-to-follow demonstrations, this course will prepare you to detect and recover from database corruption when it happens to you. The course is applicable for all SQL Server versions from SQL Server 2005 onward, and for anyone responsible for SQL Server databases with any level of experience.
In many organizations, the .Net developer is also tasked with the coding and creation of the database to hold their application data. Often they need to take over projects for which no database code can be found. Then once they've created code, they have to track changes manually in order to provide the DBA with change scripts. All the while thinking, "there's got to be a better way!" Fear not .Net Developer, it's Data Dude to the rescue! Originally code named "Data Dude", Visual Studio Database Projects havef gone through several name changes since it's inception with VS 2005. In Visual Studio 2010 it became another project type, a Database Project. In this series you will learn how to harness the power of the Database Project to create a new database, or reverse engineer the code for an existing database. You will learn how to refactor, and let Visual Studio keep track of the changes, to let it automatically generate change and deployment scripts. Finally, you'll learn how to take advantage of Visual Studio's powerful data generation capabilities to create realistic test data.
In this course, you will learn all the skills required to design good databases. This starts with information gathering: how to find all required information, and how to ask questions without miscommunications. You will learn how to abstract the information gathered into a data model, how to normalize the data model so that your database will be free of anomalies, and how to transform the final, normalized data model into a relational database design - ready to be implemented.
In this course you will learn about the fundamentals of Oracle PL/SQL programming language. You will gain a solid understanding of Pl/SQL datatypes and programming constructs like loops, conditional execution, cursors and exception handling, which will enable you to do effective debugging.
Common table expressions are a useful and versatile T-SQL query construct and this demo-centric course shows how to correctly define and use CTEs, what restrictions there are for using them, and some common usage scenarios. This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward.
It is hard to imagine searching for something on the Web without modern search engines like Bing or Google. However, most contemporary applications still limit users to exact searches only. For end users, even the standard SQL LIKE operator is not powerful enough for approximate searches. In addition, many documents are stored in modern databases; end users would probably like to get powerful search inside document contents as well. Text mining is also becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understand the meaning of documents. Finally, the Term Extraction and Term Lookup components from SQL Server Integration Services also helps with text analysis.
A detailed exploration of MySQL Workbench, a unified visual tool for data modeling, SQL development, and comprehensive administration tools for MySQL. This course will guide you through maximizing the power of MySQL Workbench and getting productive quickly with MySQL.
In this production we sit down with Brad Wilson as he uses Test-driven Development, C# 4.0, and xUnit to create the core of a subscription billing system - just like the one we have here at Tekpub. In fact - we used those exact requirements! Halfway through the episode, we throw a curveball at Brad - changing up the requirements to see how much of a drag TDD can have on the change process.
In this production, Oren Eini walks Rob through the various aspects of RavenDB - from the basics through to advanced Administrative Tasks. Along the way you'll learn how to query with the core Lucene engine, how to index your documents for searches, backups, sharding, replication to SQL Server, and how to plug all of this in to an ASP.NET MVC application.
In this production, a SQL Server DBA (Rob Sullivan) and a developer (Rob Conery) take a deep dive into PostGreSQL (v9.1). This series was originally about Mono and ASP.NET MVC - but "the Robs" quickly found themselves amazed and surprised by just how capable, intelligent and fast PostGreSQL is. The goal of this production is to introduce people to PostGres who aren't familiar with the system.
Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.
Proper database maintenance is critical for making sure that database workloads perform as well as possible. One of the simplest ways to implement database maintenance is to use the built-in Maintenance Plan functionality to schedule the critical database maintenance tasks - backups, consistency checking, statistics maintenance and index maintenance. The course starts by explaining how to configure Database Mail, and Operator, and alerts, all within SQL Server Agent. It then describes all the commonly-required maintenance tasks and shows how to configure them, along with do's and don'ts, plus some of the less commonly used tasks. After that it shows how to pull these tasks together into Maintenance Plans using the Maintenance Plan Wizard, the Maintenance Plan Designer, and through Integration Services packages. Finally the course discusses some of the alternative methods of implementing database maintenance through freely-available scripts. This course is perfect for anyone who is responsible for SQL Server databases, with any level of experience, from SQL Server 2005 onward.
Database corruption happens all the time, all over the world, and sometimes it's not so simple to deal with. The SQL Server: Detecting and Correcting Database Corruption course showed you what you need to know to detect and recover from most cases of database corruption and this course will take you to the next level of knowledge and capabilities. The course starts by explaining in depth how DBCC CHECKDB processes databases and how you can tune the performance of DBCC CHECKDB to make it run as fast as possible. You'll then learn about some undocumented DBCC commands, such as DBCC PAGE and DBCC WRITEPAGE, which can be invaluable when investigating and repairing corruption. The course then moves on to dealing with transaction log corruption, such as using EMERGENCY mode and how to re-attach damaged databases, and more advanced restore techniques, including how to analyze the transaction log to find the point to restore to and how to perform a tail-of-the-log backup using a different SQL Server instance. Finally, the course ends with advanced repair techniques, including how to deal with corrupt metadata by manually editing system tables, how to salvage data from backups and nonclustered indexes, and the ultimate in advanced recovery techniques: manually editing a database using DBCC WRITEPAGE. Packed with a wealth of information and practical, easy-to-follow demonstrations, this course will prepare you for dealing with out-of-the-ordinary corruption problems. The course is applicable to all SQL Server versions from SQL Server 2005 onward, and for more experienced SQL Server professionals.
This course covers an introduction to the academic concepts behind distributed databases, with some examples using Riak as the example database. The course moves past the academic into a full breadth coverage of the operations and development practices and approaches, including a short tour through distributed database patterns and where to start, along with full coverage of clients and other tooling for use with distributed databases.
This course is about how your database’s physical design either takes advantage of or is hindered by the way that the SQL Server platform works; knowing this can give you better long-term scalability, availability, and performance. Choosing the right data types when you're designing your columns, tables, and indexes is really critical. Using the wrong data type can cause more space to be required, affecting data density in memory, database and backup size, transaction log efficiency, and more. It's even more important when you're choosing your clustering keys, as the wrong choice there can cause nonclustered index sizes to balloon dramatically. It can even affect the performance of queries, when incompatible data types are used in comparisons and cause very costly operations to take place. This course will show you how to make the right choices and avoid all of these problems. It starts by explaining the various data structures that are used to store columns and rows, and how they can be affected by data type choice. Then it shows how data type choice factors into clustered and nonclustered index key choice. Finally it describes the implicit conversion and probe residual problems that can occur from mismatched data types used in queries. Packed with a wealth of information and practical, easy-to-follow demonstrations, this course will show you how to make the RIGHT choices to make sure you avoid all these common problems. The course is applicable for all SQL Server versions from SQL Server 2005 onward, and for SQL Server developers and anyone responsible for designing and creating SQL Server tables and indexes, with any level of experience.
This is a practical course for someone new to relational databases that moves you through basic concepts right into real-world usage, demonstrating core tasks in Microsoft SQL Server itself. You'll not only gain new knowledge, but cement that knowledge by seeing it in action and being able to follow along at home.
Part 3 of 3 in the SQL Server 2008 Advanced Database Administration series will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.
Part 2 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.
Part 1 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.