SQL

Whether you're managing large datasets or writing your first query, build your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-word applications!

Highlights:
1) Schemas
2) Tables
3) Views
4) Keys
5) PostgreSQL
6) Data definition language (DDL)
7) Data manipulation language (DML)
8) Transaction control language (TCL)
9) Data query language (DQL)
10) Data control language (DCL)
11) Entity-relationship diagrams (ERD)

Define schemas and tables; modify and query data; and configure database authorizations

Auteur
Dr. Kerem Koseoglu is a freelance SAP software architect, working professionally since 2000. He specializes in the development of comprehensive applications using design patterns and also conducts technical training related to design patterns. He has participated in global software development projects, taking diverse roles including lead architect, team lead, developer, technical advisor, instructor, and project manager. His former publications include four books and countless articles for technical magazines in Turkey. He has a Ph.D. in organizational behavior.