Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
- Understanding database definitions and comparing RDBMS with DBMS.
- Survey of leading RDBMS solutions available in the market.
- Introduction to SQL Server and hands-on experience with SQL Server Management Studio.
- Application of sublanguages including DDL, DML, and DAL.
- Table creation, data type management, constraints, and their definitions.
- Utilization of Insert, Delete, and Update statements.
- Execution of Select queries and mastery of various operators.
- Application of keywords such as Null, Not Null, And, Or, Between, Exists, Order By, Group By, and Having clauses.
- Exploration of built-in functions: Mathematical, String, and Datetime.
- Creation and utilization of Views for efficient data access.
- Implementation of Joins, understanding join types, and retrieving data across multiple tables.
- Working with Subqueries, including correlated subqueries, and distinguishing them from Joins.
- Understanding Common Table Expressions (CTEs) and employing Recursive CTEs.
Requirements
Proficiency in basic computer operations.
14 Hours
Testimonials (2)
All the various ways Darius explained concepts and then put them into our database tables.
James Rodi - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
Practical exercises for practice and understanding of the concept, clarification provided for any questions.
