SQL 5 Day Xander

None

In this 5 day course you will achieve the following:

• Learn how to correctly structure your database
• Structure efficient SQL statements using Functions, Sub Queries, Window functions, views
• Understand the working of Stored procedures and triggers
• Learn performance optimization techniques and best practices in SQL

• Database normalization and ER modelling
• MySQL setup and installation
• Working with Database and tables
• Operators, constraints, and data types
• Functions in SQL
• Subqueries, Operators and Derived Tables in SQL
• Window functions in SQL
• Working with Views
• Stored procedures and triggers in SQL
• Performance Optimization and Best Practices in SQL