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...
Gespeichert in:
| Format: | Elektronisch Video |
|---|---|
| Sprache: | English |
| Veröffentlicht: |
[Place of publication not identified]
Packt Publishing
[2023]
|
| Ausgabe: | [First edition]. |
| Schlagworte: | |
| Online-Zugang: | lizenzpflichtig |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
MARC
| LEADER | 00000cgm a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-096664886 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228122046.0 | ||
| 006 | m o | | | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 231006s2023 xx ||| |o o ||eng c | ||
| 020 | |a 9781835461808 |c electronic video |9 978-1-83546-180-8 | ||
| 020 | |a 1835461808 |c electronic video |9 1-83546-180-8 | ||
| 035 | |a (DE-627-1)096664886 | ||
| 035 | |a (DE-599)KEP096664886 | ||
| 035 | |a (ORHE)9781835461808 | ||
| 035 | |a (DE-627-1)096664886 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.75/6 |2 23/eng/20230919 | |
| 245 | 1 | 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. | ||
| 336 | |a zweidimensionales bewegtes Bild |b tdi |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a "Published in August 2023.". - Online resource; title from title details screen (O'Reilly, viewed September 19, 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. | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Database management | |
| 650 | 0 | |a Streaming video | |
| 650 | 0 | |a Internet videos | |
| 650 | 4 | |a Vidéo en continu | |
| 650 | 4 | |a Vidéos sur Internet | |
| 650 | 4 | |a Bases de données ; Gestion | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a streaming video | |
| 650 | 4 | |a Instructional films | |
| 650 | 4 | |a Nonfiction films | |
| 650 | 4 | |a Internet videos | |
| 650 | 4 | |a Films de formation | |
| 650 | 4 | |a Films autres que de fiction | |
| 650 | 4 | |a Vidéos sur Internet | |
| 700 | 1 | |a P., Vivek |e PräsentatorIn |4 pre | |
| 710 | 2 | |a Packt Publishing, |e Verlag |4 pbl | |
| 856 | 4 | 0 | |l TUM01 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781835461808/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 935 | |c vide | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-096664886 |
|---|---|
| _version_ | 1818767375992881152 |
| adam_text | |
| any_adam_object | |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)096664886 (DE-599)KEP096664886 (ORHE)9781835461808 |
| dewey-full | 005.75/6 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 |
| dewey-search | 005.75/6 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | [First edition]. |
| format | Electronic Video |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04508cgm a22005652 4500</leader><controlfield tag="001">ZDB-30-ORH-096664886</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228122046.0</controlfield><controlfield tag="006">m o | | </controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">231006s2023 xx ||| |o o ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781835461808</subfield><subfield code="c">electronic video</subfield><subfield code="9">978-1-83546-180-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1835461808</subfield><subfield code="c">electronic video</subfield><subfield code="9">1-83546-180-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)096664886</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP096664886</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781835461808</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)096664886</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">23/eng/20230919</subfield></datafield><datafield tag="245" ind1="1" ind2="4"><subfield code="a">The complete SQL bootcamp for aspiring data scientists</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">[First edition].</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Place of publication not identified]</subfield><subfield code="b">Packt Publishing</subfield><subfield code="c">[2023]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 video file (8 hr., 12 min.))</subfield><subfield code="b">sound, color.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">zweidimensionales bewegtes Bild</subfield><subfield code="b">tdi</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"Published in August 2023.". - Online resource; title from title details screen (O'Reilly, viewed September 19, 2023)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Streaming video</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Internet videos</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Vidéo en continu</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Vidéos sur Internet</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données ; Gestion</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">streaming video</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Instructional films</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Nonfiction films</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Internet videos</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Films de formation</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Films autres que de fiction</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Vidéos sur Internet</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">P., Vivek</subfield><subfield code="e">PräsentatorIn</subfield><subfield code="4">pre</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Packt Publishing,</subfield><subfield code="e">Verlag</subfield><subfield code="4">pbl</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">TUM01</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781835461808/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="935" ind1=" " ind2=" "><subfield code="c">vide</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-096664886 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-18T08:48:53Z |
| institution | BVB |
| isbn | 9781835461808 1835461808 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 online resource (1 video file (8 hr., 12 min.)) sound, color. |
| psigel | ZDB-30-ORH |
| publishDate | 2023 |
| publishDateSearch | 2023 |
| publishDateSort | 2023 |
| publisher | Packt Publishing |
| record_format | marc |
| spelling | The complete SQL bootcamp for aspiring data scientists [First edition]. [Place of publication not identified] Packt Publishing [2023] 1 online resource (1 video file (8 hr., 12 min.)) sound, color. zweidimensionales bewegtes Bild tdi rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier "Published in August 2023.". - Online resource; title from title details screen (O'Reilly, viewed September 19, 2023) 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. SQL (Computer program language) Database management Streaming video Internet videos Vidéo en continu Vidéos sur Internet Bases de données ; Gestion SQL (Langage de programmation) streaming video Instructional films Nonfiction films Films de formation Films autres que de fiction P., Vivek PräsentatorIn pre Packt Publishing, Verlag pbl TUM01 ZDB-30-ORH TUM_PDA_ORH https://learning.oreilly.com/library/view/-/9781835461808/?ar X:ORHE Aggregator lizenzpflichtig Volltext |
| spellingShingle | The complete SQL bootcamp for aspiring data scientists SQL (Computer program language) Database management Streaming video Internet videos Vidéo en continu Vidéos sur Internet Bases de données ; Gestion SQL (Langage de programmation) streaming video Instructional films Nonfiction films Films de formation Films autres que de fiction |
| title | The complete SQL bootcamp for aspiring data scientists |
| title_auth | The complete SQL bootcamp for aspiring data scientists |
| title_exact_search | The complete SQL bootcamp for aspiring data scientists |
| title_full | The complete SQL bootcamp for aspiring data scientists |
| title_fullStr | The complete SQL bootcamp for aspiring data scientists |
| title_full_unstemmed | The complete SQL bootcamp for aspiring data scientists |
| title_short | The complete SQL bootcamp for aspiring data scientists |
| title_sort | complete sql bootcamp for aspiring data scientists |
| topic | SQL (Computer program language) Database management Streaming video Internet videos Vidéo en continu Vidéos sur Internet Bases de données ; Gestion SQL (Langage de programmation) streaming video Instructional films Nonfiction films Films de formation Films autres que de fiction |
| topic_facet | SQL (Computer program language) Database management Streaming video Internet videos Vidéo en continu Vidéos sur Internet Bases de données ; Gestion SQL (Langage de programmation) streaming video Instructional films Nonfiction films Films de formation Films autres que de fiction |
| url | https://learning.oreilly.com/library/view/-/9781835461808/?ar |
| work_keys_str_mv | AT pvivek thecompletesqlbootcampforaspiringdatascientists AT packtpublishing thecompletesqlbootcampforaspiringdatascientists AT pvivek completesqlbootcampforaspiringdatascientists AT packtpublishing completesqlbootcampforaspiringdatascientists |