SQL Server Administration (Mock Internship Program Part1)

Apply core SQL Server administration principles across versions, with separate 2014, 2016, and 2017 instances. Perform common tasks like selecting data and creating or dropping objects, while embracing 2016 features.

Set up a virtual box environment, enable shared folders and emulate hard drives, then install Eskudo Server 2012 with designated data and log file directories and firewall adjustments.

Attach the Adventure Works 2012 database to a new dev sql server instance, create a database via gui, and import and export a Movies file using a shared folder.

Learn to build maintenance plans that back up system and user databases, determine size, and set simple or full recovery models.

Create an ssrs product report filtered to accessories, listing name, price, size, and color. Format with a dollar sign, centered headers, and frozen panes, and enable Bob-only access.

Create an ssrs report for products table filtered by accessories, with currency formatting and headers. Deploy to the web portal and grant read access to Bob Enescu via Eskil login.

Develop a backup plan for three large databases, choosing full, differential, or transaction log backups, and stagger jobs to meet restore windows while ensuring data integrity with dbcc checkdb.

Learn to design a backup plan for large databases using full, differential, and transaction log backups. Schedule these backups to meet restore time targets and data-loss tolerances.

Identify and investigate security breaches in a production database using the Ezekial profiler, by setting up a breach scenario, monitoring activity, and analyzing results to locate the cause.

Set up the school database mail system and an operator to alert via email when performance issues occur, then test using your SMTP email account.

Create a database using t-sql with default settings. Build a names table (first name, last name, age), insert five rows, copy the table, and export csv report via the wizard.

Create a developers database, define a names table, insert data, back up with a copy, generate a report, and export to CSV using T-SQL and the export wizard.

Design and execute a backup and restore plan for a very large database using weekly full backups, differentials every six hours, and 15-minute transaction log backups.

Write an inner join to list employees by department and a count by job title, including first name, last name, gender, and title, plus an SRS report.

Enforce data quality with T-SQL constraints by creating a database, a drivers table, inserting valid and invalid ages, removing garbage data, and adding a check constraint for ages.