Folks: Did you enjoy my Microsoft Access 2007/2010 Tutorial but wanted to learn more advanced topics and techniques? If so, then I am happy to announce a set of advanced Access tutorials that I will be posting over the next few weeks. The first advanced tutorial is already on line: Advanced Database Table Design in [...]
Advanced Database Table Design in MS Access 2010 and 2013 If you have mastered the basics of Microsoft Access 2010 or 2013 and are looking for more advanced tips and techniques, you have found the right place. If you are just getting starting with Microsoft Access, I suggest you first go through my MS Access [...]
Folks: This is my third installment of a series related to careers as a Database Administrator (DBA) You may wish to review the first two blog entries where I talked about relevant course work and obtaining other DBA skills. For this posting I am going to explore the next logical question: How do I get [...]
Folks: This is the second installment of my blog series on preparing to be a DBA. My first post talked about what college courses you might consider taking to help prepare for a career as a DBA. In this post I will talk about other steps you can take to help prepare. Getting hands-on experience [...]
Folks: I get this question pretty frequently so I figured I will write a few postings about it. Some of our students are interested in pursuing a career as a Database Administrator (DBA) and are wondering what they can do to better prepare themselves for such a career. So assuming you are currently enrolled as [...]
Database Recovery There are many situations in which a transaction may not reach a commit or abort point. An operating system crash can terminate the DBMS processes The DBMS can crash The system might lose power A disk may fail or other hardware may fail. Human error can result in deletion of critical data. In [...]
Concurrency Control and Locking We need a way to guarantee that our concurrent transactions can be serialized. Locking is one such means. Locking is done to data items in order to reserve them for future operations. A lock is a logical flag set by a transaction to alert other transactions the data item is in use. Characteristics of [...]
What you Will Learn – Transaction Processing Multi-User databases need to control the order in which data are read and updated by multiple users. Transaction Processing presents the basic ideas of transactions, some problems encountered when running multiple transactions at the same time, and the notion of a transaction schedule assembled by the DBMS. Textbook [...]
What You’ll Learm in this set of notes Database Security and Authorization Authorization Subsystem Subject-Based Security Object-Based Security The SQL GRANT and REVOKE Statements System Administration Database Administration Data Administration Database Security and Authorization Three very broad issues in DB security: Legal and Ethical considerations – Who has the right to read What information ? [...]
Folks For some time now I have been assembling a set of background notes on various aspects of programming. Here is the link http://holowczak.com/programming-concepts-tutorial-programmers/. This started as a set of notes for basic parts of programming such as declaring variables, data structures, program structures, etc. and now has expanded to include a discussion on Boolean [...]
Follow @rholowczak on Twitter