You get a bonus - 1 coin for daily activity. Now you have 1 coin

Databases, knowledge and data warehousing. big data, dbms and sql and nosql

All lectures: All lectures on the discipline: databases, knowledge and data warehousing. big data, dbms and sql and nosql are collected here. These fascinating lectures provide us with the opportunity to explore the deep principles and phenomena underlying our knowledge and our desire to understand the world.


1. Database and knowledge. types of databases. relational and non relational
2. Relational DB. types of normal data. Database normalization
3. Distributed and parallel database systems
4. Graph database NEO4J create, insert, delete, edit.Cypher
5. Explaining how SQL JOIN works using the Venn diagrams as an example
6. Explaining SQL UNION using the Venn Diagrams as an Example
7. Sets, relationships, fact table in relational databases
8. Basic concepts of the relational data model
9. 4. Relational algebra
10. 5. Elements of the SQL language
11. 6. Normal forms of relationships. Database Design, Types of Normal Forms
12. 7. Normal forms of higher orders
13. 8. Elements of the model "entity-relationship" ER-diagrams in databases
14. 9. Transactions and database integrity
15. 10. Transactions and concurrency
16. 11. Transactions and data recovery
17. ORM object-relational mapping,
18. MySQL InnoDB and MyISAM locks
19. Blocking (DBMS) Pessimistic Optimistic Joint Exclusive Lowercase Granular
20. questions and answers for the MYSQL interview in English
21. 1. The concept of a database
22. 2. Database structure
23. 3. Relational databases
24. 4. Conceptual database model
25. 5. Transformation of model into relational
26. A few words about database design.
27. Briefly about relational databases
28. Infologic DB design. Entities, objects, properties, relations
29. Data models Early approaches to data organization
30. Database Design
31. Storage Structures and Access Methods
32. Types of subqueries (subqueries) in SQL
33. Connections and set-theoretic relations on relations
34. Requests using connections
35. Theory of Data Synchronization in Computer Science
36. Transaction isolation level
37. index types Oracle, MySQL, PostgreSQL, MS SQL
38. Organization of client-server data synchronization for a mobile application
39. Multidimensional database technology
40. Big Data Part 1: Principles of working with big data, the MapReduce paradigm
41. Big Data Part 2: Hadoop
42. Big data. Part 3: Techniques and strategies for developing MapReduce applications
43. Big Data from Part 4: Hbase
44. Approaches to processing big data (Using only a detailed fact table, the method of chain interaction of documents, the relationship of tables through triggers)
45. big data
46. Big Data. Part 5.1: Hive - SQL engine over MapReduce
47. Big Data Part 5.2: Advanced hive features
48. The main functions of ETL-systems
49. Statistical analysis in PostgreSQL using PL / R
50. PostgreSQL - database overview, basics
51. Multi-user database processing systems
52. The concept and architecture of the distribution of databases. Homogeneous and heterogeneous raBD. Data Distribution Strategies in DBA
53. Distributed DBMS (RDBMS). Twelve rules of K. Data. Advantages and disadvantages of RDBMS
54. Types of data access interface (D) base
55. The concept of data storage (DS). Differences between data warehouses and databases
56. B. Inmon data warehousing classification
57. Data Warehouse Technology Solutions . Key Data Warehouse Architecture Approaches
58. Database users. Multi-user database problems. Database Administrator Functions
59. Relevance of database protection. The causes of its destruction. Legal protection of databases
60. Database recovery (using database backup, using transaction log, recovery via rollback, roll forward)
61. Database Optimization
62. Extract, transform, load (ETL)
63. Persistent data structures
64. Denormalization as a means of increasing productivity. Denormalization implementation
65. The N + 1 selection problem in object-relational mapping (ORM)
66. SQL Antipatterns