Loginless users are users that are created within the database, but don’t have the ability to log into the server. They are a great resource to use when exploring the database with permissions different from the main administrator account.
- [Instructor] When it comes time…to test the security of your system,…it can be difficult to properly assess…all of the permissions that have been assigned…to each user role and their affect…across the objects that make up a complex database.…User accounts typically have to exist…at the server level first,…before they can be assigned permission…to the individual databases.…When the server is set to use Windows Authentication,…user accounts must exist at the operating system level.…This makes it difficult to impersonate different users…in order to get a look at how they would see the database.…SQL Server also supports mixed mode…or SQL Server Authentication,…which allows user accounts to be created…directly on the server itself.…
We took advantage of this in the last movie…to more easily create a fake user account…for testing purposes.…There is another way to create users for testing purposes,…though, and this one is completely contained…within the database itself.…It doesn't actually create a user account for the server.…
Author
Adam Wilbert
Released
12/19/2016Note: This course will also help you prepare for the Developing Microsoft SQL Server Databases exam—a crucial component of the MCSA: Solutions Associate certification. Find out more about the certification at https://www.microsoft.com/en-us/learning/exam-70-762.aspx.
- Creating and altering tables
- Creating calculated columns
- Implementing advanced features like temporary tables, table variables, and compression
- Working with database views
- Ensuring data integrity through constraints
- Creating secure user accounts
- Implementing data types
- Writing stored procedures
- Creating in-memory tables
- Indexing and index optimization
- Optimizing query performance
- Designing and implementing user-defined functions (UDFs)
- Monitoring database performance
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome42s
-
Install the sample database3m 15s
-
-
1. Data Table Fundamentals
-
Table design in SQL Server4m 31s
-
Data types3m 20s
-
Create and alter tables7m 28s
-
Implement table schemas6m 21s
-
Calculate table columns6m 40s
-
-
2. Implement Advanced Table Features
-
Create temporary tables4m 38s
-
Use table variables4m 41s
-
Compress data tables3m 40s
-
3. Work with Database Views
-
What are views?2m 18s
-
Create a view of the data7m 19s
-
Enhance view performance4m 53s
-
-
4. Ensure Data Integrity through Constraints
-
Implement domain integrity2m 45s
-
5. Create Secure User Accounts
-
6. Implement Data Types
-
Store spatial data6m 12s
-
Add GUID data to a table4m 3s
-
Implement the XML data type4m 50s
-
Store BLOB data in a table3m 19s
-
Implement FILESTREAM access6m 48s
-
-
7. Create Stored Procedures
-
Recompile a stored procedure2m 13s
-
8. Create In-Memory Tables
-
9. Introduction to Indexing
-
Clustered indexes2m 18s
-
Non-clustered indexes2m 19s
-
10. Index Optimization
-
Obtain index statistics4m 11s
-
Filtered indexes3m 43s
-
11. Work with Sparse Columns
-
Implement sparse columns3m 24s
-
12. Optimize Query Performance
-
Defragment indexes4m 16s
-
-
13. Design and Implement User-Defined Functions (UDFs)
-
SQL Server function overview1m 37s
-
-
14. Monitor Database Performance
-
Use Dynamic Management Views1m 43s
-
-
Conclusion
-
Next steps46s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create loginless and contained users