Cargando…
The complete SQL bootcamp for aspiring data scientists.
Welcome to this SQL Server course designed to cater to aspiring data professionals and anyone looking to enhance their SQL skills. We will begin with the fundamentals, covering SQL syntax, data types, and essential querying techniques. You will learn how to write powerful SQL queries to retrieve, fi...
| Clasificación: | Libro Electrónico |
|---|---|
| Formato: | Electrónico Video |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Packt Publishing,
[2023]
|
| Edición: | [First edition]. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cgm a22000007i 4500 | ||
|---|---|---|---|
| 001 | OR_on1398237528 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o c | ||
| 007 | vz czazuu | ||
| 007 | cr cnannnuuuuu | ||
| 008 | 230919s2023 xx 492 o vleng d | ||
| 040 | |a ORMDA |b eng |e rda |e pn |c ORMDA |d ORMDA | ||
| 020 | |a 9781835461808 |q (electronic video) | ||
| 020 | |a 1835461808 |q (electronic video) | ||
| 035 | |a (OCoLC)1398237528 | ||
| 037 | |a 9781835461808 |b O'Reilly Media | ||
| 050 | 4 | |a QA76.73.S67 | |
| 082 | 0 | 4 | |a 005.75/6 |2 23/eng/20230919 |
| 049 | |a UAMI | ||
| 245 | 0 | 4 | |a The complete SQL bootcamp for aspiring data scientists. |
| 250 | |a [First edition]. | ||
| 264 | 1 | |a [Place of publication not identified] : |b Packt Publishing, |c [2023] | |
| 300 | |a 1 online resource (1 video file (8 hr., 12 min.)) : |b sound, color. | ||
| 306 | |a 081200 | ||
| 336 | |a two-dimensional moving image |b tdi |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 344 | |a digital |2 rdatr | ||
| 347 | |a video file |2 rdaft | ||
| 380 | |a Instructional films |2 lcgft | ||
| 511 | 0 | |a Vivek P., presenter. | |
| 500 | |a "Published in August 2023." | ||
| 520 | |a Welcome to this SQL Server course designed to cater to aspiring data professionals and anyone looking to enhance their SQL skills. We will begin with the fundamentals, covering SQL syntax, data types, and essential querying techniques. You will learn how to write powerful SQL queries to retrieve, filter, and sort data, as well as perform calculations, and leverage aggregate functions. In the second part of the course, we will dive into advanced SQL for data science. Joining tables, using subqueries, and employing window functions are vital skills for complex data retrieval and analysis. You will learn how to combine data from multiple tables, create intricate queries, and extract valuable insights from large datasets. Lastly, we will focus on database management and optimization. You will gain the skills to efficiently manage SQL Server databases, including database design, indexing, and performance tuning. This knowledge is crucial for ensuring that your databases run smoothly and deliver optimal performance. By the end of this course, you will have gained the confidence and expertise to utilize SQL for data science tasks, ranging from data exploration and manipulation to advanced analytics and reporting. What You Will Learn Learn DDL commands for creating, altering, and deleting databases Understand various data types and their significance in defining data structures Explore constraints, including NOT NULL, Primary Key, Foreign Key, Check, and Default Work with views to simplify complex queries and improve data security Learn how to use aggregate functions for data summarization and analysis Learn the order of execution in SQL queries and how it affects query performanc Audience If you are an aspiring data professional, a Database Administrator (DBA), a developer, or anyone eager to level up your SQL skills, this all-inclusive SQL Server course is tailor-made for you. Whether you are a beginner or looking to advance your SQL expertise, this course will empower you to excel in managing and manipulating data using SQL Server, unlocking new opportunities in the world of data-driven decision-making. Join us and embark on a journey to master SQL and take your career to the next level. About The Auhthor Vivek P.: Vivek P. is a Tableau Certified Associate with more than 12 years of IT experience with different technologies. He is enthusiastic about working with technology and strongly believes in hands-on learning. His teaching methodology is also driven by this belief. | ||
| 588 | |a Online resource; title from title details screen (O'Reilly, viewed September 19, 2023). | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Database management. | |
| 655 | 7 | |a Instructional films. |2 lcgft | |
| 655 | 7 | |a Nonfiction films. |2 lcgft | |
| 655 | 7 | |a Internet videos. |2 lcgft | |
| 700 | 1 | |a P., Vivek, |e presenter. | |
| 710 | 2 | |a Packt Publishing, |e publisher. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/videos/~/9781835461808/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 994 | |a 92 |b IZTAP | ||