GigaCourse Com Udemy Relational Databases SQL Complete Guide for Developers

/0. Websites you may like/

[CourseClub.Me].url

[GigaCourse.Com].url

/1. Introduction/

1. Communication plan.mp4

1. Communication plan.srt

1.1 Facebook of the Tutor.html

1.2 Facebook Page with Udemy Coupons from Learn IT University.html

1.3 Instagram of the Tutor.html

1.4 IT-Bulls Company Official Web Site.html

1.5 LinkedIn of the Tutor.html

1.6 LinkedIn IT-Bulls company - official page.html

1.7 Patreon account of the Tutor.html

1.8 Telegram Channel with Latest News, coupons and important information.html

1.9 Youtube channel with free lessons and blog.html

2. Unlimited access to 'Learn IT' application for students.mp4

2. Unlimited access to 'Learn IT' application for students.srt

2.1 Learn IT application in Play Market.html

2.2 Page where you can generate FREE bonus code for your self to remove limits in Application.html

3. Tips to Improve Your Course Taking Experience.html

/10. DAO/

1. DAO (Data Access Object) Design Pattern.mp4

1. DAO (Data Access Object) Design Pattern.srt

1.1 Source code example from the lesson.html

/11. ===== JDBC, SQL & Databases Interview Preparation =====/

1. How to be prepared for the interview.html

2. Part 1 JDBC & Databases - Questions and Answers.html

3. Part 2 Databases - Questions and Answers.html

4. Part 3 SQL - Questions and Answers.html

5. Part 4 SQL - Questions and Answers.html

/12. ===== Exam DAO, Database, JDBC, SQL ======/

1. Exam task review and solution.mp4

1. Exam task review and solution.srt

1.1 Homework description and reference to the solution.html

/13. ORM, JPA & Hibernate/

1. Introduction to JPA & ORM.mp4

1. Introduction to JPA & ORM.srt

2. First JPA Project Entity, ID GenerationType, Composite Primary Keys, etc).mp4

2. First JPA Project Entity, ID GenerationType, Composite Primary Keys, etc).srt

2.1 Source code of examples from the lesson.html

3. First JPA Project - Part 2 EntityManager, persistence.xml, Transactions in JPA.mp4

3. First JPA Project - Part 2 EntityManager, persistence.xml, Transactions in JPA.srt

3.1 Source code of examples from the lesson.html

4. Operations with Entity (Create, Read, Update, Delete) & JPA Entity Lifecycle.mp4

4. Operations with Entity (Create, Read, Update, Delete) & JPA Entity Lifecycle.srt

4.1 Source code of examples from the lesson.html

5. Locking JPA Optimistic & Pessimistic Locking.mp4

5. Locking JPA Optimistic & Pessimistic Locking.srt

5.1 Source code of examples from the lesson.html

6. Relationships Between Entities.mp4

6. Relationships Between Entities.srt

6.1 Source code of examples from the lesson.html

7. JPA Queries (Query, TypedQuery, NativeQuery, JPQL, Criteria API).mp4

7. JPA Queries (Query, TypedQuery, NativeQuery, JPQL, Criteria API).srt

7.1 Source code of examples from the lesson.html

8. Caching in JPAHibernate.mp4

8. Caching in JPAHibernate.srt

8.1 Source code of examples from the lesson.html

9. N+1 Problem and Solution.mp4

9. N+1 Problem and Solution.srt

9.1 Source code of examples from the lesson.html

/14. ===== ORM & JPA Interview Preparation =====/

1. Part 1 ORM & Hibernate Interview - Questions and Answers.html

2. Part 2 ORM & Hibernate Interview - Questions and Answers.html

3. Part 3 JPA Interview - Questions and Answers.html

4. Part 4 JPA Interview - Questions and Answers.html

/15. ===== EXAM TASK JPA & Hibernate =====/

1. ===== EXAM TASK JPA & Hibernate =====.mp4

1. ===== EXAM TASK JPA & Hibernate =====.srt

1.1 Homework description and reference to the solution.html

/16. EXTRA Spring Data/

1. Intro to the Section.html

2. Spring Data & Spring Data JPA Overview.mp4

2. Spring Data & Spring Data JPA Overview.srt

3. Spring Data JPA Practice.mp4

3. Spring Data JPA Practice.srt

3.1 Source code of examples (commit with changes).html

[CourseClub.Me].url

[GigaCourse.Com].url

/17. ===== EXAM Spring Data JPA - Online Shop =====/

1. EXAM Spring Data JPA - Online Shop.html

/18. Spring JDBC/

1. Spring JDBC Overview.mp4

1. Spring JDBC Overview.srt

2. Spring JDBC Practice.mp4

2. Spring JDBC Practice.srt

2.1 Source code of examples (commit with changes).html

/19. ===== EXAM Spring JDBC - Online Shop =====/

1. EXAM Spring JDBC - Online Shop.html

/2. Overview/

1. Databases Overview - Part 1.mp4

1. Databases Overview - Part 1.srt

2. Databases Overview - Part 2.mp4

2. Databases Overview - Part 2.srt

[CourseClub.Me].url

[GigaCourse.Com].url

/20. Bonus section/

1. Bonus lesson.mp4

1. Bonus lesson.srt

1.1 Facebook Page with Udemy Coupons from Learn IT University.html

1.10 Support me on Patreon by getting access to EXCLUSIVE content.html

1.11 Telegram Channel with Latest News and important information.html

1.12 Youtube channel with free lessons and blog.html

1.2 Facebook Andrii Piatakha.html

1.3 Free book about AI by Andrii Piatakha (sci-fi).html

1.4 Instagram Andrii Piatakha.html

1.5 IT-Bulls Company Official Web Site.html

1.6 Java Course From zero to first job.html

1.7 LinkedIn Andrii PIatakha.html

1.8 LinkedIn IT-Bulls company - official page.html

1.9 Public profile of Tutor with list of all courses - Andrii Piatakha.html

/3. Environment Configuration/

1. MySQL Overview & Installation (including Workbench Installation).mp4

1. MySQL Overview & Installation (including Workbench Installation).srt

1.1 How to Install MySQL on MacOS.html

1.2 Microsoft MySQL Installer.html

2. PostgreSQL Overview & Installation (including pgAdmin installation).mp4

2. PostgreSQL Overview & Installation (including pgAdmin installation).srt

2.1 Guide How to install PostgreSQL on Mac.html

2.2 PostgreSQL download.html

/4. Relational databases/

1. Relational Databases Basic Concepts.mp4

1. Relational Databases Basic Concepts.srt

2. Create Schema & Table Naming, Collation, Engines, Types, Column Properties.mp4

2. Create Schema & Table Naming, Collation, Engines, Types, Column Properties.srt

3. Referential Integrity Foreign Key Constraint & Cascading Operations.mp4

3. Referential Integrity Foreign Key Constraint & Cascading Operations.srt

4. Indexes in Databases.mp4

4. Indexes in Databases.srt

5. Database Normalization & Denormalization.mp4

5. Database Normalization & Denormalization.srt

/5. SQL/

1. SQL General Overview & DDL.mp4

1. SQL General Overview & DDL.srt

1.1 MySQL Documentation about statements.html

1.2 Query Examples that were shown in the lesson.html

2. SQL DML - CRUD Operations (SELECT, INSERT, UPDATE, DELETE).mp4

2. SQL DML - CRUD Operations (SELECT, INSERT, UPDATE, DELETE).srt

2.1 INSERT statement documentation.html

2.2 Query Examples that were shown in the lesson.html

3. JOIN Queries, UNION & Subqueries.mp4

3. JOIN Queries, UNION & Subqueries.srt

3.1 Query Examples that were shown in the lesson.html

/6. Relational Databases (Advanced)/

1. Views, Triggers, Stored Procedures & Functions.mp4

1. Views, Triggers, Stored Procedures & Functions.srt

1.1 Find folders with Views, Triggers, Stored Procedures, and Stored Functions SQL query examples here.html

2. MySQL Workbench Administration.mp4

2. MySQL Workbench Administration.srt

/7. Databases Database Modelling and Architecture/

1. Database Modelling & Design Conceptual, Logical and Physical Data Models.mp4

1. Database Modelling & Design Conceptual, Logical and Physical Data Models.srt

/8. EXTRA Work with Databases from Java Programs/

1. JDBC Overview Establish connection with DB from Java App.mp4

1. JDBC Overview Establish connection with DB from Java App.srt

1.1 Source code example from the lesson.html

2. Statement, PreparedStatement & CallableStatement.mp4

2. Statement, PreparedStatement & CallableStatement.srt

2.1 Source code example from the lesson.html

3. Transactions, Batch Updates and MetaData.mp4

3. Transactions, Batch Updates and MetaData.srt

3.1 Source code example from the lesson.html

/9. ===== SQL Homework Online Shop =====/

1. SQL Homework Task and Solution review.mp4

1. SQL Homework Task and Solution review.srt

1.1 Homework with links to solution.html

[CourseClub.Me].url

[GigaCourse.Com].url

/

[CourseClub.Me].url

[GigaCourse.Com].url

Total files 149