1 / 9

Mastering SQL Server: Essential Skills for Database Management

Gain proficiency in SQL Server basics, relational database management, and high availability techniques. Learn to create and maintain databases, troubleshoot performance, and design database objects like a pro.

teleri
Télécharger la présentation

Mastering SQL Server: Essential Skills for Database Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction Lesson 1

  2. Skills Matrix

  3. Relational Database Management System (RDBMS) • Installing and configuring SQL Server. • Implementing high availability and disaster recovery. • Supporting data consumers. • Maintaining databases. • Monitoring and troubleshooting SQL Server performance. • Creating and implementing database objects.

  4. Introductory Information Systems • Create a table. • Normalize to the third level. • Diagram entity relationships. • Create parent-child links. • Design an analysis services solution. Note: Appendix A presents an overview of database concepts.

  5. Structured Query Language (SQL) • Return all rows and all columns from two or more tables. • Change the table data based on a given attribute condition. • Prepare an annual report from data stored in 12 unique monthly tables. • Change the date format from 21 July 2011 to 7/21/11. • Create a query when an important test value proves unknowable prior to runtime. • Appendix B presents an introduction to the Structured Query Language Data Manipulation Language constructs.

  6. Windows Server • SQL Server executes only in a Windows operating system environment. • Consider taking an introductory course to Windows XP, Vista, Windows 7 or Windows Server 2003 (or newer)

  7. Approaching your Studies • Each lesson introduces a core concept. • At the end of each lesson, think about the new concept and how it might apply to other topics. • Try to avoid using this textbook to cram. • Use it as the foundation for learning skills to apply in your workplace. • Each lesson ends with review questions and unguided exercises you can use to check the knowledge you’ve gained and to place the concept firmly in your mind.

  8. Solid Foundation • Read each lesson carefully. • Complete all hands-on exercises in each lesson, referring to the textbook as necessary so you understand each step you take. • Answer the review questions at the end of each chapter. • Note which questions you did not understand and study the corresponding sections of the book again. • Make sure you complete the entire book. • Before taking the exam, go through the review questions, bonus exams, flash cards, etc. included on the CD that accompanies this book.

  9. Summary • You are embarking on an adventure. Learning SQL Server core concepts requires dedication and commitment.

More Related