Python MySQL
https://www.w3schools.com/python/python_mysql_getstarted.asp Download and install “MySQL Connector”: C:\Users\Your Name\AppData\Local\Programs\Python\Python36-32\Scripts>python -m pip install mysql-connector-python
Julian.Kellett
Skills needed to be a Data Engineer
A data engineer develops and constructs data products and services, and integrates them into systems and business processes. https://ddat-capability-framework.service.gov.uk/role/data-engineer You will need the following skills for this role, although the level of expertise for each will vary, depending on the role level. Data Engineer A data engineer delivers the designs set by more senior members … Read more
Skills needed to be a data scientist
Data science is a broad and fast-moving field spanning maths, statistics, software engineering and communications. Data scientists will often work as part of a multidisciplinary team, using data and analytics to inform and achieve organisational goals. In this role, you will: be inquisitive explore and visualise data make recommendations to address complex problems and to … Read more
Skills needed to be a Data Analyst
A data analyst collects, organises and studies data to provide business insight. https://ddat-capability-framework.service.gov.uk/role/data-analyst In this role, you will: You will need the following skills for this role, although the level of expertise for each will vary, depending on the role level.
How to Connect Python to SQL Server using pyodbc
https://datadiaries.dev/connecting-to-microsoft-sql-server-using-sqlalchemy-and-pyodbc
How to Run a Python Script in PHP
https://www.linuxshelltips.com/run-python-script-in-php/
Size all tables in volume
DECLARE @name VARCHAR(128) DECLARE @myList TABLE ([row] int, [id] int,[Name] VARCHAR(128)) ; DECLARE @myResult TABLE ([row] int, [Name] VARCHAR(128), [Value] VARCHAR(128)) ; INSERT INTO @myList ([row], [id], [name]) SELECT row_number() OVER(ORDER BY o.name), o.id, o.name FROM dbo.sysobjects o join sys.all_objects syso on o.id = syso.object_id where o.name like ‘f_uks_%’ and type_desc = ‘USER_TABLE’ DECLARE @total … Read more
rukovoditel.net licence key
rukovoditel.net licence keycode(x) * (len(domain)+code(0))localhost126361298711583113491263612168129871345513572l 108 9 108 12636o 111 9 108 12987c 99 9 108 11583a 97 9 108 11349l 108 9 108 12636h 104 9 108 12168o 111 9 108 12987s 115 9 108 13455t 116 9 108 13572 vip.dev.helastel.net1628414490154566348138001393816284634814352139381490413386158701600813938149046348151801393816008v 118 20 118 16284i 105 20 118 14490p 112 20 118 15456. 46 … Read more
myHelastel install
myHelastel is based on an app called Rukovoditel https://www.rukovoditel.net/ Download https://www.rukovoditel.net/download.php?action=download un-pack this in <host www> source folder MySQL Requires mySQL database Database details are in config/database.php Extension the extension is the ‘pro’ component and this is where the /plugin folder becomes active extn 3.2.1 https://www.rukovoditel.net/download_ext.php?t=1668071540 un-pack this in the folder/plugin This requires a licence … Read more