Share Description
In this course, you will learn :
- The fundamentals of SQL, such as how to create a database and insert, query, and update data.
- Basic concepts that developers and data scientists use on a daily basis, such as multi-table operations, nested queries, and how to set up views.
- Able to run SQL queries in your browser and see real-time results - no need to worry about setup.
- Some hands-on practise with common SQL interview questions at the end of this course, so that when the time comes, you'll be ready and confident to answer any question that comes your way.
Syllabus :
1. Introduction
- Introduction
- Relational vs Non-Relational
- MySQL History & Architecture
2. Basic SQL
- Exploring MySQL
- Create Database
- Data Types
- Create Table
- ... continue
- Temporary Table
- Collations & Character Sets
- Inserting Data
- Querying Data
- LIKE Operator
- Combining Conditions
- ORDER BY
- LIMIT
- Deleting Data
- TRUNCATE
- Updating Data
- Primary Key and Indexes
- ... continued
- Alterations
- Alter Index
- More on Alter
- Alias
- DISTINCT
- Aggregate Methods
- GROUP BY
- HAVING
3. Joins
- Types of Joins
- Self Inner Join
- Inner Join
- Union
- Left and Right Joins
- Natural Join
4. Nested Queries
- Nested Scalar Queries
- Nested Column Queries
- Nested Row Queries
- EXISTS Operator
- Correlated Queries
5. Multi Table Operations
- Multi-Table Delete
- Multi-Table Update
- SELECT and INSERT
- REPLACE
6. Views
- Creating a View
- Updateable Views
- With Check Option
- Local & Cascaded Check
- Drop, Show, & Rename Views
7. Stored Procedures
- What are Stored Procedures?
- Create, Delete, and Alter a Stored Procedure
- Variables
- Parameters
- Conditional Statements
- Iterative Statements
- Cursors
- Error Handling
- SIGNAL and RESIGNAL
- Stored Functions
8. Triggers
- What are Triggers?
- Create and Delete a Trigger
- INSERT Triggers
- UPDATE Triggers
- DELETE Triggers
- Multiple Triggers
9. Miscellaneous
- Transaction
- EXPLAIN
- Foreign Keys
