SQL - The UPDATE- and DELETE Statement
Über den Vortrag
Der Vortrag „SQL - The UPDATE- and DELETE Statement“ von Martin Holzke ist Bestandteil des Kurses „SQL Database for Beginners“. Der Vortrag ist dabei in folgende Kapitel unterteilt:
- Introduction - The Update Statement
- How to do the update
- How to change more than one record
- The Delete Statement
- The to delete more than one record
Dozent des Vortrages SQL - The UPDATE- and DELETE Statement
Martin Holzke
Martin Holzke’s programming career started while studying Physics in the late 1980’s when he took on an offer to learn to program at Philips instead of the more common student jobs. Once graduated, he started his own business developing applications and systems as a freelance IT Consultant which he does to this day. His 25+ years’ journey continues to take him through a vast array of technologies, methodologies and languages like OOP, UML, C++, .NET, ADF, PHP, Zend, Oracle and SQL to name just a few.Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
Auszüge aus dem Begleitmaterial
... be inserted into table projectperson: select * from person where firstname=’Paul’ and lastname=’Miller’ select * from role where label=’External Developer’ select * from project where label=’twitter’ Now insert new assignment: insert into projectperson (prid, pid, rid) values (4, 2, 7) Pre- and post-test with: select * from projectperson 6) Write a ...
... Post-test with: select * from role 9) Write a query removing the project “twitter”. Answer: delete from project where label=’twitter’ Pre-test with: select * from project where label=’twitter’ Post-test with: select * from project yRegister as a Learntoprogram.tv ...
