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.
Đề cương khóa học
- What is the meaning of Databases. Comparison of RDBMS and DBMS
- Different RDBMS available in the market.
- What is SQL Server? Working with SQL Server Management Studio
- Working with sublanguages like DDL, DML, DAL.
- Creation of Tables, data types, Constraints and their definition.
- Using Insert, Delete and Update statements.
- Using Select Query and its various operators.
- Use of Null, Not Null, And, OR, Between, Exists, Order by, Group by, Having clause
- What are inbuilt functions? Math, String and Datetime functions.
- Working with Views. How they are used for data access.
- Working with Joins. Joins types and getting data from multiple tables.
- Working with Sub Queries. What is a correlated subquery. Difference between Sub Query and Joins.
- What are Common Table Expressions. Using Recursive Common Table expressions.
Requirements
Basic Computer Skills.
14 Hours
Testimonials (2)
Tất cả các cách khác nhau mà Darius giải thích các khái niệm và sau đó đưa chúng vào bảng dữ liệu của chúng tôi.
James Rodi - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
Machine Translated
Bài tập thực hành để luyện tập và hiểu rõ khái niệm, giải đáp mọi thắc mắc.
Safdar Abbas - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
Machine Translated
