Business Rules  «Prev  Next»

Lesson 1

Enterprise Challenges and Business Rules Course

Welcome to MS SQL Server: Enterprise Issues and Business Rules, the third course in the SQL Server Database Implementation Certification Series. This series is designed to:
  1. Provide the technical skills required to implement a database solution on Microsoft’s SQL Server
  2. Help you prepare for the Microsoft's Exam 70-465: Designing Database Solutions for Microsoft SQL Server
The most current and relevant exam that tests on the topic of designing and implementing databases with Microsoft SQL Server is Exam 70-465: Designing Database Solutions for Microsoft SQL Server. This exam was released in January 2023 and covers the latest features and functionality of SQL Server.
The exam is designed to assess the skills and knowledge of database professionals who design and build database solutions in the organization. The exam covers a wide range of topics, including:
  1. Database design concepts and principles
  2. Implementing database objects
  3. Managing database objects
  4. Querying and manipulating data
  5. Optimizing database performance
  6. Securing databases

To prepare for the exam, Microsoft recommends that candidates have at least one year of experience designing and implementing database solutions with SQL Server. Candidates should also have a good understanding of database design principles and SQL Server concepts.

Microsoft offers a variety of resources to help candidates prepare for the exam, including:
  1. Exam preparation guide
  2. Study guide
  3. Practice tests
  4. Online courses

If you are interested in taking the Exam 70-465, you can register for the exam on the Pearson VUE website.


Course goals

After completing the course, you will be able to:
  1. Access data by using the stored procedure model,
  2. Create Transact-SQL scripts that incorporate control of flow methods, local and global variables, functions, and error handling techniques,
  3. Create and execute stored procedures to enforce business rules, modify data in multiple tables, perform calculations, and use input and output parameters,
  4. Create triggers that implement rules, enforce data integrity, and perform cascading updates and cascading deletes,
  5. Configure session-level settings,
  6. Assess data from static or dynamic sources by using remote stored procedures, linked servers, and OPENROWSET,
  7. Populate the database with data from an external data source using a bulk copy program and Data Transformation Services (DTS),
  8. Evaluate and optimize the performance of an execution plan by using DBCC SHOWCONTIG, , SHOWPLAN_TEXT, SHOWPLAN_ALL, and UPDATE STATISTICS,
  9. Diagnose and resolve locking problems,
  10. Identify SQL Server events and performance problems by using SQL Server Profiler.

As you probably know, you can interact with SQL Server in two ways:
  1. by issuing Transact-SQL commands and
  2. by interacting with its GUI, or
graphical user interface. This course uses 1)image galleries and 2) diagrams to explain the code syntax used in Transact-SQL commands, and exercises for practicing different elements of the SQL Server GUI.

The SQL-Server Series

MS-SQL Server: Enterprise Issues and Business Rules is the third of three courses in the SQL Server Database Implementation Certification Series.
As of 2021, the most current exam for SQL Server from Microsoft is the Microsoft Certified: Azure Database Administrator Associate. This certification validates the skills and knowledge needed to provision, manage, monitor, and troubleshoot Azure SQL Database, Azure Cosmos DB, and Azure Data Factory. It validates the skills to manage and maintain Azure data platform and Azure SQL Database, manage and secure SQL Server on Azure VM, manage and monitor Azure Data Factory.
It is worth noting that Microsoft regularly updates and releases new certification exams, so this information may change in the future. It is always best to check the Microsoft website for the most up-to-date information on certification exams.
Enterprise Issues and Business Rules is the third course in a three-part series.
  1. Creating a Database (Part 1) and
  2. Queries, Cursors and Views, (Part 2)
.

(MTA) Microsoft Technology Associate has been retired

Microsoft Technology Associate (MTA) was an introductory Microsoft Certification for individuals considering a career in technology. MTA certification addressed a wide spectrum of fundamental technical concepts, assessed and validated your core technical knowledge, and enhanced your technical credibility.
Microsoft retired all MTA certification tracks on June 30, 2022. Microsoft made this decision to focus on role-based certifications that are more aligned with the skills and knowledge that employers are looking for. If you have already earned an MTA certification, it will remain valid and will continue to be listed on your Microsoft transcript. However, it will be moved to the "Certification History" section of your transcript two years after the certification retires.
If you are interested in earning a Microsoft certification, I recommend that you consider one of the role-based certifications, such as the
  1. Microsoft Certified: Data Analyst Associate or the
  2. Microsoft Certified: Azure Administrator Associate.
Microsoft offers a variety of resources to help you prepare for these certifications, including online courses, study guides, and practice tests.

In the next lesson, prerequisites for this course will be discussed.