1 option
SQL for Beginners.
- Format:
- Video
- Language:
- English
- Physical Description:
- 1 online resource (182 minutes)
- Place of Publication:
- [Place of publication not identified] : PACKT Publishing, 2025.
- Language Note:
- In English.
- System Details:
- video file
- Summary:
- <b>Kickstart your SQL journey with practical exercises and real-world queries. Learn how to manage, analyze, and manipulate data using SQL statements, functions, joins, subqueries, and more. Gain the skills to write clean, efficient queries and build a strong foundation for database management.</b><h4>Key Features</h4><ul><li>SQL fundamentals are covered with progressive complexity</li><li>Each concept is reinforced through hands-on exercises</li><li>Practical learning is supported with real-world query examples</li></ul><h4>Book Description</h4>Structured Query Language (SQL) is the foundation of working with relational databases and a must-have skill for anyone entering data-focused careers. This course guides you step by step through the essentials, starting with basic SELECT statements and advancing through predicates, operators, and case expressions. You’ll then work with string functions, date and time operations, and data conversion, building confidence in retrieving and manipulating data effectively. From there, you’ll expand your SQL toolkit with advanced concepts such as joins across multiple tables, subqueries, and views for simplified access. You’ll also explore set operators, window functions, and data modification commands, enabling you to manage complex database tasks with accuracy and efficiency. Hands-on application is central to the course. Exercises reinforce your learning, while user-defined functions (UDFs), stored procedures (SPs), and control structures help you create more powerful, dynamic queries. By the end, you’ll have a solid SQL foundation and the practical skills to tackle real-world data challenges across industries.<h4>What you will learn</h4><ul><li>Write and execute SQL queries using SELECT statements</li><li>Apply string, date, and time functions effectively</li><li>Perform joins and subqueries across multiple tables</li><li>Create and manage views, UDFs, and stored procedures</li><li>Modify data and apply control structures in SQL</li><li>Understand and use window functions for advanced analytics</li></ul><h4>Who this book is for</h4>This course is designed for beginners, students, aspiring data analysts, and professionals entering database-related roles. No prior programming experience is required, though basic computer literacy will help you follow along more easily.
- Notes:
- Title from resource description page (viewed July 20, 2026).
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.