Setup Menus in Admin Panel

Course 9: SQL Administration Mock Internship Program Part I

0 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