• views: 338
• date: 17 June 2022
• posted by: voska89

Fundamentals of database design and management using SQL
What you'll learn
To introduce the basic concepts of database management system
To describe the relational model
To learn how to design a relational database, create tables and define their characteristics
To write and execute SQL commands
To write and execute SQL functions
Requirements
No prior experience needed.
No programming experience required.
Description
This course is designed for those who are interested in learning the fundamentals of a database system and basic structured query language (SQL).
The course does not require any pre-requisite skills other than basic knowledge of using and navigating Windows. You will be introduced to the background of different database systems and the history of SQL. The course however focuses on relational database system (RDBM). The course is a blend of theory and practical work. Students will be taught how to install a relational database server and its related graphical user interface - SQL Server Management Studio (SSMS). Next, two sample databases will be installed (as provided by Microsoft) to practice SQL statements. Moreover, you will be instructed on how to create your database. Within your database, you will be taught about designing tables and declaring their corresponding attributes (columns), data types, and other characteristics such as NULL/Not NULL and uniqueness. This leads to defining the primary key (PK) in a table.
Once a database and its table(s) are defined, you will be taught through examples to populate them with data. Data manipulation language (DML) is the main focus of this course, in which you will learn how to make use of the information/data stored in tables. Starting with the basics of SQL i.e. SELECT-FROM-WHERE, we will proceed to learn how to use calculations in SQL. You will also be taught SQL (both mathematical and string) functions, along with different SQL clauses such as TOP, HAVING, GROUP BY, etc. You will also be taught how to join multiple tables using a foreign key (FK). Finally, the UPDATE statement will be taught to show how to modify data in a database.
Once completed, students will be able to install a database server, create their database, make tables, define attributes, PK, and FK, and manipulate/modify data in their database using SQL statements. A practice exercise is a part of the course as well.
Who this course is for
Beginner database developers and IT students.
Homepage

https://www.udemy.com/course/introduction-to-databases/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.