Database
In this section, we will do an introduction to managing a database with the SQL SERVER 2017 DBMS and the SQL Management Studio tool as a graphical interface to simplify database management.
we will see how to :
- Model the database: MCD, MLD…
- Install SQL SERVER 2017 and SQL
- Management Studio
- Transact SQL (T-SQL)
- Create Alter Drop
- INSERT | SELECT | WHERE
- SELECT | WHERE | COUNT
- INNER JOIN | GROUP BY
- Inner Join | group by | having
- VIEWS | VIEWS
- Stored Procedures | Stored Procedure
- User Functions
- Triggers
- Cursors
