Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Sql Server Administration (Mock Internship Program Part1)

Posted By: ELK1nG
Sql Server Administration (Mock Internship Program Part1)

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

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.