Mastering SQL Server | Passage to become Database Developer
Mastering SQL Server | Passage to become Database Developer
Microsoft SQL database course for Beginners
What You Will Learn:
- Introduction to Database Management System (DBMS)
- Microsoft SQL Server development and administration
- Installation Guide of Microsoft SQL Server
- How to Create database
- How to create and modify tables
- Primary Key
- Foreign Key
- Composite Key
- How to drop a Table
- Insert data into table
- Select data from a table
- Update/modify existing data of a table
- Delete data from a table
- Substring function
- Group By Clause
- Average function
- Inner join
- Left join
- Right join
- Full join
- Distinct function
- Database Views
- Stored procedures
- How to execute the stored procedure
- SQL jobs
- How to use Like Operator
- Taking Database Backup
- Restoring the database backup
Requirements :
- Student must be aware of basic database concepts.
- must have a computer where Microsoft SQL Server could be installed .
Who this Course is for:
- Students who want to have solid grip over Microsoft SQL Server
- Who wants to get database knowledge
Comments
Post a Comment