Martin Guidry

Being able to perform a database backup—and recover data when something goes wrong—is a key skill any database administrator should have. In this focused course, author Martin Guidry covers the key topics necessary to master backup and recovery of a SQL Server 2014 database. Learn about the different types of backups— full, differential, and transaction log backups—and how to use the command line or the GUI tool, Management Studio, to back up and restore SQL Server. Martin also shows how to… Show more

Being able to perform a database backup—and recover data when something goes wrong—is a key skill any database administrator should have. In this focused course, author Martin Guidry covers the key topics necessary to master backup and recovery of a SQL Server 2014 database. Learn about the different types of backups— full, differential, and transaction log backups—and how to use the command line or the GUI tool, Management Studio, to back up and restore SQL Server. Martin also shows how to back up SQL Server to the cloud and automate backups with maintenance plans Show less

Learn everything you need to know to start building databases with SQL Server. Martin Guidry reviews the major features of SQL Server 2014 and shows developers how to architect efficient, high-performance solutions for organizations of any scale. Watch and learn how to install and configure SQL Server, create databases and tables, automate common tasks like backups, and use the SQL query language to retrieve and manipulate data.

Learn how to design databases, secure databases, and keep them in tip-top shape, with SQL Server 2012. Join Martin Guidry in this course, as he reviews each step in the process: from designing the infrastructure, a logical schema, and execution plan for the physical hardware, to using indexes to fine-tune performance and implementing policy-based management. He explains best practices for database design, shows where developers can bend the rules, and introduces techniques to manage your… Show more

Learn how to design databases, secure databases, and keep them in tip-top shape, with SQL Server 2012. Join Martin Guidry in this course, as he reviews each step in the process: from designing the infrastructure, a logical schema, and execution plan for the physical hardware, to using indexes to fine-tune performance and implementing policy-based management. He explains best practices for database design, shows where developers can bend the rules, and introduces techniques to manage your database throughout its lifecycle with PowerShell and other monitoring tools. Show less

Learn how to set up a network at your home or office. In this course, Martin Guidry discusses the hardware you'll need—from switches to modems—and the specifics behind using both wired (Ethernet) and wireless (Wi-Fi) methods to connect the computers and equipment in your network. Then he shows how to share files between computers and briefly discusses email and print servers, explaining how to manage connections to those services with DHCP and DNS addressing. Martin also reviews issues you… Show more

Learn how to set up a network at your home or office. In this course, Martin Guidry discusses the hardware you'll need—from switches to modems—and the specifics behind using both wired (Ethernet) and wireless (Wi-Fi) methods to connect the computers and equipment in your network. Then he shows how to share files between computers and briefly discusses email and print servers, explaining how to manage connections to those services with DHCP and DNS addressing. Martin also reviews issues you might encounter when working in a mixed (Windows/Mac/Linux) environment, and provides tips on setting up an Internet connection, as well as configuring security and local-storage options for your network. Show less

Virtualization is a vastly important topic to IT managers. It allows one computer to run multiple operating systems, leading to a more efficient use of hardware resources. In this course Martin Guidry explores the crucial concepts behind today's virtualization tech, its pros and cons, common uses, and hardware requirements. He dedicates two chapters to Microsoft Hyper-V and VMware Workstation, two of the most popular hypervisors, and then shows how to prep your existing infrastructure to… Show more

Virtualization is a vastly important topic to IT managers. It allows one computer to run multiple operating systems, leading to a more efficient use of hardware resources. In this course Martin Guidry explores the crucial concepts behind today's virtualization tech, its pros and cons, common uses, and hardware requirements. He dedicates two chapters to Microsoft Hyper-V and VMware Workstation, two of the most popular hypervisors, and then shows how to prep your existing infrastructure to accommodate virtualization. Before you leave, make sure to watch the tutorials on troubleshooting and backing up your virtual machines, so you can fix problems and recover your work in case of a system failure. Show less

Learn how to design and implement an enterprise data warehouse. Microsoft Certified Trainer Martin Guidry shows how to design fact and dimension tables using both the star and snowflake techniques, use data quality services to cleanse data, and implement an ETL process with SQL Server integration services.

SQL Server 2012 is the first cloud-ready information platform for Microsoft. In this course, author Martin Guidry explores its new possibilities, showing you how to protect, unlock, and scale the power of your data, and work with a variety of devices and data sources. The course also provides an overview on obtaining, installing, and running SQL Server 2012 and will be of immense interest to anyone considering upgrading or installing this latest edition.

This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database.