SQL and RDBMS (MySQL / PostgreSQL)
Talk to relational databases. The skill every developer and analyst needs.
0 of 35 lessons published
Syllabus
01 Getting StartedDatabases and tables. 4 lessons
- 1.1What is an RDBMS?Coming soon
- 1.2Installing MySQL and PostgreSQLComing soon
- 1.3Databases, tables, rows and columnsComing soon
- 1.4SQL command types: DDL, DML, DCL, TCLComing soon
02 Creating TablesDefining structure. 3 lessons
- 2.1CREATE, ALTER and DROPComing soon
- 2.2Data types in SQLComing soon
- 2.3Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULLComing soon
03 Working with DataInsert, read, update, delete. 5 lessons
- 3.1INSERTComing soon
- 3.2SELECT and WHEREComing soon
- 3.3UPDATE and DELETEComing soon
- 3.4ORDER BY, LIMIT and DISTINCTComing soon
- 3.5LIKE, IN, BETWEEN and NULL handlingComing soon
04 AggregationSummarising data. 3 lessons
- 4.1Aggregate functions: COUNT, SUM, AVG, MIN, MAXComing soon
- 4.2GROUP BYComing soon
- 4.3HAVINGComing soon
05 JoinsCombining tables. 4 lessons
- 5.1Why joins? How a join works behind the scenesComing soon
- 5.2INNER JOINComing soon
- 5.3LEFT, RIGHT and FULL OUTER JOINComing soon
- 5.4SELF JOIN and CROSS JOINComing soon
06 Advanced QueriesProfessional SQL. 7 lessons
- 6.1SubqueriesComing soon
- 6.2Correlated subqueriesComing soon
- 6.3CTEs (WITH clause)Coming soon
- 6.4Window functions: ROW_NUMBER, RANK, DENSE_RANKComing soon
- 6.5LEAD, LAG and running totalsComing soon
- 6.6CASE expressionsComing soon
- 6.7UNION, INTERSECT and EXCEPTComing soon
07 Database ObjectsBeyond tables. 5 lessons
- 7.1ViewsComing soon
- 7.2Indexes and query performanceComing soon
- 7.3Stored proceduresComing soon
- 7.4FunctionsComing soon
- 7.5TriggersComing soon
08 Transactions and TuningSafe and fast databases. 4 lessons
- 8.1Transactions: COMMIT, ROLLBACK, SAVEPOINTComing soon
- 8.2Isolation levelsComing soon
- 8.3EXPLAIN and query optimisationComing soon
- 8.4Users, roles and permissionsComing soon