Hi, I'm Hootan Hemmati, I'm a student of computer science and I'm a teacher assistant (TA) of Dr.Maryam Hajiesmaeili database class. In this GitHub repository, I put the note(slides) of each lesson that I taught earlier. Here is the link to each lesson to get started. Hope this collection can improve your knowledge and make the world a better place to leave and learn!
SQL And SQL Server For Beginners: Taught by Hootan Hemmati
| Lesson Number | Topic | Lesson Note | Learning Objectives | Linked Lesson |
|---|---|---|---|---|
| 01 | Review SQL and how it works | Note | Learn the basic concepts behind database , How SQL works , step by step SQL installation | video |
| 02 | Datatype in SQL , Select query | Note | Learn numeric - datetime - character string datatypes , How select and select distinct query works. | code video |
| 03 | Select Top , Order By , Group By | Note | Learn how select top , order by , group by query works and how to setup Wide World Importers sample database | code video |
| Q&A | How to install SQL Server on Linux? | -- | Learn how to setup SQL Server in linux and how to create first database in Linux! | video 1 video 2 |
| 04 | Review WHERE , AND , OR , NOT , MIN() , MAX() | Note | Learn how to filter and set conditions in our queries and introduce to SQL complete tools to use it | data file code video |
| 05 | Review WHERE , Between , Count() , Average() , Sum() | Note | Learn how to use between keyword with our conditions and how we can use Count() with between | code video |
| 06 | Review primary key | -- | Learn how primary key and identity specification work | video |
All you need to do is simply just run this SQL script file to create and insert values in your database.
Dr.Maryam Hajiesmaeili is an assistant professor in IAUCTB and IAUEC and also she has a position at Refah Bank as a manager of Information Systems. She received her Ph.D. degree (2014) from Kingston University in UK in computer science – image processing and she is extremely interested in doing research and the application of computer science in the fields of machine vision, information technology, and machine learning. Maryam has more than 13 years of experience in teaching at Kingston University and IAUCTB. She is also a member of the Board of Iranian Society Machine Vision and Image Processing (ISMVIP). Maryam has a slogan that “The Best Never Rest”. She is fluent in English, France, and Persian as oral and written, and Arabic as written. Maryam is described in five words as an ambitious, self-learner, self-motivated, team player and hard-working.