Using Databases with Windows PowerShell

  • Author: Andrew Smith
  • Level: Advanced
  • Study time: approx. 4 hours
Write your awesome label here.

ZAR 1099

Includes South African VAT
Price per individual
Please note that the rate conversion is real-time, but may not be exactly what is billed due to exchange fluctuations.
Course overview
This course consists of 5 modules encompassing the following:

  • Using a SQLite Database for simple local data storage
  • Using a MySQL Database for data storage
  • Using MariaDB Database for data storage
  • Using Microsoft SQL Server for data storage
  • Using MongoDB and the NOSQL format for data storage
  • Video time: 1 hour 40 minutes
  • Graded Practical
  • Course Starts: 
  • Live session: 

What You Can Learn


What's included?

  • 5 Module, 1 hour 40 minutes video tutorial
  • 30 minute Zoom collaboration session
  • Graded Practical for Certification
  • Community Membership for Q&A

What will you gain from this online Course with Training?

Learn how to:
  • Improve cybersecurity by recording filtered results from audit logs and uncover issues before they become problems
  • Keep track of automated processes by storing results in a single location
  • Perform trend analysis by tracking vital information over time
  • Reduce time and effort for repeat data calculations as data can be retrieved infinite times
  • Improve automation by joining multi-step processes that require a reliable data source to operate

Databases this course supports with connections and simple commands:

  • SQLite
  • MySQL
  • MariaDB
  • Microsoft SQL
  • MongoDB

Why should you take this Course?

Winning in IT means automation that reduces time and complexity. Databases are the backbone of business information systems. They can serve technologists by working with meaningful data in the same beneficial ways.

Tools

Sessions will be delivered via Zoom. There is no Zoom subscription cost for the participants, it is free to use with us.

Minimum requirements

  • PowerShell Foundation Certificate or equivalent PowerShell expertise
  • A PC with Windows 10.
  • PowerShell Command Prompt and PowerShell ISE.
  • A reliable Internet connection that can handle video and audio.
  • A working knowledge of Windows workstations, servers, and applications.
  • Fluent in the English language. All instruction, content, peer sharing, and the exam are in English.

Andrew Smith

IT Managed Services Professional, Serial Entrepreneur, Powershell Guru 
About Andrew
Andrew is an co-owner and Director of Applxbridge and an investor in JamAngle. He successfully exited his first tech company in 2016 having co-founded it in 2003. He has executed PowerShell developments on a wide variety of projects since 2007, which he still does to present day.
Created with