Data Research Labs. My "scratchpad in the sky" for sharing tools, tips, and tricks. Topics range from data analysis to data science, from SQL to Python to R, and from tools to techniques to scripts. Goal is to share simple, useful information.
I spent almost an entire day evaluating XML files that were crashing an application. Eventually, my suspicions turned to bad hidden characters. Sure enough. This was extremely helpful. Thank you!
Hey Thank you but this script is having some errors Like Msg 10757, Level 15, State 1, Line 82 The function 'STRING_AGG' may not have a WITHIN GROUP clause. Msg 10757, Level 15, State 1, Line 95 The function 'STRING_AGG' may not have a WITHIN GROUP clause. Msg 156, Level 15, State 1, Line 115 Incorrect syntax near the keyword 'AS'. Please help
Great video. Was really considering and wanted to do the university of Texas Austin computer science. But went with data analytics at WGU. Started this month already almost done with my second class. Plan to finish within the first 6 month term.
can you please clear my doubt, to get the certificate should we need to complete all the 9 curses ?....or can i get certificate for each course separately
I am 76 and retired. My career took place while the digital spreadsheet was developed and improved. I started with VisiCalc, like mostly everyone else. I too, used Lotus 1-2-3 when I was in a PC environment, but when I moved to Mac, Excel became my go-to spreadsheet. I can attest to what you said about ROI on time invested learning Excel. Today, I don't need the full power of Excel any more, but use a spreadsheet daily to keep track of my own finances on a spreadsheet born in the late 90's. I use Numbers now, since it is free with my computer. Plus, Numbers uses almost all the same commands as Excel, with some minor differences, so I didn't have to learn a new spreadsheet from the ground up when I switched. For those who are on a budget, Open Office has a free online spreadsheet, very similar to Excel. As a CFO in the 80's, 90's, and 00's, Excel was the single most valuable tool that I had available. I still have a very large paper spreadsheet that I did in 1980 to remind me not to take Excel for granted.
Sir, please can you let me know if data science still have a good perspective in the futur ? Will it be replaced by AI tools in the 5 next years ? I would like to specialized in computer vision and data science but i m afraid to be replaced by robot in the futur. Cant wait for your answer. Thank you in advance.
Awesome! are there any transferable credits from certificates that count as classes? if so, which ones? I heard there are two but no one has told me which ones lol
Hi, thanks, it’s very useful. Do you have a version that use DBMS specialized packages to automatically generate a SQL file to sync database schemes structure ?
I really enjoyed your teaching method! it will be great to see a tutorial on a full text search with postgresql.. something like searching book content..
Great video! Can I get your opinion about this degree for someone switching careers? I have some experience working in IT but my bachelor's is in Biology. I want to do a master's degree because I would be applying for financial aid. Do you think employers would take me seriously as a Data Analyst if my undergrad isn't really relevant? Thanks!
After 13 years, my husband with an MBA is making barely more than a teacher salary. He has a great deal of experience analyzing data, but a lot that he doesn't know in the computer programming section. Would this help him pivot careers?
@DataResearchLabs Do have you a MSSQL Script to generate Tables, Functions, Stored procedure for PostgreSQL Conversion of MSSQL table, views, functions and stored procedure into postgreSQL
great video. thank you! do you know how to create a query that joins 2 tables from 2 different DB systems? also, I created a connection to an excel file. I want my query to join between a DB table and this excel connection. How do I do that?
