PostgreSQL is a free and open-source relational database management system(RDBMS). It runs on all operating systems such as Linux, Windows and macOS. PostgreSQL supports features like keys, complex queries, aggregate functions, triggers, views, indexes, and procedural languages. Data is stored in the form of tables with rows and columns. Read more
Foss : PostgreSQL Database - English
Outline: Open and close the pgAdmin 4 interface. Connect to the server. About database and its objects. How to create a database.
Outline: Log in to the Linux terminal. Switch to postgres user. Access psql prompt. Create a database using SQL.
Outline: Connect to the postgreSQL local host server. Define table. Define column. Create a table.
Outline: Insert data into a table. Retrieve data from a table. Executing query. Retrieve data using a SELECT query.
Outline: About data redundancy. About primary key and its rules. Retrieve data from a table. Adding data repeatedly. Executing query to show the details. Using Primary Key. Drop or D..
Outline: About SELECT statement. Retrieving all the data from the table. Retrieving specific columns from a table. Execute the query. Compare the results of two different queries.
Outline: About WHERE clause and ORDER BY clause. Syntax of WHERE clause and ORDER BY clause. Filtering the records using the WHERE clause. Sorting the records in ascending and descending..
Outline: About Relational operators. Use of WHERE Clause to filter the records. Syntax of Relational operators using WHERE Clause. Retrieving data using Relational operators.
Outline: Logical operators. AND, OR, and NOT. Syntax of AND, OR, and NOT operators.
Outline: What is a NULL Value? Syntax of Null value. UPDATE Statement. Syntax of UPDATE Statement.
Outline: About aggregate functions in PostgreSQL. Identify common aggregate functions like COUNT, SUM, AVG, MIN, and MAX. Use aggregate functions to summarize data from a table. Handle N..
Outline: About GROUP BY clause and HAVING clause. Syntax of the GROUP BY clause. Apply aggregate functions on grouped data. Use the COUNT and ROUND functions. Filter the grouped results..
Outline: About the Conditional Operators. Syntax of the conditional operators. Apply conditions using the WHERE clause. Filter data using pattern matching with LIKE operator. Use range ..
Outline: About an Alias name. Create an alias name using: - a space - AS keyword. - an underscore - double quotes Display the student table to illustrate that alias names a..
Outline: About the JOIN Clause. Syntax of the JOIN clause. Creating a table named results. Inserting a few sample records in the results table. About the INNER JOIN clause. Syntax of..
Outline: About OUTER JOINS, LEFT JOIN, RIGHT JOIN,and FULL JOIN. Retrieve the records using LEFT JOIN, RIGHT JOIN and FULL JOINs. About SELF JOIN. Syntax of the SELF JOIN. Retrieve the..
Outline: About the Alter Table statement. Syntax of Alter Table statement. Add two new columns Maths and English to the table. Insert marks in the added columns. Modify a column name ..
Outline: Create a database and tables. Insert records into tables. Observe inconsistent data. Delete the inconsistent data from the table. Understand Foreign Key concept. Add Foreign K..
Foss : Python 3.4.3 - Bengali
Outline: > python 3.5.2 ব্যবহার করা > Ipython সংস্করণ 5.1.0 ব্যবহার করা > IPython একটি বর্ধিত ইন্টারেক্টিভ Python ইন্টারপ্রেটার > IPython ইন্টারপ্রেটার শুরু করা > IPython ইন্টারপ্রেটার ..
Outline: পাইথন 3.4.3 ব্যবহার করা Ipython সংস্করণ 5.1.0 ব্যবহার করা প্যাইল্যাব সহ IPython শুরু করা Matplotlib সংস্থাপিত না থাকলে ImportError clf () ফাংশন একই ক্ষেত্রে সমান দুরত্বের পয়ে..