Database skills are essential in whatever organization and in whatever position and it is crucial that you have this in your arsenal (Resume')
Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database.
This is a hands-on course which will take you from installing SQL Server 2016 to learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL. The course covers most of the requirements to take Microsoft's certification (98-364), the Microsoft Technology Associate. During each meeting, you will be assessed for your knowledge, competency and proficiency in SQL.
What's new in this session: SQL Server Using Powershell JSON and XML
In my previous post, I showed how ArcGIS map may be embedded in a Power BI report using the
ArcGIS Map Control in Power BI. It is easy to embed and author a report easily.
I had used US Census data for the Hawaaiian Islands' water and land areas mapped to the Hawaiian Islands. However, I found features on the map which are obviously wrong.
Here are some feeatures I observed on the map, one of them is in the Phillipines and the other in India.
Power BI has an ArcGIS Map Control. This post shows how you may use it. The example of using publicly available data (Census Data: Hawaiian Islands) to be displayed in the ArcGIS Map inside Power BI.
"A review by The Associated Press of the backgrounds and social media posts of the 16 board members appointed by Interior Secretary Ryan Zinke indicates they will agree with his position that the best way to protect critically threatened or endangered species is by encouraging wealthy Americans to shoot some of them.
One appointee co-owns a private New York hunting preserve with Trump's adult sons. The oldest son, Donald Trump Jr., drew the ire of animal rights activists after a 2011 photo emerged of him holding a bloody knife and the severed tail of an elephant he killed in Zimbabwe"
Here is a piece of twisted logic supporting hunting, employing more people.
"A licensed two-week African hunting safari can cost more than $50,000 per person, not including airfare, according to advertised rates. Advocates say money helps support habitat conservation and anti-poaching efforts in some of the world's poorest nations, and provides employment for local guides and porters.
SmartCity, SmartHome, Smart... has entered out vocabulary in increasing frequency. Recently Home Automation has picked up a lot of traction with multiple players.
It is important to know how these automation products get their connectivity for control.
Some of the main connectivity options are:
Wi-Fi Bluetooth Insteon
UPB
Thread
Z-Wave
Zigbee
They all work with different protocols and platforms. One has to consider inter-operability while choosing one or the other. Cost, availability, ease of use and power consumption are also of concern.
Wi-Fi
It is widely used. Most homes have Wi-Fi routers and a wireless hub where they can connect to devices. Interference and bandwidth are the main issues as most people have already experienced. It is also high on power consumption. A real guzzler.
This has become very common as they are used in headphones, speakers and a number of other products. Bandwidth-wise,
Wi-Fi>Bluetooth>Z-Wave/Zigbee
Consumption of power-wise it is better than Wi-Fi. The new Bluetooth low energy or BLE has greater range and capable of forming mesh network and not needing a hub. This clearly has winning points for home applications as it supports encryption as well.
Devices using Insteon use both Power lines as well as wireless increasing pathways and introducing redundancy. Insteon is X10 compatible which makes it easy for those using X10. It does not have a high learning curve and non-technical folk can use it.
Here is a comparison sheet for some of the connectivity technologies:
Universal Powerline Bus(UPB)
Universal Powerline Bus(UPB) is a replacement for X10 with superior reliability and range (mile plus range). The signal rides piggy back over the powerline reducing cost for separate control lines. Although it replaces X10, it is not compatible with it. It is also incompatible with newer technologies like Wi-Fi, Bluetooth, etc. Lacking encryption, it is not as secure as wireless.
Z-Wave
Z-Wave runs on 908.42 MHz. It is one of the most popular home automation protocols and does not interfere with your 2.4GHz band devices. It is widely compatible with all Z-wave family of products. Compatible backwards and forwards. Setting up and using the devices are a breeze.
It is low cost, low power and can run on batteries. It uses the 802.15.4 Wireless protocol and uses mesh network structure. Zigbee 3.0 appears to be better for compatibility with Zigbee from others.
Thread:
Thread is an open, IPv6-based, low-power, secure and future-proof mesh networking technology (6LoWPAN) for IoT products. The Personal Area Network Thread protocol specification is publicly available. Images from TomsHardware site
