Description
In this course, you will :
- Become an expert in SQL.
- Learn how to code in SQL.
- Boost your resume by learning an in-demand skill.
- Create, design, and operate with SQL databases.
- Start using MySQL – the #1 Database Management System.
- Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities.
- Adopt professionally tested SQL best practices.
- Gain theoretical insights about relational databases.
- Work with a sophisticated real-life database throughout the course.
- Get maximum preparation for real-life database management.
- Add data analytical tools to your skillset.
- Develop business intuition while solving tasks with big data.
- Study relational database management theory that you will need in your workplace every day.
- Learn how to create a database from scratch.
- The ability to take control of your dataset – insert, update, and delete records from your database.
- Be confident while working with constraints and relating data tables.
- Become a proficient MySQL Workbench user.
- Acquire top-notch coding techniques and best practices.
- Know how to answer specific business questions by using SQL’s aggregate functions.
- Handle complex SQL joins with ease.
- Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more.
- Merge coding skills and business acumen to solve complex analytical problems.
- Become a proficient SQL user by writing flawless and efficient queries.
- Tons of exercises that will solidify your knowledge.
- The freedom to query anything you like from a database.
Syllabus :
- Introduction to databases, SQL, and MySQL
- SQL theory
- Basic database terminology
- Installing MySQL and getting acquainted with the interface
- First steps in SQL
- MySQL constraints
- SQL best practices
- Loading the 'employees' database
- SQL SELECT statement
- SQL INSERT statement
- SQL UPDATE Statement
- SQL DELETE Statement
- MySQL - Aggregate functions
- SQL Joins
- SQL Subqueries
- SQL Self Join
- SQL Views
- Stored routines
- Advanced SQL Topics
- Combining SQL and Tableau - Introduction
- Combining SQL and Tableau - Task