SQL Mastery for Developers: Basics to Advanced Applications

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

Forge ahead in SQL mastery, seamlessly blending theory and practice, minus the DB admin detour!

1. Introduction

1. Introduction to SQL

2. Exploring SQL Databases

3. Course Objectives and Structure

2. SQL Fundamentals

1. SQL Fundamentals

2. Getting Started with SQL Databases and Their Differences

3. Setting Up a Development Environment

4. Setting Up a Development Environment Hands-On with MS SQL

5. Setting Up a Development Environment Hands-On with MS SQL using phpMyAdmin

6. Basic SQL Commands

3. Working with Data in SQL

1. Working with Data in SQL

2. Advanced Data Operations

3. Complex CRUD Operations

4. Demo on Creating and Managing Data across Databases

4. SQL Querying Techniques

1. SQL Querying Techniques

2. Demo on Sophisticated Queries in MS SQL

3. Mastering Data Retrieval

4. Data Aggregation

5. Demo on Using GROUP BY and HAVING Clauses in MS SQL

6. Demo on GROUP BY and HAVING Clauses in phpMyAdmin

7. Demo on Sophisticated Queries in phpMyAdmin

5. Application Development with SQL

1. Application Development with SQL

2. SQL Integration in Python Applications

3. Demo on Developing a Python Application using MySQL

4. Demo on Developing a Python Application using SQLite3

5. Demo on Developing a Python Application using MS SQL

6. Incorporating SQL in JavaScript Projects

7. Demo on Developing a JavaScript Application using MS SQL

8. Demo on Creating an HTML Page with CRUD Operations using JavaScript and MS SQL

6. Advanced SQL for Developers

1. Advanced SQL for Developers

2. Developing with SQL in Web Applications

3. Performance Tuning and Optimization

189,000 تومان

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

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

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

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