Share Description
In this course, you will learn :
- SQL training
- what is a database
- database management system
- introduction to sql
- sql server installation
- tables in sql
- how to select a database from existing list
- data types in sql
- different datatypes in sql
- constraints in sql
- how to create a table in sql
- select statement syntax
- select distinct syntax
- where clause
- and, or, not operator
- like , between operator
- functions in sql
- order by and top clause
- group by statement
- delete statement
- inner join
- left join
- right join
- full join
- delete using join
- union operator
- views in sql
- merge table
- types of user defined function
- temporary table
- iif() function
- stored procedure
- exception handling
- try/catch
- transactions in sql
- database administrator
- backup & restore of databases
- dynamic management views
- performance monitoring
- data integrity
