Please log in to access your purchased courses.
DBA – 1 – Intro to Database Administration DBA – 2 – Intro to benefits of SQL DBA – 3 – Intro to Normalization Preview DBA – 4 – Intro to Performance Tuning DBA – 5 – Intro to Troubleshooting DBA – 6 – Intro to High Availability DBA – 7 – Intro to Install Upgrade and Updates DBA – 8 – Report Builder – What to do with Report Builder DBA – 9 – Report Builder – VARCHAR Parameter DBA – 10 – Report Builder – Date Parameter DBA – 11 – Report Builder – Multi-parameterized report DBA – 12 – SSIS – My first SSIS package DBA – 13 – SSIS – Loading and merging multiple files Preview DBA – 14 – SSIS – Event Handlers DBA – 15 – SSIS – Loading and renaming multiple files DBA – 16 – SSIS – Scheduling SSIS packages DBA – 17 – SSIS – Interview Preparation SQL – 1- Intro – What is SQL SQL – 2- Intro – Finding a Database to run SQL SQL – 3- Intro – DDL – Create, Alter, Drop SQL – 4- Intro – DML – Insert, Update, Delete SQL – 5- Intro – DDL & DML Review SQL – 6 – SELECT Where to use & Syntax SQL – 7 – SELECT DISTINCT SQL – 8 – SELECT WHERE Clause SQL – 9 – SELECT AND & OR Clause SQL – 10 – SELECT LIKE SQL – 11 – SELECT ORDER BY SQL – 12 – SELECT GROUP BY SQL – 13 – SELECT TOP SQL – 14 – SELECT JOINS