Introduction to Databases

Introduction to Databases

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

 

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.

Who this course is for:

Beginner database developers and IT students.

 

Introduction to Databases


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Solid   |  

Information
Members of Guests cannot leave comments.


SermonBox - Seasonal Collection

SermonBox - The Series Pack Collection

Top Rated News

  • Christmas Material
  • Laser Cut & Print Design Elements Bundle - ETSY
  • Daz3D - All Materials - SKU 37000-37999
  • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
  • DigitalXModels Full Collections
  • Rampant Design Tools Full Collections Total: $4400
  • FilmLooks.Com Full Collection
  • All PixelSquid Product
  • The Pixel Lab Collection
  • Envato Elements Full Sources- 3200+ Files
  • Ui8.NET Full Sources
  • The History of The 20th Century
  • The Dover Collections
  • Snake Interiors Collections
  • Inspirational Collections
  • Veer Fancy Collections
  • All Ojo Images
  • All ZZVE Collections
  • All Sozaijiten Collections
  • All Image Broker Collections
  • Shuterstock Bundle Collections
  • Tattoo Collections
  • Blend Images Collections
  • Authors Tuorism Collections
  • Motion Mile - Big Bundle
  • PhotoBacks - All Product - 2018
  • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
Telegram GFXTRA Group
Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
Videohive Wow Pack Series


rss