346 Intervals - Learning Path SQL and Relational Databases-96E7A188.mp4426.06MB

10 Filtering Date Columns - Learning Path SQL and Relational Databases-4D7C67D2.mp418MB

100 How Data Is Organized In A Relational Database - Learning Path SQL and Relational Databases-9688E53F.mp413.85MB

101 The Entity-Relationship Approach - Learning Path SQL and Relational Databases-75834D78.mp417.65MB

102 Normalization Guidelines - Part 1 - Learning Path SQL and Relational Databases-C6CE3B2F.mp426.81MB

103 Normalization Guidelines - Part 2 - Learning Path SQL and Relational Databases-010BE473.mp423.95MB

104 Assignment 10 - Learning Path SQL and Relational Databases-1A227585.mp44.25MB

105 Assignment 10 - Solution - Learning Path SQL and Relational Databases-8D8E24E5.mp47.19MB

107 Creating Tables - Part 1 - Learning Path SQL and Relational Databases-CD229805.mp420.31MB

108 Creating Tables - Part 2 - Learning Path SQL and Relational Databases-8FBDD263.mp429.94MB

109 Specifying Keys - Learning Path SQL and Relational Databases-3B798815.mp48.63MB

11 Using Comments Within SQL - Learning Path SQL and Relational Databases-DC39580F.mp419.15MB

110 The Check Constraint - Learning Path SQL and Relational Databases-513A6CE3.mp425.55MB

111 Creating Indexes - Learning Path SQL and Relational Databases-36AEA90D.mp412.21MB

112 Modifying And Removing Tables - Learning Path SQL and Relational Databases-9FA428B9.mp49.84MB

113 More Constraints - Learning Path SQL and Relational Databases-60A43C96.mp47.73MB

114 Adding Data To A Table - Learning Path SQL and Relational Databases-F39267FF.mp421.9MB

115 Changing Data In A Table - Part 1 - Learning Path SQL and Relational Databases-66A05933.mp416.97MB

116 Changing Data In A Table - Part 2 - Learning Path SQL and Relational Databases-D5922FCB.mp412.35MB

117 Removing Data From A Table - Learning Path SQL and Relational Databases-55165958.mp46.22MB

118 Assignment 11 - Learning Path SQL and Relational Databases-3713DCAB.mp43.72MB

119 Assignment 11 - Solution - Learning Path SQL and Relational Databases-D34D5C5D.mp43.46MB

12 Use Of Wildcards In Filtering - Learning Path SQL and Relational Databases-EF19666A.mp438.91MB

120 String Functions - Part 1 - Learning Path SQL and Relational Databases-0B65C7BD.mp421.06MB

121 String Functions - Part 2 - Learning Path SQL and Relational Databases-95D3EAE3.mp413.68MB

122 Number Functions - Learning Path SQL and Relational Databases-AA34FAB5.mp419.06MB

123 Date Functions - Learning Path SQL and Relational Databases-029DF085.mp427.31MB

124 Limiting Rows And The Dual Table - Learning Path SQL and Relational Databases-13B76B43.mp417.77MB

125 Assignment 12 - Learning Path SQL and Relational Databases-C31DD5E7.mp46.93MB

126 Assignment 12 - Solution - Learning Path SQL and Relational Databases-C4CF839C.mp49.28MB

127 Creating And Using Views - Learning Path SQL and Relational Databases-49B2C400.mp430.24MB

128 Set Operators - Learning Path SQL and Relational Databases-F13A241C.mp434.89MB

129 Assignment 13 - Learning Path SQL and Relational Databases-132E0C49.mp42.32MB

13 Multiple Criteria Using And Or In - Learning Path SQL and Relational Databases-95DC044D.mp425.57MB

130 Assignment 13 - Solution - Learning Path SQL and Relational Databases-0169A187.mp45.72MB

131 Transaction Management - Learning Path SQL and Relational Databases-4F1215FD.mp45.38MB

132 Concurrency Control - Learning Path SQL and Relational Databases-1B500313.mp47.79MB

133 Security Considerations - Learning Path SQL and Relational Databases-6499951F.mp411.15MB

134 Stored Procedures And Triggers - Learning Path SQL and Relational Databases-0A22317C.mp47.46MB

135 Database Integrity - Learning Path SQL and Relational Databases-706387FC.mp46.14MB

136 Assignment 14 - Learning Path SQL and Relational Databases-E0AC42E0.mp43.42MB

137 Assignment 14 - Solution - Learning Path SQL and Relational Databases-9A6BBCDD.mp46.23MB

138 Implicit Joins - Learning Path SQL and Relational Databases-34AC9D41.mp410.36MB

139 Subqueries With Modifiers - Learning Path SQL and Relational Databases-E86D7868.mp49.05MB

14 Text Manipulation Functions - Learning Path SQL and Relational Databases-B1BFC1F1.mp437.58MB

140 Subqueries Using The Exists Clause - Learning Path SQL and Relational Databases-0D53D90A.mp411.82MB

141 Assignment 15 - Learning Path SQL and Relational Databases-2C01C657.mp44.81MB

142 Assignment 15 - Solution - Learning Path SQL and Relational Databases-10744C1C.mp411.89MB

143 Difference Between Oracle And Other SQLs - Learning Path SQL and Relational Databases-208A4913.mp412.71MB

144 SQL In A Programming Language - Learning Path SQL and Relational Databases-6EEB1519.mp411.97MB

145 Embedded SQL - Learning Path SQL and Relational Databases-4A3F8B97.mp48.46MB

146 Introduction - Learning Path SQL and Relational Databases-ED9CBDFA.mp4206.06MB

146 What Is Next- - Learning Path SQL and Relational Databases-2085DF2F.mp42.12MB

147 Basic Database Concepts Part 1 - Learning Path SQL and Relational Databases-E5C9E500.mp4199.81MB

148 Basic Database Concepts Part 2 - Learning Path SQL and Relational Databases-4F551F45.mp451.24MB

149 Relations Part 1 - Learning Path SQL and Relational Databases-63CC0A04.mp4191.19MB

15 Working With Null Or Empty Values - Learning Path SQL and Relational Databases-4F896954.mp424.88MB

150 Relations Part 2 - Learning Path SQL and Relational Databases-5650A92B.mp4102.63MB

151 Relations Part 3 - Learning Path SQL and Relational Databases-CE412166.mp432.32MB

152 Keys and Foreign Keys Part 1 - Learning Path SQL and Relational Databases-F7A7AD98.mp4279.13MB

153 Keys and Foreign Keys Part 2 - Learning Path SQL and Relational Databases-D45A760A.mp494.84MB

154 Keys and Foreign Keys Part 3 - Learning Path SQL and Relational Databases-8B7E1ABB.mp411.88MB

155 Relational Operators 1 - Part 1 - Learning Path SQL and Relational Databases-BD092842.mp4165.52MB

156 Relational Operators 1 - Part 2 - Learning Path SQL and Relational Databases-1C9E8DE1.mp4155.69MB

157 Relational Operators 1 - Part 3 - Learning Path SQL and Relational Databases-1BC94037.mp498.83MB

158 Relational Operators 1 - Part 4 - Learning Path SQL and Relational Databases-3D0DC25C.mp4250.14MB

159 Relational Operators 1 - Part 5 - Learning Path SQL and Relational Databases-91841503.mp465.41MB

16 Add A Calculating Column To A SQL Statement - Learning Path SQL and Relational Databases-C6A1AB49.mp411.77MB

160 Relational Operators 2 - Part 1 - Learning Path SQL and Relational Databases-DF6B607A.mp4173.67MB

161 Relational Operators 2 - Part 2 - Learning Path SQL and Relational Databases-B13C6579.mp4134.75MB

162 Relational Operators 2 - Part 3 - Learning Path SQL and Relational Databases-D6D092E2.mp410.64MB

163Constraints and Predicates Part 1 - Learning Path SQL and Relational Databases-EDA50537.mp4173.26MB

164 Constraints and Predicates Part 2 - Learning Path SQL and Relational Databases-4D02A7D0.mp4233MB

165 Constraints and Predicates Part 3 - Learning Path SQL and Relational Databases-F07C62AF.mp410.37MB

166 The Relational Model Part 2 - Learning Path SQL and Relational Databases-DA4F06DA.mp450.09MB

167 The Relational Model Part 1 - Learning Path SQL and Relational Databases-90606993.mp4357.48MB

168 Entr-acte Transactions Part 1 - Learning Path SQL and Relational Databases-6642743C.mp4119.54MB

169 Entr-acte Transactions Part 2 - Learning Path SQL and Relational Databases-F615071F.mp4207.93MB

17 Differences In Date Functions Within SQL - Learning Path SQL and Relational Databases-BF58E5FC.mp423.4MB

170 Entr-acte Design Theory Part 1 - Learning Path SQL and Relational Databases-6F82B0C1.mp4171.94MB

171 Entr-acte Design Theory Part 2 - Learning Path SQL and Relational Databases-A0F15E9C.mp4145.46MB

172 Entr-acte Design Theory Part 3 - Learning Path SQL and Relational Databases-5DE948A8.mp4259.73MB

173 SQL Tables Part 2 - Learning Path SQL and Relational Databases-068E1AB4.mp428.82MB

174 SQL Tables Part 1 - Learning Path SQL and Relational Databases-0EA6C433.mp4293.06MB

175 SQL Tables Part 3 - Learning Path SQL and Relational Databases-34156F65.mp447.61MB

176 SQL Operators 1 - Part 1 - Learning Path SQL and Relational Databases-004D4E77.mp4210.85MB

177 SQL Operators 1 - Part 2 - Learning Path SQL and Relational Databases-192B2347.mp4139.83MB

178 SQL Operators 1 - Part 4 - Learning Path SQL and Relational Databases-ECE48751.mp437.11MB

179 SQL Operators 1 - Part 3 - Learning Path SQL and Relational Databases-A4719CDA.mp4284.43MB

18 Calculating Age - Learning Path SQL and Relational Databases-6851DC7D.mp422.3MB

180 SQL Operators 2 - Part 1 - Learning Path SQL and Relational Databases-2C6E9E12.mp4169.82MB

181 SQL Operators 2 - Part 3 - Learning Path SQL and Relational Databases-E6C03016.mp411.52MB

182 SQL Operators 2 - Part 2 - Learning Path SQL and Relational Databases-D6EA35F6.mp4307.4MB

183 SQL Constraints - Learning Path SQL and Relational Databases-30237C33.mp4233.82MB

184 SQL vs. the Relational Model Part 1 - Learning Path SQL and Relational Databases-66B53E86.mp4219.06MB

185 SQL vs. the Relational Model Part 2 - Learning Path SQL and Relational Databases-D3DB015B.mp492.78MB

186 References Complete - Learning Path SQL and Relational Databases-69292FA1.mp497.36MB

187 About This SQL Advanced Title - Learning Path SQL and Relational Databases-58F09894.mp47.82MB

188 2 About The Author - Learning Path SQL and Relational Databases-A50E19DE.mp46.49MB

19 Concatenate Data Columns - Learning Path SQL and Relational Databases-7CF31A3A.mp418.51MB

190 Relational Databases And Key Terms Explained - Learning Path SQL and Relational Databases-FFF3F583.mp412.79MB

191 Recap Of SQL SELECT Command - Learning Path SQL and Relational Databases-04711FDD.mp432.07MB

192 How To Access Your Working Files - Learning Path SQL and Relational Databases-9298F0EE.mp44.9MB

193 Overview Of The Other DML Statements - Learning Path SQL and Relational Databases-B8A646E1.mp415.4MB

194 Installing The Sample Data And Using The Working Files - Learning Path SQL and Relational Databases-4C63395A.mp413.91MB

195 Converting Datatypes - Learning Path SQL and Relational Databases-6866414C.mp431.34MB

196 Creating A Temporary Table - Learning Path SQL and Relational Databases-E070A706.mp424.35MB

197 The DISTINCT And TOP Keywords In Action - Learning Path SQL and Relational Databases-C5DFB00C.mp422.04MB

198 Indexing To Speed Up Your Life - Learning Path SQL and Relational Databases-F79D8060.mp427.1MB

199 Declaring And Using Variables - Learning Path SQL and Relational Databases-B5B09748.mp427.61MB

2 Installing Sample Databases And Working Files - Learning Path SQL and Relational Databases-EED80787.mp414.61MB

2 What Are The SQL Commands - Learning Path SQL and Relational Databases-628A31DA.mp43.75MB

20 Which Tables Can I Join And How- - Learning Path SQL and Relational Databases-A1738DF0.mp425.74MB

200 What Is A Subquery- - Learning Path SQL and Relational Databases-0DE7A90E.mp422.67MB

201 Subquery Vs Joins - Learning Path SQL and Relational Databases-1CF6B319.mp420.09MB

202 Using Correlated Subqueries - Learning Path SQL and Relational Databases-8AC34832.mp430.28MB

203 Using The EXISTS Keyword - Learning Path SQL and Relational Databases-0E6E4C5C.mp420.3MB

204 Getting Started With The CASE Statement - Learning Path SQL and Relational Databases-F5CD31DF.mp425.77MB

205 Finding Duplicate Records - Learning Path SQL and Relational Databases-32494B58.mp424.91MB

206 Multiple Criteria Within The CASE Statement - Learning Path SQL and Relational Databases-2BAB6342.mp425.8MB

207 Using The CASE Statement With Criteria On Multiple Columns - Learning Path SQL and Relational Databases-706BEC2F.mp425.22MB

208 CASE In WHERE, ORDER BY, And GROUP BY Clauses - Learning Path SQL and Relational Databases-737BAA76.mp417.82MB

209 CASE In UPDATE And INSERT Statements - Learning Path SQL and Relational Databases-D71DFE95.mp424.52MB

21 The Special Cross Or Cartesian Join - Learning Path SQL and Relational Databases-3262A458.mp412.15MB

210 CASE Within Subqueries - Learning Path SQL and Relational Databases-835ABCC4.mp422.7MB

211 Filtering Results Based On Numbering Ranking - Learning Path SQL and Relational Databases-68451FCC.mp425.29MB

212 Filtering A Ranked Group To Determine Top N - Learning Path SQL and Relational Databases-C494CA13.mp420.65MB

213 Using Built In Functions - Learning Path SQL and Relational Databases-4EB81DF2.mp430.92MB

214 Creating And Using Your Own Functions (UDF) - Learning Path SQL and Relational Databases-2F706E73.mp422.37MB

215 Using Numbering Within Groups - Learning Path SQL and Relational Databases-3096B901.mp419.32MB

216 Numbering Or Ranking Records In A SELECT Statement - Learning Path SQL and Relational Databases-007B393F.mp427.39MB

217 Creating A View - Learning Path SQL and Relational Databases-AD802AB0.mp423.14MB

218 Example Views And Views In Views - Learning Path SQL and Relational Databases-3BC5374E.mp420.42MB

219 Using The UNION Clause - Learning Path SQL and Relational Databases-6764F285.mp424.33MB

22 Group And Summaries Within Joined Table SQL - Learning Path SQL and Relational Databases-4F68476A.mp425.91MB

220 What Is A Stored Procedure- - Learning Path SQL and Relational Databases-DA562C21.mp434.02MB

221 Creating A Stored Procedure - Learning Path SQL and Relational Databases-FD2F1E29.mp426.7MB

222 Running A Stored Procedure - Learning Path SQL and Relational Databases-2B590883.mp420.34MB

223 Looping With WHILE And IF - Learning Path SQL and Relational Databases-1268BD89.mp429.67MB

224 The Global Variables @@Identity And @@Rowcount - Learning Path SQL and Relational Databases-EB3E8CD9.mp431.38MB

225 Dynamically Build SQL Statements - Learning Path SQL and Relational Databases-9CD55C39.mp435.26MB

226 TRY And CATCH For Error Trapping - Learning Path SQL and Relational Databases-FF379FDB.mp419.17MB

227 Stored Procedures Within Stored Procedures - Learning Path SQL and Relational Databases-7D73D728.mp422.5MB

228 Cursors In Use - Part 2 - Learning Path SQL and Relational Databases-798DA27D.mp421.98MB

229 Use Of Transactions - Learning Path SQL and Relational Databases-F2C680D3.mp427.13MB

23 Using Different Join Types - Learning Path SQL and Relational Databases-6DE3EE19.mp422.67MB

230 Cursors In Use - Part 1 - Learning Path SQL and Relational Databases-7D73EBA0.mp420.62MB

231 Wrap Up - Learning Path SQL and Relational Databases-1BCFE944.mp411.61MB

232 About The Author - Learning Path SQL and Relational Databases-B8410902.mp49.52MB

233 About The Course - Learning Path SQL and Relational Databases-5E0E46DE.mp46.04MB

234 What Is A Database- - Learning Path SQL and Relational Databases-99C49DF0.mp44.56MB

235 What Is A Data Model- - Learning Path SQL and Relational Databases-67267DD9.mp43.37MB

236 How To Access Your Working Files - Learning Path SQL and Relational Databases-8560A2E7.mp44.89MB

237 Data Model Inputs And Outputs - Learning Path SQL and Relational Databases-6F2D0E79.mp42.93MB

238 Data Model Notations - Learning Path SQL and Relational Databases-F47ACBD4.mp411.65MB

239 Class And Attribute - Learning Path SQL and Relational Databases-1762EFD0.mp427.01MB

24 Amend Data In Tables - Learning Path SQL and Relational Databases-2012B7EC.mp434.97MB

240 Operation - Learning Path SQL and Relational Databases-E3D6E3C7.mp45.43MB

241 Association - Learning Path SQL and Relational Databases-AADFFF56.mp420.3MB

242 Domain - Learning Path SQL and Relational Databases-83177578.mp420.01MB

243 IE Entity Type And Relationship Type - Learning Path SQL and Relational Databases-7FEA19DC.mp413.16MB

244 Association Name - Learning Path SQL and Relational Databases-9511A53C.mp416MB

245 Generalization - UML - Learning Path SQL and Relational Databases-D6319F6A.mp410.6MB

246 Generalization - IE - Learning Path SQL and Relational Databases-EC7E3B4C.mp413.95MB

247 Practical Tips - Learning Path SQL and Relational Databases-818F3710.mp42.73MB

248 Self Assessment Test - Basic Modeling Data - Learning Path SQL and Relational Databases-BE09FC54.mp49.09MB

249 Identity - Learning Path SQL and Relational Databases-32273893.mp49.71MB

25 Joining More Than Two Tables - Learning Path SQL and Relational Databases-F215CA95.mp418.3MB

250 Derived Data - Learning Path SQL and Relational Databases-6638619B.mp48.97MB

251 Current Versus Historical Data - Learning Path SQL and Relational Databases-BE8500B9.mp41.92MB

252 Large Taxonomies - Learning Path SQL and Relational Databases-7B38D3AC.mp45.11MB

253 Qualified Association - IE - Learning Path SQL and Relational Databases-CDFC9936.mp48.76MB

254 Large Taxonomies - Learning Path SQL and Relational Databases-6AAF9C0A.mp45.11MB

255 Package - Learning Path SQL and Relational Databases-622DB343.mp46.39MB

256 Abridged UML Metamodel - Learning Path SQL and Relational Databases-50D159E5.mp44.66MB

257 Abridged IE Metamodel - Learning Path SQL and Relational Databases-3450A61E.mp44.21MB

258 Modeling Pitfalls - Learning Path SQL and Relational Databases-CD7101BE.mp410.43MB

259 Practical Tips - Learning Path SQL and Relational Databases-EAE7CF6B.mp42.47MB

26 Adding Data To Tables With Insert - Learning Path SQL and Relational Databases-1D817D96.mp431.55MB

260 Self Assessment Test - Advanced Data Modeling - Learning Path SQL and Relational Databases-3E9D5993.mp48.51MB

261 Problem Statement - Learning Path SQL and Relational Databases-B37D3B84.mp44.27MB

262 Problem Statement - Learning Path SQL and Relational Databases-3D16FBE3.mp44.27MB

263 Database Design I - Structure - Part 2 - Learning Path SQL and Relational Databases-42FB2F42.mp4131.61MB

263 Finding Classes - Learning Path SQL and Relational Databases-00C3C887.mp417.33MB

264 Finding Associations - Part 1 - Learning Path SQL and Relational Databases-F7CE2C50.mp417.15MB

265 Finding Associations - Part 2 - Learning Path SQL and Relational Databases-65F2C0AA.mp420.08MB

266 Adding Attributes - Learning Path SQL and Relational Databases-922E1E10.mp418.6MB

267 Iterating And Refining The Model - Part 2 - Learning Path SQL and Relational Databases-A8627518.mp416.21MB

268 Cleaning Up Layout - Learning Path SQL and Relational Databases-26216065.mp414.67MB

269 Simplifying The Model - Learning Path SQL and Relational Databases-77186FAB.mp45.31MB

27 Create A New Table - Learning Path SQL and Relational Databases-36D87CC2.mp420.51MB

270 Evolving A Model - Part 1 - Learning Path SQL and Relational Databases-1DCE0D94.mp46.31MB

271 Finding Generalizations - Learning Path SQL and Relational Databases-A72D57E7.mp45.19MB

272 Evolving A Model - Part 2 - Learning Path SQL and Relational Databases-AD016317.mp416.24MB

273 Enterprise Architect Techniques - Part 1 - Learning Path SQL and Relational Databases-13854DFA.mp412.83MB

274 Enterprise Architect Techniques - Part 3 - Learning Path SQL and Relational Databases-571DF511.mp414.45MB

275 Enterprise Architect Techniques - Part 2 - Learning Path SQL and Relational Databases-6B98C290.mp418.23MB

276 Creating Subject Areas - Learning Path SQL and Relational Databases-8D737452.mp410.34MB

277 Iterating And Refining The Model - Part 1 - Learning Path SQL and Relational Databases-401AFB66.mp49.77MB

278 Creating Entity Types - Learning Path SQL and Relational Databases-AB2449E0.mp49.18MB

279 Creating Domains - Learning Path SQL and Relational Databases-F2361A4C.mp419.71MB

28 Changing A Tables Structure - Learning Path SQL and Relational Databases-07CEC6DE.mp414.8MB

280 Adding Attributes - Part 1 - Learning Path SQL and Relational Databases-BA1C9CC1.mp421.25MB

281 Adding Attributes - Part 2 - Learning Path SQL and Relational Databases-89E8C3DC.mp410.73MB

282 Creating Relationship Types - Part 2 - Learning Path SQL and Relational Databases-B85F37FA.mp412.77MB

283 Creating Relationship Types - Part 1 - Learning Path SQL and Relational Databases-545D636A.mp416.33MB

284 Creating Relationship Types - Part 3 - Learning Path SQL and Relational Databases-F217E45D.mp417.68MB

285 Subtyping - Learning Path SQL and Relational Databases-D52291BF.mp410.56MB

286 Adding Alternate Keys - Learning Path SQL and Relational Databases-1063A417.mp411.78MB

287 Cleaning Up The Layout - Learning Path SQL and Relational Databases-FA7607B3.mp45.53MB

288 ERwin Techniques - Part 1 - Learning Path SQL and Relational Databases-712567F8.mp420.17MB

289 ERwin Techniques - Part 2 - Learning Path SQL and Relational Databases-CD748127.mp413.17MB

29 What Is A View And How To Create One - Learning Path SQL and Relational Databases-A0933079.mp421.04MB

290 Model Quality - Learning Path SQL and Relational Databases-C7EFB779.mp41.34MB

291 Normal Forms - Learning Path SQL and Relational Databases-C2F2F0C0.mp414.9MB

292 Constraints - Learning Path SQL and Relational Databases-BF9235B6.mp410.35MB

293 Hoberman Data Model Scorecard - Learning Path SQL and Relational Databases-AABC795B.mp410.17MB

294 Operational Data Models - Learning Path SQL and Relational Databases-1964B2BD.mp45.72MB

295 Data Warehouses - Part 1 - Learning Path SQL and Relational Databases-331F0773.mp421.87MB

296 Data Warehouses - Part 2 - Learning Path SQL and Relational Databases-BCDF4677.mp47.9MB

297 Attribute Details - Part 1 - Learning Path SQL and Relational Databases-AC589E27.mp421.89MB

298 Master Data Models - Learning Path SQL and Relational Databases-9AFFF3F3.mp47.53MB

299 Attribute Details - Part 3 - Learning Path SQL and Relational Databases-3D442529.mp426.46MB

3 Select Syntax And Examples - Learning Path SQL and Relational Databases-69D82F78.mp415.77MB

30 Alter Or Delete A View - Learning Path SQL and Relational Databases-5EE4CB42.mp410.92MB

300 Referential Integrity - Part 1 - Learning Path SQL and Relational Databases-C595B406.mp439.92MB

301 Referential Integrity - Part 2 - Learning Path SQL and Relational Databases-E8DCB55E.mp421.59MB

302 Check Constraints - Part 1 - Learning Path SQL and Relational Databases-65F09CE3.mp422.17MB

302 Creating A New Database - Learning Path SQL and Relational Databases-6891EBC8.mp414.63MB

303 Querying Sample Data - Learning Path SQL and Relational Databases-C0276D0F.mp427.6MB

304 Executing Schema - Learning Path SQL and Relational Databases-7823EAC6.mp48.12MB

305 Self Assessment Test - Database Design - Learning Path SQL and Relational Databases-AB88BB67.mp45.92MB

306 Check Constraints - Part 2 - Learning Path SQL and Relational Databases-1BF3C208.mp423.59MB

307 Other Aspects Of Design - Learning Path SQL and Relational Databases-E12F97AF.mp45.89MB

308 Indexes - Learning Path SQL and Relational Databases-426AE242.mp425.84MB

309 Inspecting Metadata - Learning Path SQL and Relational Databases-D3E915D2.mp431.53MB

31 The Main Variances In SQL Between Databases - Learning Path SQL and Relational Databases-D395ACC1.mp47.73MB

310 Views - Learning Path SQL and Relational Databases-5A87FAA7.mp439.01MB

311 Loading Sample Data - Learning Path SQL and Relational Databases-166810A4.mp412.94MB

312 Schema Adjustments - Learning Path SQL and Relational Databases-19259A8B.mp421.43MB

313 Primary And Alternate Keys - Learning Path SQL and Relational Databases-FCBE2466.mp436.48MB

314 Attribute Details - Part 2 - Learning Path SQL and Relational Databases-51FCD1AC.mp421.54MB

315 Generating An ERwin Schema - Learning Path SQL and Relational Databases-DB81ECFE.mp411.61MB

316 Creating Tables - Learning Path SQL and Relational Databases-7F55D43E.mp420.86MB

317 Creating Indexes - Learning Path SQL and Relational Databases-2B0ECB54.mp412.55MB

318 Creating Constraints And Default Values - Learning Path SQL and Relational Databases-9CD42A0D.mp48.08MB

319 Defining Foreign Keys - Learning Path SQL and Relational Databases-6D1B0118.mp414.61MB

32 Wrap Up - Learning Path SQL and Relational Databases-DFDFE147.mp47.42MB

320 Creating Views - Learning Path SQL and Relational Databases-E619A850.mp411.43MB

321 Loading Sample Data - Learning Path SQL and Relational Databases-D25F57C1.mp412MB

322 Querying Sample Data - Learning Path SQL and Relational Databases-6C9D56DF.mp415.96MB

323 Development Frameworks - Learning Path SQL and Relational Databases-4C4D818D.mp45.59MB

324 Agile Data Modelling - Learning Path SQL and Relational Databases-4849A351.mp45.5MB

325 Documenting A Model - Part 1 - Learning Path SQL and Relational Databases-575EBE9E.mp413.58MB

326 Documenting A Model - Part 2 - Learning Path SQL and Relational Databases-5CB17DC7.mp412.34MB

327 Presenting A Model - Learning Path SQL and Relational Databases-DC60F8D5.mp44.77MB

328 Overview - Learning Path SQL and Relational Databases-BDA7E864.mp42.55MB

329 Tree - Hardcoded - Learning Path SQL and Relational Databases-55AE605C.mp41.91MB

33 Removing Data From Tables - Learning Path SQL and Relational Databases-0D97BA5B.mp428.31MB

330 Tree - Simple - Learning Path SQL and Relational Databases-824EB17F.mp42.48MB

331 Tree - Structured - Learning Path SQL and Relational Databases-36EF8BA7.mp42.1MB

332 Tree - Overlapping - Learning Path SQL and Relational Databases-37F6697E.mp48.51MB

333 Tree - Changing Over Time - Learning Path SQL and Relational Databases-9B8340AC.mp46.73MB

334 Tree - Degenerate Node and Edge - Learning Path SQL and Relational Databases-3C15BBC1.mp42.63MB

335 Tree - Degenerate Node and Edge - Learning Path SQL and Relational Databases-CC570A82.mp42.63MB

336 Motives - Learning Path SQL and Relational Databases-D0AC2ACE.mp42.71MB

337 Comparison With Forward Engineering - Learning Path SQL and Relational Databases-65A9E067.mp44.98MB

338 Outputs - Learning Path SQL and Relational Databases-37066C57.mp41.62MB

339 Inputs - Learning Path SQL and Relational Databases-C0D6C3DB.mp43.29MB

34 The Powerful Subquery - Learning Path SQL and Relational Databases-06D93E30.mp421.53MB

340 Process - Learning Path SQL and Relational Databases-83575560.mp410.16MB

341 Principles - Learning Path SQL and Relational Databases-6642388C.mp42.99MB

342 Example - Part 1 - Learning Path SQL and Relational Databases-2311F789.mp416.81MB

343 Example - Part 2 - Learning Path SQL and Relational Databases-DEC1F76C.mp420.25MB

344 Wrap-Up - Learning Path SQL and Relational Databases-3C8346EB.mp411.78MB

345 Introduction - Learning Path SQL and Relational Databases-27231D47.mp4170.43MB

1 About The Author - Learning Path SQL and Relational Databases-8EFD7800.mp46.27MB

347 Relational Algebra - Part 1 - Learning Path SQL and Relational Databases-9B9CF417.mp4192.65MB

348 Relational Algebra - Part 1 - Learning Path SQL and Relational Databases-9F491885.mp4105.98MB

349 Time and the Database - Learning Path SQL and Relational Databases-AB6E9F7A.mp4268.23MB

35 Introduction And About The Author - Learning Path SQL and Relational Databases-E2BE3C5F.mp46.86MB

350 Intervals - Learning Path SQL and Relational Databases-2390688B.mp4203.46MB

351 Introduction - Learning Path SQL and Relational Databases-3A13D084.mp438.36MB

352 Types - Learning Path SQL and Relational Databases-04F2CEE5.mp4207.87MB

353 Relation Variables - Learning Path SQL and Relational Databases-EB1E3D1E.mp4303.29MB

354 Relational Algebra - Part 1 - Learning Path SQL and Relational Databases-8CAF6846.mp4192.65MB

355 Relational Algebra - Part 1 - Learning Path SQL and Relational Databases-34D518C3.mp4192.65MB

356 Relations - Learning Path SQL and Relational Databases-9AA71B0E.mp4186.66MB

357 What-s the Problem- - Learning Path SQL and Relational Databases-EF7398A7.mp4189.97MB

358 Pack and Unpack II - The Multiattribute Case - Learning Path SQL and Relational Databases-2F0877D4.mp4178.84MB

359 Pack and Unpack I - The Single Attribute Case - Learning Path SQL and Relational Databases-536FF318.mp4182.79MB

36 What Is SQL- - Learning Path SQL and Relational Databases-ED2D48D6.mp411.62MB

360 Expand and Collapse - Learning Path SQL and Relational Databases-E39D0D8E.mp4106.51MB

362 Database Design I - Structure - Part 1 - Learning Path SQL and Relational Databases-5A442D4D.mp4335.25MB

364 Database Design II - Keys and Related Constraints - Part 1 - Learning Path SQL and Relational Databases-96C28478.mp4121.46MB

365 Generalizing the Relational Operators - Learning Path SQL and Relational Databases-84E44038.mp4282.54MB

366 Updates - Part 2 - Learning Path SQL and Relational Databases-1EBD93BB.mp4185.89MB

367 Database Design III - General Constraints - Learning Path SQL and Relational Databases-9AB0A84E.mp4281.06MB

368 Queries - Learning Path SQL and Relational Databases-FD3F5B64.mp4159.88MB

369 Logged Time and Stated Time - Learning Path SQL and Relational Databases-80790CC6.mp4251.78MB

37 Relational Databases Explained - Part 1 - Learning Path SQL and Relational Databases-3F77A85F.mp415.44MB

370 Numeric Types - Learning Path SQL and Relational Databases-020A0DB5.mp4187.46MB

371 Interval Types Revisited - Learning Path SQL and Relational Databases-F9EBE6FD.mp4145.65MB

372 SQL Support - Queries - Learning Path SQL and Relational Databases-D90D3346.mp4135.49MB

373 SQL Support - Summary and Assessment - Learning Path SQL and Relational Databases-BF5188C6.mp4334.44MB

374 Appendixes - Learning Path SQL and Relational Databases-38A69593.mp4141.94MB

38 Relational Databases Explained - Part 2 - Learning Path SQL and Relational Databases-3B38D6F0.mp412.29MB

39 How To Query Data From A Database - Learning Path SQL and Relational Databases-4F6FF23E.mp411.61MB

4 Where Can I Use SQL- - Learning Path SQL and Relational Databases-5EFBB78E.mp416.7MB

40 The Difference Between SQL And PL-SQL - Learning Path SQL and Relational Databases-B0594E9D.mp48.19MB

41 Setting Up An Oracle Apex Account - Learning Path SQL and Relational Databases-A7C11436.mp430.89MB

42 Assignment 1 - Learning Path SQL and Relational Databases-F324F3D5.mp41.17MB

43 Assignment 1 - Solution - Learning Path SQL and Relational Databases-6DAF180D.mp42.36MB

44 Running SQL Using Oracle Apex - Learning Path SQL and Relational Databases-4E564805.mp422.75MB

45 How To Access Your Working Files - Learning Path SQL and Relational Databases-A135287E.mp44.9MB

46 Retrieving All Data From A Table - Learning Path SQL and Relational Databases-2EF27BCE.mp424.44MB

47 Retrieving Some Data From A Table - Learning Path SQL and Relational Databases-0D703720.mp47.94MB

48 Restricting The Retrieval Of Rows From A Table - Learning Path SQL and Relational Databases-003A085B.mp420.18MB

49 Using Mathematical And Text Expressions - Learning Path SQL and Relational Databases-1CE390DA.mp422.24MB

50 Sorting The Results Using Column Names - Learning Path SQL and Relational Databases-A3ECFCAD.mp420.95MB

51 Assignment 2 - Learning Path SQL and Relational Databases-EB014911.mp45.93MB

52 Assignment 2 - Solution - Learning Path SQL and Relational Databases-A9A166D8.mp422.56MB

53 What Is A Primary Key- - Learning Path SQL and Relational Databases-D1B8E7FA.mp420.66MB

54 Comparison Operators - Learning Path SQL and Relational Databases-C0E883F6.mp418.62MB

55 Dealing With Null Values - Learning Path SQL and Relational Databases-098193A0.mp430.65MB

56 Logical Operators - Learning Path SQL and Relational Databases-36A2FE89.mp429.58MB

57 Assignment 3 - Learning Path SQL and Relational Databases-06E3829B.mp43.65MB

58 Sorting The Results Using Column Position - Learning Path SQL and Relational Databases-56F30232.mp415.95MB

59 Assignment 3 - Solution - Learning Path SQL and Relational Databases-0E622A6D.mp425.55MB

6 How To Access Your Working Files - Learning Path SQL and Relational Databases-BBFEC3DB.mp44.9MB

60 What Is A Foreign Key- - Learning Path SQL and Relational Databases-C049BAAB.mp421.89MB

61 Inner Joins With The Using Clause - Learning Path SQL and Relational Databases-D171E8DB.mp420.04MB

62 Joins With The On Clause - Learning Path SQL and Relational Databases-D94F2D35.mp424.39MB

63 Joins And The Order Of Processing - Learning Path SQL and Relational Databases-EB5F5C89.mp414.28MB

64 Assignment 4 - Learning Path SQL and Relational Databases-754654B4.mp42.64MB

65 Assignment 4 - Solution - Learning Path SQL and Relational Databases-0D122004.mp418.78MB

66 Aggregate Functions - Learning Path SQL and Relational Databases-DE6947DD.mp418.42MB

67 The Count Functions - Learning Path SQL and Relational Databases-47272AFA.mp418.13MB

68 The Min And Max Functions - Learning Path SQL and Relational Databases-DB9DEE13.mp412.47MB

69 The Avg And Sum Functions - Learning Path SQL and Relational Databases-951B3575.mp47.88MB

7 Using Select To View Data - Learning Path SQL and Relational Databases-C93EE258.mp416.81MB

70 Concatenating Data - Learning Path SQL and Relational Databases-B72B47E8.mp412.97MB

71 Aggregates - Order Of Processing - Learning Path SQL and Relational Databases-A70E1D79.mp414.25MB

72 Assignment 5 - Learning Path SQL and Relational Databases-201ABC13.mp41.95MB

73 Assignment 5 - Solution - Learning Path SQL and Relational Databases-73C04A39.mp44.39MB

74 Many-To-Many Relationships - Part 1 - Learning Path SQL and Relational Databases-EF82503D.mp419.5MB

75 Many-To-Many Relationships - Part 2 - Learning Path SQL and Relational Databases-3794F696.mp412.32MB

76 Join Multiple Tables With The Using Clause - Learning Path SQL and Relational Databases-3B04E763.mp431.61MB

77 Join Multiple Tables With The On Clause - Learning Path SQL and Relational Databases-7D347A1A.mp427.04MB

78 Eliminating Duplicate Rows From The Results - Learning Path SQL and Relational Databases-CD498FA8.mp421.26MB

79 Sorting The Results Using Column Aliases - Learning Path SQL and Relational Databases-B39A0011.mp45.97MB

8 Sorting The Data - Learning Path SQL and Relational Databases-F8A43A2C.mp424.68MB

80 Assignment 6 - Learning Path SQL and Relational Databases-D6895D2D.mp43.46MB

81 Assignment 6 - Solution - Learning Path SQL and Relational Databases-D3ADE27C.mp412.9MB

82 Using The Group By Clause - Learning Path SQL and Relational Databases-00DEB9D9.mp424.88MB

83 Using The Having Clause - Learning Path SQL and Relational Databases-44B3283A.mp415.07MB

84 Having With Compound Conditions - Learning Path SQL and Relational Databases-CC8D24F4.mp410.79MB

85 Assignment 7 - Learning Path SQL and Relational Databases-05416155.mp42.73MB

86 Assignment 7 - Solution - Learning Path SQL and Relational Databases-5A5AA56A.mp417.71MB

87 Using The In Operator - Learning Path SQL and Relational Databases-18FED366.mp412.43MB

88 Using The Between Operator - Learning Path SQL and Relational Databases-4F7E35D1.mp427.96MB

89 Using The Like Operator For Pattern Matching - Learning Path SQL and Relational Databases-7AE36E9D.mp428.53MB

9 Adding A Where Clause To Filter Data - Learning Path SQL and Relational Databases-6FCB84F6.mp421.82MB

90 Assignment 8 - Learning Path SQL and Relational Databases-675932B8.mp42.95MB

91 Outer Joins - Learning Path SQL and Relational Databases-262B2BD0.mp448.63MB

92 Assignment 8 - Solution - Learning Path SQL and Relational Databases-121622D1.mp412.05MB

93 How Do Subqueries Work- - Learning Path SQL and Relational Databases-3862FBB2.mp424.82MB

94 Subqueries With The In Operator - Learning Path SQL and Relational Databases-BBB2E70A.mp432.65MB

95 Subqueries Using A Comparison Operator - Learning Path SQL and Relational Databases-16721710.mp424.08MB

96 Subqueries Vs. Joins - Learning Path SQL and Relational Databases-4F174758.mp414.89MB

97 Using A Subquery Vs. A Self-Join - Learning Path SQL and Relational Databases-95ACEEEF.mp411.84MB

98 Assignment 9 - Learning Path SQL and Relational Databases-9C6153D1.mp42.97MB

99 Assignment 9 - Solution - Learning Path SQL and Relational Databases-71855414.mp416.49MB