Data management with SQL.

Audience Ideal for students, business analysts, project managers, software developers, data analysts, and career changers aiming to build or enhance their database management and SQL skills, particularly in MySQL. About the Author SkillSprints Inc., Mark Lassoff: SkillSprints Inc., founded by the vi...

Full description

Bibliographic Details
Main Author: Lassoff, Mark (instructor)
Format: eBook
Language:English
Published: [Place of publication not identified] Packt Publishing 2024
Edition:[First edition]
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 03848nmm a2200325 u 4500
001 EB002207675
003 EBX01000000000000001344876
005 00000000000000.0
007 cr|||||||||||||||||||||
008 240503 ||| eng
020 |a 9781835881064 
050 4 |a QA76.73.S67 
100 1 |a Lassoff, Mark  |e instructor 
245 0 0 |a Data management with SQL. 
250 |a [First edition] 
260 |a [Place of publication not identified]  |b Packt Publishing  |c 2024 
300 |a 1 video file (2 hr., 4 min.)  |b sound, color 
653 |a Bases de données / Gestion 
653 |a SQL (Langage de programmation) 
653 |a Database management / http://id.loc.gov/authorities/subjects/sh85035848 
653 |a SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh86006628 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
856 4 0 |u https://learning.oreilly.com/videos/~/9781835881064/?ar  |x Verlag  |3 Volltext 
082 0 |a 658 
082 0 |a 005.75/65 
520 |a Audience Ideal for students, business analysts, project managers, software developers, data analysts, and career changers aiming to build or enhance their database management and SQL skills, particularly in MySQL. About the Author SkillSprints Inc., Mark Lassoff: SkillSprints Inc., founded by the visionary Mark Lassoff, specializes in teaching digitally accessible technical skills to people just getting started in their technical careers, including web development, digital design, and other career paths enabled by technology. SkillSprints has bridged the gap between entertainment and education, creating a unique, immersive learning experience that resonates with students. Their instructors are more than just tech-savvy professionals; they are educators first and foremost, handpicked for their unique ability to translate complex technological concepts into digestible, engaging lessons.  
520 |a This SQL mastery course offers a solid foundation in databases, emphasizing MySQL, a popular database management system. Starting with the essentials, learners are introduced to the pivotal role of databases in data management and given a primer on SQL, laying the groundwork for subsequent, more detailed study. The course is meticulously structured to guide you through setting up a MySQL environment, enabling practical engagement from the onset. As the course unfolds, you'll delve into designing databases and tables, learn to manage data through insertion, updating, and deletion, and explore the construction of basic to complex SQL queries for effective data retrieval. The course further advances into sophisticated SQL features like filtering with WHERE clause and operators, sorting and grouping data, and utilizing functions and aggregates for enhanced data analysis.  
520 |a SkillSprints continues to evolve, constantly innovating to stay at the forefront of the online learning landscape 
520 |a A pivotal section on JOINs elucidates the intricacies of linking data across tables, while the final modules on indexes and optimization offer crucial insights into improving database performance. Each SkillSprint is designed to be both informative and hands-on, ensuring that by the end of the course, you'll possess a comprehensive understanding of SQL and MySQL, equipped with the skills to tackle real-world data management challenges. What you will learn Understand the fundamental concepts and roles of databases and SQL. Perform data manipulation tasks including inserting, updating, and deleting data. Construct basic and complex SQL queries for effective data retrieval. Apply sorting, grouping, and filtering techniques for data analysis. Utilize built-in functions and aggregates for advanced data operations. Implement various types of JOINs to link data across multiple tables.