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.
Duration 14 hours
Course Outline
- Defining database concepts and comparing RDBMS with DBMS architectures
- Surveying the landscape of different RDBMS solutions available in the market
- Overview of SQL Server and practical workflows within SQL Server Management Studio
- Application of sublanguages including DDL, DML, and DAL
- Defining table structures, including data types and constraints
- Executing data modifications using Insert, Delete, and Update statements
- Constructing Select Queries and utilizing various operators
- Applying logical filters and sorting techniques using Null, Not Null, And, Or, Between, Exists, Order By, Group By, and Having clauses
- Understanding built-in functions, covering mathematical, string, and datetime operations
- Implementing Views for streamlined data access
- Managing Joins, exploring different join types, and retrieving data across multiple tables
- Utilizing Sub Queries, understanding correlated subqueries, and distinguishing them from Joins
- Exploring Common Table Expressions and implementing Recursive CTEs
Requirements
Familiarity with basic computer operations is required.
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.
