Welcome to the “An Intro to SQL Series,” where we embark on a journey to demystify the world of databases using the SQL programming language. This playlist is tailored just for you. Explore the Foundations of SQL: Dive into the fundamentals of SQL, the universal language for managing and manipulating relational databases. Understand key concepts…
Entity Relationship Diagrams (ERDs) are visual design tools for databases, crucial before table creation. This series teaches using Lucid Chart, an accessible browser-based tool with exportable SQL code capabilities. Instructions range from setting up workspaces and creating abstract entities to defining one-to-many and many-to-many relationships. It also covers adding field details like key types and data types. The series culminates with exporting ERD as SQL commands, demonstrating Lucid Chart’s efficiency in converting diagrams into databases.
Explore the essentials of MS Access as a relational database through a video playlist designed to teach building and managing tables, relationships, and queries. Start with the basics of database design, learn to edit existing tables, understand various data types, and handle data updates efficiently. Discover the use of MS Access Relationship Window, master query creation to retrieve and organize data, and import or export it seamlessly. Perfect for both beginners and those enhancing their database skills, the guide covers every aspect to achieve proficiency in Microsoft Access.
Sometimes you will need to have more complex conditions to determine what you need. This goes beyond having Boolean logic, but moves into finding a value in a series of values. This is where we might use a if else if series of code blocks, or a switch statement. If Else If Do you have…
Java has two different types of sets, Unsorted and Sorted… even if Math Sets are technically unsorted. Unsorted Sets Unsorted sets in Java are not a class that can be defined. Therefore you need to use the HashSet and then use the polymorphic nature of the OOP to create the set. From here, you want…
The @media rule can be used to select a set of rules that only work based upon criteria that you can test for. The media rule can test for media features such as the height and width, the orientation, as well as the media type where the presentation will be seen (most typically we’ll use…
In today’s world many people are utilizing mobile devices most, sometimes not even having a personal computer of any type. In the US, it is estimated that 61% of all web access was through a phone, up from 57% in 2019. That jumps to 68% worldwide in 2020. Tablets typically only account for 3-4%, but…
Password entropy predicts how difficult a given password would be to crack through guessing, brute force cracking, dictionary attacks or other common methods. Entropy essentially measures how many guesses an attacker will need to make to guess your password. As computing power increases, the amount of time required to guess passwords decreases, in many cases significantly especially…
