Week 3: At a Glance
Welcome to Week 3. So far, you have learned the fundamentals of SQL and already know enough to apply what you have learned to some real-life situations. This week builds on the foundation established in Weeks 1 and 2.
Week 3 covers the following:
Day 15 teaches you how to improve performance of data retrieval with the use of indexes.
Day 16 shows you how to streamline SQL statements for improved performance.
Day 17 covers database security, an integral part of every relational database management system.
Day 18 discusses the data dictionary, or system catalog, of a relational database and shows you how to retrieve valuable information.
Day 19 covers some advanced aspects of SQL, such as triggers, cursors, and stored procedures. ...
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
