Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

LinkedIn Learning - SQL Essential Training

Size
450 MB
Seeders
0
Leechers
1
Files
99
Category
Added
at 12:47pm GMT+1
Infohash
bff57fac50082ae0951771742417f31d349709bf
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.

File list
  • LinkedIn Learning - SQL Essential Training
  • 01- Understanding SQL.en.srt 1.9 KB
  • 01- Understanding SQL.mp4 22.7 MB
  • 02- How to use the exercise files.en.srt 1.8 KB
  • 02- How to use the exercise files.mp4 2.5 MB
  • 03- Course overview.en.srt 2.5 KB
  • 03- Course overview.mp4 2.6 MB
  • 04- Installing on Windows.en.srt 9.7 KB
  • 04- Installing on Windows.mp4 16.3 MB
  • 05- Installing on a Mac.en.srt 12.5 KB
  • 05- Installing on a Mac.mp4 17.9 MB
  • 06- About SQL.en.srt 6.1 KB
  • 06- About SQL.mp4 6.2 MB
  • 07- Database organization.en.srt 4.5 KB
  • 07- Database organization.mp4 5.5 MB
  • 08- The SELECT statement.en.srt 8.6 KB
  • 08- The SELECT statement.mp4 12.8 MB
  • 09- Selecting rows.en.srt 3.7 KB
  • 09- Selecting rows.mp4 7.7 MB
  • 10- Selecting columns.en.srt 2.2 KB
  • 10- Selecting columns.mp4 4.7 MB
  • 11- Counting rows.en.srt 2.9 KB
  • 11- Counting rows.mp4 4.3 MB
  • 12- Inserting data.en.srt 2.8 KB
  • 12- Inserting data.mp4 4.3 MB
  • 13- Updating data.en.srt 3 KB
  • 13- Updating data.mp4 5.2 MB
  • 14- Deleting data.en.srt 1.6 KB
  • 14- Deleting data.mp4 2.7 MB
  • 15- Creating a table.en.srt 4.5 KB
  • 15- Creating a table.mp4 6.3 MB
  • 16- Deleting a table.en.srt 3.4 KB
  • 16- Deleting a table.mp4 5 MB
  • 17- Inserting rows.en.srt 4.6 KB
  • 17- Inserting rows.mp4 7.9 MB
  • 18- Deleting rows.en.srt 3 KB
  • 18- Deleting rows.mp4 4.9 MB
  • 19- The NULL value.en.srt 7.7 KB
  • 19- The NULL value.mp4 14.2 MB
  • 20- Constraining columns.en.srt 7 KB
  • 20- Constraining columns.mp4 11.1 MB
  • 21- Changing a schema.en.srt 3.8 KB
  • 21- Changing a schema.mp4 5.8 MB
  • 22- ID columns.en.srt 5.4 KB
  • 22- ID columns.mp4 7.3 MB
  • 23- Filtering data.en.srt 10.1 KB
  • 23- Filtering data.mp4 19.5 MB
  • 24- Removing duplicates.en.srt 4.6 KB
  • 24- Removing duplicates.mp4 7.8 MB
  • 25- Ordering output.en.srt 5.2 KB
  • 25- Ordering output.mp4 8.6 MB
  • 26- Conditional expressions.en.srt 4.1 KB
  • 26- Conditional expressions.mp4 6.1 MB
  • 27- Understanding JOIN.en.srt 3.7 KB
  • 27- Understanding JOIN.mp4 4.2 MB
  • 28- Accessing related tables.en.srt 10.2 KB
  • 28- Accessing related tables.mp4 15.9 MB
  • 29- Relating multiple tables.en.srt 7.6 KB
  • 29- Relating multiple tables.mp4 13.8 MB
  • 30- About SQL strings.en.srt 2.5 KB
  • 30- About SQL strings.mp4 3 MB
  • 31- Finding the length of a string.en.srt 2.8 KB
  • 31- Finding the length of a string.mp4 4.6 MB
  • 32- Selecting part of a string.en.srt 5.2 KB
  • 32- Selecting part of a string.mp4 8.3 MB
  • 33- Removing spaces.en.srt 2.5 KB
  • 33- Removing spaces.mp4 3.3 MB
  • 34- Folding case.en.srt 3.6 KB
  • 34- Folding case.mp4 5.4 MB
  • 35- Numeric types.en.srt 5 KB
  • 35- Numeric types.mp4 4.9 MB
  • 36- What type is that value.en.srt 3.4 KB
  • 36- What type is that value.mp4 4.9 MB
  • 37- Integer division.en.srt 2.9 KB
  • 37- Integer division.mp4 4.3 MB
  • 38- Rounding numbers.en.srt 1.7 KB
  • 38- Rounding numbers.mp4 2.6 MB
  • 39- Dates and times.en.srt 3.5 KB
  • 39- Dates and times.mp4 3.5 MB
  • 40- Date- and time-related functions.en.srt 3.2 KB
  • 40- Date- and time-related functions.mp4 5.2 MB
  • 41- What are aggregates.en.srt 7.6 KB
  • 41- What are aggregates.mp4 11.9 MB
  • 42- Using aggregate functions.en.srt 2 KB
  • 42- Using aggregate functions.mp4 3.6 MB
  • 43- Aggregating DISTINCT values.en.srt 2.8 KB
  • 43- Aggregating DISTINCT values.mp4 4 MB
  • 44- What are transactions.en.srt 3.5 KB
  • 44- What are transactions.mp4 3.5 MB
  • 45- Data integrity.en.srt 6.3 KB
  • 45- Data integrity.mp4 10.6 MB
  • 46- Performance.en.srt 4.3 KB
  • 46- Performance.mp4 7.3 MB
  • 47- Automating data with triggers.en.srt 6.8 KB
  • 47- Automating data with triggers.mp4 10.7 MB
  • 48- Preventing updates.en.srt 6.5 KB
  • 48- Preventing updates.mp4 9.7 MB
  • 49- Example - Timestamps.en.srt 5.3 KB
  • 49- Example - Timestamps.mp4 9.4 MB
  • 50- Creating a subselect.en.srt 4.4 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.