Hello Everybody, In this Databases A2Z channel share events, tutorials, courses, talks, webinar, code talk... related to Database, Database Design, Database Development, SQL, MySQL, Oracle SQL, MongoDB, Apache Kafka, Database Programming, SQL Server, Oracle Certification, Database Management, PostgreSQL, Pl/SQL, Oracle Database, Business Intelligence, Oracle, Database Administration, Snowflake, Database Management System, T-SQL, Elasticsearch, SQLite, Microsoft SQL, Java, Python, PHP, NoSQL, Data Analysis, Big Data, JavaScript, Web Development, Cloud, Cloud Computing, and more... If you feel useful for you and for all, please subscribe and share it! We work hard to bring useful information for you. If you have any questions, sharing ideas ... Get in touch with us. Thank you many! -- Before report, please send email for us. I appreciate your nice play! Email: topmank9@gmail.com
how can i solve this error ? Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=GjNCEiZvSz67JdYsugt2/Q==)
I had sql developer tool working like a charm for years. Recently I got a new laptop and got sql developer installed and now it became too slow and it takes almost 30 minutes to run a simple select query. Do you see any configuration change could fix this issue?
nodejs-mssql switching database name using username and password login? Supposed that we build nodejs with mssql And we have multi users that using our application and also multi databases, each user must be connected to their own database , I want to check and verify with their username and password, more over I 've created one database name: database_headquarter to store other info like username, password, server_name, database_name, database_user, database_password). It's mean that the first login all users must be point to database_headquarter first , then check real using database in database_headquarter and after that point to their own database. The problem is that I want switching to new database name according to their username and password (but I can access only 1 time of new Database name) I'm very new in node-mssql. But thanks for your feedback. And I have one more question, if we have 1000 users so will we also need 1000 connection pools?(1000 users refer to access to different 1000 databases name)
I got this error on import/export data process. Process failed Copying table data 'public.company_data' on database 'dvdrentals' and server 'PostgreSQL 14 (localhost:5432)' What should I look for?
1:00 who is Pete 1:27 setting expectations 2:19 course modules Module 1: *Brief Introduction* 3:33 core concepts 5:19 *database* - what is it (definition) 7:26 *database table* - example (definition and a picture) 8:29 *relational database* (what is it, primary keys, foreign keys) 10:51 *DBMS* (Database Managment System) 12:38 *database server* 15:48 *SQL Server Management Studio* (SSMS) 20:58 practice with SQL Server Management Studio 24:55 schema 25:47 data modeling is important, learn it by yourself 😜 27:52 summary 29:50 break Module 2: *Relational Concepts* 30:03 *Normalization* 33:50 1st normalization 34:52 2nd normal form 35:45 3rd normal form 36:42 4rth normal form 37:00 example of normalization (1normal form) 38:23 example of normalization (2 normal form) 44:05 *Referential Integrity* 51:18 methods for enforcing referencial integrity 52:47 *Constraints* 52:48 primary key constraint 54:43 key relational structure with keys 1:02:15 example: creating CD db table 1:11:11 *SUMMARY* 1:14:05 break Module 3 1:14:14 *Creating Databases and Database Objects* 1:16:46 data types 1:18:38 unicode data types
the example you took to explain why we not use files to use large amount of data. In that you say told to assume that if we have same age for a user stored in two files then we might miss to update the new age in any of them. But it's not that good of an example - 1. what if we manage file-system such that we keep all personal details in one file and all other not to be updated repeatedly information in other files. 2. Why can't we keep just one file for one single user (no matter how big that file gets).
Hello, i'm using a MacOS but never manage to make Oracle SQL Dev. tool working on it... i always get an error message when trying to add a DB. Like this: "The Network Adapter could not establish the connection"
Great lecture, thank you so much for your work! I have a question, when I use oracle sql at work, why tables showing filtered and not showing? How to make them appear?
Timestamp : 0:01 Introduction 11:49 Entity and Column 19:45 Entity in Detail 33:59 Column in Detail 51:00 The Three-Levels of ER Model 56:23 Key and Relationship 1:14:32 Database View 1:22:42 Database Trigger and Stored Procedures 1:30:36 Generate Database 1:49:23 Patch Database 1:57:16 Reverse Database to ERD 2:07:20 Hibernate 2:24:15 Database Design Best Practices 2:32:57 Generate Data Specification