Loading...
Answers
MenuI am looking for SQL Database training materials and recommendations?
I need help finding a Relational SQL Database courses for junior engineers & product managers. They will help to build a data warehouse.
Answers
Tip: You'll only do this if you're a Thrillseeker looking to loose massive revenue.
You'll never, ever, ever turn over design of any business critical system to anyone in the class of "junior anything" who requires "SQL courses".
You'll have an experienced designer handle your SQL design.
To train your junior engineers and product managers you will find considerable help in the following sites:
1. The Complete SQL Bootcamp
This is an excellent SQL course for beginners. The course starts from scratch and does not require any previous programming skills or experience. As the name suggests, the course is inspired by Bootcamps and focuses on intense learning. It is also a comprehensive course and explains every single concept by using slides as well as live coding. The author uses PostgreSQL for demonstration purposes, which is both free and open source. It also comes with a GUI tool called PgAdmin, which makes it easy to work with the PostgreSQL database.
2. SQL for Newbs: This is another awesome and fun course for beginners to learn SQL. I really enjoyed watching this course, not just for content, but also for positive energy from both instructors, David and Pete. It is fun watching them discuss and explain SQL concepts. I know SQL is interesting, but they make it even more interesting. It is like old college days with some friends always jumping and doing stuff, which makes you laugh, but at least it helps remove boredom from the class. As for the content, as the name suggests, it is a beginner course, but you will learn all the essential concepts — e.g. creating a database, tables, stored procedures, using SELECT, INSERT, UPDATE, and DELETE statements. They use the MySQL database in this course, which is the most popular open-source database, and you can download that for free. They have a section for downloading and installing the MySQL database as well.
3. SQL & Database Design A-Z: This is another great course to learn SQL in depth. It covers almost all the topics an application developer should know about SQL. In this course, you will learn about creating basic SQL queries and different types of joins like right and left join, inner join, outer join, cross join, self-join, etc. This course also explains advanced concepts — e.g. indexes, writing SQL queries with multiple tables, and joining them together to produce a meaningful report. You will also explore database design concepts — e.g. normalization. This course has an entire section that explains normalization and various normal forms e.g. 1NF, 2NF, 3NF, BCNF, etc.
4. Oracle SQL: There is no doubt that Oracle is the most popular relational database, and there is a huge demand for people with good Oracle Database skills and experience — e.g. application developer who knows Oracle PL/SQL and a database administrator who knows the ins and outs of Oracle database. Whether or not you want to learn Oracle from an application development perspective or from a Database admin. perspective, this course is a good place to start. In this course, you will not only learn to create databases, tables, and stored procedures but also how to write SQL queries. You will learn essential SQL concepts in Oracle database — e.g. SELECT, INSERT, UPDATE, DELETE, and ALTER statements, joins, group by, where clause, and other functions.
It’s a comprehensive course with 100+ lectures and is well organized into 16 sections that will teach you all important SQL concepts using the Oracle database.
The instructor is good, and it uses free tools like Oracle SQL Developer, which you can download from the web. Overall, it is a good SQL course if you want to learn with the Oracle database.
5. 200+ SQL Interview Questions: This is an excellent course to learn SQL from an interview point of view. If you are preparing for your first job interview or next job, you can expect a lot of SQL questions on the interview. It is an important skill, and that’s why many interviews focus on SQL along with data structure and algorithms.
By taking this course, you will not only be well prepared for your next interview, but you will also learn a lot about important SQL concepts. For example, if you just watch the preview of one chapter, which discusses how to tune SQL query or how to find and explain the execution plan, you learn a lot.
6. SQL for Data Science — Coursera: If you are learning SQL for Data Science then this is the perfect course to start with. This is one of the best SQL courses on Coursera and teaches you SQL fundamentals and how to work with data.
This course is offered by the University of California, also known as UCDavis and it is delivered by instructor Sadie St. Lawrence.
Here are the skills you will gain in this course
a) SQL Basics
b) Data Analysis
c) Data Science
d) SQLite
Talking about social proof, more than 39% of learners have started a new career after completing this course, 34% have got a tangible career benefit from this course and more than 10% of people have got a pay increase or promotion. And, if you find Coursera courses useful, which they are because they are created by reputed companies and universities around the world, I suggest you get the Coursera Plus, a subscription plan from Coursera which gives you unlimited access to their most popular courses, specialization, professional certificate, and guided projects. It cost around $399/year but its complete worth of your money as you get unlimited certificates.
7. Building Basic Relational Databases in SQL Server Management Studio — Coursera: This is one of the best Coursera guided project which will teach you how to work with SQL Server using SQL Server Management studio in a step by step and guided manner.
In this one-hour based project, you will apply the basics of working with relational databases within the SQL Server Management Studio (SSMS) environment.
Here are the main things you will learn in this course:
1. Learn how to load the Adventure Works database into SQL
2. Create a database diagram using the Object Explorer window in SQL Server Management Studio (SSMS).
3. Create and run a simple structured query language (SQL) command to retrieve data from a table.
4. Create and run a simple SQL command to create a table and columns.
If you do not know Guided projects are new offering form Coursera where you learn by doing hands-on coding practice on the browser and your instructor guide you using split-screen lectures. This is a great way of learning as you learn a skill in a short time.
If you find Coursera courses useful then you can also opt for Coursera Plus subscription which provides unlimited access to Coursera courses, specialization, and professional certificates. It is actually a cost-effective way to learn in Coursera.
8. Complete SQL + Databases Bootcamp: SQL and know how to work with data is a valuable skill for almost any role and getting more valuable by the day and this is one of the best courses to learn SQL and Database fundamentals in 2020.
Created by Andrei Neagoie and his team, this course will teach you to master SQL and Database Management & Design + exercises to give you real-world experience working with all database types.
Here are the key things you will learn in this course:
1. How to create your own databases while using SQL to interact with the data
2. Learn how to handle user passwords and keep data safe
3. Advanced SQL topics like indexes, aggregates, caching to make your database queries efficient
The course is fully hands-on and there are tons of exercises to practice what you learn and test your knowledge. You will also learn how Machine Learning, Data Science and Data Engineers use Big Data and databases.
Besides if you do have any questions give me a call: https://clarity.fm/joy-brotonath
Hi, I am a primarily self taught developer and beside some of the old school reference books that were the mainstay of learning software development and server management I would say W3 Schools has a very could basic tutorial. If you are wanting to take people who have some basic understanding and advance them in their skills then some SQL specific classes on udemy or skill share is a good starting point. For even more advanced learning you really need to get into platform specific training such as from Oracle, Microsoft, or your platform of choice. I would be happy to discuss more options and understand your desired outcome over a call.
Related Questions
-
Which is the best hosted free bug tracking tool for a team size of up to 10 members?
Being a freelance developer for the last 10 years or so, I have seen and used almost every project management software you can think of, open-source and closed, and I have found that the "best bug tracking tool" completely depends on your process. I employ and direct teams in an Agile process that involves loose story-based requirements with point-based estimates, two-week cycles of iterative development, planning and retrospective sessions, and look-ahead and show-and-tell meetings with the stakeholders. It's important to me, then, that my tools have a method of capturing all those pieces with as much detail as I need but no more. On projects, I've successfully used Pivotal Tracker, Unfuddle, Redmine, Codebase HQ, Basecamp, Trello, and many others. I usually recommend people to Trello for light, agile management; it's essentially a digitized version of sticky notes and swim lanes. If your team actually needs a full-featured ticketing system, see Redmine (Rails), Trac (Python), or Mantis (PHP), depending on your language preference. Hosting a version of these yourself is fairly trivial, and numerous options exist for cheap or free hosted versions. For something in the middle, Github Issues is a good fit and the open-source clone GitLab.org replicates most of those features nicely. However, if you're looking for a hosted version, you're probably looking to offload that tricky "backup" thingy, and in that case, how important is your data? How proprietary? What's your business model? If you're working on an open-source project, Github will give your team a free account with private repos, issues, wikis, and the like. If you're okay with your project being "readable by all", public projects on Pivotal are still free. I'm mostly a consultant these days, leading small groups of junior or intermediate developers into a more productive, more mature, fully operational teams of senior software developers. One of the first things I teach folks is how to use a project management system... and why! It'll save your bacon if it's simple, effective, and reliable. With a few minutes of discussion about your project, I can probably help you select the right tool and service for your team. Let me know if I can help with that. Best of luck!DR
-
I have a great app idea, and I need help bringing it to life.
I'm not sure if this is how you imagine this world to work, but at least according to the order you wrote it "raising funds" was first. In reality it should actually be one of your final steps of the stage you are at right now. It may even come after a year or two! So you have this great app idea, and you're looking for a place to start... Don't! Don't start yet before you decide whether you have what it takes to get into a roller coaster that can ruin your life and make you miserable! Not trying to scare you but I think most people only hear about these great success stories. They have this dream of maybe, possibly, becoming the next big thing... Because they have the best idea for an app... You don't hear about the failures so often. And even if you do, you don't hear about what the founders of these failing startups had to go through. Truth is you are most likely gonna fail. And I'm saying that without even knowing what your idea is. There are so many barriers on your way that even a great product with a great team is likely to fail. Some people would say "I'm not afraid of failing", "It's good to fail cause you learn", "Failing will make me stronger for the next startup". That's somewhat true but it doesn't mean that failing is easy. As oppose to what people sometimes say - you do not want to fail! It's very painful!!! You have to understand what failing in a startup means. You can work your a$s for 2-3 years, have little to no salary, waste other people's money (most likely your friends and family first), lose friends, fight with your partners, your family, your spouse, devote 20 hours a day for your startup all this time, forget about the little and big things you used to enjoy in life, and only then, after debating 100 times whether you should quit or not, you finally decide that it's not gonna work and you've failed. Disappointing your family, your investors, yourself. Trust me it is painful. Are you sure you wanna do this to yourself? If yes, give me a call. I have the experience you need! From idea stage, to proof of concept, to running beta tests, getting millions of millions of users in ways you can't even imagine, creating features and experience that will make these millions of users completely addicted and viral, raise money in a smart way, hire the right people, find a great co-founder, succeed, fail, be persistent, and enjoy the ride! Good luck, RoyRM
-
What would be a good approach for marketing a software development businesses?
For software development business LinkedIn ads, content marketing and Google Adwords don't work well. The best and most cost effective method is email outreach. Try to find the contacts of key decision makers in Bay Area from your target companies. You want to present yourselves as custom mobile and web development specialists and highlight your core competencies to get an initial call to discuss their mobile strategy or software development needs. Attaching your case studies how you helped other similar businesses and your portfolio can be extremely helpful as well. Try to always focus on the benefits in you pitch that they can get by working with you and point their missed opportunities of not having certain types of software or apps for their business. Clients love that software development companies have not only strong execution but also ideation skills. Hope this helps. If you have any questions I am also available on call for your convenience.AA
-
How do I run a closed beta test for my mobile application? Development will be finished in 3 weeks.
You should try to engage people using social networks, it is easier to spread than email. The conversion rate on emails are low but is still a valid tool for that. Send and email with a simple and objective message that will make people want to try. The best way to have feedback from users is to watch them use the app. You should put them on the hands of everybody that you can and without any instrucions and just watch, don´t even say that the app is yours. Try to do it a lot. If you want feedback from others, you can include the feedback form inside the app and suggest users to answer occasionally. I would also strongly recommend to use a tool as Flurry Analytics. Is the best way to get data from how is the use of the application. Pay attention to those data and be open to change your app a lot, you may need more features or cut some off to make it easier to use. If you need more help please contact me.BS
-
How can I take an idea for a new app and turn it into a real product?
Here are some options: ___Free Options___ 1) Make apps without needing to spend a lot of time learning to code. Look into "MIT App Inventor" (http://appinventor.mit.edu/explore/). It's a very _easy_ way to make pretty complex apps using drag and drop coding. You can find youtube tutorials that will show you how to make your first app within 5 minutes. I've used MIT App Inventor to make prototype apps for many of my ideas, saving me tens of thousands of dollars if I paid a dev to do it instead. Learn to do "real" coding yourself. The main investment will be your time. There are plenty of free resources for learning coding on the web. I'd suggest learning "React Native", it's a relatively new way to code apps, which allows you to make one app that will run on both Android and iOS. 2) Find a software engineer cofounder. Go to Meetups, conferences, local hackerspaces / makerspaces. Hang out on relevant online forums (e.g. https://www.reddit.com/r/startups/ make sure to read their rules for posting before posting though). It won't be easy to find a tech cofounder, your idea will need to be amazing, and you yourself will need to be very passionate and capable in order to convince someone to partner up with you for sweat equity. ___Paid options___ 1) Use developers with less established reputations / portfolios (lower cost, higher risk) Be very wary of freelancers on sites like Upwork, Fiverr, etc. Here are some basic hiring rules: In your hiring script, make sure to ask for all applicants to give their account name for github/bitbucket and Trello. Don't hire agencies, only hire individuals. To get hired, ask them to do a simple task via Trello and submit the code via github/bitbucket. This task should only take them maybe 1 hour. Check the quality of what the applicants and if they deliver it in a timely manner. Keep the 1 or 2 people that do a good job. If you don't do this vetting these "low cost" developers may end up costing a lot in the longer run. 2) Use developers with more established reputations / portfolios (higher cost, lower risk) With this option your app will probably cost > $20k to develop, but it can be worth it if you have a single idea that you know you want to move forward with. I can introduce you to a very high quality developer in NY if you're at this stage. Let me know if you'd like any additional help more tailored to your specific app ideas, best, LeeLV
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.