As you probably know, you can interact with SQL Server in two ways:
- by issuing Transact-SQL commands and
- 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.
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.
- Creating a Database (Part 1) and
- 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
- Microsoft Certified: Data Analyst Associate or the
- 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.