09 - SQL Server 2022 Tutorials – Creating a Login

Number 9 of this series moves onto the security and administration side of SQL Server 2022 by introducing the creation of logins.

As a database developer, it is crucial to know and understand the creation of Logins in SQL Server because it is the foundation of security in any database system. Logins provide a way for users to authenticate themselves and access the database system.

Understanding the various types of logins available, such as SQL Server authentication and Windows authentication, and how to assign them to different users is essential, and the user will in this walkthrough.

As with previous walkthroughs in this series, all aspects are activity-driven to increase the engagement and retention factors.

A great start to the world of bigger and industry-standard database solutions – particularly if you are used to Microsoft Access – this is a great progression. The walkthrough oozes lots of inclusivity and personalisation.
The walkthroughs are styled in step-by-step mode with lots of illustrations to provide a really user-friendly approach to SQL Server 2022.

The project is from a completely invaluable series of resources for the BTEC Higher National Computing Courses (HTQ), BTEC Level 3 Computing and also priceless for business students too. The Level 3 Cambridge Technical IT, A Level Computer Science (NEA projects), Business as well as many others where Database Design & Development are a required skills set as well as a developed understanding of the concepts of RDBMS.

All updated to the latest version of SQL Server (2022). (2016 is available elsewhere on TES if this is what you prefer). Data Science is now one of the most sought-after skills sets in all workplaces.
All walkthroughs in the set are project-based to introduce concepts and embed Database Design & Development skills.

Great for both teachers and students alike. Each walkthrough, as well as projects, contains tasks and activities to reinforce and embed learning.
Both Word and PDF formats included to enable editing and personalisation.
There is also a combined set of walkthroughs available on TES.

See what you think!