- What is a DBMS?
- Differences between DBMSs etc.
- Basic database concepts (what is a database?)
- How does the DB fit into the application design (application layers)
- DML queries
- Details of "Primary key", "Foreign key" concepts
- Data aggregation
- Nested SQL queries to fetch data from database tables
- Windows functions (TOP/LIMIT/OFFSET)
- Basic DDL queries: create a database, drop a database, create a table, alter a table/column, ...
- Common Table Expressions (WITH)
- Basic knowledge of SQL join types
- Multiple-type joins
- SQL joining & nullable columns
- SQL join optimization
- Indexing purpose
- Types of SQL indexes
- Index creation and selecting column candidates
- Index optimization and maintenance
- Index fragmentation
- Full Text Index
- Detailed Execution Plan analysis
- Optimizing data types
- Data storage optimization
- SQL Stored procedures and optimization
- SQL Functions
- SQL Views
- SQL Indexed Views
- SQL SP parameter sniffing
- Basis concepts (entity, relation)
- Database schema design - best practice
- Database normalization with special accent on the 3rd Normal Form (3NF)
- Attribute (data) types
- Database backups
- Database Logs
- Database storage files
- SQL Replication
- Black box testing, white box testing
- Load testing
- Writing test cases
- Building Data Warehouses
- Star and Snowflake Schemas
- Dimensional model
- Designing and developing multidimensional cubes
- Designing and developing tabular cubes
- Cube maintenance and optimization
- Cube deployment
- Data Analysis querying: DAX, MDX
- Reporting tools
- Extracting data for reports
- Data validation
- Ad-hoc reporting
- Deploying reports
- Getting the data from various data sources
- Data transformation (DML actions)
- Data aggregation
- Data mapping
- Data export
- Machine learning basic concepts
- Linear regression, multiple linear regression
- Preparing the data, creating good training sets
- Selection process
- Association rule learning
- Reinforcement learning
- Model selection and boosting