SQL Essential Training

SQL Essential Training
SQL Essential Training
MP4 | Video: 720p | Duration: 3:17:06 | English | Subtitles: VTT | 412.9 MB

Whatever database application you createR12;whether it's for bookkeeping, sales, inventory, or even the lowly to-do listR12;it's all about the data. Completely updated for 2018, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. 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 and complete database application using SQL.



Topics include:



Understanding SQL terminology and syntax
Creating new tables
Inserting and updating data
Writing basic SQL queries
Sorting and filtering
Accessing related tables with JOIN
Working with strings
Understanding numeric types
Using aggregate functions and transactions
Automating data with triggers
Creating views
Defining functions in PHP
Download link:


Links are Interchangeable - No Password - Single Extraction
loading...
Loading...

Add comment

The author will be very pleased to hear feedback about your news.

    • bowtiesmilelaughingblushsmileyrelaxedsmirk
      heart_eyeskissing_heartkissing_closed_eyesflushedrelievedsatisfiedgrin
      winkstuck_out_tongue_winking_eyestuck_out_tongue_closed_eyesgrinningkissingstuck_out_tonguesleeping
      worriedfrowninganguishedopen_mouthgrimacingconfusedhushed
      expressionlessunamusedsweat_smilesweatdisappointed_relievedwearypensive
      disappointedconfoundedfearfulcold_sweatperseverecrysob
      joyastonishedscreamtired_faceangryragetriumph
      sleepyyummasksunglassesdizzy_faceimpsmiling_imp
      neutral_faceno_mouthinnocent
reload, if the code cannot be seen

Comments 0