Bahman Baseri Database Expert
No reviews yet

SQL Server Course Topics:

# Introduction to SQL Server
# SQL Server installation method
# How to work with SQL Server database
# Introduce database objects
# Complex Queries, Triggers, Views and Schema Modification
# T-SQL Basic Instructions
# SQL SERVER storage and INDEX structures
# DML and DDL commands
# KEYS AND LIMITS CONSTRAINTS
# Saved procedures
# How to create a backup and Job
# Security in SQL Server
# Comprehensive data in SQL Server
# Profiles VIEWS
# Write scripts and BATCHES
# Saved procedure STORED PROCEDURES
# TRANSACTIONS AND LOCKS
# Triggers
# Chart Entity Relationship (ER)
# Basics of Functional Dependencies and Normalization for Relational Databases
# SQL Relational Algebra Operations
# Conceptual Data Modeling and Database Design
# The Relational Data Model and Relational Database Constraints
# The Relational Algebra and Relational Calculus
# Normalization
# using JSON in SQL
# xml data in sql
# openquery method
# Fetch Data from Web Service (With SP)
# Creating a data warehouse with SSIS

Advanced topics in database:
# Performance Tuning:
# FileGroup
# DMF {Dynamic Management Function}
# Fragmentation
# FileStream
# FileTable
# Execution Plan
# Index Scan, Index Seek
# rebuild index, reorganize index
# Data Compression
# Index Types
# WAL Mechanism

My Experiences:

* Analysis of the design of the university system database.
* Design analysis of Universities Teacher tuition system database
* University Nutrition System Analysis
* Analysis and design of school software database
* Office database management system design
* Design and implementation of cognitive science software
* Database management of ERP products
* Convert data of the Educational Management System
* Convert office and laboratory software database data
* Jam University Alumni Database Management

Subjects

  • SQL Beginner-Expert


Experience

  • Technical Manager (Jan, 2004Nov, 2021) at Pazhohesh Afzar co. (Pafco)
    Employment and Professional Background:

     2018 – Present - PajuheshAfzar Co., Tehran - Iran
    o Managing Director
     Developing and executing business strategies to achieve short and long-term goals.
     Reporting to the board, providing market insights and strategic advice.
     Developing and implementing business plans to improve cost-efficiency
     Maintaining positive and trust-based relations with business partners, shareholders, and authorities
     Overseeing the company's business operations, financial performance, investments, and ventures
     Supervising, guiding, and delegating executives in their duties
     Ensuring company policies and legal guidelines are clearly communicated
     Assessing, managing, and resolving problematic developments and situations
     Assessing, managing, and resolving problematic developments and situations

     2005 – 2018 - PajuheshAfzar Co., Tehran - Iran
    o Project Manager, Software Developer, and Technical Manager
     Responsibilities and Experiences Involved:
    • Analysis and Design of Database for the Comprehensive Educational Management Site at universities across the country
    • Analysis and Design of Database for the Office Automation and Implementation of Workflow Engine
    • Analysis and Design of Database for short-term educational courses
    • Analysis and Design of Database for Teachers’ Payment and Salaries Site
    • Analysis and Design of Database for Thesis Management Site
    • Analysis, Design and Implementation of Electronic Payment Software (ready to be connected to ATM or POS of several banks)
    • Analysis of SMS Management Software

     2004 - 2005: TakpishroRayaneh Company, Tehran – Iran
    o Software Developer
     Responsibilities and Experiences Involved:
    • Developing and designing various software packages for customers in different industries

     2003 – 2004 :Rahampardaz Company, Tehran – Iran
    o Software Developer
     Responsibilities and Experiences Involved:
    • Developing software packages for financial systems and offices

Education

  • Bachelor (Sep, 1997Sep, 2002) from Computer Engineering, Shahid Beheshti university

Fee details

    500,000990,000/hour (US$0.370.73/hour)

    if I solve a practice or project it depends on the difficulty of that.
    Teaching for prepare student for exam
    Teaching for prepare student for job Assessment test


Reviews

No reviews yet. Be the first one to review this tutor.