Catalog Search Results
Author
Pub. Date
2016.
Language
English
Description
New to databases? Get an overview of the Office 365 version of Access, including building tables, defining relationships, and creating queries and reports.
Spreadsheets can only go so far. Databases are the next best step for complex data sets. Access 2016, Microsoft's powerful database software included with Office 365, is the perfect introduction for those new to relational databases. This course provides an overview for first-time users. Adam...
Author
Pub. Date
2020.
Language
English
Description
Learn how to use SQL Server database triggers to automate routine tasks and facilitate a more consistent, reliable, and predictable system.
SQL Server database triggers help database developers automate routine tasks. Triggers wait for an activating event to occur, then immediately respond with preprogrammed operations. This course, from database expert Adam Wilbert, takes a deep dive into leveraging these powerful and flexible components of a SQL...
Author
Pub. Date
2020.
Language
English
Description
Learn the basics of building databases in a platform agnostic way so you can continue on to other platforms later. Explore database setup, servers, GUIs, tables, objects, and more.
What is a database? How can you build one? Do you want to learn more? In this course, database expert Adam Wilbert shows you how to set up container-based servers, connect a management GUI, and start building a database for your valuable data. You don’t need to come...
Author
Pub. Date
2023.
Language
English
Description
Learn how to set up and work with one of the world’s most popular open-source database platforms, PostgreSQL.
PostgreSQL is trusted with mission critical information by some of the biggest companies in the world. It’s also highly flexible, which makes it a great choice for data science researchers, educators, nonprofit organizations, and businesses of all sizes. In this course, Adam Wilbert, who has spent the last decade helping people take their...
Author
Pub. Date
2018.
Language
English
Description
Wrangle your data by leveraging the power of Microsoft Access 2019. Learn how to use Access to build databases that help you store and retrieve your data more efficiently.
Learn how to wrangle your data and gain deeper insights by leveraging the power of Microsoft Access 2019. In this course, Access expert Adam Wilbert shows how to use Access to build databases that help you store and retrieve your data more efficiently. Adam begins by going over...
Author
Pub. Date
2020.
Language
English
Description
Learn how to execute R code directly on SQL Server with Machine Learning Services.
SQL Server now includes support for direct execution of R code. This integration allows complex data science analyses to be performed quickly in a secure environment, without having to export data sets first. In this course, database expert Adam Wilbert walks through the steps of enabling the required components—including Machine Learning Services for R—and writing...
Author
Pub. Date
2016.
Language
English
Description
Learn how to develop a SQL Server 2016 database with more advanced features, like temporary tables, stored procedures, indexes, and secure user accounts.
SQL Server is Microsoft's de facto relational database software. While you can build a simple database relatively easily straight out of the box, most administrators need to know how to take advantage of more advanced features in the latest release, SQL Server 2016, to give their clients everything...
Author
Pub. Date
2019.
Language
English
Description
Modeling phenomena with a relational database is an invaluable skill in today’s big-data world. This course covers the fundamentals of the relational model for creating databases.
In today’s big-data world, understanding how to model phenomena with a relational database is an invaluable skill. A variety of different users—from government agency employees to gamers—rely on relational databases for everyday operations. In this course, join...
Author
Pub. Date
2022.
Language
English
Description
Learn how to use Microsoft Access to build desktop databases.
Learn how to build Access databases to store and retrieve your data more efficiently. In this course, Access expert Adam Wilbert explains the concepts behind relational databases, before moving on to building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. Adam also shows how to apply rules and...
Author
Pub. Date
2018.
Language
English
Description
Learn how to design better databases using Access 2019. Pick up tips and techniques that can help you transform a boring database into a fast, efficient, and even fun environment.
Create a better experience for your Access users. This course covers tips and techniques that can help Access developers transform a boring database into a fast, efficient, and even fun environment. Access expert Adam Wilbert shows how to remove typical Access interface...
Author
Pub. Date
2017.
Language
English
Description
Learn how to administer SQL Server 2016, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.
SQL Server comes with many features for monitoring, securing, optimizing, and supporting your database infrastructure. Learn how to use these features to administer your SQL Server instances, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam. Adam...
Author
Pub. Date
2019.
Language
English
Description
Learn about the new and improved features in SQL Server 2019, including support for big data clusters and machine learning services.
SQL Server 2019 offers a number of performance enhancements and new features, including support for big data clusters and machine learning services. In this course, Adam Wilbert helps you get up to speed with the latest and greatest in the powerful relational database management system. Learn about database engine enhancements,...
Author
Pub. Date
2022.
Language
English
Description
Learn how to use Azure Data Studio to connect to a variety of server platforms, execute queries, and work with data.
Azure Data Studio is a cross-platform database management front end that allows users to connect to a variety of server platforms, execute queries, and work with data. This course, from database expert Adam Wilbert, covers how to use the program efficiently to manage database servers, write queries, create notebooks, use extensions,...
Author
Pub. Date
2022.
Language
English
Description
Create a better user experience for your Access users. Transform a boring database into a fast, efficient, and even fun environment.
This course provides tips and techniques to help Access developers create a better user experience and transform it into a fast, efficient, and even fun environment. Access expert Adam Wilbert shows how to remove typical Access interface elements (like the Welcome screen) for a better startup experience and borrow some...
Author
Pub. Date
2018.
Language
English
Description
Harness the power of databases using Microsoft Access. Learn how to build tables, define relationships, create queries, and more, using the Office 365 version of the program.
Learn how to build Access databases to store and retrieve your data more efficiently. Access expert Adam Wilbert explains the concepts behind relational databases, before moving onto building tables—the foundation of any database. He then demonstrates how to define the relationships...
Author
Pub. Date
2017.
Language
English
Description
Learn how databases work and how you can start designing one of your own.
Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course can help you overcome these hurdles. Adam Wilbert covers the basics of relational...
Author
Pub. Date
2018.
Language
English
Description
Get started with SQL Server 2017. Explore the most important features of SQL Server, and learn how the server operates, how to create tables and manipulate data, and more.
Microsoft SQL Server can be an intimidating system. In this course, instructor Adam Wilbert provides a quick overview of how SQL Server works—which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. Adam goes over the most...
Author
Pub. Date
2022.
Language
English
Description
Learn how to craft better queries—the key to finding raw data and transforming it into something usable—in Access 2021.
Learn how to find and translate complex raw data into information you can use to make better decisions. Access expert Adam Wilbert explains how to create real-world queries to filter and sort data and perform calculations, as well as refine query results with built-in functions, all while offering challenges that help you master...
Author
Pub. Date
2019.
Language
English
Description
Master the fundamentals of SQL Server 2019. Learn how to create new databases, tables, and queries; manage query performance; create and restore a backup of a database; and more.
Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. In this course, instructor Adam Wilbert equips beginners with the core skills they need to create and manage SQL Server databases. Adam begins with the basics, showing...
Author
Pub. Date
2021.
Language
English
Description
Learn the skills to help you pass the first two components of the Microsoft DP-300 certification exam.
Passing the Microsoft DP-300 certification exam allows job seekers to demonstrate proficiency with next-gen, cloud-based database technologies, and in this Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep series of courses, Adam Wilbert takes you through the key aspects of the exam that you need to know. This first course...
Didn't find it?
Can't find what you are looking for? Try our Purchase Suggestion Service. Submit Request