SQL Bootcamp: Manipulate Data Like a Pro 2024

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

Basics to Pro by working daily on real-life projects

1. Introduction

1. Online Compiler

2. Install MySQL Workbench- Optional

2. Database and Table Operations

1. CREATE DATABASE, USE

2. CREATE TABLE

3. ALTER TABLE, DROP TABLE

4. Database and Table Operations Quiz.html

5. Database and Table Operations Assignment.html

3. Basic Data Manipulations

1. INSERT INTO

2. SELECT, FROM, WHERE, ORDER BY, LIMIT

3. UPDATE, DELETE

4. Basic data Manipulations.html

5. Basic Data Manipulations.html

4. Advanced Data Selection Techniques

1. INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN

2. FILTER QUERIES

3. GROUP BY, HAVING, AGGREGATE FUNCTIONS

4. Advanced Data Selection Techniques.html

5. Advanced Data Selection Techniques.html

Files.zip

5. Data Definition and Table Management

1. CREATE INDEX, DROP INDEX

2. PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL

3. CREATE TEMPORARY TABLE, LIKE

4. Quiz Data Definition and Table Management.html

5. Assignment Data Definition and Table Management.html

Files.zip

6. Advanced MySQL Features

1. CREATE VIEW, ALTER VIEW, DROP VIEW

2. STORED PROCEDURES

3. FUNCTIONS

4. Quiz Advanced MySQL Features.html

5. Assignment.html

Files.zip

7. Transaction Control and Security

1. CREATE TRIGGER, BEFORE, AFTER, INSERT, UPDATE, DELETE

2. START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT

3. CREATE USER, GRANT, REVOKE

4. Quiz Transaction Control and Security.html

5. Assignment Quiz Transaction Control and Security.html

Files.zip

8. Performance Tuning and Optimization

1. EXPLAIN, OPTIMIZE TABLE

2. Indexing Strategies for Performance

3. OPTIMIZING JOINS

4. Quiz Performance Tuning and Optimization.html

5. Assignment Performance Tuning and Optimization.html

“Comprehensive Bioinformatics: Learn Genomics Data Analysis” به سبد خرید شما اضافه شد. مشاهده سبد خرید

189,000 تومان

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

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

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

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