This course is an advanced TSQL Querying course. The course expects that students are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS, etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course covers advanced concepts like Views, Triggers, Dynamic Queries, etc.
Effective collection, analysis, and maintenance of data are key to achieve rapid progress in almost all disciplines of science and engineering. The potential topics covered in class include processing and optimization of declarative queries, transactions, crash recovery, self-tuning database systems, data stream systems, information retrieval, and Web data management (e.g., Internet search engines like Google), and data mining. The course materials will be drawn from textbooks as well as recent research literature.
- People should have worked with the SQL server and know how to query using a management studio. All videos are recorded in Windows OS. You can, however, follow this course on MAC/Linux, if you have a Win VM setup
- They should be able to set up their databases and environments.
- Must be comfortable writing TSQL code and must know basic syntax like SELECT, INSERT, UPDATE etc.
- If you are an absolute newbie, please watch my previous course titled "Introduction to Databases and Querying"
- Teacher: Asif Khan Shakir
Skill Level: Beginner