最新消息:请大家多多支持

SQL Server Administration Part 4: Projects

未分类 dsgsd 15浏览 0评论

ivlaOGTr5XIUxxbGgMQwwGdtPRQN0LFz

Published 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.46 GB | Duration: 5h 54m

SQL SERVER PROJECTS

What you’ll learn
Students will learn how to design and develop SQL projects from the ground up, gaining hands-on experience in creating database schemas
The course will focus on scripting SQL projects, teaching students how to automate processes and enhance functionality through T-SQL.
Students will explore the objectives behind various SQL projects, understanding how data manipulation and analysis contribute to business decision-making
Through structured exercises and projects, students will deepen their understanding of T-SQL, enhancing their ability to write robust queries

Requirements
The prerequisites are that the student has taken Learn T-SQL and SQL Server Administration part 1 courses
SQL server 2022 and access to Excel application

Description
In the SQL Server Administration Part 4 Projects course, students will engage in hands-on projects that reinforce their learning and application of SQL Server management concepts. These projects will involve creating databases, defining tables and columns, defining datatypes and lengths and writing queries to interact with the database effectively. Students will learn to insert data, use Excel worksheets as data sources, and prepare data for upper management by creating graphs and charts for effective data visualization. SQL scripts will be employed to manage databases, implement security measures, and optimize performance. Moreover, students will have the opportunity to collaborate with their peers, sharing insights and troubleshooting challenges together, which mirrors real-world database administration scenarios.A key focus of the course will be on performance optimization techniques. Students will learn why shrinking a database is generally not recommended, as it can lead to fragmentation and adversely affect performance. They will explore effective strategies for managing fragmentation of indexes and data, including regular maintenance tasks like rebuilding and reorganizing indexes to ensure efficient query performance. To succeed in this course, a solid understanding of T-SQL and completion of SQL Administration Part 1 are essential, as these foundational skills are crucial for tackling more advanced topics.

Overview
Section 1: Introduction

Lecture 1 AN INTRO TO THE COURSE

Lecture 2 INSTALLING SQL SERVER

Lecture 3 INSTALL ADVENTUREWORKS

Lecture 4 INSTALLING VISUAL STUDIO

Lecture 5 VERIFY SSRS AND SSIS EXTENSION

Lecture 6 LEARNING OBJECTIVES

Lecture 7 LIBRARY SCRIPT’S PART 1

Lecture 8 LIBRARY SCRIPT’S PART 2

Lecture 9 ONLINE SCRIPTS PART 1

Lecture 10 ONLINE SCRIPTS PART 2

Lecture 11 MOVIES SCRIPTS

Lecture 12 QUIZ 1

Lecture 13 QUIZ 1 ANSWER

Lecture 14 MULTIPLE DATABASES

Lecture 15 DELETE OLD DBS

Lecture 16 SSRS REPORT DROP DOWN

Lecture 17 SOLVING PROBLEMS

Lecture 18 CREATING A SSIS PACKAGE AND SETTING UP A JOB

Lecture 19 SETTING UP A JOB FOR SSIS

Lecture 20 SHRINK OR NOT TO SHRINK A DATABASE PART 1

Lecture 21 SHRINK OR NOT TO SHRINK A DATABASE PART 2

Lecture 22 EXECUTING A JOB WITH A STORED PROCEDURE FOR FRAGMENTATION

Lecture 23 CREATING A TRIGGER FOR AUDITING

Lecture 24 BRIEF INTRO TO JOINS

Lecture 25 QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 1

Lecture 26 QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 2

Lecture 27 QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 3

Lecture 28 QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 4

Lecture 29 QUESTIONS ABOUT BEER WITHOUT SCRIPTS PART 5

Lecture 30 QUIZ 2

Lecture 31 QUIZ 2 ANSWERS PART 1

Lecture 32 QUIZ 2 ANSWERS PART 2

Lecture 33 QUIZ 2 ANSWERS PART 3

Lecture 34 QUIZ 2 ANSWERS PART 4

Lecture 35 HOSPITAL SYSTEM PART 1

Lecture 36 HOSPITAL SYSTEM PART 2

Lecture 37 TRAVEL SYSTEM QUERY PART 1

Lecture 38 TRAVEL SYSTEM QUERY PART 2

Lecture 39 TRAVEL SYSTEM QUERY PART 3

Lecture 40 TRAVEL SYSTEM QUERY PART 4

Lecture 41 QUIZ 3 ANSWERS

Lecture 42 ADVENTUREWORKS2022 PRODUCTS PROJECTIONS

Lecture 43 PREPARATION AND INTERVIEW QUESTIONS

This course is designed with the understanding that the student has good knowledge in Learn T-SQL and SQL Server Administration part 1 course at minimum


Password/解压密码www.tbtos.com

资源下载此资源仅限VIP下载,请先

转载请注明:0daytown » SQL Server Administration Part 4: Projects

您必须 登录 才能发表评论!