SQL server course for beginners with 100+ examples / [produced by Packt Publishing].

Format:

Video

Contributor:

Diwan, Amit, speaker.

Packt Publishing, publisher, production company.

Series:

Academic Video Online

Language:

English

Subjects (All):

SQL server.

SQL (Computer program language).

Database management.

Relational databases.

Electronic data processing personnel--Certification.

Electronic data processing personnel.

Genre:

Instructional films.

Physical Description:

1 online resource (119 minutes)

Edition:

[First edition].

Other Title:

SQL introduction : introduction and overview

Place of Publication:

Birmingham, England : PACKT Publishing, 2022.

Language Note:

In English.

System Details:

video file

Summary:

Advance your database management skills with a relational database management system (RDBMS) used in modern database systems such as Microsoft SQL Server, Oracle, MySQL, and Microsoft Access, and understand the concepts of SQL. About This Video: Understand the SQL query process and the role of databases in real-world applications. Create new databases and tables and perform operations to manipulate records using SQL queries. Master SQL querying and write complex query statements to enhance your understanding of MySQL. In Detail: 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. All resources are available at GitHub.

Participant:

Amit Diwan, presenter.

Notes:

Title from resource description page (viewed October 10, 2023).

Title from resource description page (viewed December 04, 2023).

OCLC:

1351841488