HSC ICT - Web Development - Computer Training Centre

Webpage Design & Development syllabus that we follow:
[1] ASP .NET Core MVC [2] C # .NET [3] MS SQL Server [4] HTML and CSS [5] Bootstrap [6] JavaScript [7] Web API [8] Project work [9] GitHub
Short Description:
~~~>> Introduction to Visual Studio 2022
How to Install and Setup visual studio 2022 Community Edition.
~~~>> Programming Basics (C # (Basic to Advance))
Introduction to C #, Data Types, Datatype conversions, Operators, Conditional Statements, Loops, Data Structures.
~~~>> Object Oriented Programming
OOP Fundamentals, Objects and Classes, Why OOP? , Interfaces, Method Overloading, Method Overriding.
~~~>> Object Oriented Design Principles
Four fundamental Principles of OOP – Abstraction, Inheritance, Encapsulation Polymorphism.
~~~>> ASP.NET Core MVC {.NET 8}
Introduction to Model-View-Controller architecture, Data flow, Fundamentals of ASP .NET MVC.
~~~>> Introduction to SQL Server Programming
Intro to SQL, Basic Queries and Commands, Table Joins
~~~>> Database designing
Fundamentals of Database Designing, Constraints, Relationships.
~~~>> MS SQL Server
Introduction to MS SQL Server and MS SQL Server Management Studio. Working with SQL Server in Asp .NET core Application
~~~>> Introduction to web technology
HTML, Bootstrap, JavaScript, jQuery Basics
~~~>> Razor view Engine
Intro to Razor view engine
~~~>> Advanced ASP.NET MVC
Design Patterns (Factory and Repository Pattern), Dependency Injection
~~~>> Entity Framework 8
ADO .NET, LINQ, Code first approach.
~~~>> Security, Authentication and Authorization in ASP.NET Core MVC
Security, Authentication and Authorization with asp .NET Identity, Role based authentication.
~~~>> Project Deployment in IIS
Deploy an asp .NET MVC project in Local IIS server.
~~~>> Version Control
Git, GitHub, Basic git commands
~~~>> Code Quality & Smart Coding
Industry good practices, Do’s And Don’ts , Basic principles for clean coding.
~~~>> Full Stack Project work with ASP.NET Core MVC
Development of a Full Stack MVC with the instructor
~~~>> ঠিকানাঃ এস. আর. আইটি, ২৬৩/১, শেরে বাংলা রোড, নিরালা, খুলনা।
(তালুকদার কমিউনিটি সেন্টার এর সাথে লাল বিল্ডিং এর নিচতলায়)
যোগাযোগের নাম্বার: 01979-406593
বিশ্বব্যাপী প্রতি মুহূর্তে তৈরি হচ্ছে হাজার হাজার ওয়েবসাইট। ওয়েব ডেভেলপমেন্ট হচ্ছে একটা ওয়েব সাইটের প্রাণ সঞ্চার করা। ওয়েব ডিজাইনার যে ডিজাইন তৈরি করেন তার প্রতিটা উপকরণকে ফাংশনাল এবং ডাইনামিক করার জন্য পরিচালিত কর্মকান্ডই হচ্ছে ওয়েব ডেভলপমেন্ট । একটা ওয়েব সাইট কে তিনটা ভাগে বিভক্ত করা যায় যেমন ডিজাইন বা টেমপ্লেট, কনটেন্টম্যানেজমেন্ট সিস্টেম এবং ডাটাবেস। ওয়েব ডেভেলপার এই তিনটি বিষয়ের মধ্যে সমন্বয় ঘটিয়ে পুরো সিস্টেমটি কে সক্রিয় এবং ডাইনামিক করে থাকেন । ওয়েব ডেভেলপারের কাজ হচ্ছে ডাটা প্রসেসিং, ডাটাবেস নিয়ন্ত্রণ, সিকিউরিটি নির্মান, ইউজার এবং এডমিনের ক্ষমতা নিয়ন্ত্রণকরা, এপ্লিকেশনের সকল ফিচারকে ফাংশনাল এবং ডাইনামিক করা এবং সমগ্র সিস্টেমের কার্যকারীতা এবং ব্যবহার যোগ্যতা নিয়ন্ত্রণ করা। শখের কাজ কিংবা পরিপূর্ণ ব্যবসা সব ধরণের কাজের পরিচয় বহন করে ওয়েবসাইট। এজন্যই ডিজিটাল প্ল্যাটফর্মে ক্যারিয়ার হিসেবে ওয়েব ডিজাইন / ওয়েব ডেভেলপমেন্টের বেশ চাহিদা রয়েছে। তাই আপনি যদি ওয়েব ডিজাইনার অথবা ওয়েব ডেভেলপার হিসেবে ক্যারিয়ার গড়তে চান, তাহলে আপনার জন্যই আমাদের Web Design / Web development Course.

Founder & Chief Instructor

আমাদের এখানে অনলাইন এবং অফলাইন দুই ভাবেই কোর্স করার সুযোগ আছে। আপনার কাংখিত কোর্স করতে আমাদের সাথে যোগাযোগ করুনঃ +৮৮০-১৯৭৯-৪০৬৫৯৩

C programming language syllabus that we follow:
--------------------------------------------------------------
* Please check the program list in the last section of this index that we will try to solve in the class
Introduction to Programming
⦁ Lesson 1. Fundamentals in C
⦁ Lesson 2. Operators and Expressions
⦁ Lesson 3. Data types
⦁ Lesson 4. Input-Output Library Functions
⦁ Lesson 5. Control statements
⦁ Lesson 6. Function
⦁ Lesson 7. Storage class
⦁ Lesson 8. Pointer
⦁ Lesson 9. Pointer and Function
⦁ Lesson 10. Array
⦁ Lesson 11. Pointer and array
⦁ Lesson 12. Array and function
⦁ Lesson 13. Dynamic memory allocation
⦁ Lesson 14. String
⦁ Lesson 15. String and function
⦁ Lesson 16. Command line arguments
⦁ Lesson 17. Preprocessor
⦁ Lesson 18. Structure
⦁ Lesson 19. Structure and function
⦁ Lesson 20. File Handling
Syllabus Details
Fundamentals in C
⦁ Lesson 1. History of 'C'
⦁ Lesson 2. A Simple C Program
⦁ Lesson 3. Program ex*****on phases
⦁ Lesson 4. Backslash character constants
⦁ Lesson 5. Character set
⦁ Lesson 6. Constants
⦁ Lesson 7. Number systems
⦁ Lesson 8. Format specifiers
⦁ Lesson 9. Identifiers
⦁ Lesson 10. Keywords
⦁ Lesson 11. Variables
⦁ Lesson 12. Data Types
⦁ Lesson 13. Declaration of Variable
⦁ Lesson 14. Assigning Values to Variables
⦁ Lesson 15. Initialization
⦁ Lesson 16. Comments
⦁ Lesson 17. Const Qualifier
⦁ Lesson 18. Basic Structure of a 'C' program
⦁ Lesson 19. Programming Examples
Operators and Expressions
⦁ Lesson 1. Arithmetic operators
⦁ Lesson 2. Increment and decrement operators
⦁ Lesson 3. Relational operators
⦁ Lesson 4. Logical operators
⦁ Lesson 5. The bitwise operators
⦁ Lesson 6. The assignment operators
⦁ Lesson 7. The conditional operator
⦁ Lesson 8. The size of operator
⦁ Lesson 9. The comma operator
⦁ Lesson 10. Type casting operator
⦁ Lesson 11. Other operators
⦁ Lesson 12. Precedence and order of evaluation
⦁ Lesson 13. Programming Examples
Data types
⦁ Lesson 1. Modifiers
⦁ Lesson 2. Format specifiers
⦁ Lesson 3. Dealing with each data types
⦁ Lesson 4. Memory representation of each type
⦁ Lesson 5. Programming Examples
Input-Output Library Functions
⦁ Lesson 1. Unformatted I-O Functions
⦁ Lesson 2. Single Character Input-Output
⦁ Lesson 3. String Input-Output
⦁ Lesson 4. Formatted I-O Functions
⦁ Lesson 5. printf() Width Specifier
⦁ Lesson 6. scanf() Width Specifier
⦁ Lesson 7. Programming Examples
Control statements
⦁ Lesson 1. Conditional Control Statements
⦁ Lesson 2. if
⦁ Lesson 3. if-else
⦁ Lesson 4. nested if-else
⦁ Lesson 5. else-if ladder
⦁ Lesson 6. Multiple Branching Control Statement
⦁ Lesson 7. switch-case
⦁ Lesson 8. Loop Control Statements
⦁ Lesson 9. while
⦁ Lesson 10. do-while
⦁ Lesson 11. for
⦁ Lesson 12. Nested Loops
⦁ Lesson 13. Jump Control statements
⦁ Lesson 14. break
⦁ Lesson 15. continue
⦁ Lesson 16. goto
⦁ Lesson 17. exit
⦁ Lesson 18. return
⦁ Lesson 19. Programming Examples
Function
⦁ Lesson 1. What is function?
⦁ Lesson 2. Why function?
⦁ Lesson 3. Advantages of using functions
⦁ Lesson 4. Function Prototype
⦁ Lesson 5. Defining a function
⦁ Lesson 6. Calling a function
⦁ Lesson 7. Return statement
⦁ Lesson 8. Types of functions
⦁ Lesson 9. Recursion
⦁ Lesson 10. Nested functions
⦁ Lesson 11. main() function
⦁ Lesson 12. Library Function
⦁ Lesson 13. Local and global variables
⦁ Lesson 14. Programming Examples
Function
⦁ Lesson 1. Types of storage class
⦁ Lesson 2. Scoping rules
⦁ Lesson 3. Dealing with all storage classes
⦁ Lesson 4. Programming Examples
Pointer
⦁ Lesson 1. Def of Pointer
⦁ Lesson 2. Declaration of Pointer Variables
⦁ Lesson 3. Assigning Address to Pointer
⦁ Lesson 4. Variables
⦁ Lesson 5. De-referencing Pointer Variables
⦁ Lesson 6. Pointer to Pointer
⦁ Lesson 7. Pointer Arithmetic
⦁ Lesson 8. Pointer comparisons
⦁ Lesson 9. De-reference and increment pointer
⦁ Lesson 10. Programming Examples
Pointer and Function
⦁ Lesson 1. Parameter Passing Techniques – call by value, call by address
⦁ Lesson 2. Using Pointers as Arguments Function Returning value
⦁ Lesson 3. Returning More than one value From A Function
⦁ Lesson 4. Functions Returning Address
⦁ Lesson 5. Function Returning Pointers
⦁ Lesson 6. Dangling pointer
⦁ Lesson 7. Pointer to a Function
⦁ Lesson 8. Calling A function through function pointer
⦁ Lesson 9. passing A function's address as an
⦁ Lesson 10. Argument to other function
⦁ Lesson 11. Functions with variable number of arguments
⦁ Lesson 12. Programming Examples
Array
⦁ Lesson 1. One dimensional arrays
⦁ Lesson 2. Declaration of 1D arrays
⦁ Lesson 3. Initialization of 1D arrays
⦁ Lesson 4. Accessing element of 1D arrays
⦁ Lesson 5. Reading and displaying elements
⦁ Lesson 6. Two dimensional arrays
⦁ Lesson 7. Declaration of 2D arrays
⦁ Lesson 8. Initialization of 2D arrays
⦁ Lesson 9. Accessing element of 2D arrays
⦁ Lesson 10. Reading and displaying elements
⦁ Lesson 11. Programming Examples
Pointer and Array
⦁ Lesson 1. Pointer and one dimensional arrays
⦁ Lesson 2. Subscripting pointer variables
⦁ Lesson 3. Pointer to an array
⦁ Lesson 4. Array of pointers
⦁ Lesson 5. Pointers and two dimensional arrays
⦁ Lesson 6. Subscripting pointer To an array
⦁ Lesson 7. Programming Examples
Array and Function
⦁ Lesson 1. 1D array and function
⦁ Lesson 2. Passing individual array elements to a function passing individual array elements address to a function
⦁ Lesson 3. passing whole 1d array to a function
⦁ Lesson 4. 2D array and function
⦁ Lesson 5. Passing individual array elements to a function
⦁ Lesson 6. Passing individual array elements address to a function
⦁ Lesson 7. passing whole 2d array to a function
⦁ Lesson 8. using arrays of function pointer
⦁ Lesson 9. Programming Examples
Dynamic memory allocation
⦁ Lesson 1. malloc()
⦁ Lesson 2. calloc()
⦁ Lesson 3. realloc()
⦁ Lesson 4. free()
⦁ Lesson 5. Core dump
⦁ Lesson 6. Memory leak
⦁ Lesson 7. Dynamic 1D and 2D Arrays
⦁ Lesson 8. Programming Examples
Strings
⦁ Lesson 1. strings versus character arrays
⦁ Lesson 2. Initializing strings
⦁ Lesson 3. Reading string
⦁ Lesson 4. Displaying string
⦁ Lesson 5. The %s format specifier
⦁ Lesson 6. The gets() and puts() functions
⦁ Lesson 7. string handling functions
⦁ Lesson 8. string pointers
⦁ Lesson 9. Two-dimensional character arrays or array of string
⦁ Lesson 10. array of pointers to strings
⦁ Lesson 11. Programming Examples
Command line arguments
⦁ Lesson 1. what is command prompt?
⦁ Lesson 2. why command line?
⦁ Lesson 3. What are command line arguments?
⦁ Lesson 4. Programs using command line
Preprocessor
⦁ Lesson 1. What is preprocessing?
⦁ Lesson 2. Macro expansions
⦁ Lesson 3. File inclusions
⦁ Lesson 4. Conditional compilation
⦁ Lesson 5. Programming Examples
Structure
⦁ Lesson 1. Why is structure used?
⦁ Lesson 2. What is structure?
⦁ Lesson 3. Advantages of structures
⦁ Lesson 4. Defining a Structure
⦁ Lesson 5. Declaration of Structure Variables
⦁ Lesson 6. Initialization of Structure Variables
⦁ Lesson 7. Accessing Structure Members
⦁ Lesson 8. Storage of Structures in Memory
⦁ Lesson 9. Size of Structures
⦁ Lesson 10. Reading and Displaying Structure Variables
⦁ Lesson 11. Assignment of Structure Variables
⦁ Lesson 12. Pointers to structures
⦁ Lesson 13. Array of structures
⦁ Lesson 14. Arrays within structures
⦁ Lesson 15. Nested structures
⦁ Lesson 16. Self-referential structures
⦁ Lesson 17. Programming Examples
Structure and Function
⦁ Lesson 1. Passing structure member to a function
⦁ Lesson 2. Passing structure variable to a function
⦁ Lesson 3. Passing structure variable address to a function
⦁ Lesson 4. Passing array of structure to a function
⦁ Lesson 5. Returning a structure variable from function
⦁ Lesson 6. Returning a structure variable address from function
⦁ Lesson 7. Returning structure variable from a function
⦁ Lesson 8. Programming Examples
Union and Enumeration and typedef
⦁ Lesson 1. What are unions?
⦁ Lesson 2. Structures versus unions
⦁ Lesson 3. Working with unions
⦁ Lesson 4. Initialising unions
⦁ Lesson 5. Advantages of unions
⦁ Lesson 6. enum keyword
⦁ Lesson 7. typedef keyword
⦁ Lesson 8. Programming Examples
File Handling
⦁ Lesson 1. Using files in C
⦁ Lesson 2. Buffer and streams
⦁ Lesson 3. Working with text files and Binary
⦁ Lesson 4. Files
⦁ Lesson 5. File operations using std. library and system calls
⦁ Lesson 6. File management I/O functions
⦁ Lesson 7. Random Access Files
⦁ Lesson 8. Programming Examples
Program list that we will solve in the class:
1. Write a program to convert the given temperature in Fahrenheit to Celsius and vice-versa.
2. Write a program to calculate of average of five numbers.
3. Write a program to find the number of sums of all integers greater than 100 and ten then 200 that are divisible by 7.
4. Write a program to calculate the area and circumference of a circle.
5. Write a c program for triangle.
6. Write a program to evaluate the polynomial 3x-5x+6 for x=3.2 and display the result.
7. Write a C program to compute the roots of a quadratic equation.
8. Write a program that will obtain the length and width of a rectangle from the user and compute its area and perimeter.
9. Write a program that evaluate y = xn
10. Write a program that read the value of x and evaluate the following function using if statement and ?: Operator
11. Write a C program to find the number of and sum of all integers greater than 50 and less than 300 that are divisible by 9.
12. Write a C program to determine whether a number is a prime or not.
13. The number in a sequence 1 1 2 3 5 8 13 21 . . . . . . . are called Fibonacci numbers. Write a C program using a for loop to calculate and print the first 20 Fibonacci number.
14. Write a program to set all the diagonal elements of a two-dimensional array to 1 and others to 0
15. Write a C program to add and subtract two same size matrixes.
16. Write a program to compute and print a multiplication for numbers 1 to 5.
17. Write a program to extract a portion of a character string and print the extracted string. Assume that m characters are extracted, starting with nth character.
18. Write a program to test whether the given input string is palindrome or not.
19. Write a program which will read a text and count all occurrences of a particular word.
20. Write a C program to find the number of and sum of all integers greater than 50 and less than 300 that are divisible by 9 using function.
21. Write a program which will input some numbers in an integer array and pass this to a function called minimum (). This function will find the minimum of the array values and returns this value to the main () function for displaying it.
22. Write a program which will input some numbers in an integer array and pass this to a function called maximum (). This function will find the maximum of the array values and returns this value to the main () function for displaying it.
23. Write a program to create a structure which will store name, roll and marks of 6 courses that you obtained. This structure will also store the total obtained marks. Which you can obtain by summing all the marks. Store all the data for 10 students. Print the name, roll and total obtained marks of each student.
24. Write a program to find the sum of the elements contained in an integer array using pointers to array.
25. Write a program which will write 10 integer numbers stored in an integer array to a data file called NUMBERFILE. The program will then close this file, and reopen it to display by reading the NUMBERFILE.
26. Write a program to print the digits of a given numbers in reverse order.
27. Write a program to find the largest number among three numbers.
28. Write a program to convert binary to decimal and decimal to binary.
29. Write individual program to print the different kind of Pyramids. (With number)
30. Write a program to read the values of x and y and print the results of the following expressions in one line: 1. (x + y) / (x - y), 2. (x + y) / 2, 3. (x + y) (x - y)
31. Write program to evaluate the power series: ex=1 + x + (x2/2!) + (x3/3!) +…….+ (xn/n!)
32. Admission to a professional course is subject to the following conditions:
33. Marks in Mathematics >=60 b. Marks in Physics >=50 c. Marks in Chemistry >= 40
d. Total in all three subjects >= 200 or Total in mathematics and physics >=150
Given the marks in three subjects, write a program to process the applications to list the eligible candidates.
34. Write a program to print the Floyd’s triangle
35. Write a program to evaluate the series: 1 + x + x2 + x3 + . .. . . .. + xn
36. Write a program to calculate factorial of a given number.
37. Write individual program to print the different Pyramids. (With symbol)
38. Write a C program to calculate the multiplication of two matrixes.
39. Write a C program to show the Pascal’s triangle
40. Write a program to read a line of text containing a series of words from the terminal.
41. Write a program to replace a particular word by another word in a given string.
42. Write a program that sort an array of integers.
43. Write a program that will scan a character and convert all lower-case characters into upper case equivalents.
44. Write a program to calculate factorial of a given number using recursion.
45. A file name DATA contains a series of integer numbers. Code a program to read these numbers and then write all ‘odd’ numbers to a file to be called ODD and all ‘even’ numbers to a file called EVEN.
46. Write a program for calculating the value of n: s=1+1/2+1/3+………………….+1/n
47. Write a program to test whether the string is palindrome or not.
48. Write a program using one dimensional array to evaluate the total values of x1, x2, x3, …….. are read from keyboard.
49. Write a program to concatenate the three arrays namely first name, second name, third name into one string to be called name.
50. Write a program to evaluate the expression of the function: f(x) = x -x3/3! + x5/5! - x7/7! + …….
51. Write a program to copy one string into another and count the number of characteristics copied.
52. Write a program to make a student’s result sheet using structure.
53. Write a program to make a student’s result sheet using pointer.
54. Write a program to make a student’s result sheet using function.
55. Write a program to make a hotel bill calculation using file operation.

C # Programming Language Syllabus We Follow:
------------------------------------------------------------
1. Introduction to C #
2. Getting Ready
3. First C # Application
4. C # Types
5. Value and Reference Types
6. IO Streams
7. C # Structs
8. C # Enums
9. C # Class
10. C # Object
11. Class Access Modifiers
12. C # Field
13. C # Constructor
14. C # Property
15. C # Method
16. C # Method Overloading
17. C # Expression
18. C # Operator
19. C # Statements
20. C # if else Statement
21. C # switch Statement
22. C # for Statement
23. C # foreach Statement
24. C # do while Statement
25. C # while Statement
26. C # go to Statement
27. C # break Statement
28. C # continue Statement
29. C # return Statement
30. C # Interface
31. C # Partial Class
32. C # Static Class
33. C # Abstract Class
34. C # Array
35. C # Stack
36. C # Queue
37. C # Hashtable
38. C # String
39. C # Dictionary
40. C # List
41. C # Array List
42. Encapsulation
43. Inheritance
44. Polymorphism
45. Exception Handling
46. C # Serialization and deserialization
47. Summary

C++ Language Syllabus We follow:
----------------------------------------------
1. Principles of Object-Oriented Programming
* Procedure-Oriented Programming vs Object-Oriented Programming
* Basic Concepts of Object-Oriented Programming
* Benefits of OOP
* Object-Oriented Languages
* Applications of OOP
2. Beginning with C++
* What is C++?
* Applications of C++
* A Simple C++ Program
* Structure of C++ Program
* Creating the Source File
* Compiling
* Debugging
3. Tokens, Expressions and Control Structures
* Keywords
* Identifiers and Constants
* Tokens
* Basic Data Types
* User-Defined Data Types
* Derived Data Types
* Symbolic Constants
* Type Compatibility
* Declaration of Variables
* Dynamic Initialization of Variables
* Reference Variables
* Operators in C++
* Scope Resolution Operator
* Member Dereferencing Operators
* Memory Management Operators
* Manipulators
* Type Cast Operator
* Expressions and their Types
* Special Assignment Expressions
* Implicit Conversions
* Operator Overloading
* Operator Precedence
4. Functions in C++
* The Main Function
* Function Prototyping
* Call by Reference
* Return by Reference
* Inline Functions
* Const Arguments
* Default Arguments
* Function Overloading
* Friend and Virtual Functions
* Math Library Functions
5. Classes and Objects
* Specifying a Class
* Defining Member Functions
* A C++ Program with Class
* Making an Outside Function Inline
* Nesting of Member Functions
* Private Member Functions
* Arrays within a Class
* Memory Allocation for Objects
* Static Data Members
* Static Member Functions
* Arrays of Objects
* Objects as Function Arguments
* Friendly Functions
* Returning Objects
* const Member Functions
* Pointers to Members
* Local Classes
6. Constructors and Destructors
* Constructors
* Parameterized Constructors
* Multiple Constructors in a Class
* Constructors with Default Arguments
* Dynamic Initialization of Objects
* Copy Constructor
* Dynamic Constructors
* Constructing Two-dimensional Arrays
* const Objects
* Destructors
7. Operator Overloading and Type Conversions
* Defining Operator Overloading
* Overloading Unary Operators
* Overloading Binary Operators
* Overloading Binary Operators Using Friends
* Manipulation of Strings Using Operators
* Rules for Overloading Operators
* Type Conversions
8. Inheritance: Extending Classes
* Defining Derived Classes
* Single Inheritance
* Making a Private Member Inheritable
* Multilevel Inheritance
* Multiple Inheritance
* Hybrid Inheritance
* Virtual Base Classes
* Abstract Classes
* Hierarchical Inheritance
* Constructors in Derived Classes
* Member Classes: Nesting of Classes
9. Pointers, Virtual Functions and Polymorphism
* Pointers to Objects
* this Pointer
* Pointers
* Pointers to Derived Classes
* Virtual Functions
* Pure Virtual Functions
10. Managing Console, I/O Operations
* C++ Streams
* Unformatted I/O Operations
* Formatted Console I/O Operations
* Managing Output with Manipulators
11. Working with Files
* Classes for File Stream Operations
* Opening and Closing a File
* Detecting end-of-file
* More about Open (): File Modes
* File Pointers and Their Manipulations
* Sequential Input and Output Operations
* Updating a File: Random Access
* Error Handling During File Operations
* Command-line Arguments
12. Templates
* Class Templates
* Class Templates with Multiple Parameters
* Function Templates
* Member Function Templates
* Function Templates with Multiple Parameters
* Overloading of Template Functions
* Non-Type Template Arguments
13. Exception Handling
* Basics of Exception Handling
* Exception Handling Mechanism
* Throwing Mechanism
* Catching Mechanism
* Rethrowing an Exception
* Specifying Exceptions
14. Introduction to the Standard Template Library
* Components of STL
* Containers
* Iterators
* Algorithms
* Application of Container Classes
15. Manipulating Strings
* Creating (string) Objects
* Manipulating String Objects
* Relational Operations
* String Characteristics
* Review Questions
* Debugging Exercises
* Programming Exercises
* Accessing Characters in Strings
* Comparing and Swapping
16. Summary

Python programming language syllabus that we follow:
----------------------------------------------------
Module 01 - Introduction to Python and computer programming
Module 02 - Data types, variables,
Module 03 - basic input-output operations, basic operators
Module 04 - Boolean values, conditional ex*****on
Module 05 - loops
Module 06 - lists and list processing
Module 07 - logical and bitwise operations
Module 08 - Functions,
Module 09 - tuples, dictionaries, and data processing
Module 10 - Modules, Packages and PIP
Module 11 - Strings, String and List Methods, Exceptions
Module 12 - Object-Oriented Programming
Module 13 - Miscellaneous

ডলার নাকি বিটকয়েন? কোনটি সবচেয়ে দামি?
কোনটাই না। ডাটা এখন দুনিয়ার সবচেয়ে দামি কারেন্সি।
দুনিয়াটাই ডাটার। আর ডিজিটাল এই দুনিয়ায় যে কোন কোম্পানি এমনকি সরকারও এখন চায়, তার ডাটা বা ডাটাবেজ থেকে মিনিংফুল ইনসাইট বের করতে। যেন যে কোন ডিসিশন অনেক একুরেটভাবে নেয়া যায়। আর ঠিক এ জায়গাতেই কুইক গো-টু-সলিউশন হচ্ছে মাইক্রোসফট SQL, গোটা দুনিয়ার most widely used ডাটাবেজ ল্যাঙ্গুয়েজ। MS SQL একটি জনপ্রিয় ডাটাবেজ ল্যাঙ্গুয়েজ। তার অনেকগুলো কারণ আছে যেমন সাইজ, স্পীড, বেটার ইউজার ইন্টারফেস, ঠিক তেমনি এটা কিন্তু শেখা খুব সহজ, গ্রহণযোগ্যতাও অনেক বেশি। তাই আপনি যদি ডাটাবেজ ল্যাঙ্গুয়েজে আগ্রহি হন তাহলে MS SQL এর এই কোর্সটি আপনার জন্য।
Database Syllabus We follow:
1. Introduction to SQL
• What is SQL? Purpose of SQL, who should learn SQL? What are the subsets of SQL? Data Definition Language, Data Manipulation Language, Data Control Language
2. Introduction to Databases and RDMBS
• What is a Database? Database Objects, Database Tables, Table Records, Types of Database Management Systems, Relational Database Management Systems, and SQL/Relational Databases
3. Install a Database Engine
• Download MS SQL Server or Oracle or MySQL Database Engine, and Install. Launch SQL Server Management Studio, Select New Query, and launch SQL Query. Type SQL Commands and Execute.
4. SQL Syntax
• Focus on SQL Syntax, SQL keywords, SQL is not case sensitive, SQL Comments, SQL Commands, and writing SQL Statements.
5. SQL Data Types
• SQL Numeric data types, Date and Time data types, Character and String data types, Unicode character string data types, Binary data types, and Miscellaneous data types.
6. SQL Operators
• SQL Arithmetic Operators, Comparison Operators, Logical Operators, and Bitwise Operators
7. SQL Expressions
• SQL Boolean Expression, SQL Numeric Expression, and SQL Date Expression
8. SQL Comments
• SQL Comments, Comments are used to explain sections of SQL statements, or to prevent the ex*****on of SQL statements. Single-Line Comments, and Multi-line Comments
9. SQL – Data Definition Language Commands and Operations.
• SQL Data Definition Language Commands, Create, Alter, Drop, Truncate, and Rename.
• Data Definition Language Operations, create a Database, Use Database, rename a Database, Drop Database, create a Table, Rename Table, add a Column to exiting Table, add multiple columns to existing Table, modify an existing column, rename a Column, drop a Column, truncate a Table, and Drop a Table.
10. SQL – Data Manipulation Language Commands and Operations
• Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE.
• Data Manipulation Language Operations, retrieving data from a table, inserting data into a table, updating existing data into a table, and deleting all records from a table.
13. SQL – Data Control Language Commands
• DCL includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system.
14. DCL Operations
• Providing the users, the access or privileges to the database objects, and taking back or canceling the privileges or permissions previously allowed or denied to the users.
15. SQL Functions
• SQL has many built-in functions for performing calculations on data. SQL Aggregate Functions, SQL String Functions, SQL Date Functions, and SQL Scalar functions.
• Count, Sum, Min, Max, Avg Group by and Having Clause Using Group by with Rollup and Cube
16. SQL Queries and Sub Queries
• A Query is used to traverse over some data that may be of small or large quantity to find the needed information.
• A Subquery is a type of query which is written inside another query. A subquery becomes a part of a larger query. A subquery is also called INNER QUERY OR NESTED QUERY.
17. SQL Clauses
• Clauses in SQL are similar to conditionals in high-level languages. We have a large variety in the SQL clauses like the Where clause, Union Clase, Order By clause, etc.
18. SQL Joins
• The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.
19. SQL Views
• Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database.
20. SQL Indexes
• An index is a schema object. It is used by the server to speed up the retrieval of rows by using a pointer. It can reduce disk I/O(input/output) by using a rapid path access method to locate data quickly.
21. SQL Transactions
• Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of database program.
22. SQL Injection
• SQL injection, also known as SQLI, is a common attack vector that uses malicious SQL code for backend database manipulation to access information that was not intended to be displayed. This information may include any number of items, including sensitive company data, user lists, or private customer details.
23. Backup and Restore
In this module, how to backup database and how to restore a database and how to generate a SQL script and executing a SQL script and how to attach and detach a database, Generating SQL Script.
• Executing SQL Script
• Generating Change Script
• Taking database Backup
• Restoring database using backup
• Attaching and detaching of database

মাইক্রোসফ্ট এক্সেল ডেটা স্টোরেজের জন্য একটি প্রাথমিক সরঞ্জাম হিসাবে দাঁড়িয়েছে, যা ছাত্রদের কার্যকলাপ থেকে শুরু করে পেশাদার এবং ব্যবসায়িক প্রচেষ্টা পর্যন্ত কাজগুলিকে অন্তর্ভুক্ত করে। যাইহোক, তাৎপর্য নিছক তথ্য সংরক্ষণের বাইরে প্রসারিত; ড্যাশবোর্ড তৈরিতে দক্ষতা অপরিহার্য। এই দক্ষতা দক্ষ তথ্য উপস্থাপনের সুবিধার মাধ্যমে দ্রুত সিদ্ধান্ত গ্রহণ করতে সক্ষম করে। আসন্ন কোর্সের লক্ষ্য হল ব্যক্তিদের তাদের রুটিন কাজগুলিকে স্ট্রিমলাইন করতে এবং স্প্রেডশীট এবং ড্যাশবোর্ডের কার্যকর ব্যবহারের মাধ্যমে সিদ্ধান্ত গ্রহণের প্রক্রিয়াগুলিকে উন্নত করার দক্ষতা দিয়ে সজ্জিত করা।
সমসাময়িক প্রেক্ষাপটে, ডেটা ব্যাপকভাবে সবচেয়ে অমূল্য সম্পদের একটি হিসাবে বিবেচিত হয়। তথ্য যেমন ব্যক্তিগত বিবরণ (যেমন, নাম, বয়স, পেশা), যোগাযোগের তথ্য (ফোন নম্বর, ইমেল ঠিকানা), এবং অফিসিয়াল নথি (যেমন NID কার্ড) পদ্ধতিগতভাবে ডাটাবেসে সংগঠিত হয়, যা সর্বোচ্চ নিরাপত্তা নিশ্চিত করে। এই ডাটাবেসগুলি প্রায়ই ম্যানেজমেন্ট ইনফরমেশন সিস্টেম (MIS) বিভাগ দ্বারা পরিচালিত এবং পরিবর্তিত হয়, পাসপোর্ট ইস্যু, ব্যাঙ্কিং লেনদেন, সিম কার্ড অধিগ্রহণ এবং সরকারি পরিষেবা এবং জরুরি সুবিধাগুলিতে অ্যাক্সেস সহ বিভিন্ন অ্যাপ্লিকেশনের জন্য অবিচ্ছেদ্য ভাণ্ডার হিসাবে কাজ করে।
আপনি কি শিখবেন?
-> ১০০ এর বেশি এক্সেল ফাংশন আলোচনা করা হবে
-> অ্যাডভান্সড এক্সেল এবং ডেটা অ্যানালিটিকসের ব্যাপক কভারেজ
-> প্রাথমিক ধারণা থেকে দক্ষ ডেটা রিপোর্টিং পর্যন্ত গভীরভাবে অনুসন্ধান
-> মৌলিক এক্সেল জ্ঞান বা নিয়মিত কাজের ব্যস্ততা আছে এমন ব্যক্তিদের জন্য উন্মুক্ত
-> বিভিন্ন পেশা জুড়ে সর্বজনীন প্রযোজ্যতা
-> ড্যাশবোর্ডের মতো ক্রমবর্ধমান প্রবণতার সাথে নথিভুক্ত করে
-> ডেটার মূল ভূমিকার স্বীকৃতি কোর্সের প্রাসঙ্গিকতাকে আন্ডারস্কোর করে
-> বিগ ডেটার রাজ্যে আপনার যাত্রাকে সমর্থন করার জন্য আপনার তালিকাভুক্তির প্রত্যাশা।
কে এই কোর্স থেকে উপকৃত হতে পারে?
যে কেউ যারা তাদের এক্সেল দক্ষতা উন্নত করতে চায় তারা একটি অ্যাডভান্সড এক্সেল কোর্স থেকে উপকৃত হতে পারে। বিশ্লেষক, হিসাবরক্ষক এবং প্রজেক্ট ম্যানেজারদের মতো নিয়মিত এক্সেল ব্যবহার করেন এমন পেশাদারদের জন্য এটি দুর্দান্ত। এমনকি আপনি ঐতিহ্যগতভাবে সংখ্যা-ভারী ভূমিকায় না থাকলেও, ডেটা সংগঠিত করার এবং জ্ঞাত সিদ্ধান্ত নেওয়ার জন্য Excel একটি শক্তিশালী হাতিয়ার হতে পারে। সুতরাং, আপনি একজন ডেটা উত্সাহী হন বা শুধুমাত্র এমন কেউ যিনি আপনার সহকর্মীদের কিছু স্প্রেডশীট উইজার্ডি দিয়ে প্রভাবিত করতে চান, এই কোর্সটি আপনার জন্য উপযুক্ত হতে পারে!
Excel topics are like: Data Filtering, PivotTable, Dashboard etc. and
functions that we try learn:
1. SUM
2. SUMPRODUCT
3. SUMSQ
4. Product
5. AVERAGE
6. Power
7. Ceiling
8. Floor
9. COUNT
10. COUNTA
11. Only Text count
12. COUNTBLANK
13. COUNTIF
14. AVERAGEIF
15. SUMIF
16. AVERAGEIFS
17. SUMIFS
18. COUNTIFS
19. IFERROR
20. MAX
21. MIN
22. SUBTOTAL
23. LARGE
24. SMALL
25. EVEN
26. ODD
27. INT
28. MOD
29. VALUE
30. CHAR
31. CODE
32. Alphabet Fill Handle
33. ISBLANK
34. ISERROR
35. ISEVEN
36. ISODD
37. ISNUMBER
38. ISTEXT
39. IF Condition
40. AND
41. NOT
42. OR
43. Using AND / NOT
44. Using NOT
45. LET function
46. Drop Down List
47. Indirect function
48. Custom Data validation
49. RAND
50. RANDBETWEEN
51. Random Array:
52. Sequence
53. Random Character & String
54. Get a Random Name from the List:
55. Choose Function:
56. CLEAN
57. TRIM
58. LEN
59. SUBSTITUTE
60. Count a specific character in a text:
61. Count total word in a cell
62. REPLACE
63. EXACT
64. LEFT
65. MID
66. RIGHT
67. Lower
68. UPPER
69. PROPER
70. REPT
71. TRANSPOSE
72. FORMULATEXT
73. CONCATENATE
74. CONCAT
75. Merge data of different cells into one cell
76. TEXTJOIN
77. Text
78. DATE
79. EDATE
80. DATEVALUE
81. TIME
82. NOW
83. TODAY
84. YEAR(), MONTH(),
85. DAY()
86. HOUR(), MINUTE(), SECOND()
87. DAYS
88. NETWORKDAYS
89. WORKDAY
90. Week Day
91. COLUMN
92. ROW
93. Row (Sequence Delete problem)
94. ROWS
95. Highlight whole row when click on a cell
96. Highlight whole row & column
97. COLUMNS
98. VLOOKUP
99. IFNA with VLOOKUP
100. XLOOKUP
101. LOOKUP
102. Lookup Example (Grade Sheet)
103. HLOOKUP
104. FIND
105. SEARCH
106. Filter
107. UNIQUE
108. SORT
109. SORTBY
110. SORT and UNIQUE together
111. TEXTJOIN-UNIQUE Multiple Values in a cell
112. TEXTAFTER
113. TEXTAFTER & TEXTBEFORE ALTERNATIVE
114. MATCH
115. INDEX
116. INDEX with MATCH
117. Find a name from a text
118. Find a mail address from a text

and more..................