₹7,000.00
My SQL
JUST COMPLETELY REDONE! Master SQL, Work With Complex Databases, Build Reports, and More!
Bestseller
Created by
About the course
What you’ll learn
-
Create your own database or interact with existing databases
-
Write complex SQL join queries across multiple tables
-
Master MySQL 8 Window Functions (LEAD, LAG, RANK, etc.)
-
Model real-world data and generate reports using SQL
-
Answer company performance or sales questions using data
-
Learns the ins and out of MySQL 8.x syntax
Explore related topics
Course content
Curriculum
- 24 Sections
- 90 Lessons
- 20 Weeks
Expand all sectionsCollapse all sections
- Data Warehouse Basics4 Items
- Data Modeling3 Items
- Schemas3 Items
- Normalization & Denormalization3 Items
- Slowly Changing Dimensions (SCD)0 Items
- Fact Table Types6 Items
- Dimension Types4 Items
- ETL Concepts3 Items
- Introduction to MySQL5 Items
- Database Basics3 Items
- Basic SQL Queries5 Items
- Functions and Operators5 Items
- Joins and Set Operations8 Items
- Subqueries & Nested Queries3 Items
- Advanced SQL Queries6 Items
- Data Manipulation (DML)4 Items
- Data Definition (DDL)4 Items
- Transaction Management2 Items
- Views2 Items
- Indexes5 Items
- Stored Procedures (PL/SQL equivalent)4 Items
- Functions3 Items
- Triggers3 Items
- Cursors2 Items
Instructor
₹7,000.00
Courses you might be interested in
Solutions
×
Live Consultation
Login with your site account
Not a member yet? Register now
Register a new account
Are you a member? Login now