Beginning T-SQL for SQL Server Developer, Data Analyst & DBA

Learn to connect to a SQL Server database engine, create a database and table with integer and varchar(50) columns, and insert data using single or multiple row inserts.

Explore how a primary key uniquely identifies each record and prevents nulls, and how a foreign key enforces referential integrity by linking student records to phone numbers.

Compare where and having: where filters the original table, while having filters the grouped result; use sum(sales) in having rather than an alias.

Learn the complete select command syntax in T-SQL, including selecting columns, from tables, where, group by, having, and order by, with aliases usable in order by.

Learn how inner joins combine student and telephone data on a common key, displaying only matching rows, and how aliases clarify column origins in the join syntax.

Master inner join and group by in T-SQL by joining two tables on id and counting telephones per name, labeling the result as number of telephones.

Explore left, right, and full outer joins and cross joins using practical examples with product and supplier tables to illustrate when records appear and when nulls occur.

Explore self joins that link employees to their managers in one table, display employee and manager names, and use inner, left, right, or full joins with isnull.

Explore union, union all, intersect, and except operations, and compare their results on two tables A and B, highlighting duplicates in union and common rows in intersect.

Schema acts as a container for database objects such as tables, views, procedures, triggers, and functions, and naming objects by schema improves organization and access control while enabling cross-database queries.

Learn to create schemas, transfer tables between schemas using T-SQL, and view all objects such as tables and views within a schema.

Explore common interview questions on finding maximum and second maximum salaries using subqueries, inner queries, and alternative approaches like top 1 with ordered data to display full employee details.

Join employee and department data to identify top earners per department by using a derived table with max salary and a two-way join to return names, salaries, and department names in t-sql.

Explore how to use subqueries as a column in SQL Server, creating calculated columns like an average salary and salary differences, and learn alias rules.

Learn how to use a subquery with not in to find products that have no records in another table, by filtering distinct product IDs.

Explore how not exists and correlated subqueries speed up a query against a product table, compared with a left outer join, and how indexing prunes lookups for better performance.

Understand data types in SQL Server, including integers, decimals, money types, and string types (char, varchar, nchar, nvarchar), plus date and time types, fixed vs variable length, and unicode considerations.

Master implicit and explicit datatype conversions in T-SQL by using convert and cast (typecasting) functions, with examples of memory handling, overflow, and date formatting styles.

Master insert, update, and delete operations in T-SQL, including create via select into, updating single or multiple columns with where conditions, joining updates, and truncating or dropping tables.

Learn how primary key, foreign key, unique, not null, default, and check constraints shape robust tables, including creating, dropping, altering, and enforcing data integrity across related records.

Join four tables—actor, actor_movie, movie, and sales—to map actors to movies. Compute each actor's total business contribution to the film industry with inner joins and aggregation.

Join four tables including hotels, websites, price list, and availability to produce a list of hotel name, website, price, and available rooms, filtering where rooms > 0.

Learn to use a case expression in SQL Server to map hotel IDs to names in select queries, label the column, and perform updates.

Explore built-in sql server functions like eomonth, iif, choose, datepart, and string functions. Learn to generate dates, random values, and formatted outputs using convert, left, right, and substring.