Cargando…
Learning SQL /
Almost 3 Hours of Video Instruction Your complete SQL video course: Master hands-on, real-world skills for working with data, tables, queries, and much more! Description In Learning SQL LiveLessons Ben Forta, the world's favorite SQL teacher, helps you master the core real-world skills you need...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Formato: | Electrónico Video |
| Idioma: | Inglés |
| Publicado: |
Addison-Wesley Professional,
2015.
|
| Edición: | 1st edition. |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cgm a22000007i 4500 | ||
|---|---|---|---|
| 001 | OR_on1232114520 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o c | ||
| 007 | cr cn||||||||| | ||
| 007 | vz czazuu | ||
| 008 | 210120s2015 xx --- o vleng d | ||
| 040 | |a NZCPL |b eng |c NZCPL |d OCLCO |d OCLCF |d DST |d OCLCO |d OCLCQ | ||
| 020 | |z 0134193709 | ||
| 024 | 8 | |a 9780134193700 | |
| 035 | |a (OCoLC)1232114520 | ||
| 036 | |b CCLOReilly | ||
| 049 | |a UAMI | ||
| 100 | 1 | |a Forta, Ben, | |
| 245 | 1 | 0 | |a Learning SQL / |c Forta, Ben. |
| 250 | |a 1st edition. | ||
| 264 | 1 | |b Addison-Wesley Professional, |c 2015. | |
| 300 | |a 1 online resource (1 streaming video file, approximately 2 hr., 45 min.) | ||
| 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 | ||
| 347 | |a video file | ||
| 500 | |a Not recommended for use on the libraries' public computers. | ||
| 520 | |a Almost 3 Hours of Video Instruction Your complete SQL video course: Master hands-on, real-world skills for working with data, tables, queries, and much more! Description In Learning SQL LiveLessons Ben Forta, the world's favorite SQL teacher, helps you master the core real-world skills you need to succeed with SQL. Drawing on his experience helping thousands of developers and other IT pros at all levels, Forta guides you from the absolute basics all the way to advanced queries, joins, and beyond. One step at a time, you'll learn how to retrieve data with SELECT; sort, filter, group, and summarize data; create calculated fields; manipulate data with string and date functions; build queries and subqueries; create basic and advanced table joins; combine queries with UNION; sort your queries; insert, update, and delete data; and even discover what you can do with triggers and stored procedures. Everything's organized into bite-sized, self-contained lessons, so you can learn key SQL skills quickly and easily. Skill Level Beginner Intermediate What You Will Learn Retrieve data using the SQL SELECT statement Sort, filter, and manipulate data Create calculated fields Group and summarize data Work with subqueries and WHERE statements Use basic and advanced table joins Combine queries with UNION statements Insert, update, and delete data Get started with advanced SQL features Who Should Take This Course Everyone who wants to master SQL to manage data, write queries, and/or build database applications with any modern relational database Professional and casual developers at all levels Course Requirements Basic experience using databases; no SQL experience necessary Lesson 1: Introducing SQL Review database basics such as tables, rows, columns, and keys; understand what relational databases are; choose a DBMS; and learn what SQL is and what it does. Lesson 2: Retrieving Data Work with SELECT, the most used SQL statement. Retrieve individual, multiple, or all columns; retrieve specific rows; and limit the data you retrieve. Master and refine some important SQL skills and best practices. Lesson 3: Sorting Retrieved Data Use SELECT ORDER BY, sort by one or multiple columns, and specify the direction of your sort. Lesson 4: Filtering Data Use SELECT WHERE and its clause operators, use BETWEEN to filter for a range of values, and use NULL to filter for no value. Lesson 5: Advanced Data Filtering Combine WHERE filters using AND and OR; correctly manage "order o ... | ||
| 550 | |a Made available through: Safari, an O'Reilly Media Company. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 710 | 2 | |a Safari, an O'Reilly Media Company. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/videos/~/9780134193700/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 936 | |a BATCHLOAD | ||
| 994 | |a 92 |b IZTAP | ||