Duration 8 h 55 m 56 s
Embark on a transformative journey into the world of databases with our comprehensive online course, "SQL Programming: Beginner to Ultimate." Whether you're a complete novice or aspiring to become a SQL maestro, this course is your roadmap to mastering the art of database management and unleashing the full potential of SQL.
Course content
Introduction19 sWhat is SQL3 m 24 sInstalling MySQL on MAC4 m 59 sInstalling MySQL on Windows5 m 21 sCreating the Database8 m 32 sWhat you will learn2 m 32 sThe Select Statement1 m 38 sThe Select Clause7 mThe Where Clause2 m 14 sThe AND, OR and NOT Operators6 m 52 sThe IN Operator1 m 42 sThe Between Operator1 m 59 sThe Like Operator1 m 55 sThe REGEXP Operator7 mThe IS NULL Operator1 m 50 sThe ORDER BY Clause7 mInner Joins8 m 27 sJoining Across Database2 m 47 sSelf Joins4 m 14 sJoining Multiple Tables6 m 47 sCompound Join Conditions3 m 41 sImplicit Join Syntax2 m 21 sOuter Joins6 m 27 sSelf Outer Joins2 m 13 sThe USING Clause5 m 23 sNatural Joins1 m 21 sCross Joins3 m 15 sUnions8 m 29 sColumn Attributes3 m 25 sInserting a Row5 m 47 sInserting Multiple Rows3 m 18 sInserting Hierarchical Rows5 m 53 sCreating a Copy of a Table8 m 48 sUpdating a Single Row3 m 55 sUpdating Multiple Rows3 m 15 sUsing Subqueries in Updates5 m 37 sDeleting Rows1 m 24 sRestoring the Database1 m 6 sAggregate Functions9 m 20 sThe Group by Clause7 m 21 sThe Having Clause8 m 51 sThe Rollup Operator5 m 6 sIntroduction1 m 29 sThe IN Operator3 m 40 sSubqueries vs Joins5 m 8 sThe ALL Keyword4 m 52 sThe ANY Keyword2 m 37 sCorrelated Subqueries5 m 37 sThe EXISTS Operator5 m 40 sSubqueries in the SELECT Clause4 m 29 sSubqueries in the FROM Clause2 m 59 sNumeric Functions2 m 54 sString Functions5 m 48 sDate Functions in MySQL4 m 8 sFormatting Dates and Time2 m 14 sCalculating Dates and Times3 m 8 sThe IFNULL and COALESCE Functions3 m 29 sThe IF Function4 m 55 sThe CASE Operator5 m 23 sCreating Views5 m 37 sAltering or Dropping Views2 m 52 sUpdatable Views5 m 12 sOther Benefits of Views2 m 38 sThe WITH OPTION CHECK Clause.2 m 18 sWhat is Stored Procedures2 m 19 sCreating Stored Procedures1 m 18 sCreating Procedures Using MySQLWorkbench1 m 21 sDropping Stored Procedures2 m 10 sParameters3 m 12 sParameters with Default Value7 mParameter Validation7 mOutput Parameters2 m 42 sVariables1 m 30 sFunctions2 m 52 sOther Conventions1 m 52 sTransactions2 m 44 sCreating Transactions5 m 11 sConcurrency and Locking4 m 7 sConcurrency Problems7 m 25 sTransaction Isolation Levels5 m 43 sRead Uncommitted Isolation Level3 m 27 sREPEATABLE READ Isolation Level3 m 30 sSERIALIZABLE Isolation Level2 m 18 sDeadlocks6 m 12 sIntroduction44 sString Types2 m 26 sInteger Types2 m 52 sLogical Model7 m 25 sPhysical Models6 m 28 sPrimary Keys3 m 23 sForeign Keys5 m 49 sForeign Key Constraints5 m 22 sJSON Type10 m 24 sFixed-point and Floating-point Types1 m 43 sBoolean Types47 sDate and Time Types45 sBlob Types1 m 18 sConceptual Model4 m 34 sLogical Models7 m 25 sPhysical Models6 m 28 sFirst Normal Form2 m 43 sSecond Normal Form6 m 33 sThird Normal Form1 m 44 sMy Pragmatic Advice2 m 56 sForward Engineering a Model2 m 35 sSynchronizing a Model with a Database4 m 49 sReverse Engineering a Database3 m 11 sSolution- Conceptual Model8 mCreating and Dropping Databases1 m 41 sCreating Tables3 m 13 sAltering Tables2 m 56 sCreating Relationships4 m 47 sIntroduction41 sIndexes2 m 50 sCreating Indexes5 m 1 sViewing Indexes3 m 20 sPrefix Indexes3 m 41 sFull Text Indexes7 m 51 sComposite Indexes5 m 12 sOrder of Columns in Composite Indexes9 m 17 sWhen Indexes are Ignored5 m 4 sUsing Indexes for Sorting7 m 2 sCovering Indexes1 m 59 sIndex Maintenance1 m 25 sIntroduction33 sCreating a User3 m 13 sViewing Users1 m 30 sDropping Users48 sChanging Passwords1 m 6 sGranting Privilege4 m 54 sViewing Privilege1 m 35 sRevoking Privileges1 m 21 sWrap Up44 s
Director and Owner
