Loading...
Answers
MenuNeed easy cloud based SQL service for non-SQL user.
I want to download a set of data into excel, about 50,000 records, which can only be downloaded using SQL. What cloud based, or other service could I use? I need bi-monthly updates and need the data converted to Excel.
Answers
PhpMyAdmin would probably work for this.
http://www.phpmyadmin.net/home_page/index.php
Lots of hosts have it pre-installed.
Excel can import CSV files, and most databases can dump data as CSV. You could potentially use something like Sequel Pro locally to do this.
Honestly, without knowing the WHY behind the need, it's tough to say what the right solution is.
Really, manually syncing an Excel document back and forth with a database seems like a complex and fragile solution to a problem. Is it possible you could remove the Excel sheet from the equation? Or use Google Sheets to make it available collaboratively online?
Depending on the problem you're trying to solve, there's probably a much easier solution that a SQL import/export.
I'd be happy to go over solutions and help you find a simpler way to solve this problem if you'd like. Just tag me for a quick call.
Good luck!
Lot of missing info in this question.
Like, how data will be accessed (frequency).
This will determine your SQL storage engine type + table structure.
You can also adjust your table structure to protect against duplicate entries.
This is important, if it takes a long time to load your data. If you setup your structure to only allow unique data, then you can just upload your new data, without having to "drop" (destroy) your old data.
This can potentially speed up your data loads considerably, especially if you're using cheap/slow hosting for your database.
Likely good to give equal consideration to how data is used first + data loading.
Related Questions
-
Will a startup only focused cloud accounting software work that also provides metrics for the startup?
What financial metrics would startups use?
Recently launched Subleger http://subledger.com/ is trying to do some or all of what you describe. It doesn't mean that there isn't room for others but consider that many early-stage companies don't have complex revenue in-flow so the core of what you're describing (converting or merging income into other operational metrics) might not have a wide appeal especially for startups. Hopefully you get some good answers here but really whatever anyone (myself included) says here is far less valuable than asking startup CEOs what their financial painpoints are with respect to reconciling their app's internal metrics with revenue and expenses. Finally, the question "is the market big enough" is too open-ended to answer for you. Big enough for what? To attract significant outside funding? Maybe not big enough. But to build a great income for you and a few others? Perhaps! Happy to discuss this with you further to help you in your evaluation of the opportunity but as I say, best thing to do is canvass the potential market first.TW
-
Where can I learn SQL for business professionals? I need only the reporting part. I can run basic queries, but want to do more heavy queries.
There are a few options. If you've done the basics through Codecademy, then you're ready to move on to the specifics of a platform (such as PostgreSQL as you've mentioned). Though this can equally be a minefield. The reporting engines/formats differ from platform to platform. As does SQL believe it or not, in the sense each of the mainstream vendors adds their own specific bits to the standard. They are all compliant for the basics though. All of them will support the latest version of SQL (ANSI standard 2011), but PL/SQL is different to Transact-SQL in the way it uses cursors. In addition, each has an even bigger variation when it comes to multidimensional queries such as MDX, since there is no standard for MDX and some vendors use their own expressions and languages to carry out such queries. I can certainly help with tutoring, having been working in SQL since 1997 (and still do), although I think it's worth focussing on getting a little better at the specifics of the SQL vendor extensions you want to use, including their Cube, Pivot and Grouping functions as well as more complex joins, as they'll be the baseline skills for future reporting exercises, including analytical processing.EA
-
Sou novo na plataforma e como poderia receber mais chamadas com interesse em Excel?
Olá! Boas-vindas à plataforma! Entendo que você é novo e quer atrair mais chamadas de pessoas interessadas em Excel. Para te ajudar a receber mais contatos relevantes, aqui estão algumas estratégias que você pode implementar: 1. Otimize seu Perfil: Título Claro e Conciso: Use um título que descreva exatamente o que você oferece em relação ao Excel. Exemplos: "Especialista em Excel | Aulas Particulares | Consultoria", "Professor de Excel | Do Básico ao Avançado", "Desenvolvedor de Planilhas Excel | Automação e VBA". Descrição Detalhada: Descreva suas habilidades em Excel, sua experiência, os tipos de serviços que oferece (aulas, consultoria, desenvolvimento de planilhas, etc.) e para quem eles são direcionados. Destaque seus diferenciais e o que te torna único. Use palavras-chave relevantes como "fórmulas", "macros", "VBA", "Power Query", "Power Pivot", "dashboards", "automação", "planilhas financeiras", etc. Foto Profissional: Use uma foto de perfil profissional e amigável. Portfólio (se aplicável): Se você tiver exemplos de planilhas que criou ou projetos em que trabalhou, inclua-os em seu perfil. Isso demonstra sua expertise de forma concreta. 2. Utilize Palavras-chave Relevantes: Identifique as palavras-chave: Pense nos termos que as pessoas usariam para procurar por serviços relacionados a Excel. Exemplos: "aula excel online", "curso excel avançado", "consultoria excel empresarial", "desenvolver planilha excel", "automatizar tarefas excel". Incorpore as palavras-chave: Use essas palavras-chave em seu título, descrição, tags (se a plataforma permitir) e em qualquer conteúdo que você publique. 3. Ofereça Conteúdo de Valor: Publique conteúdo relevante: Compartilhe dicas, tutoriais, exemplos de planilhas, artigos ou vídeos sobre Excel. Isso demonstra seu conhecimento e atrai potenciais clientes. Interaja com a comunidade: Participe de fóruns, grupos de discussão ou responda a perguntas sobre Excel na plataforma. Isso aumenta sua visibilidade e te posiciona como um especialista. 4. Promova seus Serviços: Divulgue seu perfil: Compartilhe seu perfil em suas redes sociais e peça para amigos e contatos compartilharem também. Ofereça um "gancho" inicial: Considere oferecer uma primeira consulta gratuita, um desconto inicial ou um material gratuito (como um ebook ou um modelo de planilha) para atrair os primeiros clientes. 5. Seja Ativo na Plataforma: Responda prontamente às mensagens: Demonstre profissionalismo e interesse respondendo às mensagens o mais rápido possível. Mantenha seu perfil atualizado: Revise e atualize seu perfil regularmente para garantir que as informações estejam sempre corretas e relevantes. Exemplos de como aplicar as dicas: Em vez de: "Dou aulas." Use: "Professor particular de Excel com foco em planilhas financeiras e automação com VBA. Aulas online para todos os níveis." Em vez de: "Manjo de Excel." Use: "Consultor especializado em Excel com experiência em desenvolvimento de dashboards interativos e otimização de processos com Power Query e Power Pivot." Recursos Adicionais: Pesquise na própria plataforma por perfis de outros profissionais que oferecem serviços relacionados a Excel e veja o que eles estão fazendo bem. Explore ferramentas de pesquisa de palavras-chave (como o Google Keyword Planner) para identificar os termos mais buscados relacionados a Excel. Lembre-se que construir uma presença online forte leva tempo e consistência. Seja paciente, continue aprendendo e aprimorando suas habilidades, e os resultados virão. Boa sorte!AG
-
excel anyone know the cengage test?
Cengage Learning Testing Powered by Cognero is a full-featured, online assessment system that allows instructors to create tests from publisher-provided content as well as write new questions.TM
-
What type of people are hiring companies to build mobile/web/cloud applications? Which of them have a good budget?
There's 2 types of customers for this segment that have a decent budget. 1) Funded tech startups (i.e. Anyone that recently closed a round on www.angel.co) 2) Digital agencies (or their clients) who want to build a mobile app for marketing or convenience purposes. So for #1, you can target anyone who likes sites like Angel List, Gust, etc. For #2, you can get a list of digital media agencies and run ads against them. All that being said, the best way to pull them into your funnel is to create some AMAZING free content like an infographic, video or webinar that demonstrates why you guys are the best company out there. So teach them something about mobile marketing that they had no clue about - then close them at the end. Hope that helps.DM
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.