06 - Save User Creation To SQL Database PS Script - Build Web Apps Using Powershell and PHP

Опубликовано: 26 Июнь 2021
на канале: the Sysadmin Channel

1,181

In our 6th video we're going to create a function to save user creation to SQL database. In our last video we created the new-usercreation which generates a username and email address from their first and last name.

Here we're going to save the info that was generated into our SQL database for processing. We want to send it to the database so it acts as a logging system as well as batch the creations at once. This is a great tutorial for beginner and intermediate Powershell and SQL users. We'll use the invoke-sql cmd to input data into a database as well as pull and confirm data that we've already written.

Series Playlist:
• 01 - Configure PHP and IIS on Windows Serv...

00:00 - Intro
00:30 - Start developing Powershell Script
00:49 - Create a function from scratch
01:15 - Powershell advanced function overview
02:47 - Create Powershell structure
03:16 - Starting the process block
04:14 - Writing 'insert into' SQL statement
07:40 - Validating data was inserted into the SQL database
09:05 - Testing script within Powershell

На этой странице сайта вы можете посмотреть видео онлайн 06 - Save User Creation To SQL Database PS Script - Build Web Apps Using Powershell and PHP длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь the Sysadmin Channel 26 Июнь 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 1,181 раз и оно понравилось 7 зрителям. Приятного просмотра!

3,223

127