Curriculum
Course: Software Development - Getting Started
Login

Curriculum

Software Development - Getting Started

Working Smart with Microsoft Office & the Internet

0/1

Logic Building & Effective Problem Solving

0/1

RDBMS Essentials & T-SQL Programming

0/1

Programming with Python

0/1
Text lesson

RDBMS and Querying Data Using SQL Server

  1. Create an entity-relationship model 
  2. Map an entity-relationship diagram to tables 
  3. Normalize and De-normalize data in tables 
  4. Appreciate SQL Server as a database server 
  5. Identify the SQL Server tools 
  6. Retrieve data 
  7. Use functions to customize the result set 
  8. Summarize and group data 
  9. Query data by using joins 
  10. Query data by using subqueries 
  11. Manage result sets 
  12. Manage databases 
  13. Manage tables 
  14. Manipulate data by using DML statements 
  15. Manipulate XML data 
  16. Create and manage indexes 
  17. Create and manage views 
  18. Implement a full-text search 
  19. Implement batches 
  20. Implement stored procedures 
  21. Implement functions 
  22. Implement triggers 
  23. Implement transactions 
  24. Monitor performance 
  25. Optimize performance 
This website uses cookies and asks your personal data to enhance your browsing experience. We are committed to protecting your privacy and ensuring your data is handled in compliance with the General Data Protection Regulation (GDPR).
Ok, I agree Privacy Policy