SQL database tutorial: relational database, schema, table, SQL data types, SQL constraints, RDBMS скачать в хорошем качестве

SQL database tutorial: relational database, schema, table, SQL data types, SQL constraints, RDBMS

Watch this SQL tutorial to learn the key terms - SQL database, schema, table, and fields. Find out what’s the difference between SQL vs. no-SQL dbs. Discover what a relational database management system (RDBMS) is and how it is different from the database. If you are interested in a particular topic, click on a timestamp to move right to it: 00:50 - The most common tasks you can perform using SQL (CRUD operations) 1:25 - What is a SQL database 1:39 - SQL vs. no-SQL databases 2:12 - SQL schema 2:29 - SQL tables 3:02 - SQL table structure: fields (columns) and records (rows) 3:27 - SQL data types 3:46 - SQL constraints: NOT NULL, DEFAULT, UNIQUE, PRIMARY KEY 5:16 - Database management system (DBMS) vs. database 6:29 - Relational database management systems RDBMS examples (MySQL, postgreSQL, Oracle db) 6:49 - no-SQL DBMS examples 7:05 - How to work with RDBMS: graphical user interfaces, connectors, apps 8:50 - 10 key statements about SQL Learn SQL with Railsware Academy. Subscribe to our channel and follow the SQL YouTube course. 🧐 Try Coupler.io - a tool for safe data imports from various tools to GSheets: https://bit.ly/sqldb-couplerws 🔌 Download Coupler.io in GSuite marketplace: https://bit.ly/sqldb-couplermp 💌 Contact Railsware to build your software product http://bit.ly/contactrailsware 🤝 Join Railsware team http://bit.ly/railswarecareers ✅ Subscribe to Railsware and learn the most efficient data analytics tools with us! Design: Vlad Shagov Video editor: Oleg Gorovoi Speaker: Anastasiia Avramenko