Database Engineer/DBA - (PostgreSQL, IBM-DB2, MariaDB,NoSQL)
- Description
- Curriculum
- FAQ
- Reviews
Database engineers design new databases based on company needs, data storage needs, and the number of users accessing the database. Monitor Databases and Programs. Database engineers continuously monitor databases and related systems to ensure high functionality.
Database administrator ensures that data is available, protected from loss and corruption, and easily accessible as needed. Also they oversee the creation, maintenance and security of your databases. manages, backs up and ensures the availability of the data.
PostgreSQL is commonly known as Postgres and it is also open source database. PostgreSQL is a powerful, open source object-relational database system.
IBM Db2 is a family of related data management products,including relational database servers, developed and marketed by IBM.
MariaDB is great for its open-source innovation and enterprise-grade reliability, as well as its modern relational database.
SQL -Structured Query Language is an internationally recognized language used to communicate and manipulate various database systems.
Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data . From our interaction with our banks to social media applications like Facebook and Instagram..
Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand to help interact with various databases to help business intelligence and other sectors that relies on data.
NoSQL (Non-SQL or Not-only-SQL) databases are increasing in popularity due to the growth of data as they can store non-relational data on a super large scale, and can solve problems regular databases can’t handle. They are widely used in Big data operations. Their main advantage is the ability to handle large data sets effectively as well as scalability and flexibility issues for modern applications.
-
1IntroductionVideo lesson
-
2What is PostgreSQLVideo lesson
-
3Minimum Installation RequirementsVideo lesson
-
4Installing PostgreSQL on WindowsVideo lesson
-
5Installing PostgreSQL on MacOSVideo lesson
-
6Installing PgAdmin Tool on MacOSVideo lesson
-
7Installing PostgreSQL on LinuxVideo lesson
-
8Installing PgAdmin Tool on LinuxVideo lesson
-
9Connecting to PostgreSQL Database ServerVideo lesson
-
10Load Sample DatabaseVideo lesson
-
11Database ConceptsVideo lesson
-
12Data TypesVideo lesson
-
23What is CRUDVideo lesson
-
24What is SQLVideo lesson
-
25Create Database using pgadminVideo lesson
-
26Create Table using pgadminVideo lesson
-
27Create Table using SQL StatementVideo lesson
-
28Retrieve data with SELECT statementVideo lesson
-
29Using SubqueriesVideo lesson
-
30Modify data using UPDATE StatementVideo lesson
-
31Remove data using DELETE StatementVideo lesson
-
32Add data using INSERT INTO StatementVideo lesson
-
33PostgreSQL Unique ConstraintVideo lesson
-
34Filtering data with WHERE clauseVideo lesson
-
35Retrieve all data from a tableVideo lesson
-
36Retrieve data from a specific columnVideo lesson
-
37Remove duplicate recordsVideo lesson
-
38Sorting dataVideo lesson
-
39Grouping Data using GROUP BY ClauseVideo lesson
-
40Using HAVING ClauseVideo lesson
-
41Truncating TablesVideo lesson
-
42Stored ProceduresVideo lesson
-
43Comparison OperatorsVideo lesson
-
44BETWEEN OperatorVideo lesson
-
45NOT BETWEEN OperatorVideo lesson
-
46LIKE OPERATORVideo lesson
-
47NOT OperatorVideo lesson
-
48OR OperatorVideo lesson
-
49AND OperatorVideo lesson
-
50Combining AND | OR OperatorVideo lesson
-
51LIMIT OperatorVideo lesson
-
52IN OperatorVideo lesson
-
53UNION OperatorVideo lesson
-
54UNION ALL OperatorVideo lesson
-
55INTERSECT OperatorVideo lesson
-
56EXCEPT OperatorVideo lesson
-
68SUM Aggregate functionVideo lesson
-
69Introduction to Analytic FunctionsVideo lesson
-
70Creating sample tablesVideo lesson
-
71Using AVG as window functionVideo lesson
-
72ROW Number FunctionsVideo lesson
-
73RANK FunctionsVideo lesson
-
74DENSE RANK FunctionsVideo lesson
-
75First Value FunctionVideo lesson
-
76LAST FunctionVideo lesson
-
77LAG FunctionVideo lesson
-
78LEAD FunctionVideo lesson

External Links May Contain Affiliate Links read more