Комментарии:
Thank you for everyone's feedback on this video. The intention of this video was to compare the UI and management tools for each of these, but the title and thumbnail was not representative of that. I updated the title and thumbnail to reflect it better. I do plan on diving into the actual databases to look at things like scalability, speed, and more. Thank you again for your feedback!
ОтветитьHey Alex. Avid consumer of your content here!
I am sorry Alex but I have to say something... you kept on referring to MySql, Postgresql, and Microsoft SQL Server Management Tools as SQL, or types of SQL.
MySql, Postgresql, and Microsoft SQL Server are database management systems, NOT SQL. These 3 database management systems store data using the relational model, thus they are also referred to as relational database management systems.
SQL is a query/programming language. It is the standard language for relational database management systems. Thus your SQL knowledge can be used/applied to any of these 3 relational database management systems.
Peace! 🙂
This is really helpful for me as I am studying and trying to get in the analytics field, knowing which to focus on is really useful. Thanks Alex.
Ответить@AlexTheAnalyst Is there a version for mac users ?
ОтветитьStandard SQL is called “ANSI” Standard (DB2). PostgreSQL follows the “PL/pgSQL” SQL Dialect (similar to Oracles flavor - but Im reading DB2 now supports PL/1 too). Transact-SQL was created by a company called “Sybase.” Microsoft as is their pattern “partnered’ with Sybase and basically took their tech to make MSSQL-Server. To day MSSQL-Server is my favorite flavor of DB - but I’ve been in Oracle/PostgreSQL recently.
ОтветитьHow about MariaDB?
ОтветитьHi, mysql es down in the principal page. Any other page to download MySQL?
ОтветитьTalking about importing the files into server SQL server is the best we don't need to take care about the data it takes all the data but and no need to convert to csv if it's an excel file.
comming to postgresql it's a pain we need to input all column names even after inputing all the columns there is no gaurantee that the file will import without errors we need to take care about the formatting of the csv such a large porcess
And comming to MySQL the import is some what easy but when exporting a large data set it sucks and takes more time even after waiting for the import for me sometimes it doesn't import any data these were faced 8n MySQL workbench,for MySQL we can use dbeaver which is better than MySQL workbench and import time a lot faster
Great review. Thanks.
ОтветитьThanks for the video. I use SSMS with TSQL for work, but want to create something myself and don't want to pay. Although there are free options with Microsoft, I would like to not worry about scaling up. Think I might test out MySQL.
ОтветитьThis is me right here... my college DB course textbook was in Oracle, the class project was in MySQL, and now my internship is SQL Server
ОтветитьMy biggest issue with postgre is importing data and the quotation marks.
I had to create the table Schema with exactly same column before it will work.
Alex, before finding you out i learned MySQL and would like to do your portfolio projects in MySQL, can you please guide me a bit there?
ОтветитьMySQL for small to mid-size business with a regional focus.
Postgress for National and International focus. Best for this type of relational large scale database.
MS SQL for a National and International focus, plus the MS discount for mixing it with Azure and Office 365. Best for those all into using Microsoft only.
Thanks for your honest review Alex...
ОтветитьThank you so much, Alex. I have a question. I uploaded a data containing more than 1000 rows. I want to see all rows, but it always return 135 rows. How can it happen?
ОтветитьI don't think the words: "SQL" and "Database" mean what you think they mean...
ОтветитьAnother great video! Your channel is truly amazing for someone trying to get into the world of data analysis (like myself)! Also extra points for the office reference in the data! ;)
ОтветитьI've used SQL Server at extremely large scale (taking in 1TB of data per day) and MySQL at very large scale. You get what you pay for. The performance, tools, configurability, SQL features, stability, etc are vastly better with SQL Server. It's not even close. I've only used Postgres in small instances but I would choose it over MySQL.
ОтветитьCould you please zoom in while typing?
ОтветитьHey Alex, can you make a video on importing and exporting data in each of these SQL?
Ответить