Course Content
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network
- At the end of this course the participants will be able to:
- Explain MS SQL storage engines
- Explain database transactions
- Obtain database metadata
- Describe MS SQL GUI tools
- Monitor database performance
- Perform database backup and recovery
- Export and import database data
- Describe the features and benefits of MS SQL
- Explain the basics of relational databases
- Design an effective database
- Build a database and tables by using SQL Modify or delete database entities
- Join data from multiple tables
- Use built-in MS SQL functions
- Team leaders seeking professional development in MS SQL
- IT Team Leader.
- MS SQL developer
- IT manager
- IT department managers.
- Project managers.
- Systems designers.
- Microsoft SQL Server and T-SQL (Microsoft SQL) variant language
- Differences between MS SQL and Python
- Nested Queries in MS SQL
- Operation Vs Nested query in DBMS
- Nested Queries in MS SQL
- Indexing in Databases
- MS SQL Server Database Administration
- SQL Server Programming
- SQL Server Comparison Operators
- SQL Server Joins
- Creating SQL loader mappings to Extract Data from Flat Files.
- Creating SAP extraction mappings
- Creating Code Template (CT) mappings
- Setting options for Code Templates in Code Template Mappings