|
via Udemy |
Go to Course: https://www.udemy.com/course/sql-mysql-for-beginners-analyse-and-manipulate-data/
SQL is a standard language for accessing and manipulating databases.Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsMost of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!MySQL is a very popular open-source relational database management system (RDBMS).MySQL is a relational database management systemMySQL is open-sourceMySQL is freeMySQL is ideal for both small and large applicationsMySQL is very fast, reliable, can be scaled, and easy to useMySQL is cross-platformMySQL is compliant with the ANSI SQL standardMySQL was first released in 1995MySQL is developed, distributed, and supported by Oracle CorporationMySQL is named after co-founder Monty Widenius's daughter: MyHuge websites like Facebook, Twitter, Airbnb, , Uber, GitHub, YouTube, etc.Content Management Systems like WordPress, Drupal, Joomla etc.A very large number of web developers around the world use MySQL in their development.