Cargando…
T-SQL data manipulation : inserting, updating, deleting, and merging in SQL server /
"This video course teaches how to go beyond writing SELECT statements and to manipulate data within your database tables. You'll begin with an introduction to Data to Data Manipulation Language (DML) that covers the INSERT, UPDATE, and DELETE statements. You'll use these three stateme...
| Clasificación: | Libro Electrónico |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico Video |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Apress,
2019.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cgm a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1107052648 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o c | ||
| 007 | cr cna|||||||| | ||
| 007 | vz czazuu | ||
| 008 | 190702s2019 xx 042 o vleng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d OCLCF |d ALSTP |d OCL |d INT |d OCLCQ |d OCLCO | ||
| 019 | |a 1150008060 |a 1269382040 | ||
| 029 | 1 | |a AU@ |b 000068134774 | |
| 029 | 1 | |a AU@ |b 000069947341 | |
| 035 | |a (OCoLC)1107052648 |z (OCoLC)1150008060 |z (OCoLC)1269382040 | ||
| 037 | |a CL0501000057 |b Safari Books Online | ||
| 050 | 4 | |a QA76.73.S67 | |
| 049 | |a UAMI | ||
| 100 | 1 | |a Deardurff, John, |e speaker. | |
| 245 | 1 | 0 | |a T-SQL data manipulation : |b inserting, updating, deleting, and merging in SQL server / |c John Deardurff. |
| 246 | 1 | |i Title on title screen: |a T-SQL querying : data manipulation language | |
| 264 | 1 | |a [Place of publication not identified] : |b Apress, |c 2019. | |
| 300 | |a 1 online resource (1 streaming video file (41 min., 23 sec.)) | ||
| 306 | |a 004124 | ||
| 336 | |a two-dimensional moving image |b tdi |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 337 | |a video |b v |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a video file | ||
| 511 | 0 | |a Presenter, John Deardurff. | |
| 500 | |a Title from resource description page (Safari, viewed July 1, 2019). | ||
| 520 | |a "This video course teaches how to go beyond writing SELECT statements and to manipulate data within your database tables. You'll begin with an introduction to Data to Data Manipulation Language (DML) that covers the INSERT, UPDATE, and DELETE statements. You'll use these three statements most often, and they are the next most common three to use following the SELECT statement that has been covered earlier in this series. Watching the video, you'll learn how to use these three statements to insert new data into your database to tables, and to update data in place without having to bring it down to the client and push it back and forth network. You'll also learn to delete data when it's no longer needed. Also covered in the video is the MERGE statement. You'll learn how this little used but very useful statement works to make extract, transform, load (ETL) processes much more streamlined. You'll learn to throw large numbers of rows at your database, letting the MERGE statement sort out which rows represent new data to be inserted, and which represent updates to existing data. You'll be able to write cleaner load processes for data warehouses, data marts, and other reporting statements using your knowledge of MERGE. You'll also learn some fast ways to delete data from database tables. In addition to DELETE, you'll learn about DROP and TRUNCATE. These statements provide you with options for quickly deleting data. Each has their best use, and this video helps you to make the correct choices and avoid unwanted downtime in your production database environments. Finally, you'll learn about identity columns and sequences, using them to generate primary keys to uniquely identify new rows of data that you are storing in your database tables. Throughout this video you'll learn the gamut of data manipulation statements that SQL Server places at your disposal, and when each is best applied."--Resource description page | ||
| 546 | |a In English. | ||
| 506 | |a Restricted to the University of North Texas System. |5 TxDN | ||
| 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 |0 (OCoLC)fst01376937 |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Relational databases. | |
| 650 | 0 | |a Client/server computing. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 7 | |a Client/server computing. |2 fast |0 (OCoLC)fst00864205 | |
| 650 | 7 | |a Relational databases. |2 fast |0 (OCoLC)fst01093575 | |
| 650 | 7 | |a SQL (Computer program language) |2 fast |0 (OCoLC)fst01102869 | |
| 655 | 7 | |a Instructional films. |2 fast |0 (OCoLC)fst01726236 | |
| 655 | 7 | |a Instructional films. |2 lcgft | |
| 655 | 7 | |a Films de formation. |2 rvmgf | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/videos/~/9781484249932/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Alexander Street |b ALSP |n ASP4691356/marc | ||
| 994 | |a 92 |b IZTAP | ||