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
- Defining Databases. A comparative analysis of RDBMS and DBMS
- Overview of the different RDBMS solutions available on the market.
- Introduction to SQL Server. Utilizing SQL Server Management Studio
- Managing sublanguages including DDL, DML, and DAL.
- Creating Tables, specifying data types, and defining Constraints.
- Executing Insert, Delete, and Update statements.
- Applying Select Queries and their diverse operators.
- Incorporating Null, Not Null, And, OR, Between, Exists, Order by, Group by, and Having clauses
- Exploring built-in functions, including Math, String, and Datetime functions.
- Utilizing Views. Their application in data access strategies.
- Implementing Joins. Identifying join types and retrieving data from multiple tables.
- Handling Sub Queries. Understanding correlated subqueries and distinguishing them from Joins.
- Understanding Common Table Expressions. Applying Recursive Common Table expressions.
Requirements
Essential computer literacy.
14 Hours
Testimonials (3)
data was personalised to our organisations
Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course
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.
