Setup Menus in Admin Panel

Course 9: SQL Administration Mock Internship Program Part I

5 STUDENTS ENROLLED

     The ‘Mock Internship Program Part 1’ has been created and designed specifically to answer the question ‘How do I get a job without experience, and how do I get experience without a Job’? The course will cover the following:

  • Examples of ‘real life’ questions that the SQL DBA will be responsible for in his/her job
  • Answers to those ‘real life’ examples with documentation and SQL scripts where needed
  • Having the student play the role of a SQL DBA
  • Giving the student confidence, encouragement and a sense of direction to what exactly is expected from a SQL DBA, thus increasing his/her chances of getting an opportunity in the IT industry

Course Curriculum

1. SQL Server Mock Internship Program Docs
SQL Server Mock Internship Program Docs 00:00:00
2. Introduction to Mock Program
Introduction to Mock Program 00:00:00
3. Install SQL Server 2012
Install SQL Server 2012 00:00:00
4. Install Applications Answer Part 1
Install Applications Answer Part 1 00:00:00
5. Install Applications Answer Part 2
Install Applications Answer Part 2 00:00:00
6. Attach Adventure Works Database
Attach Adventure Works Database 00:00:00
7. Attach Adventure Works Database Answer Part 1
Attach Adventure Works Database Answer Part 1 00:00:00
8. Attach Adventure Works Database Answer Part 2
Attach Adventure Works Database Answer Part 2 00:00:00
9. Backup Databases
Backup Databases 00:00:00
10. Backup Databases Answer
Backup Databases Answer 00:00:00
11. Create a SSRS Report
Create a SSRS Report 00:00:00
12. Create a SSRS Report Answer
Create a SSRS Report Answer 00:00:00
13. Deploying the SSRS Report
Deploying the SSRS Report 00:00:00
14. Backing up Large Database
Backing up Large Database 00:00:00
15. Backing up Large Database Answer Part 1
Backing up Large Database Answer Part 1 00:00:00
16. Backing up Large Database Answer Part 2
Backing up Large Database Answer Part 2 00:00:00
17. Security Breach SQL Profiler
Security Breach SQL Profiler 00:00:00
18. Security Breach SQL Profiler Answer
Security Breach SQL Profiler Answer 00:00:00
19. Creating SQL Logins
Creating SQL Logins 00:00:00
20. Creating SQL Logins Answer
Creating SQL Logins Answer 00:00:00
21. Import Data
Import Data 00:00:00
22. Import Data Answer
Import Data Answer 00:00:00
23. Restore a Database
Restore a Database 00:00:00
24. Restore a Database Answer
Restore a Database Answer 00:00:00
25. Setting up Database Mail
Setting up Database Mail 00:00:00
26. Setting up Database Mail Answer
Setting up Database Mail Answer 00:00:00
27. TSQL Database, Table, Insert, Update, Delete
TSQL Database, Table, Insert, Update, Delete 00:00:00
28. TSQL Database, Table, Insert, Update, Delete Answer
TSQL Database, Table, Insert, Update, Delete Answer 00:00:00
29. Backup and Restore VLDB
Backup and Restore VLDB 00:00:00
30. Backup and Restore VLDB Answer
Backup and Restore VLDB Answer 00:00:00
31. Create a Inner Join
Create a Inner Join 00:00:00
32. Create a Inner Join Answer
Create a Inner Join Answer 00:00:00
33. Find Longest Running Query
Find Longest Running Query 00:00:00
34. Find Longest Running Query Answer
Find Longest Running Query Answer 00:00:00
35. Monitoring the SQL Server
Monitoring the SQL Server 00:00:00
36. Monitoring the SQL Server Answer
Monitoring the SQL Server Answer 00:00:00
37. Constraints
Constraints 00:00:00
38. Constraints Answer
Constraints Answer 00:00:00
39. Install New Virtual Machine
Install New Virtual Machine 00:00:00
top
© Copyright by Rafacademy@2016