Learning Outcome SET UP an SQL server. Learn how to manage databases and tables, and SQL server management studio. Know …
| Introduction | |||
| Introduction | 00:02:00 | ||
| Setup | |||
| SQL server setup | 00:28:00 | ||
| SQL server management studio setup | 00:04:00 | ||
| Databases and tables | 00:15:00 | ||
| Basic queries | |||
| INSERT | 00:04:00 | ||
| SELECT | 00:07:00 | ||
| UPDATE | 00:03:00 | ||
| DELETE | 00:03:00 | ||
| Filter and sort | 00:04:00 | ||
| Variables | 00:02:00 | ||
| Logic | 00:04:00 | ||
| Security | |||
| Authentication | 00:08:00 | ||
| Connection strings | 00:08:00 | ||
| Vulnerability assessment | 00:05:00 | ||
| MSSQL an ddifferent drivers | |||
| Stored procedure | 00:10:00 | ||
| Example: attendee registry | 00:12:00 | ||
| c# | 00:28:00 | ||
| Python | 00:14:00 | ||
| Files | |||
| File table | 00:09:00 | ||
| Stored procedures | 00:15:00 | ||
| General | |||
| Functions | 00:08:00 | ||
| Import data | 00:03:00 | ||
| Export data | 00:06:00 | ||
| Jobs | 00:18:00 | ||
| Backup | 00:10:00 | ||
| Database email | 00:08:00 | ||
| Job notifications | 00:04:00 | ||