Cargando…

The complete guide for SQL with Microsoft SQL server.

Are you interested in learning SQL and database management? Our comprehensive course offers an in-depth look at the fundamentals of databases, including database types, SQL commands, table operations, and advanced concepts such as grouping sets and data types. In the first few sections, you will lea...

Descripción completa

Detalles Bibliográficos
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_on1378796585
003 OCoLC
005 20231017213018.0
006 m o c
007 vz czazuu
007 cr cnannnuuuuu
008 230511s2023 xx 476 o vleng d
040 |a ORMDA  |b eng  |e rda  |e pn  |c ORMDA  |d OCLCF  |d OCLCO 
019 |a 1390764904 
020 |a 9781805121503  |q (electronic video) 
020 |a 1805121502  |q (electronic video) 
035 |a (OCoLC)1378796585  |z (OCoLC)1390764904 
037 |a 9781805121503  |b O'Reilly Media 
050 4 |a QA76.9.D3 
082 0 4 |a 005.75/85  |2 23/eng/20230511 
049 |a UAMI 
245 0 4 |a The complete guide for SQL with Microsoft SQL server. 
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 (7 hr., 56 min.)) :  |b sound, color. 
306 |a 075600 
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 Abhilash Nelson, presenter. 
500 |a "Published in April 2023." 
520 |a Are you interested in learning SQL and database management? Our comprehensive course offers an in-depth look at the fundamentals of databases, including database types, SQL commands, table operations, and advanced concepts such as grouping sets and data types. In the first few sections, you will learn about data manipulation, including selecting, inserting, updating, and deleting data from a database. The course then dives into more advanced topics such as stored procedures, which allow you to write reusable code that can be executed multiple times. You will also learn about views, which provide a way to organize and simplify complex SQL queries, and triggers, which enable you to automate database actions based on certain events. The course then delves into transactions, which are essential for ensuring data consistency and reliability. You will also learn about normalization, which is the process of organizing data in a database to reduce redundancy and improve efficiency. The final sections of the course cover database backup and restore, as well as securing the database against potential threats such as SQL injection attacks. Throughout the course, you will gain hands-on experience by working with real-world examples and scenarios. By the end of the course, you will have a strong foundation in SQL and database management that will serve you well in any career that involves data management. What You Will Learn Understand the fundamentals of database design and management Learn to write SQL queries to extract and manipulate data Implement advanced SQL techniques such as subqueries and views Explore the different types of SQL triggers and transactions Create database backups and restore data in case of loss Secure your database against potential threats like SQL injections Audience This course is designed for anyone interested in learning SQL and database management, including beginners with little to no prior knowledge of SQL. It is suitable for individuals looking to gain skills for a career in data analysis, database administration, or software development. This course will also benefit professionals looking to enhance their current skill set with SQL knowledge. Students pursuing degrees in computer science, information technology, or related fields can also benefit from this course. About The Author Abhilash Nelson: Abhilash Nelson is a pioneering, talented, and security-oriented Android/iOS mobile and PHP/Python web application developer with more than 8 years of IT experience involving designing, implementing, integrating, testing, and supporting impactful web and mobile applications. He has a master's degree in computer science and engineering and has PHP/Python programming experience, which is an added advantage for server-based Android and iOS client applications. Abhilash is currently a senior solution architect managing projects from start to finish to ensure high quality and innovative and functional design. 
588 |a Online resource; title from title details screen (O'Reilly, viewed May 11, 2023). 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a SQL server. 
630 0 7 |a SQL server  |2 fast 
650 0 |a Client/server computing. 
650 0 |a Database management. 
650 6 |a Architecture client-serveur (Informatique) 
650 6 |a Bases de données  |x Gestion. 
650 7 |a Client/server computing  |2 fast 
650 7 |a Database management  |2 fast 
655 7 |a Instructional films  |2 fast 
655 7 |a Internet videos  |2 fast 
655 7 |a Nonfiction films  |2 fast 
655 7 |a Instructional films.  |2 lcgft 
655 7 |a Nonfiction films.  |2 lcgft 
655 7 |a Internet videos.  |2 lcgft 
655 7 |a Films de formation.  |2 rvmgf 
655 7 |a Films autres que de fiction.  |2 rvmgf 
655 7 |a Vidéos sur Internet.  |2 rvmgf 
700 1 |a Nelson, Abhilash,  |e presenter. 
710 2 |a Packt Publishing,  |e publisher. 
856 4 0 |u https://learning.oreilly.com/videos/~/9781805121503/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
994 |a 92  |b IZTAP