Udemy – 10-day MySQL bootcamp

Day 1: Getting started with SQL and My SQL

• An introduction to databases
• Set up MySQL / My SQL
• Familiarity with basic database terminology
• Getting to know the MySQL interface
• Writing basic SQL commands and querying the database

Day 2: Selection – A closer look

• Check the SELECT statement
• Selecting and extracting data from tables
• Various options and settings related to SELECT

Day 3: Where – A closer look

• Understanding the WHERE clause
• Filter data based on different conditions
• Complex WHERE clauses

Fourth day: Grouping and consolidation

• An introduction to data grouping
• Use of mass functions (SUM, AVG, MAX, MIN, COUNT)
• Basics of the GROUP BY and HAVING clauses

Day 5: Joining

• Overview of JOINS
• Types of connections (internal, left, right, self, cross, natural)
• Practical examples and use cases

Day Six: Database Design

• Principles of database design
• Understanding relationships (one-to-one, one-to-many, many-to-many)
• Normalization and its types

Day 7: DDL (Data Definition Language)

• Understanding DDL commands (CREATE, ALTER, DROP)
• Create and manage tables and databases

Day 8: DML (Data Manipulation Language)

• Overview of DML commands (INSERT, UPDATE, DELETE)
• Manipulation of data in tables

Day 9: Subquestions and functions

• Develop sub-questions
• WORKS BY ANY, ALL, EXISTS, NOT EXISTS

Day 10: MySQL with Python

• Setting up the Python-MySQL environment
• Running MySQL commands from Python

Day 10: MySQL with Java

• Configure MySQL with Java
• Running MySQL commands from Java

What will you learn in this SQL database design course?

• By the end of this course, you will be able to write SQL queries to perform data analysis and even manage data yourself.
• Learn how to design and structure your database by becoming familiar with various relationships and normalization techniques.
• Gain a thorough understanding of SQL syntax to effectively query, modify, and manage data in a database using MySQL. SQL concepts and knowledge applicable to platforms such as PostgreSQL and SQL Server.
• Develop a solid foundation in creating, editing, and managing databases using MySQL, an open source relational database management system.
• Learn how to perform data analysis to extract actionable insights from complex data sets using advanced SQL queries that can help you make informed business decisions.
• Develop a comprehensive understanding of database concepts, including database design and normalization, which are essential to maintaining data integrity and consistency.
• Take part in over 50 hands-on My SQL challenges to apply your knowledge to real-world scenarios.
• Learn how to use MySQL with common development environments such as Java and Python.

Database Design with MySQL Course Features:

• More than 150 examples/challenges
• Practical exercises and real project examples
• Taught by an experienced teacher
• Together with a certificate of completion

Prerequisites for this SQL with MySQL course:

• No prior knowledge of SQL or databases is required

The target group for this SQL with MySQL course:

• Engineering programmers/architects who want to learn SQL to build database-driven applications
• Budding data analysts and business analysts
• Professionals who want to improve their SQL knowledge
• Students and enthusiasts who want to learn SQL to succeed in their career

Let’s embark on this 10-day journey to transition from beginner to database master, able to integrate the functionality of MySQL with Python and Java. Let’s get data driven.

installation Guide

After extracting, you can watch it with your favorite player.

Subtitles: None

Quality: 720p