Cargando…
PowerShell Core for SQL Server Automating Your Transact-SQL Scripts /
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'l...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Formato: | Electrónico Video |
| Idioma: | Inglés |
| Publicado: |
Apress,
2020.
|
| Edición: | 1st edition. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cgm a22000007a 4500 | ||
|---|---|---|---|
| 001 | OR_on1152555738 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o c | ||
| 007 | cr cnu|||||||| | ||
| 007 | vz czazuu | ||
| 008 | 200429s2020 xx --- vleng | ||
| 040 | |a AU@ |b eng |c AU@ |d TOH |d OCLCO |d OCLCQ |d UAB |d Q2U |d FZL |d OCLCQ |d OCLCO | ||
| 019 | |a 1228510184 |a 1232115757 |a 1299317569 |a 1316033053 |a 1328733828 |a 1380770253 | ||
| 020 | |z 9781484259900 | ||
| 020 | |a 1484259904 | ||
| 020 | |a 9781484259900 | ||
| 024 | 8 | |a 9781484259900 | |
| 029 | 0 | |a AU@ |b 000067075724 | |
| 035 | |a (OCoLC)1152555738 |z (OCoLC)1228510184 |z (OCoLC)1232115757 |z (OCoLC)1299317569 |z (OCoLC)1316033053 |z (OCoLC)1328733828 |z (OCoLC)1380770253 | ||
| 082 | 0 | 4 | |a E VIDEO |
| 049 | |a UAMI | ||
| 100 | 1 | |a Cain, Robert, |e author. | |
| 245 | 1 | 0 | |a PowerShell Core for SQL Server |h [electronic resource] : |b Automating Your Transact-SQL Scripts / |c Cain, Robert. |
| 250 | |a 1st edition. | ||
| 264 | 1 | |b Apress, |c 2020. | |
| 300 | |a 1 online resource (1 video file, approximately 1 hr., 32 min.) | ||
| 336 | |a two-dimensional moving image |b tdi |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 344 | |a digital |2 rda | ||
| 347 | |a video file | ||
| 520 | |a 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. What You Will Learn Obtain PowerShell Core and the Visual Studio Code environment Install the module needed to access SQL Server from PowerShell Core Read data from SQL Server and bring that data back to PowerShell Modify, update, and delete data in your database from PowerShell scripts Send Transact-SQL scripts stored in text files to SQL Server for execution Import and export data to and from CSV, JSON, and XML files Who 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. | ||
| 538 | |a Mode of access: World Wide Web. | ||
| 542 | |f Copyright © Robert C. Cain |g 2020 | ||
| 550 | |a Made available through: Safari, an O'Reilly Media Company. | ||
| 588 | |a Online resource; Title from title screen (viewed April 22, 2020) | ||
| 533 | |a Electronic reproduction. |b Boston, MA : |c Safari. |n Available via World Wide Web., |d 2020. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a SQL server. |
| 630 | 0 | 7 | |a SQL server |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Client/server computing. | |
| 650 | 0 | |a Windows PowerShell (Computer program language) | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 6 | |a Windows PowerShell (Langage de programmation) | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a Windows PowerShell (Computer program language) |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 655 | 4 | |a Electronic videos. | |
| 710 | 2 | |a Safari, an O'Reilly Media Company. | |
| 776 | |z 1-4842-5990-4 | ||
| 856 | 4 | 0 | |u https://learning.oreilly.com/videos/~/9781484259900/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 936 | |a BATCHLOAD | ||
| 994 | |a 92 |b IZTAP | ||