<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by InFocus Engineering on Medium]]></title>
        <description><![CDATA[Stories by InFocus Engineering on Medium]]></description>
        <link>https://medium.com/@infocuslabs?source=rss-1173c47a744c------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*IOxlaSnydimudeZ-9UBjgg.jpeg</url>
            <title>Stories by InFocus Engineering on Medium</title>
            <link>https://medium.com/@infocuslabs?source=rss-1173c47a744c------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 01:33:59 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@infocuslabs/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Applied AI Engineering]]></title>
            <link>https://infocuslabs.medium.com/agentic-engineering-a845785aa13f?source=rss-1173c47a744c------2</link>
            <guid isPermaLink="false">https://medium.com/p/a845785aa13f</guid>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[deep-learning]]></category>
            <category><![CDATA[applied-mathematics]]></category>
            <dc:creator><![CDATA[InFocus Engineering]]></dc:creator>
            <pubDate>Sat, 22 Feb 2025 12:54:13 GMT</pubDate>
            <atom:updated>2026-09-01T07:31:22.583Z</atom:updated>
            <content:encoded><![CDATA[<p>Theory–Math–Code (TMC) 🤖</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1sfXvoj2GZPEXvapdN3qWg.jpeg" /></figure><blockquote><strong><em>Python Essentials, Applied Mathematics</em></strong></blockquote><blockquote><strong><em>Artificial Intelligence, Machine Learning</em></strong></blockquote><blockquote><strong><em>Artificial Neural Network, Deep Learning</em></strong></blockquote><blockquote><strong><em>Production-Inspired ML, DL, Agent Projects</em></strong></blockquote><p>Applied ML, DL, and AI Agent Projects</p><p><em>“ www.infocus .uz— Life changing education”</em></p><blockquote><strong>Python Essentials, Applied Mathematics</strong></blockquote><p>Lesson-1: Human → Algorithm → ML → LLM</p><p>Lesson-2: Variables</p><p>Lesson-3: Control Flow</p><p>Lesson-4: Loops</p><p>Lesson-5: List</p><p>Lesson-6: Tuple</p><p>Lesson-7: Set</p><p>Lesson-8: Dictionary</p><p>Lesson-9: Functions</p><p>Lesson-10: Applied Math I</p><p>Lesson-11: Numpy</p><p>Lesson-12: Pandas</p><p>Lesson-13: Matplotlib</p><p>Lesson-14: Applied Math II</p><p>Lesson-15: Vectors</p><p>Lesson-16: Matrix</p><p>Lesson-17: Applied Math III</p><p>Lesson-18: Differential</p><p>Lesson-19: Modules</p><blockquote><strong>Artificial Intelligence, Machine Learning</strong></blockquote><p>Lesson-1: AI, ML, DL, DS, BD</p><p>Lesson-2: Training Data, Test Data</p><p>Lesson-3: Applied Math I</p><p>Lesson-4: Support Vector Machine (SVM)</p><p>Lesson-5: K Nearest Neighbor (KNN)</p><p>Lesson-6: Applied Math II</p><p>Lesson-7: Decision Tree</p><p>Lesson-8: Random Forest</p><p>Lesson-9: Applied Math III</p><p>Lesson-10: Linear Regressions</p><p>Lesson-11: Polynomial Regressions</p><p>Lesson-12: Multiple Regressions</p><p>Lesson-13: Extreme Gradient Boosting<strong> (</strong>XGB)</p><p>Lesson-14: Applied Math IV</p><p>Lesson-15: K-Means Clustering</p><p>Lesson-16: Hierarchical Clustering</p><p>Lesson-17: AUC-ROC Curve</p><p>Lesson-18: Applied Math V</p><p>Lesson-19: Logistic Regression</p><blockquote><strong>Artificial Neural Network, Deep Learning</strong></blockquote><p>Lesson-1: Applied Math I</p><p>Lesson-2: Artificial Neural Network</p><p>Lesson-3: Epochs, Mini-batch, Drop-out</p><p>Lesson-4: Softmax &amp; Cross Entropy</p><p>Lesson-5: Applied Math II</p><p>Lesson-6: Optimizers (RMSprop, Adam)</p><p>Lesson-7: Image Pre-Processing I</p><p>Lesson-8: Image Pre-Processing II</p><p>Lesson-9: Image Pre-Processing III</p><p>Lesson-10: Image Pre-Processing IV</p><p>Lesson-11: Numerical Image Processing</p><p>Lesson-12: Video Image Processing</p><p>Lesson-13: Applied Math III</p><p>Lesson-14: Convolution Neural Network, CNN</p><p>Lesson-15: Applied Math IV</p><p>Lesson-16: Recurrent Neural Network, LSTM</p><p>Lesson-17: AUC-ROC Curve in Neural Network</p><p>Lesson-18: Accuracy Confidence Interval</p><p>Lesson-19: Training, Test, Validation Data</p><blockquote><strong>Production-Inspired ML, DL, Agent Projects</strong></blockquote><p>Project-1: ML → DL → (NLP → LLM) → Generative AI → Agentic AI</p><p>Project-2: Machine Learning, Imbalanced Medical Classification</p><p>Project-3: Machine Learning, Customer Segmentation Analysis</p><p>Project-4: Deep Learning, CNN - Based Image Classification</p><p>Project-5: Deep Learning, LSTM - Based Time Series Forecasting</p><p>Project-6: NLP, Natural Language Processing, Sentiment Analysis</p><p>Project-7: NLP, Natural Language Processing, Practical Text Analysis</p><p>Project-8: LLM, Large Language Model, Transformer, Text Generation</p><p>Project-9: Building AI Agents with N8N, LangChain, LangGraph, CrewAI</p><p>Project-10: Building RAG Agents with N8N, LangChain, LangGraph, CrewAI</p><p><em>“ </em><a href="http://www.infocus/"><em>www.infocus</em></a><em> .uz — Life changing education”</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a845785aa13f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Backend Engineering]]></title>
            <link>https://infocuslabs.medium.com/backend-engineering-024b69534e51?source=rss-1173c47a744c------2</link>
            <guid isPermaLink="false">https://medium.com/p/024b69534e51</guid>
            <category><![CDATA[spring-framework]]></category>
            <category><![CDATA[java-ee]]></category>
            <category><![CDATA[java-backend]]></category>
            <category><![CDATA[backend]]></category>
            <category><![CDATA[spring-boot]]></category>
            <dc:creator><![CDATA[InFocus Engineering]]></dc:creator>
            <pubDate>Tue, 19 Nov 2024 05:26:50 GMT</pubDate>
            <atom:updated>2025-11-20T11:18:50.541Z</atom:updated>
            <content:encoded><![CDATA[<p>A Cup of Java ☕</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-cdnNTXXNklNmVSv6ona_g.png" /></figure><blockquote><strong>Backend Systems I: Spring Framework &amp; Enterprise Backend</strong></blockquote><blockquote>Java EE, Spring Framework</blockquote><blockquote>JDBC, JPA, Spring Data JPA</blockquote><blockquote><strong>Backend Systems II: Web Applications &amp; Large-Scale Traffic</strong></blockquote><blockquote>Web Application, Spring Boot</blockquote><blockquote>IT Project, Large-scale traffic</blockquote><p><strong><em>“InFocus.uz — Life changing education”</em></strong></p><blockquote><strong>Backend Systems I: Spring Framework &amp; Enterprise Backend</strong></blockquote><blockquote>Java EE, Spring Framework</blockquote><p><strong>Lesson-1: SpringBoot Project</strong></p><p>Task Management Project-I</p><p>Spring Boot, Spring Data JPA</p><p>Template Engine (Thymeleaf), PostgreSQL</p><p>Maven vs Gradle</p><p>dependency-management</p><p>spring-boot-autoconfigure</p><p><strong>Lesson-2: Spring Framework, Bean</strong></p><p>Enterprise Java Beans (EJB)</p><p>Expert One-on-One</p><p>JEE Design and Development</p><p>ApplicationContext.java</p><p>Beans.properties</p><p>Aspect Oriented Container</p><p>Default Constructor</p><p>Singleton &amp; Prototype</p><p><strong>Lesson-3: Application Context, XML</strong></p><p>Interface ApplicationContext</p><p>Interface BeanFactory</p><p>ClassPathXmlApplicationContext</p><p>spring-core jar maven</p><p>spring-context jar maven</p><p>Spring Modules (Core Container)</p><p>applicationContext.xml</p><p>Inject with Spring configuration</p><p><strong>Lesson-4: AnnotationConfigApplicationContext</strong></p><p>XML inconvenient to use</p><p>Class AnnotationConfigApplicationContext</p><p>Annotation (Java Config, Component Scan)</p><p>@Configuation — application config</p><p>@Bean — method level</p><p>@Component — class level</p><p><strong>Lesson-5: Java EE, WAS, Tomcat</strong></p><p>Web Application, WAS</p><p>WAS — Web Application Server</p><p>Java EE Standard WAS</p><p>Java EE Platform Specification</p><p>Transition from Java EE to Jakarta EE</p><p>Java Web Programming</p><p>Servlet Container, JSP</p><p>WAS, Tomcat</p><p>Run Tomcat in the foreground</p><p>Run Tomcat in the background</p><p>Deploy the application on Tomcat</p><p><strong>Lesson-6: HTTP Protocol, HttpServlet</strong></p><p>DNS, nslookup</p><p>IP address, Port number</p><p>Chrome Developer Tools</p><p>Http Request, Response</p><p>Special Type of Servlet (JSP)</p><p>Http Servlet Request</p><p>Http Servlet Response</p><p>Spring Web Programming</p><p>Core class-Dispatcher Servlet</p><p><strong>Lesson-7: Servlet &amp; JSP Life Cycles</strong></p><p>Servlet Life Cycles</p><p>init, destroy, service</p><p>service (GET, POST, PUT, DELETE)</p><p>JSP Life Cycles</p><p>jspInit, jspDestroy, jspService</p><p>Servlet Project</p><p>Request Dispatcher</p><p><strong>Lesson-8: Servlet to JSP, EL Notation</strong></p><p>Servlet Project</p><p>Forward from Servlet to JSP</p><p>JSP, EL Notation</p><p>Maven Lifecycle</p><p>Maven Install</p><p>Deploy WAR on Tomcat</p><p><strong>Lesson-9: Java EE Project</strong></p><p>Task Management Project-II</p><p>Jakarta EE, Servlets</p><p>JDBC, PostgreSQL</p><p>Connection, DriverManager</p><p>JavaServer Pages Tag Library (JSTL)</p><p><strong>Lesson-10: Spring Framework</strong></p><p>Jakarta EE to Spring Project</p><p>Compile Only Dependency</p><p>WAR, Deploying on Tomcat</p><p>Spring Core Container</p><p>Spring Web MVC</p><p>WebMvcConfigurer</p><p>WebApplicationInitializer</p><p>Browser(/hello) =&gt; Tomcat =&gt; Servlet (HelloServlet)</p><p>Browser(/hello) =&gt; Tomcat =&gt; Servlet (DispatcherServlet) =&gt;ApplicationContext =&gt; Bean(Controller(“/hello”))</p><p><strong>Lesson-11: Default Servlet, ViewResolver</strong></p><p>Browser(/img.png) =&gt; Tomcat =&gt; Servlet (DispatcherServlet (/)) =&gt;ApplicationContext =&gt; Bean(Controller(“/img.png”))</p><p>Browser(/img.png) =&gt; Tomcat =&gt; Servlet (DispatcherServlet (/)) =&gt;ApplicationContext =&gt; Bean(Controller(“/…”)) =&gt; Tomcat DefaultServlet =&gt; webapp/img.png</p><p>Default Servlet Handler Configurer</p><p>Internal Resource View Resolver</p><p>Controller logic =&gt; InternalResourceViewResolver =&gt; Show using JSP</p><p>Controller logic =&gt; BeanNameViewResolver =&gt; Download using Excel</p><p><strong>Lesson-12: DataSource, PropertySource</strong></p><p>WebApplicationInitializer</p><p>AbstractAnnotationConfigDispatcherServletInitializer</p><p>getServletFilters, getRootConfigClasses</p><p>getServletConfigClasses, getServletMappings</p><p>Database Programming</p><p>SQL, JDBC, Spring JDBC, Spring Data JPA</p><p>Controller, Service, DAO, Repository</p><p>DriverManagerDataSource</p><p>AbstractDriverBasedDataSource</p><p>AbstractDataSource, DataSource</p><p><strong>Lesson-13: Setting up Spring Data JPA</strong></p><p>JDBC, Connection Pool</p><p>MyBatis, Spring JDBC, Spring Data JPA (ORM)</p><p>Transaction, EntityManager, PersistenceContext, JPAException</p><p>Transaction, Transactional</p><p>EntityManager, LocalContainerEntityManagerFactoryBean</p><p>DataSource, HibernateJpaVendorAdapter</p><p>JPAException, Spring Exception</p><p><strong>Lesson-14: Spring Framework Project</strong></p><p>Task Management Project-III</p><p>WebConfig, AppConfig</p><p>MyWebApplicationInitializer</p><p>Spring Data JPA, PostgreSQL</p><p>Controller, Service, Repository</p><p>Default Servlet, ViewResolver</p><p>DataSource, TransactionManager</p><p>EntityManager, EntityManagerFactory</p><blockquote><strong>Backend Systems I: Spring Framework &amp; Enterprise Backend</strong></blockquote><blockquote>JDBC, JPA, Spring Data JPA</blockquote><p><strong>Lesson-1: JDBC, PostgreSQL Driver</strong></p><p>Java Database Connectivity (JDBC)</p><p>MySQL, PostgreSQL, Oracle Drivers</p><p>Maven Archetype Project</p><p>Connection, PreparedStatement</p><p>ResultSet, DriverManager</p><p>PostgreSQL JDBC Connector</p><p>Connect SQL, Insert SQL</p><p>Delete SQL, Select SQL</p><p><strong>Lesson-2: SQL, JDBC Transactions</strong></p><p>SQL Transactions</p><p>Auto Commit = False</p><p>(begin, commit)</p><p>(begin, rollback)</p><p>Transaction Lock (SQL)</p><p>JDBC Transactions</p><p>connection.setAutoCommit(false)</p><p>connection.commit()</p><p>connection.rollback()</p><p>Transaction Exception</p><p>Transaction Lock (JDBC)</p><p>Spring JDBC, MyBatis, Spring Data JPA</p><p><strong>Lesson-3: JDBC, SpringBoot</strong></p><p>Spring Boot (3.3.x) System Requirements</p><p>Maven 3.6+, Gradle 7.x and 8.x.</p><p>Tomcat 10.1, Servlet version 6.0</p><p>JDBC API, PostgreSQL Driver</p><p>Dependency AutoConfiguration</p><p>DataSourceAutoConfiguration</p><p>JdbcTemplateAutoConfiguration</p><p>DataSourceProperties</p><p>application.properties (application.yml)</p><p>main class not managed by Spring</p><p>DataSource, CommandLineRunner</p><p><strong>Lesson-4: HikariCP, ConnectionPool</strong></p><p>SpringBootApplication is Component</p><p>External Libraries, HikariDataSource</p><p>HikariDataSource in Spring Beans</p><p>SpringBoot Connection Pool</p><p>HirakiCP, Oracle UCP, Tomcat Pooling</p><p>DataSource, HikariDataSource</p><p>Unlimited Connections without closing</p><p>Unlimited Connections with closing</p><p>Slow-running SQL queries</p><p><strong>Lesson-5: Spring JDBC, DAO</strong></p><p>Spring JDBC, Data Access</p><p>JdbcTemplate, RowMapper</p><p>NamedParameterJdbcTemplate</p><p>Client, Controller, Service, DAO, DB</p><p>Spring JCBC, Add, Delete, Get</p><p>SimpleJdbcInsert</p><p>SqlParameterSource</p><p>MapSqlParameterSource</p><p>BeanPropertyRowMapper</p><p><strong>Lesson-6: Hibernate with JPA</strong></p><p>JPA Provider, Native Hibernate</p><p>Hibernate ORM (2001) =&gt; JPA (2006) =&gt; JPA 2.1 (2013)</p><p>DataNucleus, EclipseLink, Hibernate</p><p>Spring Data JDBC</p><p>Spring Data Redis</p><p>Spring Data JPA</p><p>Maven Archetype, persistence.xml</p><p>EntityManager, EntityManagerFactory</p><p>Persistence Context, CRUD</p><p><strong>Lesson-7: Entity Mapping, Identifiers</strong></p><p>Entity, Table, Id, Column, Enumerated</p><p>EntityManager, EntityManagerFactory</p><p>Id Annotation — Direct Assignment</p><p>Id Annotation — Identifier Column Method</p><p>Id Annotation — Sequence Usage Method</p><p>Id Annotation — Table Storage Method</p><p>GeneratedValue, GenerationType.<em>IDENTITY</em></p><p>GeneratedValue, SequenceGenerator</p><p>GeneratedValue, TableGenerator</p><p><strong>Lesson-8: Embeddable, Embedded</strong></p><p>Not an Entity — Embeddable</p><p>Not an Entity — Embedded</p><p>EntityManager, EntityManagerFactory</p><p>AttributeOverrides, AttributeOverride</p><p>@SecondaryTable + TableName</p><p>@SecondaryTable+@AttributeOverride</p><p><strong>Lesson-9: Mapping Set, List, Map</strong></p><p>EntityManager, EntityManagerFactory</p><p>ElementCollection, CollectionTable-Set</p><p>Mapping Set, Embeddable</p><p>FetchType.EAGER<em>, </em>FetchType.LAZY</p><p>ElementCollection, CollectionTable-List</p><p>Mapping List, OrderColumn, Embeddable</p><p>ElementCollection, CollectionTable-Map</p><p>Mapping Map, MapKeyColumn, Embeddable</p><p><strong>Lesson-10: Persistent Context, Lifecycle</strong></p><p>JPA — EntityManager</p><p>JPA — Transaction</p><p>JPA — Persistence Context</p><p>Persistence Context, Repeatable Read</p><p>Lifecycle: Managed, Detached, Removed</p><p>Change Entity with close</p><p>Change Entity with detach</p><p><strong>Lesson-11: 1–1, N-1, 1-N, N-N</strong></p><p>Unidirectional Associations</p><p>One-To-One Relationship</p><p>Primary Key (PK), Foreign Key (FK), JoinColumn</p><p>Primary Key (PK), Primary Key (PK), PrimaryKeyJoinColumn</p><p>Many-To-One Relationship</p><p>One-To-Many Relationship (Set, List, Map)</p><p>Many-To-Many Relationship</p><p>CascadeTypes, CascadeType.PERSIST</p><p>Bidirectional Associations</p><p>One-To-Many with mappedBy</p><p>Many-To-Many with mappedBy</p><p><strong>Lesson-12: JPQL, CRITERIA</strong></p><p>EntityManager, EntityManagerFactory</p><p>Jakarta Persistence Query Language</p><p>TypedQuery, CreateQuery</p><p>select r from Review r where r.hotelId = :hotelId</p><p>JPA Criteria Queries</p><p>CriteriaBuilder, CriteriaQuery</p><p>Root, Predicate, TypedQuery</p><p><strong>Lesson-13: Spring Data JPA, Entity Manager</strong></p><p>DataSource (HirakiCP)</p><p>DataSourceProperties</p><p>EntityManagerFactory (Hibernate)</p><p>EntityManager</p><p>EntityTransaction</p><p>Entity, PersistenceContext</p><p>Transaction Begin, Commit</p><p>Transaction Begin, Rollback</p><p>EntityManager Persist</p><p><strong>Lesson-14: Spring Data JPA, Query Methods</strong></p><p>findByName, findByNameAndEmail</p><p>findByNameNot, findByNameOrEmail</p><p>findByUserIdBetween, existsByEmail</p><p>findByUserIdLessThan, findByUserIdGreaterThan</p><p>findByRegdateAfter, findByRegdateBefore</p><p>findByNameIsNull, findByNameIsNotNull</p><p>findByNameLike, findByNameContaining</p><p>findByNameStartingWith, findByNameEndingWith</p><p>findByOrderByNameAsc, findByOrderByNameDesc</p><p>findByUserIdIn, findByUserIdNotIn</p><p>findByFlagTrue, findByFlag(flag)</p><p>countBy, countByNameLike</p><p>deleteByName, deleteByNameLike</p><p>findFirst2By, findTop2By</p><p>findByName(String name, Pageable pageable)</p><p><strong>Lesson-15: Spring Data JPA, Associations</strong></p><p>User Entity, Role Entity, Task Entity</p><p>ManyToMany, JoinTable, JoinColumn</p><p>Do not use ToString</p><p>ManyToOne, JoinColumn</p><p>N+1 Problem in Hibernate</p><p>findAll, EAGER, LAZY, Join Table</p><p>findById, EAGER, LAZY, Join Table</p><p>JPQL, Join, Join Fetch</p><p>Native Query, Projection</p><blockquote><strong>Backend Systems II: Web Applications &amp; Large-Scale Traffic</strong></blockquote><blockquote>Web Application, Spring Boot</blockquote><p><strong>Lesson-1: Customized Tomcat</strong></p><p>Web Application Server (WAS)</p><p>Create Tomcat using Java</p><p>Web Socket with Port</p><p>Requests in Main Thread</p><p>Requests in New Thread</p><p>Requests using Thread Pool</p><p><strong>Lesson-2: Embedded Tomcat</strong></p><p>Web Application Server (WAS)</p><p>Tomcat Embedded Core</p><p>Tomcat Embedded Jasper</p><p>Use Embedded Tomcat</p><p>WebServlet with Servlet</p><p>WebServlet with GenericServlet</p><p>WebServlet with HttpServlet</p><p><strong>Lesson-3: Reflection Framework</strong></p><p>Java Reflection, Runtime</p><p>org.reflections:reflections</p><p>Controller, Service Annotation</p><p>Request Mapping Annotation</p><p>Get Types Annotated With</p><p>Get Declared Fields</p><p>Get Declared Constructors</p><p>Get Declared Methods</p><p><strong>Lesson-4: DI Framework</strong></p><p>Dependency Injection</p><p>org.reflections:reflections</p><p>Application Context</p><p>Bean Factory</p><p>@Inject, Constructor</p><p>Controller, Service</p><p>Bean Factory Test</p><p><strong>Lesson-5: MVC Framework</strong></p><p>Model View Controller</p><p>Dispatcher Servlet</p><p>Handler Mapping</p><p>Handler Adapter</p><p>View Resolver</p><p>Model and View</p><p>Request Method</p><p>Request Mapping Handler Mapping</p><p>Simple Controller Handler Adapter</p><p><strong>Lesson-6: Spring Web MVC</strong></p><p>Controller Annotation</p><p>RestController Annotation</p><p>MCV Container</p><p>Dependency Management</p><p>WebMvcAutoConfiguration</p><p>DispatcherServletAutoConfiguration</p><p>Tomcat , Web Application Server</p><p>Port Number, ServerProperties</p><p>Static, backend.fig, hello.html</p><p>Html Controller, Json Controller</p><p><strong>Lesson-7: Dispatcher Servlet</strong></p><p>WebMvcAutoConfiguration</p><p>DispatcherServletAutoConfiguration</p><p>DispatcherServlet</p><p>HandlerMapping</p><p>HandlerAdapter</p><p>ViewResolver</p><p>RequestHandledEventListener</p><p>HttpServletRequest</p><p><strong>Lesson-8: Request Mappings</strong></p><p>HTTP Method</p><p>HTTP Headers</p><p>Produces &amp; Consumes</p><p>Single Path Variable</p><p>Multi Path Variable</p><p>Request Parameters</p><p>Request Header</p><p>Cookie Value</p><p>Shortcuts</p><p>Employee CRUD APIs</p><p><strong>Lesson-9: Layered Architecture</strong></p><p>N-Tier Architecture:</p><p>Presentation Layer</p><p>Service Layer</p><p>Repository Layer</p><p>Domain-Driven Design:</p><p>Domain Layer</p><p>Application Layer</p><p>Infrastructure Layer</p><p>config, controller</p><p>model / domain</p><p>repository, service</p><p><strong>Lesson-10: Internationalization</strong></p><p>Internationalization — i18n</p><p>resources/messages.properties</p><p>resources/messages_ru.properties</p><p>resources/messages_uz.properties</p><p>LanguageConfig</p><p>AcceptHeaderLocaleResolver</p><p>ResourceBundleMessageSource</p><p>Accept-Language — EN, RU, UZ</p><p>Translator, Locale</p><p><strong>Lesson-11: Loading Initial Data</strong></p><p>Entity + Data.sql</p><p>spring.jpa.defer-datasource-initialization</p><p>spring.sql.init.mode</p><p>Schema.sql + Data.sql</p><p>spring.jpa.hibernate.ddl-auto=none</p><p>Database Migrations</p><p>org.flywaydb:flyway-core</p><p>&lt;Prefix&gt;&lt;Version&gt;__&lt;Description&gt;.sql</p><p><strong>Lesson-12: RESTful HTTP Clients</strong></p><p>RestClient — Core Spring</p><p>RestClient — Synchronous</p><p>RestClient — Blocking</p><p>WebClient — Spring WebFlux</p><p>WebClient — Asynchronous</p><p>WebClient — Non-blocking</p><p>OpenFeign — Spring Cloud</p><p>OpenFeign — Declarative</p><p>OpenFeign — Non-blocking</p><p>RestNetwork — Customized</p><p><strong>Lesson-13: Schedule Cron Jobs</strong></p><p>Timezone, JVM running</p><p>App running in UZB(+5) timezone</p><p>App running in UTC(+0) timezone</p><p>App running in KOR(+9) timezone</p><p>Scheduled with Fixed Delay</p><p>Scheduled with Fixed Rate</p><p>Cron Job — Once every 1 minute</p><p>Cron Job — Every day at 11:00 PM</p><p>Cron Job — Every 09:00 AM from Mon to Fri</p><p><strong>Lesson-14: Recursion, Mapping</strong></p><p>Bidirectional Relationship</p><p>Infinite Recursion Problem</p><p>JsonManagedReferences</p><p>JsonBackReferences</p><p>JsonIgnore</p><p>JsonIdentityInfo</p><p>Java Bean Mapper</p><p>MapStruct Gradle</p><p>MapStruct Maven</p><p>Request &gt; Dto &gt; Entity &gt; Dto &gt; Response</p><p><strong>Lesson-15: OSIV, Transactions</strong></p><p>Open Session in View</p><p>open-in-view: false</p><p>Transaction Scope</p><p>Controller, Service, Repository</p><p>Transaction Management</p><p>@Transactional — Throw Exception</p><p>@Transactional — Repository Save</p><p>@Transactional — Entity Setter</p><p>@Transactional — dontRollbackOn</p><p><strong>Lesson-16: Spring Security I</strong></p><p>1- Username &amp; Generated Password</p><p>SecurityFilterChain, HttpSecurity</p><p>FormLogin, HttpBasic</p><p>2- InMemoryUserDetailsManager</p><p>Role(USER), Authorities(ROLE_USER)</p><p>SecurityContextHolder, Principle</p><p>3- UsernamePasswordAuthenticationToken</p><p>AuthenticationProvider, Authentication</p><p>RobotAuthenticationProvider</p><p>AuthorityUtils.createAuthorityList</p><p>4- Header Token</p><p>AlienAuthentication, Authentication</p><p>AlienAuthenticationProvider, AuthenticationProvider</p><p>AlienFilter, OncePerRequestFilter</p><p>HEADER_NAME = “x-alien-token”</p><p><strong>Lesson-17: Spring Security II</strong></p><p>User Entity with UserDetails</p><p>1- AuthenticationFilter</p><p>2- UsernamePasswordAuthenticationToken</p><p>3- AuthenticationManager</p><p>4- AuthenticationProvider</p><p>5- UserDetailsService</p><p>6- UserDetails, User</p><p>7- AuthenticationProvider</p><p>8- AuthenticationManager</p><p>9- AuthenticationFilter</p><p>10- SecurityContextHolder</p><p><strong>Lesson-18: Spring Security III</strong></p><p>User Entity without UserDetails</p><p>UserEntity, UserPrinciple</p><p>UserService, UserDetailsService</p><p>SecurityConfig, JwtFilter</p><p>SecurityFilterChain</p><p>AbstractHttpConfigurer::disable</p><p>SessionCreationPolicy.<em>STATELESS</em></p><p>authorizeHttpRequests</p><p>DaoAuthenticationProvider</p><p>AuthenticationManager</p><p>ROLE_USER, ROLE_ADMIN</p><p><strong>Lesson-19: Spring Security IV</strong></p><p>Authentication Architecture</p><p>UserEntity, UserPrinciple</p><p>Access Token, Refresh Token</p><p>JwtSecretKey, JwtRefreshKey</p><p>SignIn Logic, SignOut Logic</p><p><em>ACCESS_TOKEN_EXPIRE_COUNT</em></p><p><em>REFRESH_TOKEN_EXPIRE_COUNT</em></p><p>Create Refresh Token</p><p>Load Refresh Token</p><p>Delete Refresh Token</p><p><strong>Lesson-20: Localhost, HTTPS</strong></p><p>Client, Web Server, WAS, DB</p><p>Web Server, NGINX, HTTPS</p><p>WAS, Localhost, HTTPS</p><p>mkcert -pkcs12 localhost</p><p>localhost.p12, application.yml</p><p><a href="http://localhost:8080/">http://localhost:8080/</a></p><p><a href="http://localhost:8080/">https://localhost:8080/</a></p><p>The hosts file as a domain</p><p>sudo vi /etc/hosts</p><p><a href="http://www.justdoit.dev,/">www.justdoit.dev,</a> application.yml</p><p><a href="http://localhost:8080/">https://www.justdoit.dev:8080/</a></p><blockquote><strong>Backend Systems II: Web Applications &amp; Large-Scale Traffic</strong></blockquote><blockquote>IT Project, Large-scale traffic</blockquote><p><strong>Lesson-1: The CAP Theorem</strong></p><p>The CAP theorem, Brewer’s theorem</p><p>Consistency (C): All reads return the latest write</p><p>Availability (A): Every request gets a response</p><p>Partition Tolerance (P): Works despite network issues</p><p>Domain-Driven Design, Event-Driven Architecture</p><p>Monolithic, Microservice, Modulith Architectures</p><p>Monolithic: CA (Consistency + Availability)</p><p>Microservices: AP (Availability + Partition Tolerance)</p><p>Modulith: CA (Consistency + Availability)</p><p>Modulith: CP (Consistency + Partition Tolerance)</p><p><strong>Lesson-2: Monolithic Architecture</strong></p><p>Traditional way of building app</p><p>Easy deployment, debugging</p><p>User, Product, Order Entities</p><p>User, Product, Order Controllers</p><p>User, Product, Order Services</p><p>User, Product, Order Repositories</p><p>Centralized Database, PostgreSQL</p><p>Method calls within the application</p><p><strong>Lesson-3: Microservice Architecture</strong></p><p>Small and independent services</p><p>Database per service, PostgreSQL</p><p>USER-SERVICE, Eureka Client, 8081</p><p>PRODUCT-SERVICE, Eureka Client, 8082</p><p>ORDER-SERVICE, Eureka Client, 8083</p><p>Internal Communication, RESTful</p><p>RestClient, WebClient, FeignClient</p><p>Spring Cloud Netflix, Eureka Server, 8761</p><p>Spring Cloud Gateway, Eureka Client, 8080</p><p><strong>Lesson-4: Modulith Architecture</strong></p><p>Modular+Monolith=Modulith</p><p>Spring Modulith Structures</p><p>Packages, ApplicationModuleTest</p><p>ApplicationModules, Verify</p><p>DTOs with From and ToEntity</p><p>Private Repositories, DTOs, Service APIs</p><p>External Packages, package-info.java</p><p>ApplicationEventPublisher, Event Listener</p><p>Transactional, ApplicationModuleListener</p><p>Spring Modulith JPA, event_publication</p><p><strong>Lesson-5: Real World Project — I</strong></p><p>Java, SpringBoot, PostgreSQL, Gradle, Redis, Kafka, Git</p><p>Database for large data — Cassandra</p><p>Database for relational data — PostgreSQL</p><p>Database for data analysis — Druid</p><p>Database for non-relational data — Redis</p><p>Designing the Project Architecture</p><p>Spring Security and Its Features</p><p>Developing the Auth “Sign-Up” Feature</p><p>Developing the Auth “Sign-In” Feature</p><p>Developing the “User Info” Feature</p><p>Developing the “Create Post” Feature</p><p>Developing the “Update Post” Feature</p><p>Developing the “Delete Post” Feature</p><p>Developing the “My Posts” Feature</p><p>Developing the “Feed List” Feature</p><p><strong>Lesson-6: Real World Project — II</strong></p><p>Java, SpringBoot, PostgreSQL, Gradle, Redis, Kafka, Git</p><p>Developing the “Like” Feature</p><p>Developing the “Like Count” Feature</p><p>Developing the “Leave a Comment” Feature</p><p>Developing the “Comment List” Feature</p><p>Developing the Notification Feature</p><p>Analysis of Current Architectural Problems</p><p>Current Architectural Problems — Analysis I</p><p>Current Architectural Problems — Analysis II</p><p>Current Architectural Problems — Analysis III</p><p>Current Architectural Problems — Analysis IV</p><p>Solution to retrieve User entity from DB twice</p><p>Delete comments and likes when post is deleted</p><p><strong>Lesson-7: Real World Project — III</strong></p><p>Java, SpringBoot, PostgreSQL, Gradle, Redis, Kafka, Git</p><p>Solutions for Handling Large-Scale Traffic</p><p>Introduction to Redis for Real-Time Apps</p><p>Redis (<a href="https://redis.io/">https://redis.io/</a>) vs Local Caching</p><p>Redis, In-memory, Key-Value, Commands,</p><p>Redis, Single Thread, Sentinel, Redis Cluster</p><p>UserDetails, loadUserByUsername, UserCache</p><p>Introduction to SSE for Real-Time Updates</p><p>Client, Request, Server, Response, Polling</p><p>Client, Request, Server, Response, Long-Polling</p><p>Client, Server, Request, Response, Web Socket</p><p>Client, Subscribe, Server, Server-Send Event (SSE)</p><p>Introduction to Kafka for Event Streaming</p><p>Apache Kafka, Producer, Broker, Consumer</p><p>Event Key, Topic, Partition, Consumer Group</p><p><strong>Lesson-8: Traditional Server Setup (OS)</strong></p><p>Client— WAS — DB</p><p>Browser— Tomcat — PostgreSQL</p><p>Client — Web Server — WAS — DB</p><p>Browser — NGINX — Tomcat — PostgreSQL</p><p>Operation System (Linux, Windows, Mac)</p><p>Run SpringBoot Application</p><p>Run SpringBoot with PostgreSQL</p><p>Run SpringBoot with PostgreSQL, Redis</p><p>Run SpringBoot with PostgreSQL, Redis, NGINX</p><p><strong>Lesson-9: Modern Server Setup (Docker)</strong></p><p>Host, Container, Linux, OS</p><p>OS (Linux, Windows, Mac)</p><p>App Store, Program, Process</p><p>DockerHub, Official Docker Images</p><p>Docker Commands, Image, Container</p><p>docker run -name test1 -d httpd</p><p>docker run -name test2 -d -p 8000:80 httpd</p><p>Dockerize SpringBoot Application</p><p>Individual containers (SpringBoot Application)</p><p>Multiple containers (SpringBoot, PostgreSQL)</p><p>Multiple containers (SpringBoot, PostgreSQL, Redis)</p><p>Multiple containers (SpringBoot, PostgreSQL, Redis, NGINX)</p><p>Dockerfile, docker-compose.yml</p><p>docker-compose up, docker-compose down</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=024b69534e51" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Net & Sec Engineering]]></title>
            <link>https://infocuslabs.medium.com/network-engineering-44d11b7b61a0?source=rss-1173c47a744c------2</link>
            <guid isPermaLink="false">https://medium.com/p/44d11b7b61a0</guid>
            <category><![CDATA[udp]]></category>
            <category><![CDATA[proxy]]></category>
            <category><![CDATA[tcp-ip]]></category>
            <category><![CDATA[networking]]></category>
            <dc:creator><![CDATA[InFocus Engineering]]></dc:creator>
            <pubDate>Sun, 14 Jan 2024 11:51:18 GMT</pubDate>
            <atom:updated>2026-03-05T16:39:16.740Z</atom:updated>
            <content:encoded><![CDATA[<p>IP + Port = Socket 🌐</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*erVn-Nq8Eu_gsNruiKsVdw.jpeg" /></figure><blockquote><strong><em>Network Engineering (Stage 1): Practical Network Engineering</em></strong></blockquote><blockquote><em>Module 1: Network &amp; Internet</em></blockquote><blockquote><em>Module 2: OSI7Layer &amp; TCP/IP Stack</em></blockquote><blockquote><em>Module 3: Socket Specifications</em></blockquote><blockquote><em>Module 4: World Wide Web (WWW)</em></blockquote><blockquote><strong><em>Security Engineering (Stage 2): Practical Security Engineering</em></strong></blockquote><blockquote><em>Module 1: Information &amp; Security</em></blockquote><blockquote><em>Module 2: Network &amp; Security</em></blockquote><blockquote><em>Module 3: System &amp; Security</em></blockquote><blockquote><em>Module 4: Application &amp; Security</em></blockquote><p><strong><em>“InFocus.uz — Life changing education”</em></strong></p><blockquote><strong><em>Network Engineering: Applied Skills for Network Systems</em></strong></blockquote><blockquote><em>Module 1: Network &amp; Internet</em></blockquote><p>1- IP</p><p>2- Modem</p><p>3- Wifi Router</p><p>4- Switch, Hub</p><p>5- LAN</p><p>6- WAN</p><p>7- Internet</p><p>8- ISP</p><p>9- TIERS</p><p>10- Tier1, Tier2, Tier3</p><p>11- ISP Routers</p><p>12- Dijkstra</p><p>13- Node</p><p>14- EndSystem, Host</p><p>15- Client, Server</p><p>16- Hands-On Practice I</p><p>17- Hands-On Practice II</p><p>18- Hands-On Practice III</p><blockquote><strong><em>Network Engineering: Applied Skills for Network Systems</em></strong></blockquote><blockquote><em>Module 2: OSI7Layer &amp; TCP/IP Stack</em></blockquote><p>1- Network Protocol</p><p>2- Layered Architecture</p><p>3- OSI7 Layers</p><p>4- TCP/IP Stack</p><p>5- Application layer (L7)</p><p>6- Presentation layer (L6)</p><p>7- Session layer (L5)</p><p>8- Transport layer (L3)</p><p>9- Network layer (L3)</p><p>10- Data link layer (L2)</p><p>11- Physical layer (L1)</p><p>12- Client, Router, Server</p><p>13- Wireshark</p><p>14- Hands-On Practice I</p><p>15- Hands-On Practice II</p><p>16- Hands-On Practice III</p><blockquote><strong><em>Network Engineering: Applied Skills for Network Systems</em></strong></blockquote><blockquote><em>Module 3: Socket Fundamentals</em></blockquote><p>1- Socket</p><p>2- Socket Concepts</p><p>3- Port Types</p><p>6- TCP</p><p>7- Three-Way Handshake</p><p>8- Four-Way Handshake</p><p>10- UDP</p><p>11- IP + Port = Socket</p><p>12- Socket Programming</p><p>13- Hands-On Practice I</p><p>14- Hands-On Practice II</p><p>15- Hands-On Practice III</p><blockquote><strong><em>Network Engineering: Applied Skills for Network Systems</em></strong></blockquote><blockquote><em>Module 4: World Wide Web (WWW)</em></blockquote><p>1- Tim Berners-Lee, CERN</p><p>2- World Wide Web</p><p>3- HTTP I</p><p>4- HTTP II</p><p>5- HTTP III</p><p>6- Cookie</p><p>7- Session</p><p>8- SSL/TLS</p><p>9- DNS I</p><p>10- DNS II</p><p>11- DNS III</p><p>12- DNS IV</p><p>13- CDN</p><p>14- Hands-On Practice I</p><p>15- Hands-On Practice II</p><p>16- Hands-On Practice III</p><blockquote><strong><em>Security Engineering: Applied Skills for Security Systems</em></strong></blockquote><blockquote><em>Module 1: Information &amp; Security</em></blockquote><p>1- What exactly are we securing?</p><p>2- Information Security</p><p>3- Elements of InfoSec</p><p>4- Security Attacks</p><p>5- Components of InfoSec</p><p>6- Risk Management</p><p>7- Classification of InfoSec</p><p>8- Network, System, Application</p><p>9- Hands-On Practice I</p><p>10- Hands-On Practice II</p><p>11- Hands-On Practice III</p><blockquote><strong><em>Security Engineering: Applied Skills for Security Systems</em></strong></blockquote><blockquote><em>Module 2: Network &amp; Security</em></blockquote><p>1- Network Security</p><p>2- Firewall</p><p>3- WAF</p><p>4- IPS &amp; IDS</p><p>6- VPN</p><p>7- Network Attacks I</p><p>8- Network Attacks II</p><p>9- Network Attacks III</p><p>10- DoS Attacks I</p><p>11- DoS Attacks II</p><p>12- DoS Attacks III</p><p>13- DoS Attacks IV</p><p>14- DoS Attacks V</p><p>15- Scanning Attacks I</p><p>16 - Scanning Attacks II</p><p>17- Hands-On Practice I</p><p>18- Hands-On Practice II</p><p>19- Hands-On Practice III</p><blockquote><strong><em>Security Engineering: Applied Skills for Security Systems</em></strong></blockquote><blockquote><em>Module 3: System &amp; Security</em></blockquote><p>1- Operating System, OS</p><p>2- Cloud Computing</p><p>3- IaaS, PaaS, SaaS</p><p>4- Public Cloud</p><p>5- Private Cloud</p><p>6- System Security I</p><p>7- System Security II</p><p>8- System Security III</p><p>9- System Security IV</p><p>10- System Security V</p><p>11- System Security VI</p><p>12- Encryption</p><p>13- System Attacks I</p><p>14- System Attacks II</p><p>15- System Attacks III</p><p>16- System Attacks IV</p><p>17- System Attacks V</p><p>18- Hands-On Practice I</p><p>19- Hands-On Practice II</p><p>20- Hands-On Practice III</p><blockquote><strong><em>Security Engineering: Applied Skills for Security Systems</em></strong></blockquote><blockquote><em>Module 4: Application &amp; Security</em></blockquote><p>1- Web Server &amp; WAS</p><p>2- Web Vulnerabilities</p><p>5- OWASP Top 10</p><p>6- Broken Access Control</p><p>7- Cryptographic Failures</p><p>8- Injection</p><p>9- Insecure Design</p><p>10- Security Misconfiguration</p><p>11- Vulnerable &amp; Outdated Components</p><p>12- Identification &amp; Authentication Failures</p><p>13- Software &amp; Data Integrity Failures</p><p>14- Security Logging &amp; Monitoring Failures</p><p>15- Server-Side Request Forgery</p><p>16- Web Security Model</p><p>17- Secure Coding</p><p>18- SDLC I</p><p>19- SDLC II</p><p>21- Ensuring Security I</p><p>22- Ensuring Security II</p><p>23- Ensuring Security III</p><p>24- Ensuring Security IV</p><p>25- Ensuring Security V</p><p>26- Ensuring Security VI</p><p>27- Ensuring Security VII</p><p>28- Search Engines I</p><p>29- Search Engines II</p><p>30- Search Engines III</p><p>31- Proxy I</p><p>32- Proxy II</p><p>33- Proxy III</p><p>34- Hands-On Practice I</p><p>35- Hands-On Practice II</p><p>36- Hands-On Practice III</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=44d11b7b61a0" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Database Engineering]]></title>
            <link>https://infocuslabs.medium.com/database-development-992372ed9e7b?source=rss-1173c47a744c------2</link>
            <guid isPermaLink="false">https://medium.com/p/992372ed9e7b</guid>
            <category><![CDATA[leetcode]]></category>
            <category><![CDATA[dbsql]]></category>
            <dc:creator><![CDATA[InFocus Engineering]]></dc:creator>
            <pubDate>Mon, 05 Jun 2023 08:44:59 GMT</pubDate>
            <atom:updated>2025-12-08T15:36:56.188Z</atom:updated>
            <content:encoded><![CDATA[<p>All-In-One Package 🐘</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/848/1*fVoNFTbbrE6Y1-x5zEo-TQ.jpeg" /></figure><blockquote><strong>Database Engineering I : Mastering Database Fundamentals</strong></blockquote><blockquote>Module 1: Querying and Filtering</blockquote><blockquote>Module 2: Joins and Aggregates</blockquote><blockquote>Module 3: Set Operators and Subqueries</blockquote><blockquote>Module 4: Modifying Data and Managing Table</blockquote><blockquote>Module 5: Data Types and Constraints</blockquote><blockquote>Module 6: SQL Conditions and Structures</blockquote><blockquote><strong>Database Engineering II : SQL Engineering Mindset in Action</strong></blockquote><blockquote>Module 1: SQL Essential Challenges I (Public)</blockquote><blockquote>Module 2: SQL Essential Challenges II (Premium)</blockquote><blockquote>Module 3: SQL Mastery Challenges I (Public)</blockquote><blockquote>Module 4: SQL Mastery Challenges II (Premium)</blockquote><blockquote>Module 5: SQL Expert Challenges I (Public)</blockquote><blockquote>Module 6: SQL Expert Challenges II (Premium)</blockquote><blockquote><strong>Database Engineering III : Advanced Database Mechanisms</strong></blockquote><blockquote>Module 1: Transactions, Query Speed, ACID Properties</blockquote><blockquote>Module 2: Concurrency Control and Isolation Levels</blockquote><blockquote>Module 3: MVCC Concept and Functional Dependencies</blockquote><blockquote>Module 4: Normalization, Indexing, Partitioning, DBCP</blockquote><blockquote>Module 5: RDBMS vs NoSQL Databases, B-Tree Indexing</blockquote><blockquote>Module 6: DBMS Architectures and Administration</blockquote><p><strong><em>“InFocus.uz — Life changing education”</em></strong></p><blockquote><strong>Database Engineering I : Mastering Database Fundamentals</strong></blockquote><blockquote>Module 1: Querying and Filtering</blockquote><p>1- Sample database (15 tables)</p><p>2- SELECT</p><p>3- ORDER BY</p><p>4- DISTINCT / ON</p><p>5- WHERE</p><p>6- LIMIT</p><p>7- FETCH</p><p>8- IN</p><p>9- BETWEEN</p><p>10- LIKE</p><p>11- IS NULL</p><p>12-Assignment I</p><p>13-Assignment II</p><blockquote>Module 2: Joins and Aggregates</blockquote><p>1- JOINS</p><p>2- INNER JOIN</p><p>3- LEFT OUTER JOIN</p><p>4- LEFT ONLY</p><p>5- RIGHT OUTER JOIN</p><p>6- RIGHT ONLY</p><p>7- FULL JOIN</p><p>8- FULL OUTER JOIN</p><p>9- ONLY OUTER</p><p>10- SELF JOIN</p><p>11- CROSS JOIN</p><p>12- NATURAL JOIN</p><p>13- GROUP BY</p><p>14- HAVING</p><p>15- GROUPING SETS</p><p>16- ROLL UP</p><p>17- CUBE</p><p>18- ANALYTIC FUNTIONS</p><p>19- ROW_NUMBER, RANK, DENSE_RANK</p><p>20- FIRST_VALUE, LAST_VALUE</p><p>21- LAG, LEAD</p><p>22- Assignment I</p><p>23- Assignment II</p><blockquote>Module 3: Set Operators and Subqueries</blockquote><p>1- UNION</p><p>2- UNION ALL</p><p>3- INTERSECT</p><p>4- EXCEPT</p><p>5- SUBQUERY</p><p>6- ANY</p><p>7- ALL</p><p>8- EXISTS</p><p>9-Assignment I</p><p>10-Assignment II</p><blockquote>Module 4: Data Types and Constraints</blockquote><p>1- INSERT</p><p>2- UPDATE</p><p>3- UPDATE JOIN</p><p>4- DELETE</p><p>5- UPSERT</p><p>6- DATA TYPE</p><p>7- CREATE TABLE</p><p>8- CTAS</p><p>9- VIEW</p><p>10- Change Table Structure</p><p>11- Change Table Name</p><p>12- Add Column</p><p>13- Remove Column</p><p>14- Change Column Datatype</p><p>15- Change Column Name</p><p>16- Remove Table</p><p>17- Temporary Table</p><p>18- TRUNCATE</p><p>19-Assignment I</p><p>20-Assignment II</p><blockquote>Module 5: Data Types &amp; Constrains</blockquote><p>1- BOOLEAN</p><p>2- CHAR, VARCHAR, TEXT</p><p>3- NUMERIC</p><p>4- SERIAL</p><p>5- DATE, TIME, TIMESTAMP</p><p>6- PRIMARY KEY</p><p>7- FOREIGN KEY</p><p>8- CHECK CONSTRAINT</p><p>9- UNIQUE CONSTRAINT</p><p>10- NOT NULL CONSTRAINT</p><p>11-Assignment I</p><p>12-Assignment II</p><blockquote>Module 6: SQL Conditions and Structures</blockquote><p>1- CASE</p><p>2- COALESCE</p><p>3- NULLIF</p><p>4- CAST</p><p>5- WITH</p><p>6- SCHEMAS</p><p>7- TRIGGERS</p><p>8- Assignment I</p><p>9- Assignment II</p><p>10- Assignment III</p><p>11- The Real Problems Start Now</p><blockquote><strong>Database Engineering II : Mastering Problem Solving in Action</strong></blockquote><blockquote>Module 1: SQL Essential Challenges I (Public)</blockquote><p>Essential 1- <a href="https://leetcode.com/problems/customers-who-never-order/">Customers Who Never Order</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 2- <a href="https://leetcode.com/problems/delete-duplicate-emails/">Delete Duplicate Emails</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 3- <a href="https://leetcode.com/problems/game-play-analysis-i/">Game Play Analysis I</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 4- <a href="https://leetcode.com/problems/customer-placing-the-largest-number-of-orders/">Customer Placing the Largest Number of Orders</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 5- <a href="https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/">Actors and Directors Who Cooperated At Least Three Times</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 6- <a href="https://leetcode.com/problems/user-activity-for-the-past-30-days-i/">User Activity for the Past 30 Days I</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 7- <a href="https://leetcode.com/problems/reformat-department-table/">Reformat Department Table</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 8- <a href="https://leetcode.com/problems/students-and-examinations/">Students and Examinations</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 9- <a href="https://leetcode.com/problems/list-the-products-ordered-in-a-period/">List the Products Ordered in a Period</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 10- <a href="https://leetcode.com/problems/top-travellers/">Top Travellers</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 11- <a href="https://leetcode.com/problems/group-sold-products-by-the-date/">Group Sold Products By The Date</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 12- <a href="https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/">Customer Who Visited but Did Not Make Any Transactions</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 13- <a href="https://leetcode.com/problems/average-time-of-process-per-machine/">Average Time of Process per Machine</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 14- <a href="https://leetcode.com/problems/fix-names-in-a-table/">Fix Names in a Table</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 15- <a href="https://leetcode.com/problems/daily-leads-and-partners/">Daily Leads and Partners</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 16- <a href="https://leetcode.com/problems/patients-with-a-condition/">Patients With a Condition</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 17- <a href="https://leetcode.com/problems/percentage-of-users-attended-a-contest/">Percentage of Users Attended a Contest</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 18- <a href="https://leetcode.com/problems/calculate-special-bonus/">Calculate Special Bonus</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 19- <a href="https://leetcode.com/problems/the-latest-login-in-2020/">The Latest Login in 2020</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 20- <a href="https://leetcode.com/problems/employees-with-missing-information/">Employees With Missing Information</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 21- Assignment I</p><p>Essential 22- Assignment II</p><p>Essential 23- Assignment III</p><p>Essential 24- Assignment IV</p><p>Essential 25- Assignment V</p><blockquote>Module 2: SQL Essential Challenges II (Premium)</blockquote><p>Essential 26- <a href="https://leetcode.com/problems/game-play-analysis-ii/">Game Play Analysis II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 27- <a href="https://leetcode.com/problems/consecutive-available-seats/">Consecutive Available Seats</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 28- <a href="https://leetcode.com/problems/shortest-distance-in-a-line/">Shortest Distance in a Line</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 29- <a href="https://leetcode.com/problems/friend-requests-i-overall-acceptance-rate/">Friend Requests I: Overall Acceptance Rate</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 30- <a href="https://leetcode.com/problems/product-sales-analysis-ii/">Product Sales Analysis II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 31- <a href="https://leetcode.com/problems/project-employees-ii/">Project Employees II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 32- <a href="https://leetcode.com/problems/sales-analysis-i/">Sales Analysis I</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 33- <a href="https://leetcode.com/problems/sales-analysis-ii/">Sales Analysis II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 34- <a href="https://leetcode.com/problems/reported-posts/">Reported Posts</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 35- <a href="https://leetcode.com/problems/user-activity-for-the-past-30-days-ii/">User Activity for the Past 30 Days II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 36- <a href="https://leetcode.com/problems/number-of-comments-per-post/">Number of Comments per Post</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 37- <a href="https://leetcode.com/problems/weather-type-in-each-country/">Weather Type in Each Country</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 38- <a href="https://leetcode.com/problems/find-the-team-size/">Find the Team Size</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 39- <a href="https://leetcode.com/problems/ads-performance/">Ads Performance</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 40- <a href="https://leetcode.com/problems/students-with-invalid-departments/">Students With Invalid Departments</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 41- <a href="https://leetcode.com/problems/npv-queries/">NPV Queries</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 42- <a href="https://leetcode.com/problems/create-a-session-bar-chart/">Create a Session Bar Chart</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 43- <a href="https://leetcode.com/problems/friendly-movies-streamed-last-month/">Friendly Movies Streamed Last Month</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 44- <a href="https://leetcode.com/problems/customer-order-frequency/">Customer Order Frequency</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 45- <a href="https://leetcode.com/problems/fix-product-name-format/">Fix Product Name Format</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Essential 46- Assignment I</p><p>Essential 47- Assignment II</p><p>Essential 48- Assignment III</p><p>Essential 49- Assignment VI</p><p>Essential 50- Assignment V</p><blockquote>Module 3: SQL Mastery Challenges I (Public)</blockquote><p>Mastery 1 - <a href="https://leetcode.com/problems/second-highest-salary/">Second Highest Salary</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 2- <a href="https://leetcode.com/problems/nth-highest-salary/">Nth Highest Salary</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 3- <a href="https://leetcode.com/problems/rank-scores/">Rank Scores</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 4- <a href="https://leetcode.com/problems/consecutive-numbers/">Consecutive Numbers</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 5- <a href="https://leetcode.com/problems/department-highest-salary/">Department Highest Salary</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 6- <a href="https://leetcode.com/problems/game-play-analysis-iv/">Game Play Analysis IV</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 7- <a href="https://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/">Friend Requests II: Who Has the Most Friends</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 8- <a href="https://leetcode.com/problems/customers-who-bought-all-products/">Customers Who Bought All Products</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 9- <a href="https://leetcode.com/problems/product-sales-analysis-iii/">Product Sales Analysis III</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 10- <a href="https://leetcode.com/problems/market-analysis-i/">Market Analysis I</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 11- <a href="https://leetcode.com/problems/product-price-at-a-given-date/">Product Price at a Given Date</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 12- <a href="https://leetcode.com/problems/immediate-food-delivery-ii/">Immediate Food Delivery II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 13- <a href="https://leetcode.com/problems/monthly-transactions-i/">Monthly Transactions I</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 14- <a href="https://leetcode.com/problems/restaurant-growth/">Restaurant Growth</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 15- <a href="https://leetcode.com/problems/movie-rating/">Movie Rating</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 16- Assignment I</p><p>Mastery 17- Assignment II</p><p>Mastery 18- Assignment III</p><p>Mastery 19- Assignment IV</p><p>Mastery 20- Assignment V</p><blockquote>Module 4: SQL Mastery Challenges II (Premium)</blockquote><p>Mastery 21- <a href="https://leetcode.com/problems/game-play-analysis-iii/">Game Play Analysis III</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 22- <a href="https://leetcode.com/problems/shortest-distance-in-a-plane/">Shortest Distance in a Plane</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 23- <a href="https://leetcode.com/problems/get-highest-answer-rate-question/">Get Highest Answer Rate Question</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 24- <a href="https://leetcode.com/problems/count-student-number-in-departments/">Count Student Number in Departments</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 25- <a href="https://leetcode.com/problems/second-degree-follower/">Second Degree Follower</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 26- <a href="https://leetcode.com/problems/project-employees-iii/">Project Employees III</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 27- <a href="https://leetcode.com/problems/unpopular-books/">Unpopular Books</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 28- <a href="https://leetcode.com/problems/new-users-daily-count/">New Users Daily Count</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 29- <a href="https://leetcode.com/problems/highest-grade-for-each-student/">Highest Grade For Each Student</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 30- <a href="https://leetcode.com/problems/active-businesses/">Active Businesses</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 31- <a href="https://leetcode.com/problems/reported-posts-ii/">Reported Posts II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 32- <a href="https://leetcode.com/problems/article-views-ii/">Article Views II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 33- <a href="https://leetcode.com/problems/monthly-transactions-ii/">Monthly Transactions II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 34- <a href="https://leetcode.com/problems/team-scores-in-football-tournament/">Team Scores in Football Tournament</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 35- <a href="https://leetcode.com/problems/page-recommendations/">Page Recommendations</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Mastery 36- Assignment I</p><p>Mastery 37- Assignment II</p><p>Mastery 38- Assignment III</p><p>Mastery 39- Assignment IV</p><p>Mastery 40- Assignment V</p><blockquote>Module 5: SQL Expert Challenges I (Public)</blockquote><p>Expert 1- <a href="https://leetcode.com/problems/department-top-three-salaries/">Department Top Three Salaries</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 2- <a href="https://leetcode.com/problems/human-traffic-of-stadium/">Human Traffic of Stadium</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 3- <a href="https://leetcode.com/problems/trips-and-users/">Trips and Users</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 4- <a href="https://leetcode.com/problems/median-employee-salary/">Median Employee Salary</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 5- <a href="https://leetcode.com/problems/find-median-given-frequency-of-numbers/">Find Median Given Frequency of Numbers</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 6- <a href="https://leetcode.com/problems/find-cumulative-salary-of-an-employee/">Find Cumulative Salary of an Employee</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 7- <a href="https://leetcode.com/problems/average-salary-departments-vs-company/">Average Salary: Departments VS Company</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 8- <a href="https://leetcode.com/problems/students-report-by-geography/">Students Report By Geography</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 9- Assignment I</p><p>Expert 10- Assignment II</p><blockquote>Module 6: SQL Expert Challenges II (Premium)</blockquote><p>Expert 11- <a href="https://leetcode.com/problems/tournament-winners/">Tournament Winners</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 12- <a href="https://leetcode.com/problems/number-of-transactions-per-visit/">Number of Transactions per Visit</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 13- <a href="https://leetcode.com/problems/get-the-second-most-recent-activity/">Get the Second Most Recent Activity</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 14- <a href="https://leetcode.com/problems/total-sales-amount-by-year/">Total Sales Amount by Year</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 15 - <a href="https://leetcode.com/problems/find-the-quiet-students-in-all-exams/">Find the Quiet Students in All Exams</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 16- <a href="https://leetcode.com/problems/hopper-company-queries-i/">Hopper Company Queries I</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 17- <a href="https://leetcode.com/problems/hopper-company-queries-ii/">Hopper Company Queries II</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 18- <a href="https://leetcode.com/problems/hopper-company-queries-iii/">Hopper Company Queries III</a></p><p><em>(Includes Solution-1 and Solution-2)</em></p><p>Expert 19- Assignment I</p><p>Expert 20- Assignment II</p><blockquote><strong>Database Engineering III : Advanced Database Mechanisms</strong></blockquote><blockquote>Module 1: Transactions, Query Speed, ACID Properties</blockquote><p>1- Time to Check Your Query Muscles</p><p>2- Transaction Management, TCL</p><p>2.1- SQL, AutoCommit, False, Commit, Rollback, Savepoint</p><p>3- Transaction (BEGIN, COMMIT)</p><p>3.1- Begin, Commit, Session 1, Session 2, Begin, No Commit</p><p>4- Transaction (BEGIN, ROLLBACK)</p><p>4.1- Begin, Rollback, Session 1, Session 2, Begin, No Rollback</p><p>5- Transaction (LOCK)</p><p>5.1- Begin, No Commit, Session 1, Session 2, Waiting for the …</p><p>6- Fast and Slow Queries</p><p>6.1- Query 1, SUBSTRING, Query 2, LIKE, Does Index Work?</p><p>7- ACID Properties (Atomicity)</p><p>7.1- All or Nothing, Transaction, Begin, Commit, Rollback</p><p>8- ACID Properties (Consistency)</p><p>8.1- Logically Correct, Transaction, Check Constraints</p><p>9- ACID Properties (Isolation)</p><p>9.1- Multiple Transactions, Transaction 1, Transaction 2</p><p>10- ACID Properties (Durability)</p><p>10.1- Transaction Completed, DBMS, Write-Ahead Logging</p><blockquote>Module 2: Concurrency Control and Isolation Levels</blockquote><p>1– Isolation Levels: What Every Developer Must Know</p><p>2– Concurrency Control I</p><p>2.1- Lost updates, Cases, Schedules, Speed</p><p>2.2– Serial Schedule, Non-Serial Schedule</p><p>3– Concurrency Control II</p><p>3.1– Read-Write Conflict, Write-Write Conflict</p><p>3.2– Conflict Equivalent, Conflict Serializable</p><p>4– Concurrency Control III</p><p>4.1– Unrecoverable, Recoverable Schedules</p><p>4.2– Cascading Rollback, Cascadeless Schedule</p><p>5- Isolation Level I</p><p>5.1- Dirty Read, Non-Repeatable Read, Phantom Read</p><p>6- Isolation Level II</p><p>6.1- Dirty Write, Lost Update, Dirty Read</p><p>7- Isolation Level III</p><p>7.1- Read Skew, Write Skew, Phantom Read</p><p>8- Isolation Level IV</p><p>8.1- Snapshot, MySQL, Oracle, SQL Server, PostgreSQL</p><p>9- Concurrency Control IV</p><p>9.1- Lock, Write-Lock, Read-Lock, Strange Phenomena</p><p>10- Concurrency Control V</p><p>10.1- 2PL Protocol, Deadlock, 2PL Types, Strict 2PL (S2PL)</p><blockquote>Module 3: MVCC Concept and Functional Dependencies</blockquote><p>1- The Secret Behind Database Consistency</p><p>2- Database MVCC Concept I</p><p>2.1- MVCC Background, MVCC Explanation, MVCC Examples</p><p>3- Database MVCC Concept II</p><p>3.1- Lost Update Problem, Solution, PostgreSQL, MySQL</p><p>4- Database MVCC Concept III</p><p>4.1- Lost Update, MySQL, Write Skew, Repeatable Read</p><p>5- Database MVCC Concept IV</p><p>5.1- Write Skew in MySQL, Write Skew in PostgreSQL</p><p>6- Incorrect Database Design I</p><p>6.1- Insertion Anomalies, Deletion Anomalies, Update Anomalies</p><p>7- Incorrect Database Design II</p><p>7.1- Spurious Tuples Problem, Bad Design, Good DB Schema</p><p>8- Functional Dependency I</p><p>8.1- Multiple FDs, Left-Hand Side, Right-Hand Side</p><p>9- Functional Dependency II</p><p>9.1- Trivial FD, Non-Trivial FD, Partial FD, Full FD</p><p>10- Functional Dependency III</p><p>10.1- Armstrong’s Axioms, Closure of an Attribute Set</p><blockquote>Module 4: Normalization, Indexing, Partitioning, DBCP</blockquote><p>1- Designing Databases for Speed and Scale</p><p>2- Normalization Concept I</p><p>2.1- Table, Functional Dependency, Normalization</p><p>3- Normalization Concept II</p><p>3.1- Introduction to 1NF, Introduction to 2NF</p><p>4- Normalization Concept III</p><p>4.1- Introduction to 3NF, Introduction to BCNF</p><p>5- Database Indexing I</p><p>5.1- Performance, Reasons, B-Tree-Based Indexes</p><p>6- Database Indexing II</p><p>6.1- Covering Index, Many Indexes, Full Scan</p><p>7- Database Partitioning</p><p>7.1- Vertical Partitioning, Horizontal Partitioning</p><p>8- Database Sharding, Replication</p><p>8.1- Partitioning, Sharding, Replication</p><p>9- Database Connection Pool I</p><p>9.1- Web Application Server (WAS), Connection Pool, HikariCP</p><p>10- Database Connection Pool II</p><p>10.1- DBCP (maximumPoolSize), DBMS (max_connections), minimumIdle</p><blockquote>Module 5: RDBMS vs NoSQL, B-Tree Indexing, Architecture</blockquote><p>1- The Hidden Architecture of Data Access</p><p>2- RDBMS vs NoSQL Database I</p><p>2.1- RDB Disadvantages, Schema, Joins, Scaling, ACID Affects</p><p>3- RDBMS vs NoSQL Database II</p><p>3.1- MongoDB, Schema, Duplication, Scaling-out, Throughput</p><p>4- Binary Search Tree (BST)</p><p>4.1- BST, Depth First Traversal, Breadth First Traversal</p><p>5- B-Tree Indexing I</p><p>5.1- BST, B-Tree, M-Order B-Tree, M, M-1, [M/2], [M/2]-1</p><p>6- B-Tree Indexing II</p><p>6.1- Data Insertion, 3rd B-Tree, Leaf Nodes, Same Level</p><p>7- B-Tree Indexing III</p><p>7.1- B-Tree Deletion, Leaf Node, Problems, Solutions</p><p>8- B-Tree Indexing IV</p><p>8.1- B-Tree Deletion, Internal Node, Problems, Solutions</p><p>9- B-Tree Indexing V</p><p>9.1- Secondary Storage, AVL Tree Index, 5th Order B-Tree Index</p><p>10- B-Tree Indexing VI</p><p>10.1- B-Tree Index, 101 Order B-Tree, M, M-1, [M/2], [M/2]-1</p><blockquote>Module 6: DBMS Architectures and Administration</blockquote><p>1- PostgreSQL Architecture</p><p>1.1- Logical &amp; Physical Structures, Process &amp; Memory Architectures</p><p>2- PostgreSQL Administration</p><p>2.1- postgresql.auto.conf, pg_ctl, pgtune, pgconfig, cybertec</p><p>3- MySQL Architecture</p><p>3.1- Server Engines, Connection Layer, SQL Layer, Storage Layer</p><p>4- MySQL Administration</p><p>4.1- my.cnf, Option File Groups, Redhat Package Manager, Log Types</p><p>5- Oracle Architecture</p><p>5.1- Client, Listener, DB Server, Memory, Process, Disk, SGA, PGA</p><p>6- Oracle Administration</p><p>6.1- User &amp;Server Process, Instance Startup, Instance Shutdown</p><p>7- SQL Server Architecture</p><p>7.1- SQL Server, Protocol Layer, Relational Engine, Storage Engine</p><p>8- SQL Server Administration</p><p>8.1- SSMS Configuration, Start &amp; Stop Server, Restore &amp; Backup</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=992372ed9e7b" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>