SQL Server Administration (Mock Internship Program Part1)

SQL Server Administration (Mock Internship Program Part1), available at $64.99, has an average rating of 4.65, with 38 lectures, based on 171 reviews, and has 1788 subscribers.

You will learn about At this end of the course, the student will have the necessary ‘experience’ in managing, configuring, installing, deploying, and creating a SQL Server environment to enhance the knowledge gained by the 7 courses. This course is ideal for individuals who are This course is specifically designed for students that have taken all 7 courses mentioned above. It is targeted for those students that are aware of SQL Administration, Reporting Services, and Integration Services. If you’re not aware of these technologies, don’t take this course, unless you are aware of SQL Administration. It is particularly useful for This course is specifically designed for students that have taken all 7 courses mentioned above. It is targeted for those students that are aware of SQL Administration, Reporting Services, and Integration Services. If you’re not aware of these technologies, don’t take this course, unless you are aware of SQL Administration.

Enroll now: SQL Server Administration (Mock Internship Program Part1)

Summary

Title: SQL Server Administration (Mock Internship Program Part1)

Price: $64.99

Average Rating: 4.65

Number of Lectures: 38

Number of Published Lectures: 38

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 38

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

At this end of the course, the student will have the necessary ‘experience’ in managing, configuring, installing, deploying, and creating a SQL Server environment to enhance the knowledge gained by the 7 courses.

Who Should Attend

This course is specifically designed for students that have taken all 7 courses mentioned above. It is targeted for those students that are aware of SQL Administration, Reporting Services, and Integration Services. If you’re not aware of these technologies, don’t take this course, unless you are aware of SQL Administration.

Target Audiences

This course is specifically designed for students that have taken all 7 courses mentioned above. It is targeted for those students that are aware of SQL Administration, Reporting Services, and Integration Services. If you’re not aware of these technologies, don’t take this course, unless you are aware of SQL Administration.

The following ‘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 following course will provide that missing gap by giving the students an opportunity to manage, design, and configure the SQL Server by having the student themselves take on the role of a SQL DBA, and actually produce results by executing projects, tasks, and taking on responsibilities that are conducted on a day to day or weekly basis. This in turn will give 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

Chapter 1: Gain the SQL Server Experience with this course

Lecture 1: SQL SERVER COURSES NOT BASED ON SQL VERSION BUT RATHER ON PRINCIPLES

Lecture 2: Introduction to Mock Program

Lecture 3: Project 1 Install Applications

Lecture 4: Project 1 Install Applications Answer part 1

Lecture 5: Project 1 Install Applications Answer part 2

Lecture 6: Project 2 Attach Adventureworks Database Answer part 1

Lecture 7: Project 2 Attach Adventureworks Database Answer part 2

Lecture 8: Project 3 Back up database using Maintenance Plan

Lecture 9: Project 3 Backup databases using mantnance plans answer

Lecture 10: Project 4 Create a SSRS Report

Lecture 11: Project 4 Create a SSRS Report answer

Lecture 12: Project 5 Deploying the SSRS report

Lecture 13: Project 6 Backing up large database

Lecture 14: Project 6 backing up large database answer part 1

Lecture 15: Project 6 backing up large database answer part 2

Lecture 16: Project 7 Security Breach SQL Profiler

Lecture 17: Project 7 Security Breach SQL Profiler answer

Lecture 18: Project 8 Creating SQL Logins

Lecture 19: Project 8 Creating SQL Logins answer

Lecture 20: Project 9 Import data

Lecture 21: Project 9 Import data answer

Lecture 22: Project 10 Restore database

Lecture 23: Project 10 Restore database answer

Lecture 24: Project 11 Setting up database mail

Lecture 25: Project 11 Setting up database mail answer

Lecture 26: Project 12 TSQL database, table, insert, update, delete

Lecture 27: Project 12 TSQL database, table, insert, update, delete answer

Lecture 28: Project 13 Backup and restore VLDB

Lecture 29: Project 13 Backup and restore VLDB answer

Lecture 30: Project 14 create a inner join

Lecture 31: Project 14 create a inner join answer

Lecture 32: Project 15 Find Longest running query

Lecture 33: Project 15 Find Longest running query answer

Lecture 34: Project 16 Monitoring the SQL Server

Lecture 35: Project 16 Monitoring the SQL Server answer

Lecture 36: Project 17 Constraints

Lecture 37: Project 17 Constraints answer

Lecture 38: Project 18 Install new virtual machine Q AND A

Instructors

Raphael Asghar
Production SQL Database Administrator

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 11 votes
4 stars: 34 votes
5 stars: 124 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu