Share Description
In this course, you will :
- Become a SQL Guru! Be that 'go-to' person!.
- Master SQL to create reports from realistic MySQL databases.
- See how to aggregate and analyze data using SQL functions.
- Create your own database through the power of SQL.
- Understand How to Leverage Database Transactions.
- Tune SQL statements for optimum performance.
- Avoid common mistakes with SQL.
Syllabus :
- SQL Beginner to Guru MySQL Edition Introduction
- Introduction to SQL
- Installation of MySQL
- Connecting to MySQL
- Selecting Data from a Single Table
- Grouping and Summarizing Data with SQL
- Using SQL to Select Data from More Than One Table
- Using SQL to Insert Data
- Using SQL to Update Data
- Using SQL to Delete Data
- Using SQL Transactions
- Advanced SQL Reporting
- Introduction to DDL Statements - Creating SQL Views
- Using SQL to Create MySQL Database Tables
- Using SQL to Update Tables
