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