SQL Server Administration (Mock Internship Program Part1)
4.7 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
401 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Administration (Mock Internship Program Part1) to your Wishlist.

Add to Wishlist

SQL Server Administration (Mock Internship Program Part1)

Ge the 'experience' you desperately need for a SQL Server Administration job by taking this course.
4.7 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
401 students enrolled
Created by Raphael Asghar
Last updated 3/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • All students taking this course MUST have the 7 requisite courses; those courses are: Learn T-SQL, SQL Admin part 1,2,3, SSRS part 1, SSIS, and SSRS part 2. You can use a desktop or a laptop with Windows operating system. All material and software will be provided via trial downloads. DO NOT TAKE THIS COURSE IF YOU HAVE NOT TAKEN THE 7 COURSES, UNLESS YOU KNOW SQL ADMINISTRATION.
Description

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.

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
06:08:04
+
Gain the SQL Server Experience with this course
37 Lectures 06:08:04


Project 1 Install Applications Answer part 1
15:00

Project 1 Install Applications Answer part 2
15:59

Project 2 Attach Adventureworks Database Answer part 1
10:00

Project 2 Attach Adventureworks Database Answer part 2
11:27

Project 3 Back up database using Maintenance Plan
05:37

Project 3 Backup databases using mantnance plans answer
10:32

Project 4 Create a SSRS Report
09:21

Project 4 Create a SSRS Report answer
13:17

Project 5 Deploying the SSRS report
09:30

Project 6 Backing up large database
09:10

Project 6 backing up large database answer part 1
12:00

Project 6 backing up large database answer part 2
13:49

Project 7 Security Breach SQL Profiler
08:23

Project 7 Security Breach SQL Profiler answer
11:49

Project 8 Creating SQL Logins
06:26

Project 8 Creating SQL Logins answer
12:49

Project 9 Import data
04:19

Project 9 Import data answer
18:32

Project 10 Restore database
07:53

Project 10 Restore database answer
09:42

Project 11 Setting up database mail
02:57

Project 11 Setting up database mail answer
08:54

Project 12 TSQL database, table, insert, update, delete
06:23

Project 12 TSQL database, table, insert, update, delete answer
11:51

Project 13 Backup and restore VLDB
11:56

Project 13 Backup and restore VLDB answer
15:33

Project 14 create a inner join
06:32

Project 14 create a inner join answer
11:23

Project 15 Find Longest running query
05:41

Project 15 Find Longest running query answer
09:18

Project 16 Monitoring the SQL Server
06:15

Project 16 Monitoring the SQL Server answer
12:45

Project 17 Constraints
06:28

Project 17 Constraints answer
08:08

Project 18 Install new virtual machine Q AND A
08:08
About the Instructor
Raphael Asghar
4.5 Average rating
2,333 Reviews
24,823 Students
13 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.