SQL Server Administration Part 4 - Projects - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: SQL Server Administration Part 4 - Projects (/Thread-SQL-Server-Administration-Part-4-Projects)

SQL Server Administration Part 4 - Projects - OneDDL - 11-22-2024 Free Download SQL Server Administration Part 4 - Projects Published 11/2024 MP4 | Video: h264, 1920x1080 | 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 Homepage [To see links please register or login] Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live [To see links please register or login] No Password - Links are Interchangeable