العربية
- Duration: 16 hours
Categories: Information & Communication Technology (ICT)
| This course covers the essentials for Database management using Microsoft SQL Server, including the connection, implementation, profiling, and maintenance for the relational database management systems. Learn how an efficient and secured SQL Server Database should be, from Database design with minimum anomaly to database implementation in MS SQL Server, from principles of database administration and management to composing the structured query language (SQL) commands via stored procedures; how to connect to a database and handle queries using the query windows or the composed views, and how to maintain a secured database and tune the queries to decrease the delay. |
After completing this course you will be able to:
- Create databases, tables via MS SQL Server datasets.
- Backup/Restore and maintain SQL Server databases.
- Compose efficient SQL queries using Stored Procedures and Functions.
- Handle database maintenance and tuning procedures.
- Secure DB environment.
- Use Front-End Tools for the Database Engine.
- Use SQL Server Management Studio with the Database Engine.
- Perform Transact-SQL Operations.
- Utilize Data Definition and manipulation Language commands (DDL/DML).
- Compose Stored Procedures and User-Defined Functions.
- Define DDL and DML Statements and views.
- Manage Security System of the Database Engine.
- Use profilers and improving the performance of the queries and database.
Students and Employees in Organizations
23-26/02/2025
English – SQL
Sohar University
Omar said Al Shibli
Phone Number: 91271393 – 26850111
Email: OSShibli@su.edu.om
Related Courses
Business Digital Transformation
This course covers Business Digital Transformation with Robotic Process, Automation (RPA), UI Automation and Selectors. How to leverage technologies strategically for the company, maximize the value of digital transformation, minimize its risks, and evaluate their inherent opportunities and challenges.
Business Intelligence and Data Analytics
This course covers Basics of insight generation, Basic statistics: Foundations of quantitative insights. The application of BI is limitless, covering operational, tactical and strategic business decisions, extending to all departments and to all users who perform data curation, reporting, analysis, integration and automation.
Artificial Intelligence for Cybersecurity
This course covers Cyber Security Introduction and fundamentals, Security of Network, Systems, Applications, and Data. In addition to training on cybersecurity rules, and how to deal with artificial intelligence technologies in industrial and vital institutions.
AI for Business Professionals
Topics of program: AI Fundamentals Non-Specialist AI Applications in Marketing and Finance AI Applications in People Management AI Strategy and Governance
End-to-End Python Programming and Machine learning
This course covers the essentials for Machine Learning using Python libraries, including advanced components such as feature engineering, attribute combination, transformers, and empirical visualizations. Learn how real machine learning algorithms work, from preprocessing to feature scaling, from training and tuning to visualization of the models; how to save and load…