Title SN video coding and web development. PowerShell Core for SQL server / Springer

Published London, England : Springer Nature, 2020

Click on the following:
Academic Video Online

Copies

Description 1 online resource (93 minutes) Summary Get up and running with accessing SQL Server from PowerShell Core. By the end of this video you'll have learned how to issue Transact-SQL statements and get results back, how to insert, modify, and delete data in the database, and how to import and export data to and from SQL Server. You'll be equipped to automate database administration and other maintenance tasks through using PowerShell to automate the execution of Transact-SQL scripts that are stored in files that you can easily edit to keep up with changing business needs. The video begins by showing where to download PowerShell Core, along with the Visual Studio Code environment that is commonly used as a development platform. Next you'll learn how to install the module that enables communication between PowerShell and SQL Server. Then the fun begins as you learn how to execute Transact-SQL statements and get results back. A common use case for PowerShell with SQL Server is the importing and exporting of data, and the course concludes with examples showing how to perform imports and exports to and from common file formats, including CSV, JSON, and XML. Also covered is the execution of Transact-SQL scripts stored in text files that you can easily edit, making it easy to keep abreast of changing automation needs. This video is for those familiar with PowerShell who want to use PowerShell as the basis for automating SQL Server maintenance tasks. The video applies to the Windows, Linux, and the macOS platforms Notes Title from resource description page (viewed March 4, 2021) In English SUBJECT SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. fast (OCoLC)fst01376937 Subject Database management. SQL (Computer program language) Windows PowerShell (Computer program language) Client/server computing. Client/server computing. Database management. SQL (Computer program language) Windows PowerShell (Computer program language) Genre/Form Instructional films. Instructional films. Films de formation. Form Streaming video Author Cain, Robert C., speaker Springer Nature (Firm), publisher.

Other Titles PowerShell core for SQL server PowerShell core for Structured Query Language server Springer Nature video coding and web development

  Permalink