So, I decided to share some knowledge about relational / no relational databases among my colleagues. Therefore I begun a course of lectures for selected databases based on my new courses at Kazan Federal University.
Under the invitation of the company a series of lectures were held on introduction to the language of SQL for project managers. The lectures included theoretical and practical parts on the theory of relational databases.Before the lectures commenced, the DataLab…
How to find and analyze a SQL bottlenecks of incoming traffic from performance plan / profiling perspectives on a production system? This question is simple if you have a similar pre-production environment with name “load-test” and you check all new…
Actually, there are secure restrictions to see client / user / etc. PII (Personally Identifiable Information) data from inside and outside of company (one of restrictions is for example GDPR law). Ekaterina made a research how to restrict data inside…
Sometimes a company and startup do know all details about incoming traffic. The reasons may be various. In the past we could ignore this thing, because we had only one opportunity with serverfull approach. We were creating a new physical…
The AWS Educate Student Ambassador Program provides student leaders from around the world the opportunity to gain real-life experience while helping their peers gain valuable Amazon Web Services (AWS) technical skills to develop successful cloud careers. Students from my DataLab…
Hi there! Sometimes, we need to know how many UNIQUE rows exist in a table. In a Relational Database World there is a simple but high-costly action for DB engine level (for example DISTINCT or GROUP BY with subquery). The…
Hi there! You can find out here my 10th lecture of “Introduction into Relational Databases” course. Please if you have some comments / questions or remarks , just let me know about it. Thanks!
Hi there! You can find out here my 9th lecture of “Introduction into Relational Databases” course. Please if you have some comments / questions or remarks , just let me know about it. Thanks!
Hi there! You can find out here my 8th lecture of “Introduction into Relational Databases” course. Please if you have some comments / questions or remarks , just let me know about it. Thanks!