Creation and Design of MySQL Schema Objects Required Knowledge > Design and create normalized databases > Create and modify tables using appropriate data types and indexing > Describe and create table constraintsRead More…
Required Knowledge > Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words. > Identify MySQL data type properties and appropriate usage > Recognize and useRead More…
General MySQL Syntax Required Knowledge > Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words. > Identify MySQL data type properties and appropriate usage >Read More…
MySQL Architecture Required knowledge: > Use MySQL client programs to interface with the MySQL Server interactively and in batch > Describe SQL Modes and their impact on behavior of MySQL > IdentifyRead More…
I couldn’t really find an exam prep tool for the MySQL 5.6 Developer Exam, so I decided to create my own. I figured if I had something online, then I could study anywhere,Read More…
When I first ran across Events in MySQL, I wondered what I could use them for, particularly things I normally did with PHP or Python. In most instances where I am loadingRead More…
When I purchased my BMW F800GS (2009 model, instead of this one), it came with Continental Trail Attack 2 tires on it. After having worn them out in various riding conditions, I thinkRead More…
Cookies are designed to be a string, and often contain just one key/value pair, or get serialized into a string delimited by semi-colons or commas. On one of my sites, I’m updatingRead More…
Components are going to be the way to do things in Angular 2, but I’ve got plenty of apps that are still using Angular 1.x, so to make my code more re-usableRead More…
I’ve been rebuilding one of my sites to use Angular, and had attached my controllers to several endpoints that returned a variety of data models. I built the endpoints following the principle ofRead More…