Database Bootcamp: SQL, Python, Integration, and MORE!

سرفصل های دوره

Master SQL, Python, Integration, and Advanced Data Management Techniques for Comprehensive Data Analysis

1. Database Fundamentals

1. Understand What a Database Is

2. Understand the Importance of Databases in Software Development.html

3. Categorize Databases Relational, NoSQL, and Beyond

4. Databases An Introductory Guide.html

2. Exploring Relational Databases

1. Delve into Relational Database Concepts An Overview

2. Grasp Tables, Rows, and Columns Essential Database Components

3. Master Primary Keys and Foreign Keys Database Key Concepts

4.1 Slides normalization.pdf

4. Optimize Data Normalization and Database Design Essentials

5. Normalization CheatSheet.html

3. Mastering SQL (Structured Query Language)

1. Unveil SQL (Structured Query Language) An Introduction

2. Begin Your SQL Journey

3. Installing on Windows Step-by-Step Guide

4. Mastering SQL Essentials SELECT, INSERT, UPDATE, DELETE Commands

5. Creating Tables in SQL Step-by-Step Tutorial

6. Inserting Data with SQL A Comprehensive Guide

7. Updating Data in SQL Essential Techniques

8. Deleting Data in SQL Best Practices and Procedures

9. Executing SELECT Queries in SQL

10. Refining Data Advanced Filtering and Sorting Techniques

11.1 inner join.txt

11. Mastering SQL Joins and Relationships

12.1 all joins.txt

12. Comprehensive Guide to SQL Joins

13. Unlocking the Power of SQL Aggregation Functions COUNT, SUM, AVG, and More

14. Retrieving Employee Names and Their Respective Departments in SQL.html

15. Retrieving Employee Names in the Engineering Department.html

16. Retrieving the total number of employees in each department..html

17. SQL cheat Sheet.html

4. Database Connectivity in Programming Languages

1. Module Introduction Connecting to Databases in Programming Languages

2. Getting Started with Python

3. Installing mysql-connector Step-by-Step Guide

4. Establishing and Verifying Database Connections

5. Mastering CRUD Operations (Create, Read, Update, Delete)

1. Module Introduction CRUD Operations (Create, Read, Update, Delete)

2. Creating a Database Step-by-Step Guide

3. Creating Database Tables Step-by-Step Tutorial

4. Executing Read Operations Retrieving Data from Databases

5. Performing Update Operations Modifying Database Records

6. Executing Delete Operations Removing Data from Databases

7. Building a Simple Library Database.html

6. Wrapping Up the Course

1. Recap of Key Course Concepts

2. Advancing Your Database Programming Skills

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy