What you’ll study
-
Primary Database Design (Tables, Columns, Knowledge Varieties, Main Keys, International Keys, Normalization)
-
The best way to Use set up and MySQL Workbench
-
SELECT Statements: Queries towards single tables (Filtering, Ordering, Grouping)
-
DELETE: The best way to take away information from a database
-
INSERT INTO: The best way to insert information right into a desk
-
UPDATE: The best way to replace present information
-
General Database Development Finest Practices
-
Creating Relationships and International Keys
-
The best way to craft SQL statements primarily based on actual eventualities
-
The best way to export Question Outcomes to Excel
-
Utilizing Combination Capabilities in SQL
-
The best way to question associated information from a number of tables
Submit expires at 2:50pm on Saturday January twenty first, 2023