CG数据库 >> SQL Fundamentals for beginners

.MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 6 hours | Size: 2.15 GBLearn to interact with databases using SQLWhat you’ll learnInstalling PostgreSQL relational database management systemConnecting to a databaseLoading a sample databaseCreating database and tableUsing constraints to ensure data intergrityUsing SQL SELECT Statement to retrieve dataUsing SQL CREATE Statement to create a tableUsing SQL UPDATE Statement to modify dataUsing SQL DELETE to remove dataUsing SQL DISTINCT to filter duplicate dataFilter data using SQL WHERE ClauseSort data using SQL ORDER BYManipulating data with various operatorsRetrieve and combine data from multiple tablesManipulating data using Aggregate FunctionsRequirementsBasic knowledge of using a computerBasic knowledge of using the internetDescriptionAlmost all applications you interact with on a daily basis involves data which are stored in databases .

Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.

SQL is the language used to interact with the data inside these databases.

SQL skills are always in demand due to the ever increasing use and reliance of data.

In this beginners course, you will learn the building blocks of SQL by interacting with a PostgreSQL database.

From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.

Topics include:Installing PostgreSQL Relational Database SystemConnecting to PostgreSQL Default DatabaseLoad sample databaseCreating database and tablesUsing constraintsRetrieving data from database tableUpdating data inside a tableDeleting data inside a database tableFiltering data returned from a database tableSorting data returned from a database tableRetrieving data using various operatorsCombining data from multiple tablesUsing aggregate functions to manipulate data.

Using subqueriesWho this course is for:Beginners to SQLBeginners to database


SQL Fundamentals for beginners的图片1
SQL Fundamentals for beginners的图片2