Cargando…

SQL server course for beginners with 100+ examples.

SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server also allows user-defined composite types (UDTs) to be used. The SQL Server services operate within SQL server instances, allowing people to do machine learning and data analytics. In this course, you wil...

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, [2022]
Edición:[First edition].
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cgm a22000007i 4500
001 OR_on1351841488
003 OCoLC
005 20231017213018.0
006 m o c
007 vz czazuu
007 cr cnannnuuuuu
008 221128s2022 xx 120 o vleng d
040 |a ORMDA  |b eng  |e rda  |e pn  |c ORMDA  |d OCLCF 
020 |a 9781837630226  |q (electronic video) 
020 |a 1837630224  |q (electronic video) 
029 1 |a AU@  |b 000072997831 
035 |a (OCoLC)1351841488 
037 |a 9781837630226  |b O'Reilly Media 
050 4 |a QA76.73.S67 
082 0 4 |a 005.75/6  |2 23/eng/20221128 
049 |a UAMI 
245 0 0 |a SQL server course for beginners with 100+ examples. 
250 |a [First edition]. 
264 1 |a [Place of publication not identified] :  |b Packt Publishing,  |c [2022] 
300 |a 1 online resource (1 video file (2 hr.)) :  |b sound, color. 
306 |a 020000 
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 Amit Diwan, presenter. 
500 |a "Published in November 2022." 
520 |a SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server also allows user-defined composite types (UDTs) to be used. The SQL Server services operate within SQL server instances, allowing people to do machine learning and data analytics. In this course, you will understand the difference between SQL and NoSQL. You will query SQL and learn about built-in SQL functions. You will create and modify databases and tables using the CREATE DATABASE and CREATE TABLE statements. You will create, select, and modify records and create constraints in SQL. You will advance to create indexes, drop tables, and databases in SQL. You will learn about operators (AND, OR, NOT, LIKE, BETWEEN, IN, LIKE), functions, statements, and constraints in SQL. You will look at stored procedures and aliases, and learn to back up databases in SQL. You will use the WHERE clause to query and learn about the SELECT and DISTINCT functions. You will arrange data using the ORDER BY keyword and ASC and DESC keywords. After completing the course, you will thoroughly understand SQL's features and components. You will create complex databases and maintain existing databases. Finally, you will acquire complex SQL query capabilities and write complex queries. What You Will Learn Create databases and tables from the start Learn to handle MySQL queries Learn to query SQL to manipulate records in tables Explore functions, statements, and constraints in SQL Create and maintain complex databases and table structures Write complex query statements for maximum data optimization Audience This course delivers a substantial learning experience for database creators, web developers, application developers, and programmers who must operate with SQL and database structures. Database analysts and administrators who are looking to advance/refresh their knowledge skillsets can benefit from this course. The course has no additional prerequisites besides basic computer use knowledge. About The Author Amit Diwan: Studyopedia was founded by Amit Diwan in 2018 after working for Tutorialspoint , IIT, IASRI, Sitepoint, DU, and C# Corner. Studyopedia sells courses on Udemy, Tutorialspoint, Geeksforgeeks, and Skillshare, providing video courses to master various technologies and programming languages, databases, frameworks, Python, data science, machine learning, Java, Android, C/C++, HTML5, Bootstrap, JavaScript, jQuery, PHP, CSS, WordPress, Drupal, Joomla, Magento, osCommerce, OpenCart, PrestaShop, and other disciplines. Studyopedia delivers high-quality video courses to millions of students and professionals enrolled through their website on multiple programming languages and technologies. 
588 |a Online resource; title from title details screen (O'Reilly, viewed November 28, 2022). 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a SQL (Computer program language) 
650 0 |a Electronic data processing personnel  |x Certification. 
650 0 |a Microsoft software  |x Examinations  |v Study guides. 
650 7 |a Electronic data processing personnel  |x Certification.  |2 fast  |0 (OCoLC)fst00907100 
650 7 |a Microsoft software  |x Examinations.  |2 fast  |0 (OCoLC)fst01020090 
650 7 |a SQL (Computer program language)  |2 fast  |0 (OCoLC)fst01102869 
655 7 |a Instructional films.  |2 fast  |0 (OCoLC)fst01726236 
655 7 |a Internet videos.  |2 fast  |0 (OCoLC)fst01750214 
655 7 |a Nonfiction films.  |2 fast  |0 (OCoLC)fst01710269 
655 7 |a Study guides.  |2 fast  |0 (OCoLC)fst01423888 
655 7 |a Instructional films.  |2 lcgft 
655 7 |a Nonfiction films.  |2 lcgft 
655 7 |a Internet videos.  |2 lcgft 
700 1 |a Diwan, Amit,  |e presenter. 
710 2 |a Packt Publishing,  |e publisher. 
856 4 0 |u https://learning.oreilly.com/videos/~/9781837630226/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
994 |a 92  |b IZTAP