SQL Videos Only

admin
Last Update February 27, 2024
1 already enrolled

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

admin

4.67/5
14 Courses
3 Reviews
96 Students
See more

Want to receive push notifications for all major on-site activities?

Don't have an account yet? Sign up for free