Introduction to SQL

Bi'ir Academy

Course level:Intermediate

Course Details

Categories software development

Instructor

Bi'ir Academy

Duration

Certificate

yes

Last Updated

February 21, 2025

5.00 (1 Rating)

Add to Wishlist

Master SQL Basics: Understand fundamental SQL commands and syntax to interact with databases effectively.
Data Retrieval Skills: Learn how to write SELECT queries to extract, filter, and sort data.
Work with Multiple Tables: Explore JOINs and relationships to combine data from different tables seamlessly.
Data Manipulation: Gain proficiency in inserting, updating, and deleting data using SQL.
Data Aggregation and Analysis: Use GROUP BY, HAVING, and aggregate functions to analyze data efficiently.
Optimize Performance: Discover indexing and query optimization techniques to enhance database performance.

Course Curriculum

Section 1: Introduction

1.1 Introduction

10:55
1.2 SQL Server Edition And SQL Type

06:59
1.3 SQL server installation and Backup Adventurework2019

15:03

Section 2: Database Design

Section 3: Data Definition Language

Section 4: Data Manipulation Language

Section 5: Selecting Data from a Database

5.1 Select statment

08:35
5.2 SQL functions (String Functions)

16:52
5.3 SQL functions (Date Functions)

13:49
5.4 SQL functions (Advanced Functions)

06:36
5.5 Where Clause

11:31
5.6 Where Clause continuation

10:22
5.7 Information Schema

08:02
5.8 Order By

07:35
5.9 Join

18:38
5.10 Data Merging

05:02
Quiz
Exercise

Section 6: Data Aggregation

Section 7: Advanced SQL

Student Ratings & Reviews

5.0

Total 1 Rating

3 Ratings

0 Rating

Aberus Technologies

5 months ago

awesome

Description

SQL (Structured Query Language) is an essential skill for anyone working with data. It powers the backbone of modern applications, helping you store, retrieve, and analyze data efficiently. Learning SQL opens doors to high-demand careers in tech, data analytics, software development, and business intelligence. With SQL, you can transform raw data into actionable insights, solve complex problems, and gain a competitive edge in industries like finance, healthcare, marketing, and more. It’s a universal skill that ensures you’re prepared for the data-driven future.

Beginners in data analysis or programming.
Aspiring data analysts and data scientists.
Software developers enhancing database skills.
Students studying computer science or IT.
Business professionals need database insights.
IT professionals expand their skill set.
Career changers entering tech or data fields.