Sql Server Administration (Mock Internship Program Part1)
Last updated 12/2017
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.89 GB | Duration: 6h 16m
Last updated 12/2017
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.89 GB | Duration: 6h 16m
Ge the 'experience' you desperately need for a SQL Server Administration job by taking this course.
What you'll 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.
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.
Overview
Section 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
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.