About This Course
SQL (Structured Query Language) is a fundamental tool for managing and manipulating data in relational database management systems (RDBMS). This comprehensive course is designed to provide participants with a solid foundation in SQL, covering everything from basic querying techniques to advanced data manipulation and optimization strategies. Through a combination of theoretical concepts, hands-on exercises, and real-world examples, participants will gain the skills and confidence to write complex SQL queries, design efficient databases, and extract valuable insights from data.
Learning Objectives
Power BI
Reports
Schema
Snowflake
DAX Functions
Material Includes
- Yes Materials Included
Requirements
- No Programming experience required.
- A Laptop or Pc with access to the internet.
Target Audience
- University Student
- College Student
- School Student
Curriculum
17 Lessons
Week 1 : SQL Server Introduction, Configuration, Familiarization, and data Import export
Module 100:00
Module 200:00
Week 2 : SQL Basic Queries, Data Types, Restore, and Schema for tables
Week 3 : Understanding Aggregation functions, different key constraints, and different types of join.
Week 4 : Understanding ERD, Different types of join, diagram design, and join multiples tables.
Week 5 : Learn SQL Command category, what is a view, temporary tables, and Union of tables.
Week 06 : Understanding Subqueries, window functions, Calculated columns, and functions like Cast(), Convert(), isnull(), concate() so on.
Week 07 : Understanding Dynamic Queries, table variables, table index, constraints, and Date and Time Functions
Week 08 : Learn Stored Procedure with Parameter, loop, conditional statement, Trigger and commit and rollback
Week 09 : Learn Case studies, and real-world projects, solve business problems, and overall revision
Your Instructors
