5. Structured Query Language (SQL) - Complete Introduction
Review of previous lecture. Working on MS Access. File based Vs relational database management system. What are the advantages of RDBMS? Indexing, security, optimization, integrity, backup. Anomalies in non RDBMS system. What is insertion, updating and deletion anomaly? Types of databases: RDBMS, OO database, graph databases, NoSQL databases. What is a query? What is a table? Tuple, column. Primary key. Foreign key. What are triggers/ indexes? Creating a database in MS Access. Creating tables, inserting data. Executing queries. Select, alter, update, delete clause. Specifying where clause. Add a column, drop a column in a table. Insert clause. Using like clause. Specifying alias. Aggregate functions. Uppercase string, round number functions.
These videos were recorded as part of the Track 2 of 1 year Data Science course by Aladin Academy. The trainer was Prof. Dr. Noman Islam. The full playlist can be seen at: • Object Oriented Programming using Python
#MS access #select #update #delete #alter #SQL #aggregate functions #dr noman #aladin academy
На этой странице сайта вы можете посмотреть видео онлайн 5. Structured Query Language (SQL) - Complete Introduction длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Noman Islam 15 Декабрь 2022, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 23 раз и оно понравилось 0 зрителям. Приятного просмотра!
